Job Description

Role Overview

We are seeking an experienced and highly skilled Database Administrator (DBA) with expertise in MySQL 8+ and PostgreSQL. The DBA will be responsible for the design, implementation, administration, and performance optimization of large-scale database systems. The ideal candidate should have proven experience in high-availability environments, performance tuning, troubleshooting, and database security best practices.

Key Responsibilities

Design, install, configure, and maintain MySQL 8+ and PostgreSQL database systems across development, staging, and production environments.

Architect and implement high availability, clustering, replication, and disaster recovery solutions.

Monitor database performance, proactively identify bottlenecks, and implement tuning and optimization strategies (indexes, queries, caching).

Ensure data security, integrity, and compliance by implementing database access controls, encryption, and backup strategies.

Troubleshoot complex database issues, conduct root cause analysis, and provide permanent resolutions.

Collaborate with application and DevOps teams to optimize database schemas, queries, and stored procedures.

Implement and maintain monitoring and alerting systems for database health and performance.

Manage scaling strategies to support large-scale, high-volume applications.

Document standards, procedures, and guidelines for database management and disaster recovery.

Stay updated with the latest database features, tools, and industry best practices.

Required Skills & Experience

8+ years of professional experience as a Database Administrator (DBA) in large-scale environments.

Strong expertise in MySQL 8+ and PostgreSQL administration.

Hands-on experience with replication and clustering (e.g., MySQL Group Replication, Patroni, pgPool, etc.).

Proficiency in performance tuning (query optimization, indexing strategies, partitioning).

Experience with backup & recovery tools (Percona XtraBackup, pgBackRest, WAL archiving).

Knowledge of high availability & disaster recovery (HAProxy, Failover strategies).

Familiarity with NoSQL databases (MongoDB, Redis, etc.) is a plus.

Experience with cloud-based DB services (AWS RDS, Aurora, GCP Cloud SQL, Azure Database for PostgreSQL/MySQL).

Proven capacity planning, scaling strategies, and experience with large-volume transaction systems.

Strong understanding of database security best practices (encryption, auditing, role-based access).

Proficiency in Linux system administration related to database hosting.

Strong scripting skills (Bash, Python, or similar) for automation.

Familiarity with DevOps practices, CI/CD pipelines, and containerization (Docker, Kubernetes).

Preferred Qualifications

Bachelor's or Master's degree in Computer Science, Information Technology, or related field.

Certifications in MySQL, PostgreSQL, or cloud database technologies.

Exposure to Data Warehousing, BI, or Big Data platforms.

Knowledge of monitoring tools like Prometheus, Grafana, Percona Monitoring and Management (PMM), or Zabbix.

Soft Skills

Strong problem-solving and analytical skills.

Excellent communication and documentation abilities.

Ability to collaborate effectively with cross-functional teams.

Proactive mindset with a focus on continuous improvement.

Job Type: Contractual / Temporary
Contract length: 6 months

Pay: ₹16,691.17 - ₹64,252.67 per month