Senior Discovery DBA: SQL Server, Data Lakes & Cloud Migrations

Cgsfederal; New York (NY); On-site; USD 110,000 - 180,000; Full time

Benefits offered by this job

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

401k

FSA (Health)

PTO & Holidays

Job summary

CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced, hard-working team supporting legal accounts. This role focuses on SQL Server 2019/2022, security setup, data modeling, data warehouse concepts, and cloud migration within a clustered environment.

The Senior DBA will design and optimize databases, implement backup/recovery strategies, and develop SSRS reports, with responsibilities spanning maintenance jobs, data lake integration, and high-availability

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.

Job description

CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced, hard-working team supporting legal accounts. This role focuses on SQL Server 2019/2022, security setup, data modeling, data warehouse concepts, and cloud migration within a clustered environment.

The Senior DBA will design and optimize databases, implement backup/recovery strategies, and develop SSRS reports, with responsibilities spanning maintenance jobs, data lake integration, and high-availability