Developer - Database (Oracle PL/SQL)

Loc:New York, NY

Dur:6 M+

Rate:OPEN

• Java that brings experience in the Investment Banking Services Industry.
• This is a 6+ month contract opportunity

KeyResponsibilities:

• Senior Oracle PL/SQL Developer - Contract
• Our client is seeking a Senior PL/SQL developer. In this role you will work directly with data architects, project managers and other developers to migrate an analytics application database from multiple databases to an integrated Oracle platform.
• Your in-depth experience with problem solving capabilities, solution design, PL SQL development and Linux shell scripting will be crucial to migrating/developing complex procedural SQL code to PL/SQL.

Minimum Educationrequirements:

• Degree in Computer Science, MIS, or other related
• Engineering field Oracle Advanced PL/SQL -- Oracle Certified Professional level or higher

Responsibilities:

• Learn the application specific subject matter behind the procedural code to be migrated Formulate high-performing technical design/solution to solve for complex data models.
• Hands on developer migrating procedural SQL code from other DBMS to robust, high quality and performant PL/SQL code and Linux shell scripts.
• Test and promote code from DEVELOPMENT through QA, UAT to PRODUCTION.
• Create data to support, and maintain unit test cases, scenarios, and data.
• Present innovative ideas for product improvements based on understanding of complex data models.

Required:

• 5+ years experience in Oracle PL/SQL development
• 5+ years experience developing Linux/Unix shell scripts
• 5+ years experience with data loading into Oracle databases
• Must have experience implementing External tables for data loading
• Experience with PL/SQL bulk read and write code Must have experience with PL/SQL package driven development
• Experience and knowledge in the performance design aspects of PL/SQL coding
• Experience with complex SQL statements and performance aspects of SQL Understanding of data modeling concepts
• Excellent verbal and communications skills
• Prior experience in defining coding standards and best practices for Oracle PL/SQL development
• Minimum Oracle v11 experience. Knowledge/experience in 12c PL/SQL enhancements a plus
• Ability to come up with technical design for loading based on a complex data model
• Working experience in data mapping for data loading, bulk data loading and External tables
• Ability to perform SQL tuning of queries, optimize reports and data retrieval response times
• Strong in debugging and understanding existing code for modifications
• Strong analytical and problem solving skills and ability to work in a fast paced environment
• Ability to think creatively and work independently on complex tasks
• Must have strong work ethics and past accomplishments
• Recent PL/SQL development experience