Discovery Database Administrator (DBA) (Top Secret Clearance Req with Security Clearance

Skills and attributes for success

• Provide database administration support to include, but not limited to, the following activities:
• Aid in managing Microsoft SQL Server 2019 and 2022, including setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs.
• Apply best practices for optimizing databases.
• Aid 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 diagrams, 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 manage 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).
• Create reports using Microsoft SQL Server Reporting Services (SSRS).
• Set up a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.

Pay

$142,100 - $192,850 a year

Schedule

N/A

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

About the role

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.

Responsibilities

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

• Database administration support to include, but not limited to, the following activities:
• Aid in managing Microsoft SQL Server 2019 and 2022, including setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs.
• Apply best practices for optimizing databases.
• Aid 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 diagrams, 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 manage 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).
• Create reports using Microsoft SQL Server Reporting Services (SSRS).
• Set up a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.

Requirements

N/A

Qualifications

N/A

Skills

N/A

Benefits

N/A

Contact Government Services, LLC

Contact Government Services, LLC if you have any questions or need further information about the position. You can reach them via phone at +1 (888) 680-5916 or email at [email protected].