ANF - DB Links Conversion Developer (MilPDS)

Description:

Alaska Northstar Federal (ANF) is currently seeking a DB Links Conversion Developer to join our team on a long-term project. This is a fully remote opportunity. This project supports the modernization of a mission-critical enterprise workforce management platform through cloud migration and technology transformation. The effort focuses on improving scalability, security, reliability, and operational resilience while implementing modern DevSecOps and automation practices. Team members will contribute to cloud engineering, systems integration, cybersecurity, and process modernization initiatives that enable a more secure and efficient enterprise environment.

The DB Links Conversion Developer is responsible for designing, developing, and unit testing PL/SQL extraction routines across 45 external partner interfaces, migrating legacy database links to secure, delimited file extracts transmitted via SFTP. The DB Links Conversion Developer will develop PL/SQL packages to extract database records into delimited files for 45 partner interfaces and Implement extraction specifications based on Interface Control Documents (ICDs) using automated file transports to target SFTP servers and testing all extraction scripts. The DB Links Developer will also refactor code for performance, readability, and adherence to development standards, while troubleshooting, debugging, and remediating identified functional defects. All code maintained in the centralized Source Control System will be in collaboration with the Mission Partners (MPs).

The DB Links Conversion Developer will complete the following for each of the 45 interface partner systems:

• Will code and extract data to a delimited file using PL/SQL Packages.
• Use ICD’s as definition for each of the extraction requirements.
• Code, Unit Test and transport to SFTP.
• Clean up Issues and rework code for cleanliness and found bugs.
• Document Technical flow and development of Code Set.
• Assist MP on Storing Code in Source Control System.

Requirements:

Minimum Candidate Requirements

Candidate must be a U.S. Citizen

Candidate must have an active DoD Secret Clearance at minimum

Candidate must have an active Security+ CE (or equivalent IAT Level II Certification)

Candidate must have completed a Bachelor’s Degree

Candidate must have 2+ years experience with data mapping and delimited file structures.

Candidate must have at 4+ years of experience in the following:

• Working with major database technology (Oracle Database preferred), including cloud database experience.
• Using major coding language (such as Java, python, etc.)
• Working with Oracle PL/SQL (Packages, Procedures, Functions), Database Extraction, and SFTP protocols.
• Git/Version Control best practices, Unit Testing, and creating Technical Documentation.

Desired Knowledge, Skills, and Abilities

• Experience with Oracle-provided migration tools, utilities, and scoped cutover activities.
• Troubleshooting experience, including coordination directly with product vendors to troubleshoot platform anomalies and implement official bug fixes.
• Experience in database tuning, including: software configuration, memory usage, data access, data manipulation, SQL, and physical storage.
• Experience with Interface Control Document (ICD) analysis.
• An understanding of Oracle Apps.
• Strong analytical and problem-solving skills.
• Ability to provide accurate and realistic effort estimates, commit and deliver accordingly.
• Ability to work productively in a team environment and participate as a positive and cooperative team member.
• Strong verbal, written, organizational and documentation skills.

About ANF

Alaska Northstar Federal (ANF) maintains an outstanding work environment that includes competitive compensation, outstanding benefits, and challenging work assignments with opportunities for advancement/career growth. To be considered for employment opportunities you must complete an online application.

Our Mission

We deliver meaningful value to our shareholders, people, partners and customers.

Our Values

We are open, honest, and trustworthy

We respect all beliefs and perspectives

We work together as one team

We are committed to excellence in all that we do

We are responsible and accountable for our actions

Our Vision

Our people thrive, prosper and are self-sustaining. We inspire and hold each other up through meaningful connections to our land, oce…