11 Oct
|
MostEdge
|
Hyderabad
11 Oct
MostEdge
Hyderabad
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, Current Relic Cloud Platforms AWS, Azure, Google Cloud Platform.
📌 Database Administrator (Hyderabad)
🏢 MostEdge
📍 Hyderabad