Senior SQL DBA: Cloud Migrations & Data Warehousing

CGS Federal (Contact Government Services); Philadelphia (Philadelphia County); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Health, Dental, Vision

Life Insurance

401k

FSAs (Health, Dep Care, Commuter)

Paid Time Off

Job summary

CGS is seeking a Senior Discovery Database Administrator (DBA) to join the Legal department. The role focuses on SQL Server 2019/2022 administration, security, and reporting, including SSRS development and maintenance jobs.

The position requires ensuring data integrity, performance tuning, and high availability within a clustered environment. You will support data lake/warehouse integrations, design data models, and facilitate cloud migration.

Qualifications

• Experience administering Microsoft SQL Server 2019 and 2022.
• Migration to cloud infrastructure experience desired.
• Design, development, and maintenance of data models and reports.

Responsibilities

• Provide DBA support for SQL Server 2019/2022, security setup, tables, indexes, stored procedures, and maintenance jobs.
• Create and maintain databases in clustered server environments; optimize performance.
• Design and implement data warehouses, data lakes, and data marts; include metadata modeling.
• Mirror DB servers, perform log shipping, ensure high availability, backups, and recovery using SQL Server.
• Lead migration to cloud infrastructure and SSRS report development.

Skills

Database administration

SQL Server

Cloud migration

Backup and recovery

Tools

SSRS

SSMS

SSIS

Job description

CGS is seeking a Senior Discovery Database Administrator (DBA) to join the Legal department. The role focuses on SQL Server 2019/2022 administration, security, and reporting, including SSRS development and maintenance jobs.

The position requires ensuring data integrity, performance tuning, and high availability within a clustered environment. You will support data lake/warehouse integrations, design data models, and facilitate cloud migration.