Data Base Administrator; DBA MySQL​/PostgreSQL -Consultant

Role Overview

We are seeking an experienced and highly skilled Database Administrator (DBA) with expertise in MySQL 8+ and Postgre

SQL. 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 Postgre

SQL 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 Dev Ops 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 Postgre

SQL 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 Xtra Backup, pgBackRest, WAL archiving).

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

·
• Familiarity with No

SQL databases (Mongo

DB, Redis, etc.) is a plus.

·
• Experience with cloud-based DB services (AWS RDS, Aurora, GCP Cloud SQL, Azure Database for Postgre

SQL/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 Dev Ops 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, Postgre

SQL, 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.