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 Preferred Skills Experience with NoSQL and relational databases in hybrid environments. Knowledge of data warehousing concepts. Familiarity with Redis or Elasticsearch. Experience with Kafka-based data pipelines. Understanding of Data Governance and Data Security. Knowledge of GDPR, PCI DSS, or ISO 27001. Exposure to AI/ML data platforms and vector databases is a plus. Soft Skills Strong analytical and troubleshooting skills. Excellent communication and documentation abilities. Ability to work in Agile/Scrum environments. Strong stakeholder management. Ownership mindset with proactive problem-solving. Nice to Have MongoDB Certified DBA PostgreSQL Professional Certification Oracle MySQL Certification AWS Certified Database Specialty Azure Database Administrator Associate Google Professional Cloud Database Engineer