Title: Sr. Information Systems Specialist
Location: onsite in Washington, DC - Local DMV candidates only
Client is looking for a senior SQL Server/PostgreSQL Database Engineer with strong DBA, DevOps, Infrastructure as Code (IaC), GitLab CI/CD, PowerShell/Ansible automation, and database performance tuning experiencePosition Requirements:Provide a senior engineer to deliver
database server administration for the Board's on-premises SQL Server and PostgreSQL environments as automated, FISMA-compliant code — supporting the PostgreSQL ATO, cloud-readiness, and platform modernization.
Tasks
- Design and implement CI/CD pipelines in GitLab for database server and instance builds, version upgrades, patching, cumulative updates, and configuration changes across SQL Server and PostgreSQL server enterprise service offerings.
- Develop and maintain Infrastructure as Code (Powershell, Ansible playbooks/roles executed via AAP; IaC modules) to provision, configure, and enforce desired state for on-premises database servers.
- Develop PowerShell scripts and T-SQL stored procedures to automate routine tasks
- Automate routine maintenance — backups, health checks, patch cycles, drift remediation.
- Embed security and compliance in the pipeline: vulnerability scanning, hardening, and FISMA control evidence supporting the PostgreSQL ATO.
- Documentation, runbooks, and knowledge transfer.
- Database Administration & Operations
- Install, configure, upgrade, and maintain SQL Server instances (2019/2022/2025) across development, test, and production environments
- Manage database backups, restores, and disaster recovery procedures
- Monitor database performance, capacity, and availability using native tools and third-party monitoring solutions
- Perform routine maintenance: index optimization, statistics updates, integrity checks (DBCC CHECKDB)
- Manage database security: user accounts, roles, permissions, encryption (TDE/Always Encrypted)
- Strong experience with Performance Tuning and Optimization.