DB Links Conversion Developer

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

📋 Description

• Design, develop, and perform unit testing of PL/SQL extraction routines for 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.

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

• Automate the transfer of files to designated SFTP servers.

• Conduct testing for all extraction scripts.

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

• Diagnose, debug, and resolve functional defects.

• Code and extract data to delimited files utilizing PL/SQL packages for each of the 45 interface partner systems.

• Perform unit testing and manage the transport of extracts to SFTP.

• Address issues and refine code for clarity and bug elimination.

• Document the technical flow and development of the code-set.

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

• Collaborate with Mission Partners on the maintenance of source-controlled code.

• Contribute to initiatives in cloud migration, systems integration, cybersecurity, DevSecOps, automation, and process modernization.

⛳️ Requirements

• Must be a U.S. Citizen.

• Minimum of an active DoD Secret Clearance.

• Active Security+ CE (or equivalent IAT Level II Certification) required.

• Bachelor’s Degree is a prerequisite.

• A minimum of 2 years of experience with data mapping and delimited file structures.

• Over 4 years of experience with major database technologies, preferably Oracle Database, including experience in cloud databases.

• More than 4 years of experience in major coding languages such as Java or Python.

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

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

• Familiarity with Oracle-provided migration tools, utilities, and scoped cutover activities.

• Experience in troubleshooting, including working with product vendors and implementing formal bug fixes.

• Background in database tuning, including software configuration, memory management, data access, data manipulation, SQL, and physical storage.

• Experience analyzing Interface Control Documents (ICDs).

• Knowledge of Oracle Apps.

• Strong analytical and problem-solving capabilities.

• Ability to provide accurate and realistic effort estimates and deliver results accordingly.

• Capacity to work effectively in a team setting.

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

🏝️ Benefits

• Competitive compensation.

• Outstanding benefits.

• Engaging work assignments.

• Opportunities for career advancement and growth.

• Equal Opportunity/Affirmative Action employer.

• Reasonable accommodations for qualified individuals with disabilities and disabled veterans.

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