Sr OFSAA and Oracle Database

• Acts as a lead in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology within the OFSAA framework / Oracle Datamart.
• Analyzes business requirements, architects and writes technical specifications to design or redesign computer solutions.
• Configures OFSAAi data flows using provided out-of-the-box as well as custom T2Ts, rules framework, task and batch schedules, integrates existing flows provided by vendors.
• Installs, configures and troubleshoots OFSAA installations and participates in upgrades.
• Leads projects and project teams, including assignment of tasks, and provides mentorship, direction, and guidance to less experienced staff.
• Develops original and complex solutions or provides technical guidance to less experienced staff.
• Leads and/or performs modeling, simulations and analysis efforts.
• Verifies program logic by overseeing the preparation of test data, testing and debugging of programs written using SQL, PL/SQL or UNIX scripting.
• Participates in overall systems integration testing. Provides input and direction on the scope of testing scripts. Maintains testing data for SIT and UAT environments.
• Analyzes and troubleshoots various Oracle performance issues (for both batch processing as well as end-user interaction) in the datamart.
• This leads to the migration of applications to production according to the SDLC model.
• Develops new documentation, participates in the development of department technical procedures and designs user guides.
• As an escalation point for application support and troubleshooting, provides guidance and direction to less experienced staff in resolution of escalated issues and/or complex production, application or system problems for various front-end applications, downstream and upstream applications and others.
• Assures quality, security and compliance requirements are met for supported area and oversees updating and testing of the business continuation plan.
• The ideal candidate will be an individual who takes ownership of a process and accountability for its day to day activities, is able to work independently or as part of a team, and seeks to work on a diverse range of programming languages.

• 7+ years of application development and implementation experience
• 4+ years of UNIX experience
• 8+ years of Oracle experience
• 3+ years of Oracle Financial Services Analytical Applications (OFSAA) experience
• 5+ years of experience leading the requirement design process with both technical and business partners
• 8 + years of experience writing relational database queries for stored procedures, query optimization and performance tuning
• 8+ years of PL/SQL experience

Desired Qualifications

• Good verbal, written, and interpersonal communication skills
• A BS/BA degree or higher in science or technology
• Business intelligence experience
• ETL (Extract, Transform, Load) Programming experience
• OBIEE (Oracle Business Intelligence Enterprise Edition) experience
• Knowledge and understanding of accounting principles and policies, * Understanding of batch processing and scheduling tools.
• Familiarity with Oracle GL business suite and its processing.
• Understanding of Java and .NET-related technologies.