Database Administrator

Position Database Administrator (MongoDB | PostgreSQL | MySQL)

Experience 610 Years

Location Hyderabad (Onsite- US Shift timings.

Job Summary

We are seeking an experienced Database Administrator (DBA) to manage, optimize, secure, and maintain enterprise-scale MongoDB, PostgreSQL, and MySQL databases. The ideal candidate will have hands-on experience with database administration, performance tuning, high availability, backup & recovery, replication, upgrades, migrations, automation, and cloud-native database deployments. The candidate should possess strong troubleshooting skills and work closely with Development, DevOps, Cloud, and Infrastructure teams to ensure high availability, scalability, and reliability of mission-critical database systems.

Key Responsibilities

Database Administration Administer enterprise MongoDB, PostgreSQL, and MySQL environments. Install, configure, upgrade, and maintain database servers. Manage multiple production and non-production database environments.

Ensure high availability, scalability, and reliability of database infrastructure.

Monitor database health and proactively resolve issues. Performance Tuning Analyze slow-running queries and optimize execution plans.

Perform database indexing and query optimization. Monitor CPU, memory, disk I/O, and locking issues.

Optimize database parameters for maximum throughput. Perform database capacity planning.

Backup & Recovery

Design and manage automated backup strategies.

Perform backup validation and disaster recovery testing. Restore databases during failures.

Maintain Recovery Point Objective (RPO) and Recovery Time Objective (RTO) compliance. Ensure business continuity through regular recovery drills.

High Availability & Replication

Configure and maintain:

MongoDB Replica Sets & Sharding

PostgreSQL Streaming Replication & Logical Replication

MySQL Replication & Group Replication

Read Replicas Automatic Failover Clusters Database Security Implement authentication and authorization.

Manage roles and privileges. Configure SSL/TLS encryption. Implement encryption at rest. Perform database security hardening.

Conduct regular security audits and vulnerability remediation. Database Migration

Plan and execute: Database upgrades Schema migrations Version upgrades Cloud migrations Cross-platform migrations Perform minimal-downtime production migrations. Monitoring & Automation Implement proactive monitoring using enterprise monitoring tools.

Create dashboards and alerts. Automate routine administrative tasks using scripting. Monitor replication health and storage utilization.

Maintain operational runbooks and documentation.

Cloud Database Administration Experience managing databases on:

AWS RDS Amazon Aurora Azure Database Services Google Cloud SQL MongoDB Atlas Database Development Support Support development teams with:

Schema design Data modeling Stored procedures Functions Triggers Views Query optimization Performance troubleshooting Disaster Recovery Maintain Disaster Recovery environments.

Execute failover/failback procedures. Perform periodic DR drills. Validate backup integrity.

Required Technical Skills

MongoDB MongoDB Administration, Replica Sets, Sharding, Atlas, Aggregation Framework,Index Optimization, BSON, MongoDB Security, Backup & Restore, Performance Tuning, PostgreSQL

PostgreSQL Administration, Streaming Replication, Logical Replication, Partitioning, Vacuum & Analyze, WAL Management, pgBouncer, pgAdmin, Query Optimization, Backup & Recovery.

MySQL MySQL Administration , Replication, InnoDB, Partitioning, MySQL Enterprise Backup, Percona Toolkit, Performance Schema, Slow Query Analysis, High Availability, Failover.

Database Concepts SQL, Query Optimization, Indexing, Normalization, De-normalization ,Locking, Transactions, ACID, Concurrency Control, Partitioning, Data Modeling Automation & Scripting Shell Scripting, Bash, Python, SQL Scripting, Cron Jobs, Ansible (preferred) Operating Systems Linux Administration, Windows Server Administration Monitoring Tools Prometheus, Grafana, Zabbix, Datadog, Nagios, New Relic Cloud Platforms AWS, Azure, Google Cloud Platform.