Discovery Database Administrator DBA Top Secret Clearance Required - cgsfederal

OpenTalent; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Job summary

CGS, a Government Services division, seeks a dedicated Discovery Database Administrator to join a fast-paced team in supporting legal accounts. The role emphasizes SQL Server administration, reporting, security, and data architecture within a modern data ecosystem.

As part of the Legal department, you will help design, maintain, and optimize databases, execute backups, and contribute to migrations toward cloud infrastructure while ensuring high availability and robust data delivery.

Responsibilities

• Provide database administration support for Microsoft SQL Server environments (2019/2022).
• Set up security, create tables/indexes/stored procedures, and design SQL reports.
• Maintain databases in clustered server environments and design data models.
• Assist in data lake/warehouse/mart architectures and data integration.
• Ensure replication, log shipping, backup/recovery, and high availability.

Skills

SQL Server administration

Database design

Query optimization

SSRS report development

Backup and recovery

Tools

SQL Server 2019

SQL Server 2022

SSRS

Data lakes

Data warehouse

Job description

Discovery Database Administrator (DBA)

Employment Type: Full-Time, Executive-Level

Department: Legal

CGS is seeking a dedicated Discovery Database Administrator to join a fast-paced and hard-working team to assist with any legal accounts. As a Discovery Database Administrator, you will play a key role in supporting various aspects of the company's portfolio.

CGS brings motivated, highly skilled, and creative people together to solve the government’s most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities.

Skills and attributes for success:

The Contractor shall provide the following services to include but not limited to:

• - The Contractor shall provide database administration support to include, but not limited to the following activities:
• - Contractor shall assist in managing Microsoft SQL Server 2019 and 2022 to include setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs etc. Must apply best practices for optimizing databases;
• - Contractor shall assist in creating and maintaining databases in a Clustered Server environment. Must apply expert knowledge of the design, development and maintenance of various data models and their components;
• - Contractor shall 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;
• - Contractor shall mirror database servers, log shipping, latest techniques for Database redundancy and high Availability, and full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform;
• - Contractor shall facilitate the migration of system into cloud infrastructure.
• - Contractor shall upgrade SQL Servers from lower versions to the latest version (version 2019 and up), and create reports using Microsoft SQL Server Reporting Services (SSRS);
• - Contractor shall setup a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.

Our Commitment:

Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client’s specific needs. We are committed to solving the most challenging and dynamic problems.