Senior Aws Database Administrator

Redfin Redfin · Seattle · MI · Remote

Senior AWS Database Administrator responsible for ensuring the performance, design, and integrity of databases supporting technology systems, with a focus on AWS MySQL, Azure TSQL, and Databricks AnsiSQL environments. The role involves database maintenance, performance optimization, Master Data Management (MDM) solutions, data modeling, security, disaster recovery, and mentoring team members.

What you'd actually do

  1. Create and modify database structures, ensuring optimal design for both transactional integrity and analytical reporting
  2. Perform advanced database maintenance tasks, including backups/restores, statistics updates, index optimization, and performance tuning
  3. Proactively monitor and optimize database performance across AWS MySQL, Azure TSQL, and Databricks AnsiSQL environments
  4. Design, implement, and manage Master Data Management (MDM) solutions that ensure data consistency across systems
  5. Collaborate with data engineers to map production data to data warehouse solutions with MDM standards

Skills

Required

  • 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
  • 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
  • Skilled at translating complex data models into clear, compelling presentations for leadership and stakeholders
  • Fluent in both data and technology languages, comfortable communicating with individual contributors, managers, and senior leaders
  • 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

Nice to have

  • 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