Senior AWS Database Administrator

About the role

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.
Maintain system security and data integrity across all data environments.
Partner with systems engineers to optimize hardware and storage subsystems for AWS.
Develop and maintain comprehensive Entity Relationship Diagrams (ERDs), system flow documents, and technical specifications for leadership and cross-functional teams.
Maintain 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.

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.
• Maintain system security and data integrity across all data environments.
• Partner with systems engineers to optimize hardware and storage subsystems for AWS.
• Develop and maintain comprehensive Entity Relationship Diagrams (ERDs), system flow documents, and technical specifications for leadership and cross-functional teams.
• Maintain 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

Preferred Qualifications

• Demonstrated success creating or managing Master Data Management (MDM) solutions
• Hands-on experience with Databricks platforms
• Experience with AWS data orchestration or equivalent ETL tools

Skills

• Cloud & Technical Expertise: Very strong AWS experience with demonstrated ability to architect and optimize database solutions
• Proficiency across multiple SQL dialects and database platforms
• Advanced expertise in data modeling, ERD creation, and performance optimization for competing priorities (write speed vs. relational integrity)
• Hands-on experience with Databricks platforms
• Exceptional ability to create and manage ERDs, system flow documents, process flow documents, and technical specifications
• Fluent in both data and technology languages, comfortable communicating with individual contributors, managers, and senior leaders

Interpersonal & Leadership

• Highly approachable with the ability to build strong relationships across all business areas, particularly within Technology and Data teams
• Skilled at navigating complex, politically sensitive conversations and influencing positive change without escalation
• Collaborative mindset with a commitment to mentoring and developing team members

Pay

$97,000.00-$207,000.00

Schedule

N/A