Princeton, New Jersey
SORRY, NO 3rd PARTIES!!!
A Contract position at an acknowledged market leader in institutional investing.
Pay Options: IC - Self Incorporated or w2.
Contact Claire Volis. call (732) 791-4721 / (212) 616-4800 ext.590 or email firstname.lastname@example.org
with the Job Code AT31385 or Click the Apply Now button ().
Detailed Info: Accomplished, result-oriented, self-motivated, analytical, and organized PL/SQL Developer with excellent programming skills, having experience in all stages of SDLC, using variety of software
Development methodologies, including Agile.
Development/Computing Environment: Experience in implementation of business application using Oracle Relational Databases in Oracle (12c, 11g, 10G, 9i, 8i) and related Oracle technologies and utilities.
Expertise in Oracle PL/SQL coding dealing with and custom data structures like collections, varrays and object tables.
Expertise in structuring code using Oracle PL/SQL packages, procedures, functions, triggers using Oracle PLSQL Development tools like Quest Toad for Oracle, Oracle SQL Developer, etc.
Expertise in SQL-98 and -93 writing different types of SQL queries including sub queries, hierarchical queries, co related queries, oracle extensions, analytical queries, etc.
Excellent problem-solving skills with ability to perform requirement analysis, contribute to requirement discussions with end users, and convert acquired knowledge into actionable code design. Good writing skills to record/document mapping between business requirements, application's expected behavior and code design.
Solid understanding of architecture and data analysis and modeling. Ability to read and understand complex data models.
Exposure to data and architecture modeling tolls like ERWIN, UML and BPMN, and related tools.
Solid understanding of physical database design for OLTP and OLAP systems.
Hands on experience on ORACLE database tuning, SQL performance tuning, on using SQL Plan baselines, AWR, ASH, and DBMS_Advisor oracle APIs and performance tuning of PLSQL code.
Hands on experience on maintaining performance levels via DB maintenance by using Oracle APIs like DBMS_SPACE, DBMS_STATS, UTL_FILE, DBMS_UTILITY,UTL_ SMTP and DBMS_SCHEDULER.
Java and .NET are plus
Skills required for the position: Oracle, PL/SQL, Data Modeling, OLAP, OLTP, ORACLE database tuning, SQL performance tuning
Location: Princeton, NJ or NYC.
The position offers competitive rate.
Job Id: 31385