Pythian

Senior Database Consultant, PostgreSQL

Pythian

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇨🇦 Canada

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AnsibleAWSAzureChefCloudGoGoogle Cloud PlatformGrafanaJavaKubernetesMySQLOraclePostgresPrometheusPuppetPythonSaltStackSQLTerraform

About the role

  • Database Management & Technical Expertise: Solution Design & Implementation: Coordinate, analyze, design, implement, and administer IT solutions, including database server configuration and ongoing maintenance.
  • Infrastructure Analysis & Improvement: Analyze client infrastructure and processes, recommending best practices to enhance current operational procedures. This includes ensuring maximum uptime and recoverability for all databases.
  • Backup & Disaster Recovery: Administer backup procedures and disaster recovery plans. This involves proactive monitoring to prevent issues, responding to alerts, and troubleshooting operational problems.
  • Data Integrity & Recovery: Oversee backup, clustering, mirroring, replication, failover, and the restoration of corrupted databases.
  • Action Plan Development: Develop and review action plans for maintenance, deployment, and upgrades, ensuring all relevant client documentation is completed.
  • Data Architecture: 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.
  • Problem Management: 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.
  • Oncall: Participate equally in the team’s on call rotation, typically one weekend per month.
  • Client Engagement & Communication: Client Commitments: Make, manage, and meet client commitments in collaboration with team members.
  • Reporting & Communication: Prepare client status and incident reports, review client reports regularly, and respond to client requests and inquiries.
  • Client Alignment: Maintain alignment with client operating procedures, including change control, and manage client allotments, alerting the Team Manager to any pacing concerns.
  • Technical Client Affinity: Take on technical client affinity as assigned by the Team Manager.
  • Process Improvement: Innovation & Improvement: 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

  • 10+ years of related experience
  • 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.
  • 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. is required.
  • Experience in database migrations from different database engines, including Oracle, MySQL, and MSSQL, to PostgreSQL.
  • Experience with 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 analyzing and optimizing schema conversions, SQL compatibility issues, and performance tuning post-migration.
  • Experience with Debezium and Striim is not mandatory but beneficial.
Benefits
  • 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!
  • 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!
  • 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, as well as a day off to volunteer for your favourite charity.

Applicant Tracking System Keywords

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

Hard skills
PostgreSQL administrationscriptingautomation technologiesHigh Availability (HA) solutionsdatabase migrationsdatabase backup toolsmonitoring PostgreSQL databasesdata architecturetroubleshootingdata integrity
Soft skills
documentation skillsclient engagementproblem managementprocess improvementcommunicationcollaborationanalytical skillsinnovationleadershiporganizational skills