Ad Platforms - Database Engineer (DBA)

Company	Software And ServicesSee more
Address	Austin, TX
Category	Information Technology

Job description

- Take ownership for fast-paced, complex, and distributed database environments (200+ Oracle, Aurora Postgres, and Aurora MySQL databases) supporting OLTP and OLAP systems across on-premises and AWS - Design, build, and continuously maintain high performance and highly available database and change data capture infrastructure - Migrate mission-critical database applications leveraging on-prem Oracle to using AWS Aurora Postgres - Work closely with development engineering teams in advancing their strategic initiatives, operational readiness, engineering standards, designs, and performance - Support various database maintenance activities like database upgrades, patch management, user management, and backup and recovery - Setup and maintain Oracle GoldenGate Active-Active environments for databases and Big Data - Configure Oracle Data Guard and RAC for high availability and implement zero data loss solutions - Implement infrastructure automation and scripting using tools like Shell, Python, and Terraform - Troubleshoot and resolve database performance issues and tune SQL queries proficiently - Database on-call for production and non-production during US hours as part of a 12x7 rotation

Request

3 or more years of industry experience designing, managing, and supporting production databases at scale
2+ years supporting Oracle
1+ years supporting Aurora Postgres and Aurora MySQL
Extensive experience in handling architectural and design considerations such as performance, scalability and availability
Expertise in relational database engineering and administration for on-prem and RDS Oracle (19c, 12c), Aurora Postgres (12+), and Aurora MySQL (5.7+)
Strong knowledge in change data capture technologies (GoldenGate, Debezium)
Very skilled in database monitoring, tuning, and alerting with tools like Datadog, OEM, CloudWatch, Grafana, PagerDuty or similar technologies
Experienced in Infrastructure as Code via Terraform or similar technologies
Good knowledge of Linux/Unix internals, systems/application design & architecture.
Strong analytical, critical thinking, and root cause analysis
Have the ability to communicate effectively, both written and verbal, with technical and non-technical multi-functional teams