Senior Database Administrator (PostgreSQL & MySQL Focus)

GeoAlpha Solutions; Georgia; On-site; USD 110,000 - 165,000; Full time

Job summary

GeoAlpha Solutions seeks a Senior Database Administrator to design, deploy, and optimize PostgreSQL and MySQL in production, spanning on‑premises and cloud environments.

Ideal candidates will work with AWS, GCP, or Azure managed services, lead migrations, and collaborate with DevOps and data teams on performance, security, and automation.

Qualifications

• 3+ years of hands-on PostgreSQL in production environments.
• 3+ years of MySQL in production environments.
• Experience with at least one public cloud platform (AWS, GCP, or Azure), including managed services (e.g., RDS, Cloud SQL).
• Strong SQL skills with indexing, query optimization, and partitioning.
• Proven knowledge of backup & recovery strategies, replication, and high-availability configurations.
• Proficiency in scripting and automation (Bash, Python, Ansible).
• Experience supporting database migration projects (e.g., PostgreSQL to cloud, MongoDB to Atlas, SQL Server upgrades).

Responsibilities

• Design, configure, and maintain PostgreSQL and MySQL databases in production environments.
• Ensure high availability, disaster recovery, and performance optimization of database systems.
• Perform database migrations (on-premises to cloud and cross-cloud environments).
• Troubleshoot and resolve database issues across development, testing, and production environments.
• Implement database monitoring, backup strategies, and security best practices.
• Collaborate with development, DevOps, and data teams on schema design, query tuning, and ETL pipelines.
• Participate in capacity planning, cost optimization, and automation initiatives.
• Document database systems, configurations, procedures, and runbooks.

Skills

PostgreSQL

MySQL

Cloud platforms

SQL

Backup & recovery

Scripting & automation

Database migrations

NoSQL familiarity

ETL / data warehousing

Certifications

DevOps exposure

Job description

We are seeking a Senior Database Administrator with strong expertise in PostgreSQL and MySQL to join our team.

The ideal candidate is a hands‑on professional capable of designing, deploying, maintaining, and optimizing highly available and scalable database systems. Experience with additional database technologies such as SQL Server and MongoDB is a strong advantage.

This role also involves working with cloud‑native database services across providers such as AWS, Google Cloud, or Azure. Candidates with database migration experience will be given preference.

Key Responsibilities

• Design, configure, and maintain PostgreSQL and MySQL databases in production environments
• Ensure high availability, disaster recovery, and performance optimization of database systems
• Perform database migrations (on‑premises to cloud and cross‑cloud environments)
• Troubleshoot and resolve database issues across development, testing, and production environments
• Implement database monitoring, backup strategies, and security best practices
• Collaborate with development, DevOps, and data teams on schema design, query tuning, and ETL pipelines
• Participate in capacity planning, cost optimization, and automation initiatives
• Document database systems, configurations, procedures, and runbooks

Required Qualifications

• 3+ years of hands‑on experience with PostgreSQL in production environments
• 3+ years of experience with MySQL
• Experience with at least one public cloud platform (AWS, GCP, or Azure), including managed database services (e.g., RDS, Cloud SQL)
• Strong SQL skills with a solid understanding of indexing, query optimization, and partitioning
• Proven knowledge of backup & recovery strategies, replication, and high‑availability configurations
• Proficiency in scripting and automation (e.g., Bash, Python, Ansible)
• Experience supporting database migration projects (e.g., PostgreSQL to cloud, MongoDB to Atlas, SQL Server upgrades)

Advantageous Qualifications

• Familiarity with MongoDB, SQL Server, Neo4j, or other NoSQL databases
• Experience with ETL tools, BigQuery, or data warehousing concepts
• Relevant certifications (PostgreSQL, MySQL, AWS, GCP, or Azure)
• Exposure to DevOps practices and infrastructure‑as‑code tools

Soft Skills

• Strong problem-solving and analytical skills
• Ability to work both independently and collaboratively in cross‑functional teams
• Excellent communication and documentation skills