Discovery Database Administrator
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Senior Discovery Database Administrator
CGS Federal (Contact Government Services)
full-time
Posted on:
Location Type: Hybrid
Location: Los Angeles • California • 🇺🇸 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
- Create and maintain databases in a Clustered Server environment and apply best practices for optimization
- Design, develop, and maintain data models and integrate data lakes, data warehouses, and data marts with legacy infrastructure
- Implement mirroring, log shipping, redundancy/high availability, and backup/recovery strategies
- Facilitate migration of systems into cloud infrastructure and upgrade SQL Server versions
- Setup reporting servers and develop SSRS reports; perform all DBA functions and report development
Requirements
- Top Secret Clearance required
- Experience managing Microsoft SQL Server 2019 and 2022
- Setting up security, creating tables, indexes, stored procedures
- Designing SQL reports and creating maintenance jobs
- Best practices for optimizing databases
- Creating and maintaining databases in a Clustered Server environment
- Design, development and maintenance of data models
- Working knowledge of data lakes, data warehouse and data mart architectures
- Metadata and data modeling, data flow, ER diagrams, schema architectures
- Proficiency with query languages (SQL)
- Experience with mirroring, log shipping, redundancy and high availability
- Full backup and recovery capabilities for SQL Server platforms
- Experience facilitating migration of systems into cloud infrastructure
- Upgrading SQL Servers from lower versions to 2019+
- Creating reports using Microsoft SQL Server Reporting Services (SSRS)
- Setting up reporting servers and performing DBA functions and report development
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 modelingquery languagesbackup and recoverydata lakesdata warehousesdata marts
Certifications
Top Secret Clearance