SQL Developer SR Onsite in Fairfax, VA Security Clearance

Position: SQL Developer SR Onsite in Fairfax, VA with Security Clearance
Our client asked us to help them find a SR SQL Developer to support the DEA onsite in Fairfax, VA. Requires an active secret clearance in order to get the DEA clearance, and a current security+ certification. Looking for strong experience with SQL Server 2016, 2019, and 2022 as well as T-SQL and SSIS experience for data manipulation and loading.

This is a direct hire and will pay $150k-$160k or so. If this is a good fit and if you are interested, pls respond with your current resume in word format if possible and give me a call. If not, pls feel free to pass this on to anyone you know that may be interested. Thank you. This is supporting DEA Vortex contract.

The Vortex contract refers to a data management support services agreement between the Drug Enforcement Administration (DEA). This contract aims to enhance the DEA's data management capabilities, supporting its mission to enforce controlled substances laws and regulations. The contract provides comprehensive data management services, including data analysis, integration, and reporting, to help the DEA effectively manage and utilize its data resources.

This contract underscores the DEA's commitment to leveraging data-driven strategies in its operations, ensuring efficient and effective enforcement of drug-related laws.
Sr. SQL Developer

• Assignment Duration and

Job Location ? Direct Placement
- Onsite
- Fairfax, VA 22031 - Parking free in garage across the street

• Salary: $150-160k or so.
• How long is this contract before re-compete? Through 09/31/2026.

• Clearance needed? Secret clearance is Required for DEA suitability. DEA Suitability will take anywhere from 2-6 weeks to complete.
• Certifications Needed? CompTIA Security +

• Educational Requirements? Bachelor’s Degree Top 3 Skill Sets:

• 8+ years of experience in the design, development and implementation of SQL Server databases creating and maintaining T-SQL Procedures, functions, and triggers.
• 5+ years of experience with SSIS packages for data manipulation and loading in an enterprise data warehouse environment.
• 5+ years of experience with the SQL Server 2016, 2019, & 2022 environment

Job Summary:

Seeking a Sr. SQL Developer / Enterprise Data Warehouse with Data Warehousing and cloud environment experience to support to the Office of Information Systems (TC) within the Drug Enforcement Administration (DEA). The DEA’s SQL Server-based EDW is used by a majority of DEA’s applications and is a critical component of statistical reporting. An active secret clearance is required.
Responsibilities:

Essential Duties and Responsibilities:

(Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)

• To assist the EDW Team and provide data warehouse information and facilitate the transition to a cloud environment.
• Create and maintain database integrity and performance using scripts and/or Visual Studio Database Projects;

• Create new and maintain/improve any and all data transformation services:
Microsoft SSIS and others using VS data tools;

• Create SQL Scripts to deploy / enhance / maintain databases;

• Create and maintain database security, including, but not limited to:
Data Base Roles, Users and Logins;

• May write reports or facilitate data access by other means as needed, to include SSRS, Power

BI, etc.

• Conducts performance tuning and database design, dimensional analysis and modeling.

• Maintain and add to an extensive set of SQL Server Integration Service (SSIS) packages for Extract, Transform, and Load (ETL) of data.

• Support the ongoing effort to establish a Data Engineering environment supported by Python and other languages to perform ETL and ELT (Extract, Load, and Transform) operations.

• Supports the review of database systems from non-Concorde applications in other DEA offices for ingestion into the EDW

• Participates in daily Agile stand-up meetings and monthly planning sessions, sprint reviews, and retrospective sessions.

• Other duties as assigned.
Desired

Qualifications:

• Knowledge of, and experience within, an Agile development environment.

• Knowledge of, and prior experience with Git and Power Shell

• Knowledge…