What are the responsibilities and job description for the Lead Oracle Application Developer position at Lams Technology LLC?
Should be local to Albany, NY
Need Locals with Local projects
Job Title: Oracle Apex Developer
Location: NYC NY (Remote)
Job Summary:
We are seeking a highly skilled Oracle Apex Developer with expertise in PL/SQL, Power BI, and BI Publisher to modernize our legacy application currently built on Oracle Forms, Oracle Reports, and PL/SQL. The ideal candidate will be responsible for migrating and enhancing our application using Oracle Apex, integrating modern reporting tools, and ensuring seamless data management.
Key Responsibilities:
* Application Modernization: Migrate existing Oracle Forms and Reports applications to Oracle Apex while maintaining functionality and improving performance.
* Oracle Apex Development: Design, develop, and implement robust, scalable, and secure applications using Oracle Application Express (Apex).
* Database Development: Write, optimize, and maintain complex PL/SQL procedures, packages, triggers, and views.
* Reporting & Analytics: Develop interactive reports and dashboards using Power BI and BI Publisher to improve data visualization and decision-making.
* Integration & Performance Optimization: Ensure seamless integration of Apex applications with Oracle databases and optimize database performance, as well as integration with current Oracle Forms application until modernization completed.
* version Control & Deployment: Implement best practices for version control and CI/CD pipelines to manage Apex applications.
* Collaboration: Work closely with business analysts, stakeholders, and other IT teams to gather requirements and deliver solutions aligned with business goals.
* Training & Documentation: Provide knowledge transfer, training, and technical documentation to ensure smooth transition and adoption of modernized applications.
Required Qualifications & Skills:
* 5 years of experience in Oracle application development, including Apex and PL/SQL.
* Strong expertise in Oracle Apex 22.x or later, including Dynamic Actions, RESTful Web Services, and Interactive Reports.
* Proficiency in PL/SQL development, including performance tuning and optimization.
* Experience with Power BI and BI Publisher for data visualization and reporting.
* Hands-on experience in migrating legacy Oracle Forms and Reports applications to modern platforms.
* Knowledge of Oracle Database (12c/19c), SQL, and relational database design.
* Familiarity with APIs, RESTful web services, and JSON/XML processing in Oracle Apex.
* Understanding of security best practices in Apex development, including authentication and authorization mechanisms.
* Experience with source control tools (Git, Azure DevOps, or similar).
* Strong problem-solving skills, ability to work independently, and excellent communication skills.
* Strong Experience in Oracle PL/SQL
* Familiarity with Oracle Forms, Oracle Reports
* Strong development experience Oracle Apex
* Experience in cloud-based deployment (Oracle Cloud, AWS, or Azure).
* Knowledge of JavaScript, HTML, and CSS for Apex UI customization.
* Familiarity with Agile development methodologies.
* Experience with CI/CD pipeline integration for Apex applications.
Job Types: Full-time, Contract
Pay: $75,000.00 - $85,000.00 per year
Schedule:
- 8 hour shift
- Monday to Friday
Ability to Commute:
- Albany, NY 12202 (Preferred)
Ability to Relocate:
- Albany, NY 12202: Relocate before starting work (Preferred)
Work Location: Hybrid remote in Albany, NY 12202
Salary : $75,000 - $85,000
