Database Administrator - MySQL / PostgreSQL / MongoDB

M2P; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

M2P in Chennai is seeking a Database Administrator to manage MySQL, PostgreSQL and MongoDB in Linux environments. You will automate routine DBA tasks with shell scripts and contribute to automation and reliability engineering practices.

The role covers monitoring, backup strategies, replication, HA, security hardening, and collaboration with DevOps and development teams to optimize schemas and deployments.

Qualifications

• 2-4 years of hands-on experience administering MySQL, PostgreSQL in production environments.
• Strong Linux (Ubuntu/CentOS/RHEL) system administration knowledge.
• Proficiency in bash scripting to automate routine DBA tasks.
• Experience with backup/restore tools: mysqldump/mysqlpump, pg_dump/pg_basebackup/pgBackRest, mongodump/mongorestore.
• Understanding of replication and HA concepts across all three database platforms.
• Exposure to automation/configuration tools like Ansible or Cron-based orchestration.
• Monitoring with Prometheus/Grafana or similar tools.
• SQL query tuning and performance troubleshooting.
• Knowledge of database security practices: encryption, access controls, auditing.
• Strong analytical and communication skills.
• Exposure on MongoDB as an additional advantage.

Responsibilities

• Install, configure, and maintain MySQL, PostgreSQL, and MongoDB in Linux environments.
• Monitor database health and performance; tune queries and configuration parameters.
• Design and manage backup and recovery strategies including PITR.
• Set up and maintain replication and high-availability configurations.
• Manage database users, roles, and access permissions.
• Write and maintain shell scripts to automate backups, health checks, and maintenance tasks.
• Troubleshoot production incidents including connectivity, replication lag, and performance issues.
• Apply patches and security hardening across database servers.
• Collaborate with development and DevOps on schema design and deployment automation.
• Maintain runbooks, SOPs, and inventory of database assets.
• Participate in an on-call rotation for production support.

Skills

Linux administration

Shell scripting

Performance tuning

Security best practices

Analytical skills

Communication

Education

Bachelor's degree in Computer Science/IT

Tools

MySQL

PostgreSQL

MongoDB

Ansible

Docker

Kubernetes

Terraform

Job description

Database Administrator MySQL / PostgreSQL / MongoDB

Location: Chennai

Experience: 2 4 years

About the Role

We are looking for a Database Administrator with 2-4 years of hands‑on experience managing MySQL, PostgreSQL, and MongoDB databases on Linux. The ideal candidate is comfortable working close to the OS, writes shell scripts to automate routine DBA work, and is looking to grow into deeper automation and reliability engineering practices.

What Will You Do in this Role

• Install, configure, and maintain MySQL, PostgreSQL, and MongoDB instances in Linux environments (on-prem and/or cloud).
• Monitor database health and performance; tune queries, indexes, and configuration parameters.
• Design and manage backup and recovery strategies, including logical and physical backups and point-in-time recovery.
• Set up and maintain replication and high-availability configurations (MySQL replication/Group Replication, PostgreSQL streaming replication, MongoDB replica sets/sharding).
• Manage database users, roles, and access permissions in line with security best practices.
• Write and maintain shell (bash) scripts to automate backups, health checks, log rotation, alerting, and routine maintenance tasks.
• Troubleshoot and resolve production database incidents, including connectivity, locking, replication lag, and performance issues.
• Apply patches, version upgrades, and security hardening across database servers.
• Partner with development and DevOps teams on schema design, query optimization, and deployment automation.
• Maintain runbooks, SOPs, and an up-to-date inventory of database assets.
• Participate in an on‑call rotation for production support.

What Youll Need to be Successful in this Role

• 2-4 years of hands‑on experience administering MySQL, PostgreSQL in production environments with strong knowledge on DB fundamentals.
• Strong working knowledge of Linux (Ubuntu/CentOS/RHEL) system administration.
• Proficiency in shell scripting (bash) to automate routine DBA tasks.
• Working knowledge of backup/restore tools: mysqldump/mysqlpump, pg_dump/pg_basebackup/pgBackRest, mongodump/mongorestore.
• Understanding / Exposure of replication and HA concepts across all three database platforms.
• Exposure to automation or configuration management tools such as Ansible, Cron‑based orchestration, or similar.
• Familiarity with monitoring tools such as Prometheus/Grafana, Percona Monitoring and Management, Nagios, or equivalent.
• Solid understanding of SQL query tuning and performance troubleshooting.
• Awareness of database security practices: encryption at rest/in transit, access controls, auditing.
• Strong analytical and troubleshooting mindset with good communication skills.
• Exposure on MongoDB as an additional advantage.

Good to Have

• Exposure to managed cloud databases (AWS RDS/Aurora, GCP Cloud SQL, Azure Database).
• Basic knowledge of containerization (Docker) and orchestration (Kubernetes).
• Experience with CI/CD pipelines and infrastructure-as-code tools (Terraform, Ansible).
• Relevant certifications (Oracle MySQL, PostgreSQL, MongoDB Certified DBA).

Education

Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.