Senior Sql Database Administrator

*****CONTRACT ROLE**********CONTRACT ROLE**********CONTRACT ROLE*****Role : Senior Database AdministratorLocation : Austin,TXJob Description :The Senior DatabaseAdministrator (DBA) architects, operates and maintains high-availability (HA),mission-critical database estates spanning relational engines (Oracle andPostgreSQL) and a document store (MongoDB).Role involves production-operationsand reliability role - Database ReliabilityKey responsibilities•Architect, operate and maintainHA, mission-critical database clusters across Oracle, PostgreSQL and MongoDB inproduction environments.Perform advanced performancetuning, query optimization, indexing strategy and capacity planning across bothrelational and document-based data layers.•Design and manage robustbackup, point-in-time recovery (PITR), failover and DR strategies to guaranteestrict Recovery Point Objective (RPO) and Recovery Time Objective (RTO)targets.•Implement proactive monitoring,telemetry and automated alerting; troubleshoot bottlenecks; and participate inon-call rotations to sustain five-nines reliability.•Automate routine operations(provisioning, patching, health checks) and maintain runbooks and post-incidentreviews.Must-Have technical skillsCore reliability& operations — required regardless of engine•8+ years of production DBAexperience on mission-critical, high-availability systems.•Demonstrated five-nines(99.999%) operations and active participation in 24×7 on-call rotations andincident response.•Backup, restore, PITR, failoverand DR design meeting defined RPO/RTO objectives.•Advanced performance tuning:execution-plan analysis, query optimization, indexing strategy, lock/waitdiagnosis.•Capacity planning and growthforecasting.•Proactive monitoring, telemetryand automated alerting (e.g., Prometheus/Grafana, Oracle Enterprise Manager(OEM), or equivalent).•Automation and scripting:Structured Query Language (SQL), Shell and Python; configuration automation(e.g., Ansible).Oracle: Real Application Clusters (RAC), Data Guard, Recovery Manager(RMAN), Automatic Storage Management (ASM), Automatic Workload Repository (AWR)/ Automatic Database Diagnostic Monitor (ADDM) tuning; OR•PostgreSQL: streaming and logical replication, Patroni or repmgr for HA,pgBackRest or Barman for backup/PITR, VACUUM/autovacuum and planner tuning.Note : If you are interested please share me your resumes to Dhamu@vmcsofttech.com or else reach me at 4804076920.