Key Responsibilities:
- 1. Database Provisioning & Infrastructure-as
- Code
- Deploy and configure recent database instances (dev, test, prod) in accordance with system and storage requirements
- Build and maintain automated provisioning pipelines using Terraform, Ansible, and CI/CD tools
- Enforce infrastructure-as-code standards, audit logging, and reporting
- Validate automation through test runs and integrate database changes into CI/CD workflows
- 2. Backup, Recovery & Disaster Recovery
- Design and schedule daily, weekly, and monthly backups; configure and validate backup jobs in native DBMS tools
- Test recovery scenarios quarterly and maintain up-to-date DR runbooks
- Monitor backup job success/failure; escalate and remediate missed or failed backups
- Implement and validate log shipping, Always On Availability Groups, Oracle RAC or clustering for DR
- 3. Patch Management & Upgrades
- Plan and coordinate quarterly patch reviews and database version upgrades
- Apply vendor-released patches, perform post-upgrade validation, and resolve any functional regressions
- 4.



Performance Monitoring, Tuning & Capacity Planning
- Monitor CPU, memory, storage usage, query performance, waits and latches using native and third-party tools
- Run baseline health checks post-maintenance, resolve anomalies, and document changes
- Forecast resource growth (1224 months), identify workload spikes, and plan infrastructure scaling
- Recommend and implement index and query optimizations in collaboration with application owners
- 5. High Availability & Replication
- Design, configure, and validate HA solutions including clustering, Always On, log shipping, and replication
- Monitor replication jobs, troubleshoot latency/errors, and conduct periodic failover drills
- 6. Security, Compliance & Audit
- Implement database security standards: encryption, data masking, role-based access control, schema and user setup
- Approve or deny access requests, remove orphaned accounts, and audit user a

📌 Database Administrator (Delhi)
🏢 Pricewater House Coopers Service Delivery Center Bangalore
📍 Delhi