Information Systems Specialist

Sr. Information Systems Specialist

Local DMV candidates only.

Candidate must be able to work onsite in Washington, DC.

Engagement is through the end of the year, with the possibility of extension.

Position 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.