SQL Database Administrator

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.

Requisition #:SQLDA004085

Job Title: SQL Database Admin

Location: Fort Bragg, NC (Remote)

Clearance Level: Active DoD - Secret

Salary Range: $73,500 - $110,250

Required Certification(s): 

DoD IAT Level II Certification (must have upon starting).

Advanced Oracle or Microsoft SQL Server certification (preferred).

SUMMARY

Agile Defense is seeking a SQL Database Admin 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

Maximize database stability and uptime of databases supporting the Enterprise, including Production, Test, and Development environments through system monitoring, performance tuning, and routine maintenance tasks such as index rebuilds, file compression, statistical updates, and database consistency checks.

Manage the storage environments for the databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics.

Create tables, views, indexes, database links, materialized views, stored procedures, and other database objects as needed; create and assign database roles and privileges.

Create and execute database backup and recovery policies and maintain integrity and reliability of access to information.

Import and export data to and from the database servers.

Perform routine backup and recovery testing, including testing and documenting recovery scenarios.

Work with application/development teams to assist in overall database design, help developers tune queries, assign proper indexes, and aid developers in the creation of triggers and stored procedures.

Responsible for database performance monitoring and capacity planning.

Monitor and analyze disk I/O, and queue lengths.

Conduct troubleshooting of issues associated with supported SQL databases.

Perform SQL performance tuning tasks.

Create and maintain detailed SOPs, configuration documentation, and maintenance plans for the database environment.

Serve as technical liaison between cloud, security, and pay teams.

Support client site change control activities, support change control requests, and review boards concerning system implementation.

Perform security hardening via group policies, local policies, scripting, etc.

Distinguish between necessary security settings that would protect the system while ensuring usability versus security settings to meet security compliance.

QUALIFICATIONS

Required Certifications

DoD IAT Level II Certification (must have upon starting).

Advanced Oracle or Microsoft SQL Server certification (preferred).

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

Ability to assist and work alongside the SQL Developer in creating, maintaining, and sustaining required streamlined solutions while ensuring database administration and security best practices.

Capable of leading and participating in the development and maintenance of database systems while also offering Database development resource to the development team.

Support the review of and provide technical solutions to projects which may be in different stages of the development life cycle.

Requires knowledge and experience with Oracle or MS SQL Server DBMS, SQL Language, Unix/Linux including basic shell commands, data warehousing, report generation, job scheduling and monitoring tools, XML, HTML, open source development, and technical documenting skills (Windows

Office/Visio, etc.).

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

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)

Salary : $73,500 - $110,250