Job Duties and Responsibilities

Implement SQL software features across all layers of the Microsoft technology stack.
Design and deploy data table structures, forms, reports, and queries.
Coordinate and work with other technical staff to develop relational databases and secondary databases.
Identify inefficiencies in current databases.
Develop and maintain database stored procedures, views, and functions for hosted web applications.
Produce ad hoc queries and develop reports to support business needs.
Create and maintain technical documentation; produces design artifacts such as class diagram and entity relationship diagrams, data dictionary, etc.
Implement data dashboards to display data in differing formats.
Participate in designing, maintaining, enhancing, and coding relational databases.
Create complex functions, scripts, stored procedures, and triggers to support application development.
Analyze and determine information needs and elements; data relationships and attributes; data flow and storage requirements; and data output and reporting capabilities.
Coordinate new data development ensuring consistency and integration with existing data warehouse structure.
Tests designed applications.
Perform SQL performance tuning tasks.

Requirements

Required Certifications

Education, Background, and Years of Experience

Master’s Degree with 10 years of experience, or Bachelor’s Degree with 12 years experience.

Additional Skills & Qualifications Required Skills

Possess a strong background and understanding of US Army Finance operations and experience writing complex, custom SQL logic to achieve required organizational outcomes.
Must be able to tailor SQL development to support PMD’s Mission of paying USAR Soldiers and Submissions to develop SQL solutions for all components of military pay.
Capable of developing data warehousing blueprints, evaluating hardware and software platforms, and integrating systems.
Ability to evaluate reusability of current data for additional analyses.
Experience working in a data warehouse environment that includes data design, database architecture, metadata and repository creation.
Able to translate business needs into long-term architecture solutions.
Defines, designs, and builds dimensional databases.
Conducts data cleaning to rid the system of old, unused, or duplicate data.
Reviews object and data models and the metadata repository to structure the data for better management and quicker access.

Preferred Skills

Excellent communications skills.
Excellent Customer Focus/Satisfaction skills.
Strong team/personnel leadership skills.
Strong understanding of and ability to demonstrate the Agile Defense Core Values: Happy, Helpful, Honest, Humble, Hungry, Hustle.

Benefits

Remote support (e.g. work from home) available 100% of the time with 0%-5% travel possible. Possible off-hours work to support releases and outages.
Work is generally sedentary in nature, but may require standing and walking for up to 10% of the time.
Periodic visits to nearest USARC facility may be required for GFE system updates / maintenance.

Working Conditions

Environmental Conditions

Remote support (e.g. work from home) available 100% of the time with 0%-5% travel possible. Possible off-hours work to support releases and outages.
Work is generally sedentary in nature, but may require standing and walking for up to 10% of the time.
Periodic visits to nearest USARC facility may be required for GFE system updates / maintenance.

Strength Demands

Sedentary – 10 lbs. Maximum lifting, occasional lift/carry of small articles. Some occasional walking or standing may be required. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Physical Requirements

Stand or Sit; Walk; Repetitive Motion; Use Hands / Fingers to Handle or Feel; Stoop, Kneel, Crouch, or Crawl; See; Push or Pull; Climb (stairs, ladders) or Balance (ascend / descend, work atop, traverse).

SQL Engineer Developer Senior at Agile Defense Full Time

Log In