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). Requirements 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). #J-18808-Ljbffr