Data Base Administrator (DBA MySQLPostgreSQL 8+ years Consultant)

Work set-up: 
Full Remote
Contract: 
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Minimum 8 years of experience as a Database Administrator in large-scale environments., Expertise in MySQL 8+ and PostgreSQL database management., Hands-on experience with replication, clustering, and high availability solutions., Strong skills in performance tuning, security, and backup strategies..

Key responsibilities:

  • Design, install, and maintain MySQL and PostgreSQL database systems.
  • Implement high availability, replication, and disaster recovery solutions.
  • Monitor and optimize database performance and troubleshoot issues.
  • Collaborate with development and DevOps teams to improve database schemas and queries.

Panasa Tech logo
Panasa Tech
51 - 200 Employees
See all jobs

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 largescale database systems. The ideal candidate should have proven experience in highavailability 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 largescale, highvolume 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 largescale environments.

· • Strong expertise in MySQL 8+ and PostgreSQL administration.

· • Handson 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 cloudbased DB services (AWS RDS, Aurora, GCP Cloud SQL, Azure Database for PostgreSQLMySQL).

· • Proven capacity planning, scaling strategies, and experience with largevolume transaction systems.

· • Strong understanding of database security best practices (encryption, auditing, rolebased access).

· • Proficiency in Linux system administration related to database hosting.

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

· • Familiarity with DevOps practices, CICD 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 problemsolving and analytical skills.

· • Excellent communication and documentation abilities.

· • Ability to collaborate effectively with crossfunctional teams.

· • Proactive mindset with a focus on continuous improvement.

Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Collaboration
  • Communication
  • Analytical Skills
  • Problem Solving

Related jobs