Senior AWS Database Administrator
About The Position
As a Senior AWS Database Administrator, you'll ensure the databases that support our technology systems are designed and performing as needed while providing the necessary data to the appropriate team members. You'll be a strategic technical partner who bridges our Technology and Data teams, driving database excellence across both environments. Create and modify database structures, ensuring optimal design for both transactional integrity and analytical reporting. Perform advanced database maintenance tasks, including backups/restores, statistics updates, index optimization, and performance tuning. Proactively monitor and optimize database performance across AWS MySQL, Azure TSQL, and Databricks AnsiSQL environments. Design, implement, and manage Master Data Management (MDM) solutions that ensure data consistency across systems. Collaborate with data engineers to map production data to data warehouse solutions with MDM standards. Develop and maintain comprehensive Entity Relationship Diagrams (ERDs), system flow documents, and technical specifications for leadership and cross-functional teams. Maintain system security and data integrity across all data environments. Partner with systems engineers to optimize hardware and storage subsystems for AWS. Develop, manage, and maintain robust disaster recovery and high availability plans. Collaborate with Infosec and Security teams on data compliance, security, and retention. Participate in data architectural design reviews with both Technology and Data teams. Mentor and coach team members on database best practices.
Requirements
- Bachelor's degree in computer science or a related field (or equivalent professional experience)
- 6+ years of hands-on SQL coding experience across multiple platforms (AWS MySQL, Azure TSQL, Databricks AnsiSQL)
- 6+ years of experience in data modeling, ERD design, and database tuning for both production write performance and reporting/auditing integrity
- Proven experience supporting data systems in both Technology and Data team environments
- Strong AWS cloud platform knowledge
Nice To Haves
- Demonstrated success creating or managing Master Data Management (MDM) solutions
- Hands-on experience with Databricks (AWS and/or Azure)
- Experience with AWS data orchestration or equivalent ETL tools
Responsibilities
- Create and modify database structures, ensuring optimal design for both transactional integrity and analytical reporting
- Perform advanced database maintenance tasks, including backups/restores, statistics updates, index optimization, and performance tuning
- Proactively monitor and optimize database performance across AWS MySQL, Azure TSQL, and Databricks AnsiSQL environments
- Design, implement, and manage Master Data Management (MDM) solutions that ensure data consistency across systems
- Collaborate with data engineers to map production data to data warehouse solutions with MDM standards
- Develop and maintain comprehensive Entity Relationship Diagrams (ERDs), system flow documents, and technical specifications for leadership and cross-functional teams
- Maintain system security and data integrity across all data environments
- Partner with systems engineers to optimize hardware and storage subsystems for AWS
- Develop, manage, and maintain robust disaster recovery and high availability plans
- Collaborate with Infosec and Security teams on data compliance, security, and retention
- Participate in data architectural design reviews with both Technology and Data teams
- Mentor and coach team members on database best practices
Benefits
- medical, dental, and vision benefits
- 401K retirement plan
- paid-time off
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
