Oracle Programmer

Position Overview:

Chas Roberts is seeking a versatile and highly accountable Oracle Programmer to serve as the primary developer for Oracle-based applications across multiple departments. This individual will take ownership of designing, upgrading, migrating, and maintaining Oracle applications while ensuring optimal performance, seamless collaboration with end users, and strict adherence to best practices. The ideal candidate will demonstrate technical expertise in SQL coding, Oracle APEX, and legacy Oracle Forms, as well as possess exceptional interpersonal and documentation skills to support a diverse organizational environment.

Key Responsibilities:

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.

Upgrades & Migrations:

• 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

Integrations:

• Integrating software and multiple data sources using different methodologies
• Develop and maintain web APIs, 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.

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, and enhancing workflows.
• Stay informed about the latest Oracle technologies and trends to implement cutting-edge solutions.

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.
• Exposure to or experience with Oracle Forms and other legacy Oracle systems.
• Expertise on software development lifecycle processes, process automation, and integrations.

Technical Skills:

• 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).

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:

• 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)