Oracle Developer

Job Title:  Oracle Developer (PL/SQL, APEX, Oracle Forms Experience) 

Location:  Phoenix, Arizona (On-site, near I-17 & Peoria) 

**Hybrid/Remote work 1-2 days a week available after the first 6 months of employment.** 

Salary Range:  $100,000 - $120,000 DOE  Position Type:  Full-Time 

Position Overview: 

Chas Roberts is seeking a versatile and highly accountable Oracle Developer to serve as the primary developer for Oracle-based applications across multiple departments. This role operates as the primary day-to-day developer and collaborates with IT Leadership on escalated architectural, cross-system, or modernization decisions. This individual will manage, develop, and maintain Oracle applications and tangential 3rd party applications and integrations. The ideal candidate will demonstrate technical expertise in PL/SQL coding, Oracle APEX, and Oracle Forms, and possess exceptional interpersonal and documentation skills to support a diverse organizational environment. 

Key Responsibilities: 

Core Development & Maintenance: 

• Serve as the primary programmer supporting multiple departments by developing, maintaining, and optimizing Oracle-based applications. 

• Write, optimize, and maintain complex SQL queries for Oracle databases. 

• Design, develop, and implement user-friendly applications in Oracle APEX to meet diverse departmental needs. 

• Support, develop, troubleshoot, and manage Oracle Forms-based systems to ensure continued functionality. 

Upgrades & Migrations: 

• Participate in the planning, testing, and execution of Oracle software patches and upgrades, ensuring minimal disruption to business operations. 

• Develop and execute comprehensive migration plans for any system upgrades or system changes needed. 

• Migrate existing Oracle Forms Processes to Oracle APEX for increased sustainability. 

Integrations: 

• Integrating software and multiple data sources using different methodologies 

• Develop and maintain web API’s, SFTP, point-to-point integrations, Pub & Sub, etc. 

Testing & Validation: 

• Implement rigorous testing protocols to validate processes and code prior to deployment. 

• Ensure thorough testing and quality assurance for all upgrades, new developments, and changes to existing systems. 

• Collaborate with stakeholders to validate system functionality and compliance with user requirements. 

Collaboration & Accountability: 

• Act as the key point of contact for programming needs across departments, ensuring timely and accurate delivery of solutions. 

• Collaborate directly with end users and department leaders to gather requirements, provide support, and deliver high-quality results. 

• Maintain clear and consistent communication with stakeholders, proactively managing expectations and project timelines. 

• Communicate progress, blockers, and timeliness for assigned tasks to IT leadership and related department leaders. 

Documentation & Knowledge Sharing: 

• Document existing and newly developed code, workflows, and visual designs to ensure long-term maintainability and understanding. 

• Maintain up-to-date records of all upgrades, changes, and testing processes. 

• Provide technical insights and guidance to other teams or contractors when required. 

Continuous Improvement: 

• Identify opportunities for optimizing system performance, improving user interfaces, improving user security, improving data security, and enhancing workflows. 

• Stay informed about the latest Oracle technologies and trends to implement cutting-edge solutions. 

Working Conditions: 

Work Environment: Office-based with occasional remote work flexibility. 

Physical Requirements: Ability to sit for extended periods and use a computer for long hours. 

Benefits: 

• Health, Dental, Vision, Insurance offerings
• 401(k) plan with company match
• paid time off and holidays
• company wide cell phone and service plan
• opportunites for professional development and training

Required Qualifications: 

Education: Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience. 

Experience: 

• Strong proficiency in SQL development/coding and Oracle database programming. 

• Demonstrated experience developing and maintaining applications using Oracle APEX. 

• 3–5 years PL/SQL and APEX experience in production environments. 

• Exposure to or experience with Oracle Forms and other Oracle systems. 

• Expertise in software development lifecycle processes, process automation, and integrations. 

Technical Skills: 

• Expertise in SQL, PL/SQL, and database-driven application development. 

• Proficiency with Oracle databases and performance tuning. 

• Familiarity with version control systems and debugging methodology.  

• Familiarity with modern web development practices (HTML, JavaScript, PHP, WordPress,+). 

Soft Skills: 

• Exceptional problem-solving and analytical abilities. 

• Strong interpersonal skills to foster collaboration with non-technical end users and technical teams. 

• Ability to self-manage and prioritize tasks effectively in a high-accountability environment. 

Other Requirements: 

• Strong attention to detail and commitment to following best practices for testing and validation. 

• Excellent written and verbal communication skills, particularly in technical documentation. 

Preferred Qualifications: 

• Oracle Reports experience and knowledge. 

• Proficiency in developing Oracle Forms. 

• Database administration skills and experience. 

• Hands-on experience with Oracle database upgrades and migrations. 

• Experience with middleware technologies, like Tomcat or WebLogic. 

• Experience integrating legacy systems with modern application frameworks. 

• Windows Server OS knowledge and familiarity. 

• SQL Server & MySQL knowledge and familiarity. 

• Experience with Oracle Cloud Infrastructure and migrations from on-premises to cloud 

• Experience with Microsoft Active Directory and Microsoft Entra ID (Azure Active Directory)