
Oracle Programmer
- Phoenix, AZ
- $60.00-65.00 per hour
- Permanent
- Full-time
- Expertise in SQL, PL/SQL, and database-driven application development.
- Proficiency with Oracle databases 10g, 11g, 12c, or later versions and performance tuning.
- Familiarity with version control systems and debugging methodology.
- Familiarity with modern web development practices (e.g., HTML, JavaScript).
- Experience with Microsoft Active Directory and Microsoft Entra ID (Azure Active Directory)
Core Development & Maintenance:
- Serve as the sole 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, troubleshoot, and upgrade legacy Oracle Forms-based systems to ensure continued functionality and integration with modern platforms.
- Lead the planning, testing, and execution of Oracle software upgrades, ensuring minimal disruption to business operations.
- Develop and execute comprehensive migration plans for moving systems to newer Oracle versions or alternative platforms when required. Example: Migrating Forms to APEX
- Integrating software and multiple data sources using different methodologies
- Develop and maintain web API’s, SFTP, point-to-point integrations, Pub & Sub, etc.
- 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.
- 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.
- 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.
- Identify opportunities for optimizing system performance, improving user interfaces, and enhancing workflows.
- Stay informed about the latest Oracle technologies and trends to implement cutting-edge solutions.
- Strong proficiency in SQL development/coding and Oracle database programming.
- Demonstrated experience developing and maintaining applications using Oracle APEX.
- Exposure to or experience with Oracle Forms and other legacy Oracle systems.
- Expertise on software development lifecycle processes, process automation, and integrations.
- 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.
- Strong attention to detail and commitment to following best practices for testing and validation.
- Excellent written and verbal communication skills, particularly in technical documentation.
- 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
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.