Job Description
Design and evolve database schemas and data models to support new features, scale, and maintainability.Write, review, and optimize SQL for PostgreSQL and SQL Server:Execution plan analysis, indexing strategy, query refactors, and performance baselines.Build database-side logic and utilities:PL/pgSQL functions/procedures/triggers/views and T-SQL objects as needed.Troubleshoot complex production issues:Performance regressions, locking/blocking/deadlocks, resource contention, connectivity issues, and reliability problems.Develop operational tooling and automation in Python (required) plus Bash (preferred) and database scripting.Evaluate, test, and improve backup/restore and disaster recovery procedures:Retention, security, restore validation, and recovery runbooks.Evaluate and improve high availability / clustering approaches appropriate to Postgres, SQL Server, and ElasticSea...