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 PostgreSQL database environments.
Requirements
- 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.
- 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 DevOps 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, standards documentation, and operational procedures.
Benefits
- Comprehensive benefits package
- Incentive compensation plan
- Discretionary profit sharing bonus program
