About the Role
This role drives performance optimization and operational excellence across Azure-managed PostgreSQL and Oracle environments, tuning SQL and improving data access patterns within application architecture and business logic. The ideal candidate is comfortable working in modern DevOps and cloud environments using Git, CI/CD, Helm, and Terraform, and will utilize Datadog for observability, performance monitoring, and alerting across database and application layers.
Responsibilities
- Monitor database health, performance, and capacity across Azure-managed PostgreSQL and Oracle using Datadog for alerting, SLO tracking, and trend analysis.
- Manage backups, restores, and disaster recovery procedures, regularly validating recovery readiness through testing.
- Administer access controls and user provisioning in alignment with security and financial compliance requirements.
- Collaborate with developers to analyze and optimize SQL execution paths in the application’s data access layer, using Datadog APM traces to pinpoint inefficient queries.
- Read and understand Java code to trace data access patterns and ensure tuning aligns with application interaction.
- Partner with software engineers and architects during design and sprint planning to shape efficient relational data models, indexing approaches, and query strategies.
- Identify performance bottlenecks using database monitoring and work with developers to implement query rewrites and schema adjustments.
- Establish and track performance baselines for business-critical queries and implement anomaly detection to prevent regression.
Requirements
- 5+ years of experience supporting relational databases (e.g., Postgres, Oracle).
- Hands-on experience with Git, CI/CD, Helm, and Terraform for database changes, automation, and releases.
- Proficiency with Datadog (or similar observability tools) for performance monitoring and alerting across database and application layers.
- Ability to read and understand Java application code to trace data access patterns.
- Strong communication skills and ability to partner effectively with engineering and infrastructure teams.
- Hands-on administration of Azure Database for PostgreSQL, including configuration, upgrades, and parameter tuning.
- Experience designing and operating high availability and disaster recovery (replication, failover, RPO/RTO), including regular testing.
- Strong performance tuning skills, including execution plan analysis (EXPLAIN), indexing strategy, query rewrites, and diagnosing locking/contention.
- Experience implementing database security best practices, including encryption, secrets management, role-based access, and audit logging.
- Ability to automate DBA workflows using Python, Bash, or PowerShell.
- Comfort participating in an on-call rotation, leading incident triage, and writing post-incident reviews.
- Hands-on administration of Oracle Database, including installation, configuration, upgrades, parameter tuning, and backups using RMAN.
- Experience with distributed databases, such as CockroachDB.
- Experience managing databases hosted on Kubernetes.
Skills
- PostgreSQL
- Oracle
- Git
- CI/CD
- Helm
- Terraform
- Datadog
- Java (code understanding)
- Python
- Bash
- PowerShell
- SQL optimization
- Relational data modeling
- Indexing strategies
- Query strategies
- Execution plan analysis (EXPLAIN)
- Database security best practices
- High availability
- Disaster recovery
- Performance tuning
- Anomaly detection
- Incident triage
- Post-incident review writing
- CockroachDB
- Kubernetes (database management)
- Azure Database for PostgreSQL administration
- Oracle Database administration (RMAN)
Experience Level
- 5+ years of experience supporting relational databases
