Senior Database Administrator

Responsibilities

• Administer, monitor, and maintain MS SQL Server (primary) and PostgreSQL (secondary) database environments across development, QA, and production.
• Manage and optimize query performance through index tuning, execution plan analysis, statistics management, and query rewrites.
• Implement and maintain database security, including role-based access control, auditing, and encryption at rest and in transit.
• Manage database capacity planning, storage allocation, and growth forecasting.
• Perform routine database maintenance including integrity checks, index rebuilding/reorganization, and statistics updates.
• Design, implement, and maintain HA/DR solutions including SQL Server Always On Availability Groups, Failover Clustering, and PostgreSQL Streaming Replication.
• Develop and maintain comprehensive backup and recovery strategies; conduct regular recovery testing to validate RPO/RTO objectives.
• Collaborate with application and data engineering teams on schema design, data modeling, and database object development (stored procedures, functions, views, triggers).

• A Bachelor's Degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
• 10+ years of experience in information technology, preferably within financial services or another highly regulated industry.
• 7+ years of hands‑on database administration experience with MS SQL Server as the primary platform.
• 3+ years of PostgreSQL administration and development experience.
• 3+ years of Python development experience focused on data pipelines and ETL.
• 3+ years of experience working within an Agile environment.
• Demonstrated experience with HA/DR technologies including Always On Availability Groups, Failover Clustering, and PostgreSQL replication.
• Experience with infrastructure-as-code tooling (Terraform or equivalent) and CI/CD pipeline participation.
• Microsoft Certified:
  Azure Database Administrator Associate or equivalent SQL Server certification (preferred).
• Experience with cloud database services (Azure SQL Managed Instance, AWS RDS for SQL Server or PostgreSQL, or equivalent).