ANF - Database Links Conversion Developer (MilPDS)
Description
Alaska Northstar Federal (ANF) is seeking a Database Links Conversion Developer to join our team on a long-term project supporting the US Air Force. 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.
Skills
Sign in to read and join the discussion.