Schema Design: Develop and maintain scalable database schemas ensuring strict adherence to normalization and data integrity principles.
Optimization Leadership: Analyze and optimize advanced SQL queries to ensure maximum efficiency across massive data volumes.
Security Governance: Oversee the security landscape of the database, proactively monitoring for vulnerabilities and managing sophisticated access controls.
Operational Oversight: Manage daily operations, including health monitoring, capacity planning, and ensuring disaster recovery readiness.
Technical Documentation: Create comprehensive architectural blueprints, data dictionaries, and best-practice guidelines for development teams.
Required Skills::
Experience: 10+ years of professional experience with a primary focus on PostgreSQL at an enterprise scale.
Strategic Thinking: Strong ability to design database structures that align with long-term business growth and technical scalability.
Tooling Expertise: Hands-on experience with industry-standard monitoring tools (e.g., pgBadger, Prometheus, Grafana) and management systems.
Communication: Excellent interpersonal skills to lead multidisciplinary teams and present architectural solutions to stakeholders.