Senior SQL Server DBA - Cloud Migrations & Data

Cgsfederal; Boston (MA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

Dependent Care, and Commuter

Paid Time Off and Holidays

Job summary

CGS is seeking a Senior Discovery Database Administrator to join a fast-paced, hard-working team supporting various aspects of the company’s portfolio. You will play a key role in providing database administration across security, tables, indexes, stored procedures, and maintenance jobs for SQL Server environments.

Responsibilities include managing SQL Server 2019 and 2022, designing data models, ensuring backups and high availability, migrating systems to cloud infrastructure, and developing

Responsibilities

• Provide database administration support, including security, creating tables, indexes, stored procedures, designing SQL reports, and 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, ER 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 Senior Discovery Database Administrator to join a fast-paced, hard-working team supporting various aspects of the company’s portfolio. You will play a key role in providing database administration across security, tables, indexes, stored procedures, and maintenance jobs for SQL Server environments.

Responsibilities include managing SQL Server 2019 and 2022, designing data models, ensuring backups and high availability, migrating systems to cloud infrastructure, and developing