Senior Discovery Database Administrator (DBA) (Top Secret Clearance Required)

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

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401k

FSAs (Health, Dependent Care, Commuter

PTO & Holidays

Job summary

CGS is seeking a Senior Discovery Database Administrator to join a fast-paced team within the Legal department. You will manage SQL Server 2019/2022, build and optimize databases, ensure security, and drive data architecture across data lakes and warehouses.

The role includes cloud migration and SSRS reporting responsibilities in a full-time capacity. Ideal candidates will have deep DBA expertise, experience with clustered environments, and a track record of maintaining high availability and

Qualifications

• Provides DBA support for Microsoft SQL Server 2019/2022.
• Designs and maintains databases in clustered server environments.
• Applies data lake/warehouse/data mart architectures and data modeling.

Responsibilities

• Provide DBA support for SQL Server 2019/2022 including security, tables, indexes, and stored procedures.
• Create and maintain databases in a clustered server environment with data models.
• Work with data lakes, data warehouse, and data mart architectures and metadata modeling.
• Mirror servers, implement log shipping, high availability, and backups/recovery.
• Migrate systems to cloud infrastructure.
• Upgrade SQL Server versions (2019+) and develop SSRS reports.
• Set up a reporting server and perform DBA functions and report development.

Skills

SQL Server Admin

Security setup

Tables & indexes

Stored procedures

SSRS

Data modeling

Data warehouse

Data lakes

Cloud migration

Backup & recovery

High availability

Tools

SSRS

Job description

Senior Discovery Database Administrator (DBA)Employment Type: Full-Time, Executive-LevelDepartment: Legal

CGS is seeking a dedicated Senior Discovery Database Administrator to join a fast-paced and hard-working team to assist with any legal accounts. As a Senior Discovery Database Administrator, you will play a key role in supporting various aspects of the company's portfolio. CGS brings motivated, highly skilled, and creative people together to solve the government's most dynamic problems with cutting-edge technology. To carry out our mission, we are seeking candidates who are excited to contribute to government innovation, appreciate collaboration, and can anticipate the needs of others. Here at CGS, we offer an environment in which our employees feel supported, and we encourage professional growth through various learning opportunities.

Skills and attributes for success:

• - The Contractor shall provide database administration support to include, but not limited to the following activities:
• - Contractor shall assist in managing Microsoft SQL Server 2019 and 2022 to include setting up security, creating tables, indexes, stored procedures, designing SQL reports, and creating maintenance jobs etc. Must apply best practices for optimizing databases;
• - Contractor shall assist in creating and maintaining databases in a Clustered Server environment. Must apply expert knowledge of the design, development and maintenance of various data models and their components;
• - Contractor shall 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 a seamless solution within legacy infrastructure;
• - Contractor shall mirror database servers, log shipping, latest techniques for Database redundancy and high Availability, and full backup and recovery capabilities of the Microsoft SQL Server 2019 and 2022 platform;
• - Contractor shall facilitate the migration of system into cloud infrastructure.
• - Contractor shall upgrade SQL Servers from lower versions to the latest version (version 2019 and up), and create reports using Microsoft SQL Server Reporting Services (SSRS);
• - Contractor shall setup a reporting server and be responsible for all DBA functions and report development utilizing Software Systems development Architecture and Design.

Our Commitment:

Contact Government Services (CGS) strives to simplify and enhance government bureaucracy through the optimization of human, technical, and financial resources. We combine cutting-edge technology with world-class personnel to deliver customized solutions that fit our client's specific needs. We are committed to solving the most challenging and dynamic problems. For the past seven years, we've been growing our government-contracting portfolio, and along the way, we've created valuable partnerships by demonstrating a commitment to honesty, professionalism, and quality work. Here at CGS we value honesty through hard work and self-awareness, professionalism in all we do, and to deliver the best quality to our consumers mending those relations for years to come.

We care about our employees. Therefore, we offer a comprehensive benefits package.

• Health, Dental, and Vision
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays

Contact Government Services, LLC is an Equal Opportunity Employer. Applicants will be considered without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Join our team and become part of government innovation!

Explore additional job opportunities with CGS on our Job Board:https://cgsfederal.com/join-our-team/

For more information about CGS please visit: https://www.cgsfederal.com or contact:Phone: [phone]Email: [emailprotected]

#CJ $182,700 - $263,900 a year

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.