Senior Discovery Database Administrator
CGS Federal (Contact Government Services)
CloudMS SQL ServerSQL
Senior Discovery Database Administrator, DBA
CGS Federal (Contact Government Services)
full-time
Posted on:
Location Type: Hybrid
Location: Dallas • Texas • 🇺🇸 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 data model best practices
- Integrate data lake/warehouse/mart architectures, metadata, data modeling, and schema designs within legacy infrastructure
- Implement mirroring, log shipping, redundancy, high availability, and backup/recovery strategies for SQL Server
- Facilitate migration of systems into cloud infrastructure and upgrade SQL Server versions
- Setup reporting servers, develop SSRS reports, and handle all DBA functions and report development
Requirements
- Top Secret Clearance Required
- Database administration support experience with Microsoft SQL Server 2019 and 2022
- Experience setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs
- Best practices for optimizing databases
- Experience creating and maintaining 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 diagram, schema architectures and query languages
- Experience with mirroring database servers, log shipping, database redundancy, high availability, and full backup and recovery for MS SQL Server
- Experience facilitating migration of systems into cloud infrastructure
- Experience upgrading SQL Servers to 2019+ and creating reports using Microsoft SQL Server Reporting Services (SSRS)
- Experience setting up reporting servers and report development utilizing Software Systems development Architecture and Design
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 administrationdata modelingstored proceduresSSRS reportsbackup and recoveryhigh availabilitylog shippingdata lake architecture
Certifications
Top Secret Clearance