At our organization, every team member plays a pivotal role in transforming lives through financial empowerment and personalized wealth management strategies. We foster a workplace where job satisfaction thrives, offering you the freedom to support causes that matter and ensuring inclusivity in every aspect of our operations. Your journey to a fulfilling career begins here.
Position OverviewWe are looking for an accomplished Lead Database Administrator with expertise in MySQL, MySQL Aurora, Redshift, and AWS Cloud Services (experience with PostgreSQL and DynamoDB is a plus). The ideal candidate will possess a robust background in managing diverse database systems in production environments, proficiency in cloud-based solutions, and skills in implementing effective sharding strategies. This role involves designing, implementing, and maintaining our expansive database infrastructure, while providing leadership and mentorship to our DBA team.
Key ResponsibilitiesDesign, implement, and maintain MySQL, MySQL Aurora, Redshift, PostgreSQL, and DynamoDB database schemas, tables, indexes, and relationships in AWS Cloud environments for optimal performance and scalability.
Deploy and manage MySQL Aurora instances, RedShift, PostgreSQL instances, and DynamoDB tables to ensure high availability and performance scalability.
Configure and optimize Redshift clusters for data warehousing and analytics, focusing on data loading, query optimization, and performance tuning.
Implement database sharding strategies for horizontal data partitioning across multiple shards to enhance scalability and performance.
Develop and implement backup and recovery strategies across various databases to maintain data integrity and availability during failures or disasters.
Manage user access, permissions, and security policies for databases to safeguard sensitive data and comply with regulatory standards.
Design and implement high availability and disaster recovery solutions 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 closely with developers, DevOps engineers, and data engineers to optimize database solutions for various applications and workloads.
Stay updated on database technologies, AWS services, and industry trends to drive continuous improvement initiatives.
Document database configurations, procedures, and troubleshooting guides for knowledge sharing and reference.
Required Skills And ExperienceMinimum of 8 years of experience as a Database Administrator, specializing in MySQL, MySQL Aurora, and Redshift.
Profound understanding of database architectures, replication, clustering, and performance optimization techniques across different database systems.
Hands-on experience with AWS Cloud services including RDS, Aurora, Redshift, DynamoDB, EC2, S3, IAM, and CloudWatch.
Experience in implementing database sharding techniques for horizontal data partitioning.
Strong grasp of database security concepts, including authentication, authorization, encryption, and compliance.
Excellent troubleshooting skills with the ability to diagnose and resolve complex database issues.
Proven experience in leading and mentoring a team of DBAs.
Strong communication and interpersonal skills, adept at collaborating effectively with cross-functional teams.
Preferred QualificationsRelevant certifications (e.g., AWS Certified Database - Specialty) would be advantageous.
Familiarity with NoSQL databases, PostgreSQL, and additional AWS Cloud services.
Note: Applicants must have authorization to work for any employer in the U.S. Sponsorship for employment visas, including CPT/OPT, is not available at this time.
Location: Remote
Employment Type: Full-Time