Oracle Apex Database Developer,
New York City, NY
Phone + Skype
Position: Senior Database Developer with APEX
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.
PL/SQL and SQL coding, tuning and troubleshootingOracle 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 12cOracle Rest Data Services (ORDS) installationOracle 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.
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 optimizationStrong working knowledge of Oracle PL/SQL features for performance and new features launched with 11g and 12cOracle APEX 4.x/5.x administration and development.Oracle Rest Data Services (ORDS) installation and web services developmentUnderstanding of NoSQL distributed databases, MongoDB/DynamoDBJava (J2EE) application developmentOracle Database 11g and 12c experience is requiredApache Tomcat installation and administration.Understanding of Data Modeling concepts and Database designStrong command of English language, both oral and writtenExcellent self-tasking and team work skills
Practical experience with one or more of the following preferred, but not required:
Must have good problem-solving, trouble-shooting and communication skillsVery strong writing and speaking skillsClient-facing skillsGood interpersonal skillsMentoring and tutoring skillsPractical experience with Perl and Perl DBI, Shell ScriptKnowledge of e-Commerce systemsExperience with Oracle APEX Development and security access implementation
Bachelor's Degree in Computer Science or Software Engineering