Senior Database Consultant, PostgreSQL

Pythian

Senior Database Consultant providing comprehensive database support and solutions for clients at Pythian. Aiming to enhance operational procedures and ensure data integrity.

Posted 5/14/2026full-timeRemote • 🇲🇰 North MacedoniaSeniorWebsite

Tech Stack

Tools & technologies

AnsibleAWSAzureChefCloudGoGoogle Cloud PlatformGrafanaJavaKubernetesMySQLOraclePostgresPrometheusPuppetPythonSaltStackSQLTerraform

About the role

Key responsibilities & impact

Provide comprehensive support for all database and application infrastructure aspects to a diverse client base
Coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance
Analyze client infrastructure and processes, recommending best practices to enhance current operational procedures
Administer backup procedures and disaster recovery plans, involving proactive monitoring to prevent issues
Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases
Develop and review action plans for maintenance, deployment, and upgrades
Develop, implement, and maintain complex data architectures (e.g., normalized and/or dimensional data models and DDL generation)
Lead problem management efforts by assessing incidents for recurring patterns
Make, manage, and meet client commitments in collaboration with team members
Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries
Maintain alignment with client operating procedures
Participate in and, at times, lead efforts to suggest, recommend, and potentially design/implement new monitoring checks

Requirements

What you’ll need

Knowledge and experience in installing, configuring and upgrading PostgreSQL databases & tools relevant in PostgreSQL Administration
Experience administering PostgreSQL in virtualized and cloud environments, especially AWS, GCP or Azure
Experience with scripting (bash/python) and software development (C++, Java, Go)
Automation technologies such as Ansible, Terraform, Puppet, Chef, SALT experience
Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, capacity to think outside of the box to resolve complex issues
Very good documentation skills
Nice to haves include; Understanding of current IT service standards such as ITIL
Being a contributor to projects relevant to PostgreSQL, or other database or infrastructure software
Hands-on experience in monitoring PostgreSQL databases using industry-standard tools such as Prometheus, Grafana, SolarWinds, pgAdmin, Zabbix, Nagios and Datadog
Experience with cloud-native and managed database monitoring tools, including AWS CloudWatch, Google Cloud Operations (Stackdriver), and Azure Monitor
Experience in setting up, configuring, and administering PostgreSQL on Kubernetes is a nice-to-have
Knowledge in monitoring and observability solutions with Prometheus, Grafana is a nice-to-have
Experience with High Availability (HA) solutions for PostgreSQL, including Patroni, and repmgr, is required
Experience with PostgreSQL backup tools, including Barman, pgBackRest, pg_basebackup, etc. is required
Experience in database migrations from different database engines, including Oracle, MySQL, and MSSQL, to PostgreSQL
Experience migrating between on-premises and cloud-based databases
Experience analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post-migration
Experience with Debezium and Striim is not mandatory but beneficial

Benefits

Comp & perks

Competitive total rewards package
Blog during work hours; take a day off and volunteer for your favorite charity
Flexibly work remotely from your home, there’s no daily travel requirement to an office!
Collaborate with some of the best and brightest in the industry!
Hone your skills or learn new ones with our substantial training allowance; participate in professional development days, attend training, become certified, whatever you like!
We give you all the equipment you need to work from home including a laptop with your choice of OS, and an annual budget to personalize your work environment!
Pythian cares about the health and well-being of our team. You will have an annual wellness budget to make yourself a priority (use it on gym memberships, massages, fitness and more)
A generous amount of paid vacation and sick days

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PostgreSQLscriptingbashpythonC++JavaGoHigh Availability (HA)database migrationsperformance tuning

Soft Skills

problem managementdocumentationcollaborationclient communicationanalytical skillstroubleshootingproactive monitoringbest practices recommendationincident assessmentcommitment management

Certifications

ITIL