Sr. Information Systems Specialist

Expert In Recruitment Solutions
  • Washington, DC
  • Quick Apply
4 days ago

Job Description

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 experience

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
  1. 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.
  2. 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.
  3. Develop PowerShell scripts and T-SQL stored procedures to automate routine tasks
  4. Automate routine maintenance — backups, health checks, patch cycles, drift remediation.
  5. Embed security and compliance in the pipeline: vulnerability scanning, hardening, and FISMA control evidence supporting the PostgreSQL ATO.
  6. Documentation, runbooks, and knowledge transfer.
  7. Database Administration & Operations
    1. Install, configure, upgrade, and maintain SQL Server instances (2019/2022/2025) across development, test, and production environments
    2. Manage database backups, restores, and disaster recovery procedures
    3. Monitor database performance, capacity, and availability using native tools and third-party monitoring solutions
    4. Perform routine maintenance: index optimization, statistics updates, integrity checks (DBCC CHECKDB)
    5. Manage database security: user accounts, roles, permissions, encryption (TDE/Always Encrypted)
    6. Strong experience with Performance Tuning and Optimization.

Numbers & Facts

LocationWashington, DC

Skills

  • Ansibleunmatched
  • Automationunmatched
  • Build Managementunmatched
  • Cloud Computingunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Cryptographyunmatched
  • Data Recoveryunmatched
  • Database Administrationunmatched
  • Database Backupunmatched
  • Database Programmingunmatched
  • Database Technologyunmatched
  • DevOpsunmatched
  • Disaster Recoveryunmatched
  • Documentationunmatched
  • FISMA - Federal Information Security Management Actunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • Knowledge Transferunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft SQL Server DBA (Database Administration)unmatched
  • Microsoft Transact-SQL (T-SQL)unmatched
  • Performance Analysisunmatched
  • Performance Tuning/Optimizationunmatched
  • PostgreSQLunmatched
  • Production Systemsunmatched
  • Scripting (Scripting Languages)unmatched
  • Security Monitoringunmatched
  • Software Patchesunmatched
  • Statisticsunmatched
  • Stored Proceduresunmatched
  • Systems Administration/Managementunmatched
  • Test Plan/Scheduleunmatched
  • Vulnerability Scannersunmatched
  • Windows PowerShellunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder