Senior Discovery Database Administrator
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Discovery Database Administrator, DBA
CGS Federal (Contact Government Services)
full-time
Posted on:
Location Type: Hybrid
Location: Los Angeles • California • 🇺🇸 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 including security, schema and stored procedures for legal accounts
- Manage Microsoft SQL Server 2019 and 2022 environments including optimization and maintenance jobs
- Create and maintain databases in clustered server environments and design data models
- Implement data lake, data warehouse and data mart integrations within 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
- Set up reporting servers and develop reports using Microsoft SQL Server Reporting Services (SSRS)
- Responsible for all DBA functions and report development utilizing Software Systems development architecture and design
Requirements
- Top Secret Clearance required
- Experience managing Microsoft SQL Server 2019 and 2022
- Setting up security, creating tables, indexes, and stored procedures
- Designing SQL reports and creating maintenance jobs
- Experience creating and maintaining databases in a Clustered Server environment
- Working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling
- Knowledge of data flow, entity relationship diagrams, schema architectures and query languages
- Experience with database mirroring, log shipping, redundancy and high availability techniques
- Full backup and recovery capabilities for Microsoft SQL Server
- Experience facilitating migration of systems into cloud infrastructure
- Experience upgrading SQL Server versions and creating reports using SSRS
- Experience setting up reporting servers and 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 lakedata warehousedata martdatabase mirroringlog shippingbackup and recovery
Certifications
Top Secret Clearance
Similar jobs on JobTailor
Discovery Database Administrator
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Senior Discovery Database Administrator, DBA
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Senior Database Administrator
CGS Federal (Contact Government Services)
ASP.NETAWSAzureCloudMS SQL Server.NETPostgresSDLCSQLVMware