Data Base Administrator (DBA MySQL/PostgreSQL 8+ years -Consultant) Job ID: 2692

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.

#J-18808-Ljbffr