Senior Discovery DBA - Cloud Migration & Data Architecture

CGS Federal; New York (NY); On-site; USD 142,000 - 193,000; Full time

Benefits offered by this job

Health, Dental, Vision

401k

Flexible Spending Account

Paid Time Off

Job summary

CGS, Contact Government Services, is seeking a dedicated Discovery Database Administrator (Full-Time) to support legal accounts and a dynamic government-focused portfolio. The role emphasizes SQL Server 2019/2022 administration, reporting via SSRS, and advanced data modeling within clustered environments.

You will help migrate systems to cloud infrastructure, design scalable data architectures, and maintain high-availability solutions.

Qualifications

• Proficient in administering Microsoft SQL Server 2019/2022
• Experience designing and maintaining databases in cluster environments
• Knowledge of data lakes, data warehouses, and data marts, metadata and data modeling

Responsibilities

• Provide DBA support for SQL Server 2019/2022 inklusive security, tables, indexes, procedures, reports, and maintenance jobs
• Maintain databases in a clustered server environment and design data models
• Assist in data lake/warehouse/data mart architectures and data integration
• Mirror database servers, implement log shipping, ensure high availability and disaster recovery
• Facilitate migration of systems to cloud infrastructure
• Upgrade SQL Server versions (>=2019) and create reports with SSRS
• Set up a reporting server and handle DBA functions and report development

Skills

SQL Server admin

Database security

Backup & recovery

SSRS reporting

Data modeling

Cloud migration

Performance tuning

Clustered environments

Tools

SSRS

Job description

CGS, Contact Government Services, is seeking a dedicated Discovery Database Administrator (Full-Time) to support legal accounts and a dynamic government-focused portfolio. The role emphasizes SQL Server 2019/2022 administration, reporting via SSRS, and advanced data modeling within clustered environments.

You will help migrate systems to cloud infrastructure, design scalable data architectures, and maintain high-availability solutions.