Senior Database Consultant, PostgreSQL

Pythian

Senior Database Consultant providing comprehensive support for all database aspects at Pythian. Collaborating with a diverse client base and leading improvements in managed services.

Posted 5/14/2026full-timeRemote • 🇷🇴 RomaniaSeniorWebsite

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
Delivering and consulting on services, as well as for implementing improvements and optimizations for managed services customers
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
Oversee backup, clustering, mirroring, replication, failover, and 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
Participate equally in the team’s on call rotation, typically one weekend per month
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
Participate in and, at times, lead efforts to suggest, recommend, and potentially design/implement new monitoring checks, enhancements to DBC toolkits, and other process improvements

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 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
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
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, as well as a day off to volunteer for your favorite charity

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++JavaGoAnsibleTerraformHigh Availability

Soft Skills

problem managementdocumentationcollaborationtroubleshootingclient communicationprocess improvementanalytical skillsteam participationcommitment managementincident assessment