Cortera - A Moody's Analytics Company

Role Overview: With over 6 years of programming experience as an Oracle PL/SQL Developer, you have been involved in the Analysis, Design, and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). You have a proven track record of Database Modeling, Development, Implementation, and Maintenance, consistently meeting aggressive deadlines. Key Responsibilities: - Develop Client-Server applications using Oracle 12C/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL DEVELOPER, and SQL DEVELOPER DATA MODELER. - Utilize Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, and Query Re-Write effectively. - Create Tables, Views, Constraints, and Indexes to optimize database performance. - Design and implement complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. - Implement Materialized Views for data replication in distributed environments. - Demonstrate expertise in advanced PLSQL topics including Oracle supplied packages, Dynamic SQL, Records, Bulk Collect, and PL/SQL Tables. - Apply basic knowledge of key Oracle performance-related features such as Query Optimizer and Indexes. - Conduct Performance Tuning for Oracle RDBMS using Explain Plan and HINTS. Qualifications Required: - Excellent communication, interpersonal, and analytical skills with a strong ability to work effectively as part of a team. - Good knowledge of Agile methodology and experience working with tools like Birt and Eclipse. - Hands-on experience with the repository tool Eclipse.,