ANF - DB Links Conversion Developer; MilPDS

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 Dev Sec Ops  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.

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

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

Alaska Northstar Federal (ANF) maintains an outstanding work environment that includes competitive compensation, outstanding benefits, and challenging work assignments with opportunities…