Database Engineer (Remote)

Frontdoor, Inc. is reimagining how homeowners maintain and repair their homes through innovative technology. As a Database Engineer, you will optimize database performance and security, automate tasks, and collaborate with a skilled team to ensure the integrity and availability of database systems.

Responsibilities:

• Deploy, configure, and upgrade relational and NoSQL 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 GoldenGate extracts and replicats – GoldenGate Core and BigData
• Troubleshoot issues with GoldenGate installation, setup, and configuration

Requirements:

• Strong proficiency in writing, optimizing, and debugging queries, stored procedures, and triggers
• Demonstrated experience in managing Oracle, MongoDB, Postgres, MySQL, and other database platforms in AWS RDS
• Demonstrated experience in configuring and managing GoldenGate replication – GG Core and BigData
• Able to debug complex database/system issues and analyze Splunk or ElasticSearch 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
• 5+ years Database Engineering or Database Administration experience