Senior Database Administrator II
CGS Federal (Contact Government Services)
ASP.NETAWSAzureCloudMS SQL Server.NETPostgresSDLCSQLVMware
Discovery Database Administrator, DBA
CGS Federal (Contact Government Services)
full-time
Posted on:
Location Type: Hybrid
Location: Chantilly • Virginia • 🇺🇸 United States
Visit company websiteSalary
💰 $142,100 - $192,850 per year
Job Level
Mid-LevelSenior
Tech Stack
CloudMS SQL ServerSQL
About the role
- Provide database administration support for legal discovery accounts
- Manage Microsoft SQL Server 2019 and 2022 including security, schema, stored procedures, reports, and maintenance jobs
- Create and maintain clustered server databases and data models
- Integrate solutions across legacy infrastructure using data lakes, warehouses, and marts
- Implement replication and high-availability strategies (mirroring, log shipping, backups, recovery)
- Facilitate cloud migrations and upgrade SQL Server instances to supported versions
- Setup reporting servers and develop reports using Microsoft SQL Server Reporting Services (SSRS)
- Responsible for all DBA functions and report development utilizing software systems architecture and design
Requirements
- Top Secret Clearance required
- Manage Microsoft SQL Server 2019 and 2022: security, tables, indexes, stored procedures, maintenance jobs
- Apply best practices for optimizing databases
- Create and maintain databases in a Clustered Server environment
- Expert knowledge of design, development, and maintenance of various data models
- Working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, ER diagrams, schema architectures, and query languages
- Implement database replication techniques: mirroring, log shipping, redundancy, high availability
- Full backup and recovery capabilities for Microsoft SQL Server 2019 and 2022
- Facilitate migration of systems into cloud infrastructure
- Upgrade SQL Servers from lower versions to 2019+ and create reports using SSRS
- Setup reporting servers and perform report development and all DBA functions
Benefits
- Health, Dental, and Vision
- Life Insurance
- 401k
- Flexible Spending Account (Health, Dependent Care, and Commuter)
- Paid Time Off and Observance of State/Federal Holidays
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Microsoft SQL Server 2019Microsoft SQL Server 2022database administrationstored proceduresdata modelingreport developmentdatabase replicationhigh availabilitybackup and recoverycloud migration
Certifications
Top Secret Clearance