Discovery DBA: Cloud-Ready SQL Server & Data Warehouse Lead

Cgsfederal; Atlanta (GA); On-site; USD 95,000 - 140,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

Dependent Care

Commuter

Job summary

Contact Government Services, LLC seeks a Discovery Database Administrator to join its Legal team in Atlanta. The role focuses on managing Microsoft SQL Server 2019 and 2022, implementing security, backups, mirroring, and high-availability strategies.

Responsibilities include designing schemas, building reports with SSRS, migrating systems to the cloud, and maintaining data lakes and data warehouses to support the company's portfolio.

Qualifications

• Experience administering Microsoft SQL Server 2019/2022.
• Experience with data lake and data warehouse concepts.
• Experience migrating systems to cloud.

Responsibilities

• Provide database administration support for Microsoft SQL Server 2019 and 2022, including setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs.
• Assist in managing Microsoft SQL Server 2019 and 2022, applying best practices for optimizing databases.
• Assist in creating and maintaining databases in a clustered server environment, applying 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.
• Implement database mirroring, log shipping, redundancy and high availability, and full backup and recovery capabilities for Microsoft SQL Server 2019 and 2022.
• Facilitate migration of systems into cloud infrastructure.
• Upgrade SQL Servers from lower versions to the latest 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.

Skills

SQL Server administration

High availability planning

Database optimization

Security configuration

Cloud migration

Communication

Tools

SQL Server 2019/2022

SSRS

SSMS

Job description

Contact Government Services, LLC seeks a Discovery Database Administrator to join its Legal team in Atlanta. The role focuses on managing Microsoft SQL Server 2019 and 2022, implementing security, backups, mirroring, and high-availability strategies.

Responsibilities include designing schemas, building reports with SSRS, migrating systems to the cloud, and maintaining data lakes and data warehouses to support the company's portfolio.