Database Engineer; Remote

Overview

Frontdoor is reimagining how homeowners maintain and repair their most valuable asset – their home. As the parent company of two leading brands, we bring over 50 years of experience in providing our members with comprehensive options to protect their homes from costly and unexpected breakdowns through our extensive network of pre‑qualified professional contractors. American Home Shield, the category leader in home service plans with approximately two million members, gives homeowners budget protection and convenience, covering up to 23 essential home systems and appliances.

Frontdoor is a cutting edge, one‑stop app for home repair and maintenance. Enabled by our Streem technology, the app empowers homeowners by connecting them in real time through video chat with pre‑qualified experts to diagnose and solve their problems. The Frontdoor app also offers homeowners a range of other benefits including DIY tips, discounts and more. For more information about American Home Shield and Frontdoor, please visit

As a Database Engineer, you will work on multiple database systems--optimizing performance, resiliency, scale, and security. You will be involved in scripting and creating automation for repeatable tasks, assist in architecting highly available and performant database systems, and being stewards of security and data integrity. You will be working with a team of skilled database engineers who have deep domain and technical knowledge of Frontdoor’s databases and cloud infrastructure.

As a Database Engineer, you will work on multiple database systems--optimizing performance, resiliency, scale, and security. You will be involved in scripting and creating automation for repeatable tasks, assist in architecting highly available and performant database systems, and being stewards of security and data integrity. You will be working with a team of skilled database engineers who have deep domain and technical knowledge of Frontdoor’s databases and cloud infrastructure.

• Deploy, configure, and upgrade relational and No
  
  SQL databases.
• Analyze and optimize slow‑running queries, collaborate with software development teams to optimize query performance.
• Monitor database health and performance using cloud‑native or third‑party tools.
• Maintain accurate documentation of configurations, procedures, and troubleshooting runbooks.
• Set up and maintain monitoring dashboards and alerting systems for database performance and capacity planning.
• Support implementation of data security policies, including handling of PII and PCI data.
• Configure backups, perform annual DB restore/failover testing, and patching activities.
• Act as a first responder for database‑related issues and collaborate with developers and senior database engineers to resolve incidents.
• Use scripting (e.g., Bash, Shell, Python) and tools like Ansible or Terraform to automate database tasks.
• Participate in an on‑call rotation to support production systems.
• Perform additional tasks as assigned in support of team and organizational goals.

• Install, configure, and manage Golden Gate extracts and replicats – Golden Gate Core and Big Data
• Troubleshoot issues with Golden Gate installation, setup, and configuration.

• Strong proficiency in writing, optimizing, and debugging queries, stored procedures, and triggers.
• Demonstrated experience in managing Oracle, Mongo
  
  DB, Postgres, MySQL, and other database platforms in AWS RDS.
• Demonstrated experience in configuring and managing Golden Gate replication – GG Core and Big Data
• Able to debug complex database/system issues and analyze Splunk or Elastic Search APM logs/metrics.
• Demonstrated experience in writing automation scripts (bash/shell). Knowledge of Python and other languages are a plus.
• Passion for automating tasks and learning new skills.
• Experience with managing databases and services hosted in AWS.
• Experience with Unix/Linux systems.

Bachelor’s degree in Computer Science, Software Engineering, Data Science, or related field

(number of years necessary to…