Position: PL/SQL Developer
Location: Brooklyn, NY
Duration: 12 Months
Position Description:
Support development. Expertise and experience in back-end data designing creating packages, procedures, functions, materialized views and complex SQL queries. In-depth understanding of Oracle 11g/12C database and hands-on experience in the development of Oracle PL/SQL language. Extensive knowledge of APEX. Collaborate with DevOps and server administrators to maintain and troubleshoot errors. Follow architecture team’s coding standards and best practices.
Mandatory Experience:
8+ years’ experience minimum.
Oracle Database Design and development (SQL & PL/SQL) with respect to Application Development
Proficient in Oracle 11g/12c database
Good understanding of Views, MVs, dB links and refresh methods.
Proficient in Web Services and Oracle Rest Data Services (ORDS)
Good understating of data transformation, schema structures
Very good understanding of Normalization /Denormalization in RDBMS
Understanding of Entity relationships between table structures and provide solution for the new DB design
Ability to deliver modern elegant web application using a combination of APEX and JavaScript
Experience in managing web page layouts with APEX templates and themes
Expertise and hands-on experience with web applications and programming languages such as HTML, CSS, JavaScript, JQuery and API’s
Knowledge of web application usability trends
Deep functional knowledge and hands on design experience with Web Services (REST, SOAP, etc.)
Good understanding of the structure of XML, JSON, DOM
Experience in responsive web design
Ability to analyze and resolve complex infrastructure resource and application deployment issues
Desirable Experience:
Knowledge of Oracle Forms and Reports and OBIEE reporting tool is a plus
Ability to write and interpret SQL queries
Knowledge in database migration, performance tuning and optimization in 12c environment
Good knowledge of ERWIN or data modelling tool
Experience in ETL, data load process, delta load process and data migration a plus
Good knowledge of JSON files development and storage using standards and best practices in Oracle 12c
Good knowledge of APEX Universal Theme
Experience in APEX Plug-in development
Experience in Oracle APEX database installation and troubleshooting
Knowledge of any HR system is a plus
Proven ability to work creatively and analytically in a problem-solving environment
