Job Details

Job Overview:

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.

• 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.