Description

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

Key Skills

Education

Bachelor's degree