Discovery DBA: SQL Server Expert for Data Lakes & Cloud

CGS Federal (Contact Government Services); Massachusetts; On-site; USD 142,000 - 193,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

Flexible Spending Account (Health, Dep

Paid Time Off

Holidays

Job summary

CGS Federal, a government services contractor, is seeking a Discovery Database Administrator (DBA) to join a fast-paced legal team. You will manage Microsoft SQL Server environments, implement security, create maintenance jobs, design data models, and support reporting with SSRS.

The role emphasizes high availability, backups, and cloud migration planning. The ideal candidate will have hands-on experience with SQL Server 2019/2022, data lakes, data warehouses, and complex data architectures, and

Qualifications

• DBA experience with Microsoft SQL Server environments and security.
• Manage SQL Server 2019/2022, security, tables, indexes, stored procedures, and reports.
• Design data models and maintain data architectures, data flows, and ER diagrams.
• Implement backups, replication, high availability, and cloud migration.
• Upgrade SQL Server versions and develop SSRS reports.

Responsibilities

• Provide comprehensive DBA services including security setup and maintenance jobs.
• Design and maintain databases in clustered environments.
• Develop reports using SSRS and support report server setup.
• Assist in migrating systems to cloud infrastructure.

Skills

Database administration

SQL Server

Data modeling

Backup & recovery

High availability

SSRS reporting

Cloud migration

Security best practices

Tools

SQL Server 2019

SQL Server 2022

SSRS

Data Lake

Data Warehouse

Clustered Server environment

Job description

CGS Federal, a government services contractor, is seeking a Discovery Database Administrator (DBA) to join a fast-paced legal team. You will manage Microsoft SQL Server environments, implement security, create maintenance jobs, design data models, and support reporting with SSRS.

The role emphasizes high availability, backups, and cloud migration planning. The ideal candidate will have hands-on experience with SQL Server 2019/2022, data lakes, data warehouses, and complex data architectures, and