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

CGS Federal (Contact Government Services); United States; On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Health, Dental, and Vision

Life Insurance

401(k)

Flexible Spending Account

Paid Time Off and Holidays

Job summary

A government services technology firm is seeking a Discovery Database Administrator to support legal accounts and manage SQL Server databases. The role involves duties such as setting up security, creating maintenance jobs, and optimizing performance. Candidates should be well-versed in Microsoft SQL Server 2019 and 2022, with a focus on cloud migration and data integration. This position offers a range of benefits, including health and retirement plans, and promotes a collaborative and growth-oriented environment.

Qualifications

• Strong expertise in Microsoft SQL Server 2019 and 2022.
• Experience with database security setup and maintenance.
• Familiarity with data integration solutions and architectures.

Responsibilities

• Provide database administration support including setup and maintenance.
• Manage Microsoft SQL Server instances and apply best practices.
• Facilitate system migrations to cloud infrastructure.
• Apply data lake/warehousing concepts to integrate solutions with legacy systems.
• Mirror servers, implement log shipping, and ensure backup/recovery capabilities.
• Facilitate migration of systems to cloud infrastructure and upgrade SQL Server versions.
• Create SSRS reports and set up a reporting server for DBA functions.

Skills

SQL Server 2019 and 2022

Database administration

Data modeling

Data lakes and data warehouses

Performance optimization

Cloud Migration

Tools

Microsoft SQL Server Reporting Services (SSRS)

SQL

SSRS

Data Lakes/Data Warehouses

Job description

Discovery Database Administrator (DBA)

Employment Type: Full‑Time, Executive‑Level

Department: Legal

CGS is seeking a dedicated Discovery Database Administrator to join a fast‑paced and hard‑working team to assist with any legal accounts. As a 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.

Key Responsibilities

• Provide database administration support, 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 optimization.
• Assist in creating and maintaining databases in a clustered server environment, applying expert knowledge of design, development, and maintenance of data models.
• Apply working knowledge of data lakes, data warehouse, data mart architectures, metadata, data modeling, data flow, entity‑relationship diagrams, schema architectures, and query languages to integrate solutions within legacy infrastructure.
• Mirror database servers, implement log shipping, and apply latest techniques for database redundancy, high availability, and full backup and recovery capabilities for Microsoft SQL Server 2019 and 2022.
• Facilitate the 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.

Benefits

• Health, Dental, and Vision
• Life Insurance
• 401(k)
• 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: [e-mail]

#CJ

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. 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.