Sr Database Administrator

Description

The Senior Database Administrator (DBA) is a senior technical role responsible for the design, implementation, administration, and optimization of the organization’s Microsoft SQL Server and Postgre

SQL database environments. This role maintains the stability, integrity, and performance of all production and non‑production database systems while actively contributing to the design and development of database solutions supporting the Enterprise Data Warehouse and operational applications. The Senior DBA collaborates closely with Software Engineers, Data Engineers, Data Architects, and Infrastructure teams to deliver reliable, scalable data storage and movement solutions.

As the organization transitions toward cloud‑hosted infrastructure, this role will play a key part in planning and executing that migration while maintaining on‑premises environments.

• Administer, monitor, and maintain MS SQL Server (primary) and Postgre
  
  SQL (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 Postgre
  
  SQL Streaming Replication.
• Develop and maintain comprehensive backup and recovery strategies; conduct regular recovery testing to validate RPO/RTO objectives.
• Configure and manage log shipping, database mirroring, and replication topologies as appropriate.
• Maintain and test disaster recovery runbooks and failover procedures.

• Collaborate with application and data engineering teams on schema design, data modeling, and database object development (stored procedures, functions, views, triggers).
• Design and develop ETL/ELT pipelines and data movement solutions using T‑SQL, PL/pgSQL, and Python.
• Analyze data requirements and translate them into optimized, scalable database designs consistent with enterprise data warehouse best practices.
• Review and validate database‑related code from development teams; participate in code reviews and enforce standards.
• Develop and maintain data dictionaries, database documentation, and architectural diagrams.

• Manage on‑premises database infrastructure including patching, upgrades, and configuration management.
• Support cloud readiness initiatives; contribute to planning and executing database migrations to cloud platforms (Azure SQL, AWS RDS/Aurora, or equivalent).
• Work with IaC tooling (Terraform or equivalent) to define and version‑control database infrastructure.
• Participate in CI/CD pipeline design for database change management (schema migrations, release automation).
• Collaborate with infrastructure and Dev Ops teams on environment provisioning, monitoring, and alerting.

• Develop Python‑based data pipeline and ETL solutions for data ingestion, transformation, and loading workflows.
• Write automation scripts for routine DBA tasks including health checks, backup validation, and alerting.
• Integrate database workflows with orchestration tools and data platform components.

• Work within an Agile/Scrum framework; participate in sprint planning, stand‑ups, retrospectives, and backlog grooming.
• Collaborate with cross‑functional Agile teams as well as independently managing assigned work items.
• Perform and coordinate unit and integration testing for database changes.
• Troubleshoot database application issues and resolve defects in a timely manner.
• Escalate issues and impediments proactively; communicate clearly in both technical and non‑technical terms.
• Update and maintain database runbooks,…