Full-Time

Discovery Database Administrator

Database Administrator

CGS Federal (Contact Government Services)

CGS Federal (Contact Government Services)

Federal professional services

Compensation Overview

$142.1k - $192.8k/yr

Dallas, TX, USA

Hybrid

Category
DevOps & Infrastructure (1)
Required Skills
Data Lake
SQL

Get referred to CGS Federal (Contact Government Services)

See people who can refer or advise you

Requirements
  • Experience managing Microsoft SQL Server 2019 and Microsoft SQL Server 2022, including 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, and experience 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 flow, entity relationship diagram, schema architectures and query languages to integrate a seamless solution within legacy infrastructure.
  • Experience 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.
  • Experience facilitating the migration of systems into cloud infrastructure.
  • Experience upgrading SQL Servers from lower versions to the latest version (version 2019 and up), and creating reports using Microsoft SQL Server Reporting Services (SSRS).
  • Setup a reporting server and responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.
Responsibilities
  • Provide database administration support to include but not limited to the following activities: assisting in managing Microsoft SQL Server 2019 and 2022, setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs.
  • Assist in creating and maintaining databases in a Clustered Server environment with expert knowledge of 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 diagram, schema architectures and query languages to integrate solutions within legacy infrastructure.
  • Mirror database servers, implement log shipping, and apply latest techniques for database redundancy and high availability, including full backup and recovery of SQL Server 2019 and 2022.
  • Facilitate the migration of systems into cloud infrastructure.
  • Upgrade SQL Servers to the latest version (2019 and up) and create reports using SSRS.
  • Setup a reporting server and perform all DBA functions and report development.
CGS Federal (Contact Government Services)

CGS Federal (Contact Government Services)

View

CGS Federal (Contact Government Services) is a government contractor providing professional and technology services to public agencies. The company supports federal programs with information technology, litigation support, records work, data services, cybersecurity, and program operations. It serves federal agencies, legal teams, public-sector program leaders, and mission-oriented operating units. Its operating model centers on contract teams embedded in regulated government environments and supported by recruiting, security, delivery, and corporate operations. Teams work across software, infrastructure, cybersecurity, legal support, data, project management, recruiting, and administration. Teams support coordinated daily delivery.

Company Size

N/A

Company Stage

N/A

Total Funding

N/A

Headquarters

N/A

Founded

N/A

Get referred to CGS Federal (Contact Government Services)

See people who can refer or advise you