Requisition #: QASPE004051
Job Title: QA Spec II
Location: Remote
Clearance Level: Active DoD – Secret
Salary Range: $98,000 – $147,000
Required Certification(s):
- DoD IAT Level II Certification.
SUMMARYAgile Defense is seeking a Senior SQL Engineer/Developer to support the United States Army Reserve Command (USARC) military pay and personnel operations. On this project, you will help support the development, modernization, and sustainment of the Regional Level Application Software (RLAS) application and the Pay Management Division (PMD) data environment.
In this role, you will be working with a team to create a new shared data environment that integrates seamlessly with the A365 Environment and DoD Data Strategy. To accomplish this, you will provide programming, coding, and database development support to modernize and re-engineer automated and semi-automated business processes and the USAR Pay Management Division (PMD).
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.
QUALIFICATIONS
Required Certifications
- DoDI 8570 IAT II Certification (e.g. Security+ CE) upon starting.
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.
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; Repetitive Motion; Use Hands / Fingers to Handle or Feel; See; Push or Pull
About Us!
Agile Defense provides leading-edge Digital Transformation solutions to support and advance our customers’ mission. We deliver innovative and high-quality services to our customers worldwide through an empowered and engaged workforce.
Employees of Agile Defense are our number one priority, and the importance we place on our culture here is fundamental. Our culture is alive and evolving, but it always stays true to its roots. Here, you are valued as a family member, and we believe that we can accomplish great things together. Agile Defense has been highly successful in the past few years due to our employees and the culture we create together. We believe several attributes are the root of our very best employees and extraordinary culture. We have named these attributes “The 6 H’s” – Happy, Helpful, Honest, Humble, Hungry, and Hustle.
- Happy: We exhibit a positive outlook in order to create a positive environment.
- Helpful: We assist each other and pull together as teammates to deliver.
- Honest: We conduct our business with integrity.
- Humble: We recognize that success is not achieved alone, that there is always more to learn, and that no task is below us.
- Hungry: We desire to consistently improve.
- Hustle: We work hard and get after it.
These Core Values are present in all our employees and our organization’s aspects. Learn more about us and our culture by visiting us here.
COVID-19 Vaccination Requirements
Agile Defense is subject to federal vaccine mandates or other customer/facility vaccination requirements as a federal contractor. As such, to protect its employees’ health and safety and comply with customer requirements, Agile Defense may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)