Senior Database Administrator
CGS Federal (Contact Government Services)
ASP.NETAWSAzureCloudMS SQL Server.NETPostgresSDLCSQLVMware
Senior Discovery Database Administrator
CGS Federal (Contact Government Services)
full-time
Posted on:
Location Type: Hybrid
Location: Atlanta • North Carolina • 🇺🇸 United States
Visit company websiteSalary
💰 $182,700 - $263,900 per year
Job Level
Senior
Tech Stack
CloudMS SQL ServerSQL
About the role
- Provide database administration support for legal accounts and company portfolio
- Manage Microsoft SQL Server 2019 and 2022 including security, tables, indexes, stored procedures, reports, and maintenance jobs
- Apply best practices to optimize database performance
- Create and maintain databases in Clustered Server environments and design/maintain data models
- Integrate data lakes, data warehouses and data marts with legacy infrastructure using metadata, data modeling, ER diagrams and query languages
- Implement server mirroring, log shipping, redundancy, high-availability, and full backup/recovery strategies
- Facilitate migration of systems into cloud infrastructure and upgrade SQL Server versions
- Develop reports using SSRS and setup/maintain reporting servers
- Own DBA functions and report development within Software Systems development Architecture and Design
Requirements
- Manage Microsoft SQL Server 2019 and 2022 (security, tables, indexes, stored procedures, SQL reports, 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 and their components
- Working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, entity relationship diagrams, schema architectures and query languages
- Implement mirror database servers, log shipping, database redundancy, high availability, and full backup and recovery for SQL Server 2019/2022
- Facilitate migration of systems into cloud infrastructure
- Upgrade SQL Servers from lower versions to 2019 and up
- Create reports using Microsoft SQL Server Reporting Services (SSRS)
- Setup a reporting server and be responsible for all DBA functions and report development
- Top Secret Clearance required
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
ATS Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Microsoft SQL Server 2019Microsoft SQL Server 2022database administrationdata modelingquery languagesSSRSdatabase performance optimizationdata lakesdata warehousesdata marts
Certifications
Top Secret Clearance