Frontdoor, Inc. is reimagining how homeowners maintain and repair their homes. The Senior Database Engineer will be responsible for architecting and building relational and NoSQL database systems, mentoring junior engineers, and leading database-related projects to ensure high availability and performance of database systems.
Responsibilities:
- Architect and build relational and NoSQL database systems that are performant, highly available, and scalable
- Perform advanced query tuning and configure data replication using tools like Oracle GoldenGate or AWS DMS
- Operate independently, mentor junior engineers, and lead database-related projects and upgrades
- Develop tools and scripts to automate database deployment, monitoring, and maintenance workflows
- Implement proactive performance tuning and set up and maintain monitoring dashboards and alerting systems for database performance and capacity
- Design efficient database schemas, conduct code reviews, and optimize queries for high performance
- Establish and enforce policies for handling PCI and PII data, including data redaction and compliance with regulatory standards
- Implement robust backup, recovery, and security protocols aligned with data governance and business continuity requirements
- Contribute to infrastructure-as-code initiatives for database provisioning
- Diagnose and resolve database-related issues to ensure high availability and minimal downtime
- Proactively recommend and implement improvements to database systems and infrastructure
- Work cross-functionally with software development and IT teams to troubleshoot and resolve incidents
- Participate in an on-call rotation to support production systems
- Perform additional tasks as assigned in support of team and organizational goals
Requirements:
- Deep expertise in relational databases (e.g., Oracle, PostgreSQL, MySQL, SQL Server) and NoSQL technologies (e.g., MongoDB, DynamoDB, Cassandra)
- Proven experience with query optimization, indexing strategies, and data replication using tools like Oracle GoldenGate or AWS DMS
- Strong proficiency in SQL, with scripting experience in Python or Shell
- Familiarity with AWS services (RDS, Aurora, DynamoDB, CloudWatch) and cloud-native database management
- Experience implementing monitoring, alerting, and performance tuning in production environments
- Solid understanding of data governance, security protocols, and compliance standards (e.g., PCI, PII)
- Comfortable working in Agile/Scrum environments and participating in on-call rotations
- Able to solve complex database/system issues and analyze Splunk or ElasticSearch APM logs/metrics
- Strong familiarity with Unix/Linux systems
- 7+ years hands-on experience in database engineering, administration or architecture
- Experience with CI/CD pipelines, Terraform, or CloudFormation for infrastructure automation
- Knowledge of containerized environments (Kubernetes) and their impact on database deployment
- Strong communication skills and ability to collaborate across engineering, product, and IT teams
- Demonstrated ability to mentor junior engineers and lead cross-functional database initiatives
- Bachelor's or Master's degree in computer science, information systems, engineering or related field highly preferred
- Professional certifications are preferred