SUMMARY – The PL/SQL Programmer will function as a senior technical resource for a large, high-profile development effort extending a pension administration system. This position will be responsible for the developing packages, stored procedures, functions, triggers, views, and other database objects to support IS Department development efforts. The PL/SQL Programmer will also develop custom reports and be responsible for enterprise data dictionary and enterprise reporting platforms. This position will partner closely with the business stakeholders, project manager, architect, and other IS staff. This position requires critical thinking and problem solving abilities to address complex issues.
Support application development in a .Net / Oracle 11g environment
Work both independently and as part of an Agile (SCRUM) development team
Design and develop reports which integrate data from multiple LOB applications
Review and repair legacy code
Design and develop PL/SQL objects and programs
Design and develop reports against Oracle databases
Develop and maintain an enterprise data model of all production database applications
Analyzing performance issues and providing recommendation based on testing results
Proactively diagnosing and resolving problems affecting database
Maintaining database configurations in compliance with release management and change management policies
Participate in special projects and performs additional duties as required
Perform 2nd-level escalation of support tickets
Participate in special projects
Assist in development of training materials, user documentation, etc.
Knowledge, skills and general abilities:
Must be proficient in SQL and PL/SQL
Minimum 6+ years experience with hands-on PL/SQL development on Oracle 10g / 11g
Minimum 3+ years experience with logical/physical data design
Experience with Unix operating system and Unix scripting
Experience with Oracle 11g preferred
Experience with SAP Business Objects reporting tools is strongly preferred
A background working with hierarchical database systems is a plus
Experience supporting .Net applications on an Oracle database is a plus
Excellent analytical skills, time management skills, ability to prioritize and multi task, ability to routinely make effective and timely decisions in alignment with management direction is required.
Bachelor’s degree in a technical field such as computer science or equivalent combination of education and experience is required. Advanced degree preferred.
This list of duties and responsibilities is not intended to be all-inclusive and may be expanded to include other duties or responsibilities that management may deem as necessary.