SQL Database Admin

Fort Liberty, NC
Defense – Information Technology /
Regular /
Hybrid
At Agile Defense we know that action defines the outcome and new challenges require new solutions. That’s why we always look to the future and embrace change with an unmovable spirit and the courage to build for what comes next.

Our vision is to bring adaptive innovation to support our nation's most important missions through the seamless integration of advanced technologies, elite minds, and unparalleled agility—leveraging a foundation of speed, flexibility, and ingenuity to strengthen and protect our nation’s vital interests.

Requisition Details

General Summary of Program

Agile 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.
General Summary of Position

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).

Duties
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.
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. What makes us Agile? We call it the 6Hs, the values that define our culture and guide everything we do. Together, these values infuse vibrancy, integrity, and a tireless work ethic into advancing the most important national security and critical civilian missions. It's how we show up every day. It's who we are.

Happy - Be Infectious.
Happiness multiplies and creates a positive and connected environment where motivation and satisfaction have an outsized effect on everything we do.

Helpful - Be Supportive.
Being helpful is the foundation of teamwork, resulting in a supportive atmosphere where collaboration flourishes, and collective success is celebrated.

Honest - Be Trustworthy.
Honesty serves as our compass, ensuring transparent communication and ethical conduct, essential to who we are and the complex domains we support.

Humble - Be Grounded.
Success is not achieved alone, humility ensures a culture of mutual respect, encouraging open communication, and a willingness to learn from one another and take on any task.

Hungry - Be Eager.
Our hunger for excellence drives an insatiable appetite for innovation and continuous improvement, propelling us forward in the face of new and unprecedented challenges.

Hustle - Be Driven.
Hustle is reflected in our relentless work ethic, where we are each committed to going above and beyond to advance the mission and achieve success.

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)