Senior Discovery DBA - SQL Server, Data Lakes & HA Expert

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

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Life insurance

401k

FSA - Health/DC/Commuter

Paid time off

Holidays

Job summary

CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced team supporting legal accounts. You will provide database administration, develop SQL reports, and maintain security and maintenance jobs across SQL Server 2019 and 2022.

You will assist in clustering, data modeling, and migrating systems to cloud infrastructure, while ensuring high availability, backups, and scalable data architectures.

Qualifications

• Experience administering Microsoft SQL Server environments (2019/2022).
• Experience with data lakes, data warehouses and data marts and data modeling.
• Experience with high availability, log shipping, backups and recovery.
• Experience migrating systems to cloud infrastructure.
• Experience creating reports with SSRS.

Responsibilities

• Provide database administration support, 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, 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, applying expert knowledge of design, development and maintenance of data models and components.
• Apply knowledge of data lakes, data warehouses and data mart architectures, metadata and data modeling, data flow, entity relationship diagrams, schema architectures and query languages to integrate a seamless solution within legacy infrastructure.
• Mirror database servers, perform log shipping, implement database redundancy and high availability, and maintain full backup and recovery capabilities on 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

Database administration

Data modeling

Data warehousing

SSRS

High availability

Backup and recovery

Cloud migration

Tools

Microsoft SQL Server 2019

Microsoft SQL Server 2022

Job description

CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced team supporting legal accounts. You will provide database administration, develop SQL reports, and maintain security and maintenance jobs across SQL Server 2019 and 2022.

You will assist in clustering, data modeling, and migrating systems to cloud infrastructure, while ensuring high availability, backups, and scalable data architectures.