Job Title: PL/SQL Developer
Location:Onsite Only- Must be Vaccinated
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.
4+ years' experience minimum.
MANDATORY SKILLS/EXPERIENCE
· 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 SKILLS/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
Familiar with HR system is plus