Role description
Role Summary
Database Administrator responsible for MongoDB and MySQL administration automation performance tuning backuprestore and production support across Dev Test and Production environments
Key Responsibilities
1 MongoDB Administration
Install configure upgrade and maintain MongoDB databases
Monitor performance replication and availability
Manage backup restore logicalphysical and validate recovery procedures
Implement security controls authentication RBAC access
Troubleshoot issues related to performance replication connectivity and storage
Collaborate with application teams for schema design and query optimization
2 MySQL Administration
Install configure and maintain MySQL databases
Execute backup restore and DR operations
Monitor performance capacity and availability
Perform performance tuning indexing query optimization
Manage users privileges and security
Handle patching upgrades and maintenance
3 Backup Restore DR Management
Design and implement backup strategies for MongoDB MySQL
Conduct regular restore testing and DR validation
Maintain documentation for backup restore and DR processes
Support audit and compliance requirements
4 Monitoring Production Support
Monitor database health and proactively resolve issues
Participate in incident management and RCA
Provide oncall production support
Maintain SOPs and operational documentation
5 Automation Scripting
Develop and maintain automation scripts for
Backuprestore operations
Health checks and monitoring
Routine maintenance tasks
Automate database deployment configuration and patching activities
Implement scheduled jobs cronautomation tools for recurring DB tasks
Utilize scripting Shell Python to improve operational efficiency
Contribute to runbook automation and operational standardization
Required Skills Qualifications
7 years of experience in MongoDB andor MySQL administration
Strong expertise in
Backup restore and DR strategies
Performance tuning and troubleshooting
Handson experience in
Production database support and monitoring
Strong knowledge of
LinuxUnix environments
Experience in automation and scripting ShellPython
Strong problemsolving and communication skills
Preferred Skills
Experience with MongoDB Atlas AWS RDS cloud DB platforms
Exposure to
High availability replication clustering
DR and failover mechanisms
Knowledge of
Security and compliance practices
Experience with
Automation tools Ansible Jenkins pipelines good to have
