CGS Federal (Contact Government Services) · 5 months ago
Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)
CGS Federal is dedicated to solving the government’s most dynamic problems with cutting-edge technology, and they are seeking a Senior Discovery Database Administrator to assist with various legal accounts. In this role, you will provide database administration support, manage Microsoft SQL Server environments, and facilitate the migration of systems into cloud infrastructure.
ConsultingInformation TechnologyLegalProfessional ServicesProject ManagementSoftware
Responsibilities
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
Qualification
Required
Top Secret Clearance Required
Database administration support including managing Microsoft SQL Server 2019 and 2022
Setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs
Expert knowledge of the 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
Mirroring 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
Facilitating the migration of system into cloud infrastructure
Upgrading SQL Servers from lower versions to the latest version (version 2019 and up)
Creating reports using Microsoft SQL Server Reporting Services (SSRS)
Setting up a reporting server and 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
Company
CGS Federal (Contact Government Services)
Contact Government Services strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources.