Senior Database Administrator (DBA Operations)
Experience: 5-8 years | Level: Senior Engineer
Role Summary
Own the availability, performance, security, and recoverability of our production database estate across on-prem and cloud. You will run day-to-day DBA operations, lead incident response and root cause analysis, and set operating standards for Oracle, Microsoft SQL Server, PostgreSQL, MongoDB, and Google Cloud SQL.
Key Responsibilities
- Install, configure, patch, and upgrade Oracle, SQL Server, PostgreSQL, MongoDB, and Cloud SQL instances.
- Provision databases to standards, refresh non-production environments, and decommission with proper data retention.
- Plan and execute migrations and version upgrades with tested rollback plans and minimal downtime.
- Design, implement, and test backup/restore, HA, and DR (Data Guard/RAC, Always On Availability Groups, streaming replication, replica sets, Cloud SQL HA and cross-region replicas).
- Validate backups regularly and run DR drills, reporting measured RTO and RPO.
- Monitor daily health: availability, replication lag, blocking, storage growth, and job failures.
- Tune queries, indexes, and configuration using execution plans, wait analysis, and diagnostic views.
- Capacity plan, manage storage, tablespaces/filegroups, partitioning, and archival/purge strategies.
- Manage user access, roles, ensuring compliance with security standards, encryption at rest and in transit, and auditing.
- Run periodic access reviews, meet patch SLAs, and provide evidence for audits.
- Provide L2/L3 support, including on-call rotation, and lead RCA for major incidents.
- Review database changes, support production deployments, and advise developers on schema and SQL design.
Qualifications
- Bachelors degree in computer science, IT, or equivalent experience.
- 5-8 years of hands-on production DBA experience.
- Preferred certifications: Oracle Certified Professional, any other DB admin certifications. GCP certifications are added advantage.