Oracle WAM Software Developer Lead

About the role

The Oracle WAM Software Developer Lead supports the United States Air Force Test Operations and Sustainment efforts at Arnold Air Force Base in Arnold, TN. This role is open to internal candidates only.

Responsibilities

• Administer the Oracle WAM and Oracle Analytics Publisher applications.
• Lead the development of custom scripts, forms, and reports using XPath, Oracle Forms, and PL/SQL within the Oracle Utilities Application Framework (OUAF).
• Create and maintain PL/SQL packages, procedures, functions, and triggers to interface with applications such as Oracle BI and PeopleSoft Financials.
• Develop and manage REST APIs for data integration and loading into Oracle WAM.
• Architect and execute complex SQL queries for data extraction, transformation, and loading (ETL).
• Provide technical guidance, mentorship, and leadership to other developers on the team.
• Maintain system security and manage user access and privileges within Oracle applications.
• Collaborate with stakeholders to gather requirements, analyze needs, and deliver effective technology solutions.

Requirements

• Bachelor’s degree
• L10: Minimum of 11 years of experience with SQL and Oracle databases.
• L11: Minimum of 14 years of experience with SQL and Oracle databases.
• Active DoD Secret security clearance or the ability to obtain one.

Qualifications

• Seasoned developer and administrator with extensive experience in the Oracle ecosystem.
• Capable of creating robust solutions, leading complex technical projects, and mentoring team members.

Skills

• Experience with Oracle Forms and Reports, Informatica, TOAD, and SQL Developer.
• Knowledge of version control systems like Git.
• Skilled in oral and written communication.
• Skilled at building and maintaining personnel and customer relationships.
• Ability to effectively manage multiple priorities and lead technical projects.
• CompTIA Security+ certification.
• Extensive experience as an Oracle WAM administrator and developer.
• Proven expertise in PL/SQL development (packages, procedures, functions, triggers).
• Experience with Oracle BI / Oracle Analytics Publisher development and administration.
• Familiarity with Linux server administration.
• Experience with XPath and the Oracle Utilities Application Framework (OUAF).

Benefits

• Competitive salaries
• Continuing education assistance
• Multiple healthcare benefits packages
• 401K with employer matching
• Paid time off (PTO) along with a federally recognized holiday schedule

Pay

Salaries for this role range from $145,000 to $195,000 for L10 and $165,000 to $200,000 for L11, depending on location.

Schedule

Normal business hours apply, but occasional outside business hours may be required for application upgrades.