Interpro, Inc. has an opening for the position of Oracle PL/SQL Developer (Ref# SQL122SS).
Work Location: Keego Harbor, MI and relocation required to various unanticipated locations throughout the U.S.
Job Duties: Design, develop, implement, test, maintain, and support business and computer applications software or specialized utility programs, including database applications, and major enhancements of existing systems. Involved in the complete software development life-cycle. Responsible for administration and development of applications using Oracle database, PL/SQL, and Oracle APEX (Oracle Application Express). Perform application modernization, migrating existing Oracle Forms and Reports applications to Oracle APEX for large-scale business applications. Responsible for database development using PL/SQL and reporting and analytics using Power BI and Oracle Business Intelligence (BI) Publisher / Oracle Analytics Publisher. Perform integration and performance optimization of APEX applications with Oracle databases. Create PL/SQL scripts to extract data from the operational database. Implement multi-threading in PL/SQL package. Perform SQL and PL/SQL tuning and application tuning using various tools including SQL Trace. Conduct performance tuning including optimizing queries and analyzing AWR reports. Generate reporting dashboards and data extract using Tableau. Follow best practices for version control and CI/CD (Continuous Integration / Continuous Deployment). Collaborate with business analysts, stakeholders, and other IT teams to gather requirements and deliver solutions. Involved in knowledge transfer, user training, and technical documentation. Use of PL/SQL, SQL, Python, Java, Tableau, SQL Tuning Advisor, SQL Developer, Oracle, SQL Server, Linux, UNIX, and Windows.
Requirements: This position requires a Master’s degree or foreign academic equivalent in Computer Science, Computer Engineering, Information Technology, Information Systems, or a related field. Plus 2 years of experience in the job offered or a related occupation including Oracle Technical Consultant, Oracle Technical Manager, or related experience. Will accept a Bachelor’s degree in any field of study plus 5 years of progressive experience in lieu of the required education and experience. Position requires 2 years of experience with PL/SQL and Oracle database. Will accept any suitable combination of education, training, or experience as per the requirements cited herein. 40hrs/week.
Application Instructions: To apply, please MAIL resume to referenced address, ensuring to indicate the position reference code (Ref# SQL122SS) for which you are applying. Mail to: Interpro, Inc., Attn: HR, 3265 Orchard Lake Road, Keego Harbor, MI 48320.
