Lead Cloud Dba - Mysql & Aws

Grow your career with a growing organization Whether they're helping people reach their long-term financial goals or providing personal wealth management strategies, every associate contributes to changing the lives of those we serve for the better. When it comes to job satisfaction, that's hard to beat. And from a personal satisfaction perspective, you'll enjoy the freedom to support causes that matter to you and experience a truly inclusive work environment. Your future starts now. Position Overview:   We are seeking a skilled and experienced L ead Database Administrator with expertise in MySQL, MySQL Aurora,   Redshift, AWS Cloud S ervices ( Nice to have PostgreSQL and DynamoDB), and experience in database sharding. The ideal candidate will have a strong background in managing various database systems in production environments, familiarity with cloud-based database solutions, and proficiency in implementing sharding strategies. The l ead DBA will be responsible for designing, implementing, and maintaining our diverse database infrastructure while providing leadership and guidance to the database administration team.   What you will do :   Design, implement, and maintain MySQL, MySQL Aurora,  Red shift , PostgreSQL, and DynamoDB database schemas, tables, indexes, and relationships to ensure optimal performance, scalability, and reliability in AWS Cloud environments.   Deploy and manage MySQL Aurora instances, RedShift, PostgreSQL instances, and DynamoDB tables for high availability, scalability, and performance.   Configure and optimize Redshift clusters for data warehousing and analytics workloads, including data loading, query optimization, and performance tuning.   Implement database sharding strategies to horizontally partition data across multiple shards for improved scalability and performance.   Develop and implement backup and recovery strategies for various databases to ensure data integrity and availability in case of failures or disasters.   Manage user access, permissions, and security policies for different databases to protect sensitive data and ensure compliance with regulatory requirements.   Design and implement high availability and disaster recovery solutions for different databases using AWS services such as Aurora Global Database, Multi-AZ deployments, and DynamoDB Global Tables.   Lead and mentor a team of database administrators by providing technical guidance, support, and training.   Collaborate with cross-functional teams , including developers, DevOps , data engineers to design and optimize database solutions for various applications and workloads.   Stay up-to-date with database technologies, AWS services, and industry trends to make recommendations for continuous improvement.   Document database configurations, procedures, and troubleshooting guides for knowledge sharing and reference.     What you will bring :   Minimum of 8 years of experience as a Database A dministrator, with expertise in MySQL, MySQL Aurora,   and Re dshift   In-depth knowledge of database architectures, replication, clustering, and performance optimization techniques for various database systems   Hands-on experience with AWS Cloud services such as RDS, Aurora, Redshift, DynamoDB, EC2, S3, IAM, and CloudWatch   Experience implementing database sharding techniques for horizontal partitioning of data across multiple shards   Strong understanding of database security concepts including authentication, authorization, encryption, and compliance   Excellent troubleshooting skills with the ability to diagnose and resolve complex database issues   Experience leading and mentoring a team of DBAs   Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams     What will set you apart:   Relevant certifications (e.g., AWS Certified Database - Specialty) are a plus   E xperience with NoSQL, PostgreSQL and AWS Cloud services   #LI-Remote #PJT What we offer you We offer an array of diverse and inclusive benefits regardless of where you are in your career. We believe that providing our employees with the means to lead healthy balanced lives results in the best possible work performance. Medical, dental, vision and life insurance Retirement savings – 401(k) plan with generous company matching contributions (up to 6%), financial advisory services, potential company discretionary contribution, and a broad investment lineup Tuition reimbursement up to $5,250/year Business-casual environment that includes the option to wear jeans Generous paid time off upon hire – including a paid time off program plus ten paid company holidays and three floating holidays each calendar year Paid volunteer time — 16 hours per calendar year Leave of absence programs – including paid parental leave, paid short- and long-term disability, and Family and Medical Leave (FMLA) Business Resource Groups (BRGs) - internal networks that rally around common interest, experiences and identities such as race, ethnicity, gender, ability, military status and sexual orientation. BRGs play a vital role in educating and engaging our people and advancing our business priorities. Base Salary Range $109,600.00 - $158,950.00 The salary range above shows the typical minimum to maximum base salary range for this position in the location listed. Non-sales positions have the opportunity to participate in a bonus program. Sales positions are eligible for sales incentives, and in some instances a bonus plan, whereby total compensation may far exceed base salary depending on individual performance. Actual compensation offered may vary from posted hiring range based upon geographic location, work experience, education, licensure requirements and/or skill level and will be finalized at the time of offer. Equal opportunity employer •  Drug-free workplace We are an equal opportunity employer with a commitment to diversity.  All individuals, regardless of personal characteristics, are encouraged to apply.  All qualified applicants will receive consideration for employment without regard to age (40 and over), race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.  ***For remote and hybrid positions you will be required to provide reliable high-speed internet with a wired connection as well as a place in your home to work with limited disruption. You must have reliable connectivity from an internet service provider that is fiber, cable or DSL internet. Other necessary computer equipment, will be provided. You may be required to work in the office if you do not have an adequate home work environment and the required internet connection.*** Job Posting End Date at 12:01 am on: 11-01-2024 Want the latest money news and views shaping how we live, work and play? Sign up for Empower's free newsletter and check out The Currency . Workplace Flexibility: Remote - Nationwide