DB Links Conversion Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and conduct unit tests for PL/SQL extraction routines across 45 external partner interfaces.

• Transition legacy database links to secure, delimited file extracts sent via SFTP.

• Create PL/SQL packages to extract database records into delimited files.

• Execute extraction specifications in accordance with Interface Control Documents (ICDs).

• Automate the transport of files to designated SFTP servers.

• Conduct tests on extraction scripts.

• Refactor code to enhance performance, readability, and compliance with development standards.

• Identify, debug, and resolve functional defects.

• Code and extract data into delimited files for each of the 45 interface partner systems.

• Address issues and rework code to rectify bugs and enhance code quality.

• Document the technical flow and development of code sets.

• Support Mission Partners in storing code within the centralized Source Control System.

• Collaborate with Mission Partners on maintained code.

⛳️ Requirements

• Must be a U.S. Citizen.

• Must possess an active DoD Secret Clearance at a minimum.

• Must have an active Security+ CE (or an equivalent IAT Level II Certification).

• Must have completed a Bachelor's Degree.

• Requires 2+ years of experience with data mapping and delimited file structures.

• Requires 4+ years of experience with major database technology, preferably Oracle Database, including experience with cloud databases.

• Requires 4+ years of experience using a major programming language such as Java or Python.

• Requires 4+ years of experience with Oracle PL/SQL packages, procedures, functions, database extraction, and SFTP protocols.

• Requires 4+ years of experience with Git/version control best practices, unit testing, and technical documentation.

• Experience with Oracle-provided migration tools, utilities, and scoped cutover activities is preferred.

• Troubleshooting experience, including collaboration with product vendors and implementation of official bug fixes, is necessary.

• Experience in database tuning, encompassing software configuration, memory usage, data access, data manipulation, SQL, and physical storage.

• Familiarity with Interface Control Document (ICD) analysis is required.

• Understanding of Oracle Applications is preferred.

• Strong analytical and problem-solving abilities are essential.

• Capability to provide accurate and feasible effort estimates and deliver results accordingly.

• Ability to work effectively in a team-oriented environment.

• Excellent verbal, written, organizational, and documentation skills are required.

🏝️ Benefits

• Competitive compensation package.

• Exceptional benefits.

• Engaging work assignments.

• Opportunities for career advancement and growth.

• Preference in hiring for qualified shareholders of Shee Atiká Incorporated.