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

CGS Federal (Contact Government Services) · Baltimore, MD · 1 mo ago

Information Technology$142k–$193k/yrFull-time

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, 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.
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).
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

Full-Time, Executive-Level

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. 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.

Responsibilities

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, 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.
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).
Set up a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.

Requirements

Must apply best practices for optimizing databases.

Must apply expert knowledge of the design, development, and maintenance of various data models and their components.

Must 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.

Must 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.

Must facilitate the migration of systems into cloud infrastructure.

Must upgrade SQL Servers from lower versions to the latest version (version 2019 and up), and create reports using Microsoft SQL Server Reporting Services (SSRS).

Must set up a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.

Qualifications

Must have a bachelor’s degree in Computer Science, Information Technology, or a related field.

Must have at least 5 years of experience in database administration, preferably with Microsoft SQL Server.

Must have strong problem-solving skills and the ability to work independently and as part of a team.

Must have excellent communication and interpersonal skills.

Must have experience with data modeling, data warehousing, and data analytics.

Must have experience with cloud computing platforms such as AWS, Azure, or Google Cloud.

Must have experience with data migration and integration processes.

Must have experience with SQL Server Reporting Services (SSRS).

Must have experience with software development architecture and design.

Must have experience with data lake and data mart architectures.

Must have experience with Entity Relationship Diagrams (ERD).

Must have experience with database redundancy and high Availability techniques.

Must have experience with full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform.

Must have experience with cloud migration and integration processes.

Must have experience with Software Systems development Architecture and Design.

Must have experience with data flow and query languages.

Must have experience with data modeling and data warehousing.

Must have experience with data analytics and data visualization.