ANF - DB Links Conversion Developer (MilPDS)

Alaska Northstar Resources LLC.; United States; Remote; USD 120,000 - 170,000; Full time

Job summary

Alaska Northstar Federal (ANF) seeks a Database Links Conversion Developer to join a long-term, fully remote MilPDS project. You will design, develop, and test PL/SQL extraction routines across 45 external partner interfaces, migrating legacy database links to secure delimited file extracts via SFTP.

You will implement ICD-based extraction specifications, refactor for performance and readability, and collaborate with MPs, maintaining code in centralized Source Control and delivering robust

Qualifications

• U.S. citizen required.

Responsibilities

• Design, develop, and unit test PL/SQL extraction routines across 45 partner interfaces.

Skills

Oracle PL/SQL

Java

Python

Database Extraction

SFTP

Git Version Control

Unit Testing

Technical Documentation

Cloud Database Experience

Education

Bachelor's Degree

Tools

Oracle Database

SFTP

Git

Job description

All Jobs > ANF - DB Links Conversion Developer (MilPDS)

Fully Remote SA-Tech

Full-time

Description

Alaska Northstar Federal (ANF) is currently seeking a Database 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

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.

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, ocean, traditions and heritage.

EEO Statement

ANF is committed to hiring and retaining a diverse workforce. We are proud to be an Equal Opportunity/Affirmative Action-Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or protected veteran status. U.S. Citizenship is required for most positions.

For further information on our equal opportunity protections as part of the employment process:

ANF accords a hiring preference to qualified shareholders of its parent corporation, Shee Atiká Incorporated, an Alaska Native corporation, in accordance with and in implementation of applicable law, including without limitation 43 U.S.C. §1626(g).

Accessibility

ANF is committed to expanding access to employment for people with disabilities and disabled veterans. If you are a qualified individual with a disability or a disabled veteran, and your disability prevents you from applying, please advise what reasonable accommodation ANF can provide to assist you in applying for one of our open positions. You may contact us by sending an email to [e-mail]

Reasonable accommodations are considered on a case-by-case basis. Please note that only those inquiries concerning a request for reasonable accommodation for applying for a specific posted position will be responded to. Requests will be kept confidential and shared strictly on a need-to-know basis.

The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.