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, Recent 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

📌 Database Administrator (Telangana)
🏢 Mostedge Services
📍 Telangana