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