Senior Oracle Application Developer

Job Title: Senior Oracle Application Developer

Location: 100% Remote (Open to Out-of-State Candidates)

Duration: 12 Months

Client :State of AZ

Position Overview

We are seeking a highly experienced Senior Oracle Application Developer to play a critical role in designing and delivering robust Oracle-based applications. This position bridges database architecture and application development, requiring deep expertise in PL/SQL, Oracle tools, and enterprise application design.

The ideal candidate will bring strong technical acumen, a collaborative mindset, and the ability to translate complex business requirements into scalable technical solutions.

Key Responsibilities

• Architect, design, develop, and document complex Oracle-based permitting and enterprise applications
• Develop and enhance application features in alignment with functional and technical specifications while adhering to SDLC and coding standards
• Debug, test, and validate applications to ensure performance, reliability, and compliance before production deployment
• Integrate new modules, enhancements, and upgrades into production systems
• Collaborate with business analysts, SMEs, and stakeholders to convert business requirements into technical designs
• Provide production support by troubleshooting issues, resolving defects, and addressing end-user service requests
• Produce clear and comprehensive technical documentation, including design specifications and workflows
• Actively participate in Agile ceremonies (sprint planning, backlog grooming, daily stand-ups, retrospectives)
• Maintain a customer-focused approach by proactively addressing stakeholder needs and managing expectations

Required Skills & Experience

• 7+ years of hands-on experience in Oracle development
• Strong expertise in:
• PL/SQL (Oracle 19c/12c)
• Oracle Forms & Reports (12c)
• Oracle APEX
• Advanced PL/SQL programming, including:
• Stored Procedures, Packages, and Triggers
• Collections, Records, Table/Object Types
• Dynamic SQL
• Experience with Ref Cursors and robust Exception Handling mechanisms
• Hands-on experience with Git/GitHub for version control
• Proven experience working in Agile/Scrum environments, using tools like Jira
• Strong analytical, debugging, and problem-solving skills
• Ability to collaborate effectively with cross-functional teams, including QA and developers

Preferred Qualifications

• Experience in system analysis, solution design, and technical blueprint creation
• Ability to manage multiple priorities in a fast-paced environment
• Familiarity with Oracle Redgate for code promotion
• Experience with Unix Shell scripting
• Basic understanding of Java (for cross-functional collaboration)
• Exposure to Data Warehousing concepts
• Bachelor s degree in Computer Science or related field (or equivalent experience)

Additional Requirements

• Remote Flexibility: Open to both local and non-local candidates
• Interview Format: Conducted via Google Meet (camera-on required)