JOB 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 developing packages, stored procedures, functions, triggers, views, and other database objects to support development efforts. The PL/SQL Programmer will also develop custom reports. 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.
PRINCIPAL DUTIES AND RESPONSIBILITIES
- Support application development in a .Net / Oracle 19c 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, including packages, procedures, functions, triggers, views, materialized views, and indexes
- Analyzing performance issues and providing recommendations based on testing results
- Proactively diagnose and resolve problems affecting the database
- Maintain database configurations in compliance with release management and change management policies
- Perform 2nd-level escalation of support tickets
- Participate in special projects
- Assist in the development of training materials, user documentation, etc.
- Other duties as assigned
REQUIRED AND PREFERRED KNOWLEDGE, SKILLS, AND ABILITIES
- Minimum 6+ years’ experience with hands-on PL/SQL development on Oracle 12c / 18 / 19; Minimum 3+ years’ experience with logical/physical data design
- Bachelor’s degree in Computer Science or Computer Engineering, or a closely related discipline or equivalent experience required
- Must be proficient in SQL and PL/SQL
- Experience supporting transactional application development teams is required
- Experience supporting .Net application development teams is preferred
- Experience with Oracle 19c preferred
- Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, subject matter experts, and end users
- Demonstrates ability to manage complex issues while maintaining a flexible, positive, and cooperative demeanor
- Responds promptly to operations leaders and stakeholders to facilitate informed decision-making
- Troubleshoots assigned issues, gathers evidence and investigates all relevant information with participants, vendors, and internal departments to resolve the problem in a cooperative and collaborative manner
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.