Senior Database Administrator (DBA Operations)

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.