Oracle PLSQL Developer

We are seeking a highly experiencedSenior Oracle PL/SQL Developer / Database Architectto support the development modernization and ongoing maintenance of mission-critical enterprise applications and Oracle database environments.

The ideal candidate will bring5 years of hands-on Oracle PL/SQL development experience along with strong database architecture and data modeling expertise. This individual will be responsible for developing and troubleshooting complex PL/SQL packages and procedures improving existing database designs developing APIs and supporting integrations with enterprise applications.

This position supports systems within agovernment environment so candidates with recent federal government or government contracting experience are strongly preferred. ATier 3 background investigation completed within the past two yearsis highly desirable due to system and database access requirements.

• Design develop maintain and troubleshoot complexOracle PL/SQL packages procedures functions and related database components.
• Analyze existing Oracle database environments and recommend architectural and design improvements.
• Troubleshoot complex database and application issues including performance and data-related problems.
• Design develop and maintainAPIsused to integrate enterprise applications and external data sources.
• Support integrations between Oracle databases APIs and custom enterprise applications.
• Work withJava-based applicationsthat serve as ingestion points for certain APIs.
• Support Oracle database environments hosted onLinux servers.
• Participate in application security and code-quality activities including monthly PL/SQL code scans usingFortifyor similar static code analysis tools.
• Track development activities defects enhancements and project work throughJira.
• Work withinServiceNowfor incident request and ticket management.
• Support applications and integrations involving government financial and employee spending data.
• Collaborate with application developers database administrators architects security teams and business stakeholders.
• Follow established development security documentation testing and change-management standards.

• 5 years of Oracle PL/SQL development experience.
• Extensive hands-on experience developing and troubleshooting:
  • PL/SQL packages
  • Stored procedures
  • Functions
  • Complex SQL queries
  • Oracle database objects
• 3 years of database architecture/design experience.
• Strong experience designing and/or redesigning existing relational databases.
• 25 years of API development experience.
• Experience integrating APIs with databases and enterprise applications.
• Experience working withLinux-based database servers.
• Experience supporting complex enterprise-scale applications and database environments.
• Ability to troubleshoot application integration database and data-related issues.
• Ability to work effectively within structured development and change-management environments.

• Experience usingFortifyor comparable static application security/code-scanning tools.
• Experience withJirafor software development tracking.
• Working knowledge ofJava particularly applications used as API ingestion or integration points.
• Familiarity withGlobal Distribution Systems (GDS)and travel-related data.
• Experience supporting applications involvingfinancial auditing expense management or government employee spending.
• Previous federal government or government contracting experience.
• CompTIA Security certificationis a plus but is not required.

• ATier 3 background investigation completed within the past two years is strongly preferred.
• Candidates with recent federal government or government contracting experience are highly desirable.
• Due to the nature of the environment candidates without a recent qualifying background investigation may experience a significant delay in obtaining required database and system access.

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race color religion sex national origin age disability genetics or any other protected status. INSPYR Solutions complies with all applicable laws governing nondiscrimination in employment in every location in which the company has facilities. Applicants requiring reasonable accommodation during the application or interview process should contact for assistance.

Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions Privacy Policy and INSPYR Solutions AI and Automated Employment Decision Tool Policy: By submitting an application you are consenting to being contacted by INSPYR Solutions through phone email or text.