Senior Database Engineer [PostgreSQL Expert]

Dice is seeking a seasoned Senior Database Engineer for a high-impact, short-term engagement with Medically Home. The role focuses on stabilizing a PostgreSQL instance, conducting a comprehensive health check of the database ecosystem, and refining the long-term data strategy.

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

Requirements:

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