At EMPOWER, we empower our associates to make a meaningful impact on people's lives, whether by helping them achieve financial goals or providing personalized wealth management strategies. Our commitment to job satisfaction is unmatched, offering you not only professional fulfillment but also the freedom to support causes you care about in an inclusive work environment. Your future begins now.
Position Overview
We are seeking a talented Lead Database Administrator with a robust skill set in MySQL, MySQL Aurora, Redshift, AWS Cloud Services (with familiarity in PostgreSQL and DynamoDB), and expertise in database sharding. The ideal candidate will possess a strong background in managing diverse database systems in production environments, cloud-based solutions, and implementing effective sharding strategies. As Lead DBA, you will play a pivotal role in designing, implementing, and maintaining our database infrastructure while providing leadership and guidance to our team of administrators.
What You Will Do
-
Design, implement, and maintain MySQL, MySQL Aurora, Redshift, 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, focusing on data loading, query optimization, and performance tuning.
-
Implement database sharding strategies to horizontally partition data across multiple shards, enhancing scalability and performance.
-
Develop and execute backup and recovery strategies across various databases to ensure data integrity and availability during failures or disasters.
-
Manage user access, permissions, and security policies to safeguard sensitive data and ensure compliance with regulatory standards.
-
Design and implement high availability and disaster recovery solutions using AWS services like Aurora Global Database, Multi-AZ deployments, and DynamoDB Global Tables.
-
Lead and mentor a team of database administrators, providing technical guidance, support, and ongoing training.
-
Collaborate with cross-functional teams, including developers, DevOps, and data engineers, to optimize database solutions for diverse applications and workloads.
-
Stay abreast of database technologies, AWS services, and industry trends to recommend continuous improvements.
-
Document database configurations, procedures, and troubleshooting guides to facilitate knowledge sharing and reference.
What You Will Bring
-
Minimum of 8 years of experience as a Database Administrator, specializing in MySQL, MySQL Aurora, and Redshift.
-
Deep understanding of database architectures, replication, clustering, and performance optimization techniques across multiple database systems.
-
Hands-on expertise with AWS Cloud services such as RDS, Aurora, Redshift, DynamoDB, EC2, S3, IAM, and CloudWatch.
-
Proven experience implementing database sharding techniques for horizontal data partitioning.
-
Strong grasp of database security concepts, including authentication, authorization, encryption, and compliance.
-
Exceptional troubleshooting skills with the ability to diagnose and resolve complex database issues.
-
Track record of leadership and mentorship within a DBA team.
-
Excellent communication and interpersonal skills, capable of effective collaboration with diverse teams.
What Will Set You Apart
-
Relevant certifications (e.g., AWS Certified Database - Specialty) are a plus.
-
Experience with NoSQL databases, PostgreSQL, and additional AWS Cloud services.
Additional Details
-
Applicants must be authorized to work for any employer in the U.S.; sponsorship of employment visas, including CPT/OPT, is not available at this time.
-
#LI-Remote #PJT
What We Offer You
-
We provide a comprehensive range of inclusive benefits, supporting your well-being at every career stage to optimize your performance.
-
Medical, dental, vision, and life insurance coverage.
-
Robust retirement savings plan with up to 6% company matching contributions, financial advisory services, and potential discretionary contributions.
-
Tuition reimbursement up to $5,250/year.
-
Business-casual environment, including the option to wear jeans.
-
Generous paid time off upon hire, including a paid time-off program, ten paid company holidays, and three floating holidays annually.
-
Paid volunteer time — 16 hours per calendar year.
-
Leave of absence programs, encompassing paid parental leave, short- and long-term disability, and Family and Medical Leave (FMLA).
-
Business Resource Groups (BRGs), internal networks advocating common interests, experiences, and identities.
Base Salary Range
$109,600.00 - $158,950.00
Note: Actual compensation may vary based on geographic location, work experience, education, licensure requirements, and skill level.
Equal Opportunity Employer
We are committed to diversity, fostering an inclusive workplace where all individuals, regardless of personal characteristics, are encouraged to apply. Qualified applicants will receive consideration without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender identity, marital status, pregnancy, religion, disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.
To apply, please visit our website and submit your application before the job posting deadline on 07-08-2024.
Workplace Flexibility
Remote - Nationwide
Apply on our company site, referencing Job ID: empower-1417815085
Related Posts:
- Job Opening: Financial Advisor at EMPOWER Littleton, CO, USA
- Job Opening: RN Unit Manager (UM) at CIENA HEALTHCARE
- SAP Data Migration Consultant, Manager at PWC