Senior Discovery DBA — Cloud Migrations & SQL Reporting

CGS Federal (Contact Government Services); United States; On-site; USD 125,000 - 180,000; Full time

Benefits offered by this job

Health, dental, and vision

Life Insurance

401k

Flexible Spending Account

Paid Time Off & holidays

Job summary

CGS seeks a Senior Discovery Database Administrator to join the Legal department. The role focuses on SQL Server 2019/2022, security, maintenance, reporting, and high-availability in a fast-paced government-contracting environment.

You will design, deploy, and optimize databases, support data lakes and data warehouses, perform backups and restores, and lead cloud migration efforts while creating SSRS reports and maintaining robust DB administration.

Qualifications

• Experience managing Microsoft SQL Server 2019/2022 including security, tables, indexes, stored procedures, and jobs.
• Experience in creating and maintaining databases in a Clustered Server environment with data modeling components.
• Knowledge of data lakes, data warehouses, data marts, metadata, data modeling, and data flow.

Responsibilities

• Provide database administration support across MS SQL Server environments.
• Assist in migration of systems into cloud infrastructure.
• Design, develop, and maintain reports using SSRS.
• Maintain backups, log shipping, and high availability.

Skills

Microsoft SQL Server

SSRS

Data modeling

Data lakes / data warehouse

Cloud migration

Backup & high availability

Clustered server environment

Tools

SQL Server 2019

SQL Server 2022

SSRS Reporting Services

Job description

CGS seeks a Senior Discovery Database Administrator to join the Legal department. The role focuses on SQL Server 2019/2022, security, maintenance, reporting, and high-availability in a fast-paced government-contracting environment.

You will design, deploy, and optimize databases, support data lakes and data warehouses, perform backups and restores, and lead cloud migration efforts while creating SSRS reports and maintaining robust DB administration.