LEAD DATABASE ENGINEER

Empower
US - Colorado - Englewood
July 1, 2024
IT

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 lead database administrator with expertise in MySQL, MySQL Aurora, Redshift, AWS Cloud Services (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 lead 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, 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, 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 Administrator, with expertise in MySQL, MySQL Aurora, and Redshift
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
Experience with NoSQL, PostgreSQL and AWS Cloud services

*Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time, including CPT/OPT.*

#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.

Read the full job description and apply online on the recuiter's web-site

Related Job Postings

CNA - Certified Nursing Assistant

La Villa Grande Care Center

United States - CO - CO - Clifton
July 1, 2024

CNA - Certified Nursing Assistant - Senior Living Community • PRN only at this time • Are you ready to be part of something extraordinary? We're on the lookout for an exceptional Certified Nursing Assistant - CNA to join the heart of our community at La Villa Grande CareCenter. • Join a family of...

Find Jobs Hiring Now Near You!

Get Jobilize Job Search Mobile App Now