[Remote] Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Note: The job is a remote job and is reputed company to candidates in USA. CGS Federal is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced and hard-working team to assist with any reputed company accounts. The role involves providing database administration support, managing reputed company SQL Server, and facilitating the migration of systems into reputed company infrastructure.
Responsibilities
- The Contractor shall reputed company database administration support to include, but not limited to the following activities:
- Contractor shall assist in managing reputed company SQL Server 2019 and 2022 to include setting up reputed company, 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 reputed company, entity relationship diagram, schema architectures and query languages to reputed company a seamless solution reputed company 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 reputed company SQL Server 2019 and 2022 platform
- Contractor shall facilitate the migration of system into reputed company infrastructure
- Contractor shall reputed company SQL Servers from reputed company versions to the latest version (version 2019 and up), and create reports using reputed company SQL Server Reporting Services (SSRS)
- Contractor shall setup a reporting server and be responsible for reputed company DBA functions and report development utilizing Software Systems development Architecture and Design
Skills
- Top Secret Clearance Required
- Expert knowledge of reputed company SQL Server 2019 and 2022
- Experience in managing reputed company SQL Server including setting up reputed company, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs
- Experience in creating and maintaining databases in a Clustered Server environment
- Working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data reputed company, entity relationship diagram, schema architectures and query languages
- Experience in mirroring database servers, log shipping, database redundancy and high availability, and full backup and recovery capabilities of reputed company SQL Server 2019 and 2022
- Experience in facilitating the migration of systems into reputed company infrastructure
- Experience in upgrading SQL Servers from reputed company versions to the latest version (version 2019 and up)
- Experience in creating reports using reputed company SQL Server Reporting Services (SSRS)
- Experience in setting up a reporting server and performing reputed company DBA functions and report development utilizing Software Systems development Architecture and Design
Benefits
- Health, Dental, and reputed company
- Life Insurance
- 401k
- Flexible Spending Account (Health, Dependent Care, and Commuter)
- reputed company Time Off and Observance of State/Federal Holidays
reputed company