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

Skills and attributes for success

• Provide database administration support to include, but not limited to, the following activities:
  • Set up security, create tables, indexes, stored procedures, design SQL reports, and create maintenance jobs.
  • Optimize databases using best practices.
  • Manage Microsoft SQL Server 2019 and 2022 in a Clustered Server environment.
  • Create and maintain databases.
  • Apply expert knowledge of data models and their components.
  • Design, develop, and maintain data lake, data warehouse, and data mart architectures.
  • Apply working knowledge of metadata and data modeling, data flow, entity relationship diagrams, schema architectures, and query languages.
  • Mirror database servers, implement log shipping, and ensure database redundancy and high availability.
  • Create 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 (version 2019 and up).
  • Create reports using Microsoft SQL Server Reporting Services (SSRS).
  • Setup a reporting server and manage all DBA functions and report development.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Minimum of 5 years of experience in database administration and management.
• Expertise in Microsoft SQL Server 2019 and 2022.
• Strong understanding of data architecture, data modeling, and data warehousing concepts.
• Experience with data lake, data warehouse, and data mart architectures.
• Knowledge of data flow, entity relationship diagrams, and schema architectures.
• Proficiency in query languages and database optimization techniques.
• Experience with database mirroring, log shipping, and high availability solutions.
• Experience with cloud infrastructure and migration processes.
• Experience with Microsoft SQL Server Reporting Services (SSRS).
• Experience with 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

Pay

$142,100 - $192,850 annually

Schedule

Nightly shift

Contact Government Services, LLC

Equal Opportunity Employer
Phone: +1 (888) 680-5916
Email: [email protected]