PL/SQL Developer

Description

About Investor Reporting 2 (IR2) Investor Reporting 2 is a mediumscale (10 Mil), highperformance transaction mortgage shadow servicing system to support the governments loan modification program, one of the major work streams of Homeowners Affordability and Stability Plan (HASP). The application is being developed using proven technologies, including PL/SQL, ORACLE, AbInitio and Java in complex combinations following industry best practices for development. About the IR2 Reporting Team The IR2 Reporting Team is designing and constructing a data mart for IR2 data. Once that is complete, the team will develop a suite of operational reports for internal users, servicers, and the Treasury Department. It will also develop reports of compensation due to participants in the HMP program. About the position The Senior PL/SQL developer will participate in the design, construction, testing, and support of the IR2 data mart. Responsibilities 1. Provide technical expertise and lead junior developers. 2. Design PL/SQL implementations. 3. Optimize existing PL/SQL packages. 4. Document Technical Specifications. 5. Automate UNIT testing for PL/SQL packages. 6. Provide metrics and project planning updates for the development effort. Qualifications MustHave Skills 1. 10 years of development experience at least 5 years experience with Oracle PL/SQL. 2. Expertise in advanced PL/SQL techniques in a 9i or 10g environment. 3. Expertise in SQL tuning of large database environments (1+ terabytes). 4. Experience programming PL/SQL batch environment utilizing large tables and high transaction throughput requirements. 5. Demonstrated experience using Oracle Collections, bulking techniques, partition utilization to increase performance. 6. Demonstrated experience in a production environment. 7. Strong knowledge and use of development, methodologies, standards and procedures. 8. Ability to multitask and provide expertise for multiple development teams across concurrent project tasks. 9. Ability to provide technical expertise to junior team members and consult with other application developers to tune and performance test new and existing code base. 10. Excellent written and verbal communications skills. 11. Excellent teaming and leadership skills.