Discovery DBA: Cloud Migrations & Data Warehousing

Cgsfederal; New York (NY); On-site; USD 95,000 - 135,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

Paid Time Off and Holidays

Job summary

CGS seeks a Discovery Database Administrator to support Microsoft SQL Server 2019/2022, implement security, design tables, and create reports. The role includes maintaining high availability, backups, and migration to cloud environments.

Responsibilities cover clustering, data model design, and SSRS reporting, with a focus on data lake and data warehouse architectures within legacy setups.

Qualifications

• Proven experience with Microsoft SQL Server 2019/2022 administration.
• Experience with backup, recovery, mirroring, and log shipping.
• Familiarity with data warehouse, data lake concepts, and metadata management.
• Cloud migration and infrastructure integration experience.

Responsibilities

• Provide database administration support for Microsoft SQL Server 2019 and 2022, 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, applying best practices for optimizing databases.
• Assist in creating and maintaining databases in a clustered server environment, applying expert knowledge of data models and their components.
• Apply working knowledge of data lakes, data warehouse and data mart architectures, metadata and data modeling, data flow, entity relationship diagram, schema architectures and query languages to integrate solutions within legacy infrastructure.
• Implement database mirroring, log shipping, redundancy and high availability, and full backup and recovery capabilities for Microsoft 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 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

Backup & restore

High availability

Data warehousing

Data lakes

SSRS reporting

Cloud migration

Security configuration

Database design

Tools

SSMS

SSRS

Job description

CGS seeks a Discovery Database Administrator to support Microsoft SQL Server 2019/2022, implement security, design tables, and create reports. The role includes maintaining high availability, backups, and migration to cloud environments.

Responsibilities cover clustering, data model design, and SSRS reporting, with a focus on data lake and data warehouse architectures within legacy setups.