Job Title #1: Oracle Developer with UNIX scripting
Location: Remote
Position Type: Contract position
Responsibilities:
Minimum of 8 years of professional experience in Oracle development with specific focus on:
· PL/SQL and SQL coding, tuning and troubleshooting in 11g 12c and 19cenvironments with Explain Plan analysis and optimization
· Strong working knowledge of Oracle PL/SQL features for performance and new features launched with 11g 12c and 19C
· Understanding of Data Modeling concepts and Database design
· Strong command of English language, both oral and written
· Excellent self-tasking and team work skills
Additional Qualifications:
Practical experience with one or more of the following preferred, but not required:
· Practical experience with Perl and Perl DBI, Shell Script
· Knowledge of e-Commerce systems
· Experience in Data Warehouse implementations (ETL/BI Tools)
· Experience with Oracle APEX Development and security access implementation
Education Requirements:
· Bachelor’s Degree in Computer Science or Software Engineering
Key Must haves:
· Strong SQL Loader experience
· In depth Unix scripting experience
· PL/SQL and SQL coding, tuning and troubleshooting in 11g 12c and 19C environments with Explain Plan analysis and optimization
· Strong working knowledge of Oracle PL/SQL features for performance and new features launched with 11g 12c and 19C
· Oracle11g 12c and 19C experience is required
· Understanding of Data Modeling concepts and Database design
· Strong command of English language, both oral and written
· Excellent self-tasking and teamwork skills
Job Title #2: Oracle Application and Web Services Developer
Location: Remote
Position Type: Contract position
Responsibilities:
Role Description and Objectives:
Responsible for gathering requirements, document specifications and work with analysts for development, tuning and troubleshooting of Oracle PL/SQL code (Packages, Procedures, triggers, etc.), Oracle APEX 5.x Screens/Web Services and ORDS (Oracle Rest Data Services), Java (J2EE) Application Development, JSON files.
Key Responsibilities:
· PL/SQL and SQL coding, tuning and troubleshooting
· Oracle APEX 5.x workspace admin, pages and web services development.
· Web Services Development using ORDS and Oracle APEX.
· JSON files development and storage using standards and best practices in Oracle 12c
· Oracle Rest Data Services (ORDS) installation
· Oracle APEX database installation and troubleshooting.
· Experience with Application Development Support.
· Apache Tomcat installation, application deployment, jdbc connection pooling creation.
· Java (J2EE) application development.
· Conform to SQL and PL/SQL coding standards and best practices.
· Assist in database design and application development.
· Some analysis and requirement gathering as well as documenting specifications.
· Create and maintain all necessary documentation for developed applications.
Experience:
· Minimum of 7 years of professional experience in Oracle development with specific focus on:
· PL/SQL and SQL coding, tuning and troubleshooting in 10g and 11g environments with Explain Plan analysis and optimization
· Strong working knowledge of Oracle PL/SQL features for performance and new features launched with 11g and 12c
· Oracle APEX 4.x/5.x administration and development.
· Oracle Rest Data Services (ORDS) installation and web services development
· Java (J2EE) application development
· Oracle Database 11g and 12c experience is required
· Apache Tomcat installation and administration.
· Understanding of Data Modeling concepts and Database design
Special Skills:
· Practical experience with one or more of the following preferred, but not required:
· Client-facing skills
· Practical experience with Perl and Perl DBI, Shell Script
· Knowledge of e-Commerce systems
· Experience with Oracle APEX Development and security access implementation
