Chenega Corporation Microsoft Sr. SQL Dev-DEA-CPTS in Virginia

CHENEGA PROFESSIONAL & TECHNICAL SERVICES

Company Job Title:

Microsoft Sr. SQL Developer-DEA-CPTS

Chenega Job Title:

Engineer VI, General

Clearance:

Secret

Location:

Merrifield, VA

Reports To:

Program Manager

FLSA Status:

Regular, Full Time, Salaried, Exempt

Prepared Date:

03-06-2018

Approved Date:

03-06-2018

Summary:

Chenega Professional & Technical Services (CPTS) is seeking aMicrosoftSr.SQL Developer to provide enterprise data warehouse support to the Office of Information Systems (SI) within the Department of Justice (DOJ), Drug Enforcement Administration (DEA). TheMicrosoftSr.SQL Developer will serve as a subject matter expert on all aspects of the Enterprise Data Warehouse.

Essential Duties and Responsibilities:(Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position)

· Lead the EDW team through the use of best practices in SQL development; make recommendations for improvements; research Microsoft solutions.

· Develop scripts, perform database support activities, conduct 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) data manipulation.

· Maintain, enhance, and create enterprise and application level reports using SQL Server Report Service (SSRS) and other Business Intelligence (BI) tools.

Non-Essential Duties:

· Other duties as assigned.

Supervisory Responsibilities:

· None.

Minimum Qualifications:(To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.)

· Bachelor’s degree required.

· Minimum of 15 years of total database experience.

· Minimum of 12 years of SQL Server experience.

· Microsoft Azure certification is required. One of the following Microsoft certifications is required: 70-532, 70-533, 70-5345

· Minimum of 3 years of experience with Microsoft BI tools such as SSRS and PowerPivot.

· An active Secret Clearance is required.

Knowledge, Skills and Abilities:

· Experience with SQL Server databases of at least 3 TB and 100 million total rows of data.

· Experience with the configuration of a database disaster recovery option at a geographically separated facility.

· Ability to work independently and part of a team.

· Excellent oral and written communication skills.

Diversity:

· Shows respect and sensitivity for cultural differences; Educates others on the value of diversity; Promotes a harassment-free environment; Builds a diverse workforce.

Ethics:

· Treats people with respect; Keeps commitments; Inspires the trust of others; Works with integrity and ethically; Upholds organizational values.

Physical Demands:

· The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

· While performing the duties of this Job, the employee is regularly required to sit and talk or hear. The employee is frequently required to walk; use hands to finger, handle, or feel and reach with hands and arms. The employee is occasionally required to stand; climb or balance and stoop, kneel, crouch, or crawl. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision.

Work Environment:

· The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

· The employee will normally work in a temperature-controlled office environment, with frequent exposure to electronic office equipment.

· During visits to areas of operations, may be exposed to extreme cold or hot weather conditions. Is occasionally exposed to fumes or airborne particles, toxic or caustic chemicals, and loud noise.

Chenega Corporation and family of companies is an EOE.

Equal Opportunity Employer Minorities/Women/Veterans/Disabled/Sexual Orientation/Gender Identity

Native preference under PL 93-638.

We participate in the E-Verify Employment Verification Program.M#

Minimum Qualifications:(To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.)

·Bachelor’s degree required.

·Minimum of 15 years of total database experience.

·Minimum of 12 years of SQL Server experience.

·Microsoft Azure certification is required.One of the following Microsoft certifications is required:70-532, 70-533, 70-5345

·Minimum of 3 years of experience with Microsoft BI tools such as SSRS and PowerPivot.

·An active Secret Clearance is required.

Job: General Engineering

Organization: Chenega Professional & Technical Services

Title: Microsoft Sr. SQL Dev-DEA-CPTS

Location: Virginia

Requisition ID: 1800000625