Senior Discovery Database Administrator (DBA)

Summary

Join CGS's Legal department as a Senior Discovery Database Administrator and become a key player in supporting the company's portfolio. You will provide database administration support, manage Microsoft SQL Server environments, and contribute to database design, development, and maintenance. This role requires expertise in data modeling, data warehousing, and cloud migration. You will also be responsible for database redundancy, high availability, and backup/recovery. The position offers a comprehensive benefits package and the opportunity to contribute to government innovation. CGS values honesty, professionalism, and quality work, creating a supportive environment for professional growth.

Requirements

• Expert knowledge of Microsoft SQL Server 2019 and 2022
• Expert knowledge of data modeling, data warehousing, and cloud migration

Responsibilities

• Provide database administration support, including managing Microsoft SQL Server 2019 and 2022
• Assist in setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs
• Apply best practices for optimizing databases
• Assist in creating and maintaining databases in a Clustered Server environment
• Apply expert knowledge of the design, development, and maintenance of various data models and their components
• Apply 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 to integrate a seamless solution within legacy infrastructure
• Mirror database servers, implement log shipping, utilize latest techniques for Database redundancy and high Availability, and ensure full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform
• Facilitate the migration of systems into cloud infrastructure
• Upgrade SQL Servers from lower versions to the latest version (version 2019 and up), and create reports using Microsoft SQL Server Reporting Services (SSRS)
• Setup a reporting server and be responsible for all DBA functions 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