Job Summary:
CGS Federal is a company dedicated to solving government’s dynamic problems through innovative technology. They are seeking a Senior Discovery Database Administrator to provide database administration support, manage Microsoft SQL Server environments, and facilitate cloud migrations among other responsibilities.
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.
Qualifications:
Required:
• Top Secret Clearance Required
• Experience in managing Microsoft SQL Server 2019 and 2022
• Ability to set up security, create tables, indexes, stored procedures, design SQL reports, and create 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
• Knowledge of metadata and data modeling, data flow, entity relationship diagram, schema architectures, and query languages
• Experience in mirroring database servers, log shipping, and techniques for database redundancy and high availability
• Full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform
• Experience in facilitating the migration of systems into cloud infrastructure
• Ability to upgrade SQL Servers from lower versions to the latest version (version 2019 and up)
• Experience in creating reports using Microsoft SQL Server Reporting Services (SSRS)
• Ability to set up a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design
Company:
Contact Government Services strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. Founded in , the company is headquartered in Washington, USA, with a team of 51-200 employees. The company is currently Growth Stage.