Senior Database Consultant, PostgreSQL

Pythian

IndiaremotePosted 1 month ago

Skill Required

Database-AdministrationPostgreSQLCloud-Database-AdministrationDatabase-MigrationDatabase-ConsultingSenior-Database-ConsultantPostgreSQL-ConsultantSenior-Database-Administrator-(SQL-NoSQL)Senior-Database-SpecialistBackup and RecoverytroubleshootingObservabilityGCPKubernetesPrometheusautomationNetwork MonitoringSnowflakeTerraformdesigningdebugginganalyticsPythonAnsibleDatadogOracledesignC++AzureCloudJavaITILShell ScriptingFulltime

Key highlights

Competitive total rewards package
Fully remote work
Annual wellness budget
Experience with PostgreSQL HA solutions (Patroni, repmgr) required
Experience with PostgreSQL backup tools (Barman, pgBackRest, etc.) required
Experience with database migrations (Oracle, MySQL, MSSQL to PostgreSQL) required

Role overview

At Pythian, we are experts in strategic database and analytics services, driving digital transformation and operational excellence. The Senior Database Consultant will provide comprehensive support for all database and application infrastructure aspects to a diverse client base. This role is crucial for delivering and consulting on services, as well as for implementing improvements and optimizations for managed services customers.

Responsibilities

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, including ensuring maximum uptime and recoverability for all databases.
Administer backup procedures and disaster recovery plans, including proactive monitoring to prevent issues, responding to alerts, and troubleshooting operational problems.
Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases.
Develop and review action plans for maintenance, deployment, and upgrades, ensuring all relevant client documentation is completed. Maintain a thorough understanding of client information, including warnings, handoffs, and briefing notes.
Develop, implement, and maintain complex data architectures (e.g., normalized and/or dimensional data models and DDL generation). Perform data transformation and migration using scripts or stored procedures.
Lead problem management efforts by assessing incidents for recurring patterns, designing technical procedures for regular requests and changes, and developing/reviewing action plans and associated documentation.
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.
Maintain alignment with client operating procedures, including change control, and manage client allotments, alerting the Team Manager to any pacing concerns.
Take on technical client affinity as assigned by the Team Manager.
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 (e.g., Initial Reviews, Performance Reviews, Audits). Focus on initiatives that increase the value Pythian provides to clients.

Requirements

Knowledge and experience in installing, configuring, and upgrading PostgreSQL databases and tools relevant to 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).
Experience with automation technologies such as Ansible, Terraform, Puppet, Chef, or SALT.
Debugging skills and the ability to troubleshoot methodically, identifying and applying fixes for known errors, and when necessary, the capacity to think outside of the box to resolve complex issues.
Very good documentation skills.
Experience with High Availability (HA) solutions for PostgreSQL, including Patroni and repmgr. The candidate should be proficient in configuring and managing automated failover, replication, and cluster health monitoring to ensure database resilience and minimal downtime.
Experience with PostgreSQL backup tools, including Barman, pgBackRest, pg_basebackup, etc. The candidate should be proficient in configuring full, incremental, and differential backups, as well as managing Point-in-Time Recovery (PITR) and WAL archiving for disaster recovery.
Experience in database migrations from different database engines, including Oracle, MySQL, and MSSQL, to PostgreSQL. Using migration tools such as ora2pg, AWS/GCP/Azure Database Migration Services (DMS), and other CDC-based techniques to ensure a smooth transition with minimal downtime.
Experience migrating between on-premises and cloud-based databases.
Experience analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post-migration.

Nice to have

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. This includes configuring monitoring solutions, analyzing performance metrics, setting up alerts, and troubleshooting database issues in cloud environments.
Experience in setting up, configuring, and administering PostgreSQL on Kubernetes.
Knowledge in monitoring and observability solutions with Prometheus and Grafana.
Experience with EnterpriseDB (EDB) solutions, such as EDB Postgres Distributed (PGD) for multi-master replication and EDB BigAnimal for managed PostgreSQL in the cloud. Familiarity with automatic failover strategies, consensus-based leader election, and cloud-based database resilience.
Experience with Debezium and Striim.

Benefits

Competitive total rewards package.
Flexible remote work from home with no daily travel requirement to an office (only a stable internet connection needed).
Collaborate with some of the best and brightest in the industry.
Substantial training allowance; participate in professional development days, attend training, become certified.
All the equipment needed to work from home, including a laptop with your choice of OS, and an annual budget to personalize your work environment.
Annual wellness budget to use on gym memberships, massages, fitness, and more.
Generous amount of paid vacation and sick days, as well as a day off to volunteer for your favorite charity.
Blog during work hours.

Additional details

The successful applicant will need to fulfill the requirements necessary to obtain a background check.
Accommodations are available upon request for candidates taking part in any aspect of the selection process.
Pythian may utilize Enterprise Generative Artificial Intelligence (AI) tools or features throughout its hiring process. These tools help manage high volumes of applications efficiently and may be employed to review applications, analyze resumes, and assist with other recruitment steps. While Pythian uses AI in its hiring process, it does not substitute for human judgment. Our Talent Acquisition Team reviews all AI-generated recommendations, and the system is subject to regular bias audits to ensure fairness and compliance with all applicable employment and human rights laws. All final hiring decisions are made by, and remain the responsibility of, human decision-makers. By applying for this position, you consent to Pythian’s use of these AI tools in the evaluation of your application. You have the right to request a human review of any solely AI-driven decision or to request an accommodation. Should you require further details regarding the processing of your data, please reach out to us.