Pythian

Senior Database Consultant, PostgreSQL

Pythian

full-time

Posted on:

Location Type: Remote

Location: Canada

Visit company website

Explore more

✨ 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 & Tools
PostgreSQL administrationscriptingautomation technologiesHigh Availability (HA) solutionsdatabase migrationsdatabase backup toolsmonitoring PostgreSQL databasesdata architecturetroubleshootingdata integrity
Soft Skills
documentation skillsclient engagementproblem managementprocess improvementcommunicationcollaborationanalytical skillsinnovationleadershiporganizational skills