EI
Sr. Information Systems Specialist
Expert In Recruitment Solutions
πΊπΈ United States
On-site
Senior
1 month ago
- PostgreSQL
- Devops
- IaC
- GitLab CI/CD
- PowerShell
- Ansible
- FISMA
- CI/CD
- GitLab
- T-SQL
- Disaster Recovery
1 month ago
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 deliverdatabase 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.
Sr. Information Systems Specialist Β· Expert In Recruitment Solutions