Senior Database Engineer [PostgreSQL Expert]

Senior Database Engineer [PostgreSQL Expert]

Posted 4 days ago by Highbrow

Negotiable
Undetermined
Remote
Remote

Summary: We are looking for a Senior Database Engineer with over 8 years of experience, specializing in PostgreSQL, to engage in a short-term contract aimed at stabilizing a PostgreSQL instance and enhancing our database ecosystem. The role involves urgent problem-solving, infrastructure audits, and strategic recommendations for long-term data management. The candidate will also be responsible for performance tuning and ensuring data integrity through robust backup protocols. This position requires both technical expertise and the ability to communicate findings effectively to stakeholders.

Key Responsibilities:

  • Diagnose and resolve a specific, high-priority performance/stability issue currently affecting a primary PostgreSQL instance.
  • Review current DBaaS providers and configurations to evaluate hosting strategy for scaling needs.
  • Conduct a deep-dive audit of backup protocols and restoration strategies to ensure zero-data-loss integrity.
  • Audit general DB usage across the fleet, identify missing or redundant indexes, and implement query tuning.
  • Optimize schema design where bottlenecks are identified.
  • Review current monitoring and alerting stack; implement or suggest improvements.
  • Provide a comprehensive "State of the Union" report on database health, including a prioritized list of technical debt and architectural improvements.

Key Skills:

  • 8+ years of experience in Database Engineering/Administration.
  • Mastery of PostgreSQL.
  • Deep familiarity with cloud database environments (DBaaS).
  • Proven track record of optimizing complex queries and managing large-scale production databases.
  • Ability to translate technical findings into actionable business recommendations.

Salary (Rate): £50

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Location: Remote

Duration: 2+ months contract
Client: Medically Home

Job Description:

Qualifications:

Experience: 8+ years of experience in Database Engineering/Administration, with a mastery of PostgreSQL.
DBaaS Expertise: Deep familiarity with cloud database environments (PostgreSQL).
Performance Tuning: Proven track record of optimizing complex queries and managing large-scale production databases
Communication: Ability to translate technical findings into actionable business recommendations for stakeholders.

Job Responsibilities:

Role Overview:

We are seeking a seasoned Senior Database Engineer to join us for a high-impact, short-term engagement. Our goal is to stabilize a specific PostgreSQL instance, conduct a comprehensive "Health Check" of our entire database ecosystem, and refine our long-term data strategy.
You will act as both a forensic specialist and a strategic advisor, moving from immediate firefighting to long-term architectural recommendations.

Key Responsibilities:

Urgent Problem Solving: Diagnose and resolve a specific, high-priority performance/stability issue currently affecting a primary PostgreSQL instance.
Infrastructure Audit: Review our current DBaaS providers and configurations. Evaluate if our current hosting strategy meets our scaling needs or if migration/optimization is necessary.
Reliability & Disaster Recovery: Conduct a deep-dive audit of our backup protocols and restoration strategies to ensure zero-data-loss integrity.
Performance Engineering: Audit general DB usage across the fleet.
Identify missing or redundant indexes and implement query tuning.
Optimize schema design where bottlenecks are identified.
Observability: Review our current monitoring and alerting stack; implement or suggest improvements to ensure we catch issues before they impact users.
Strategic Roadmap: Provide a comprehensive "State of the Union" report on our database health, including a prioritized list of technical debt and architectural improvements.