Oracle PL/SQL Developer

BinTech Group; Rockville (MD); Hybrid; USD 110,000 - 140,000; Full time

Job summary

BinTech Group seeks a true back-end PL/SQL Developer for an enterprise pension administration system built in .NET. You will deliver new development in Oracle 12c/18c/19c and design database objects to support business needs, including packages, procedures, functions, triggers, and views.

You must have 6+ years of hands-on PL/SQL experience, strong data design skills, the ability to propose performance improvements, and the capacity to work with stakeholders in an Agile SCRUM environment to

Qualifications

• Must be proficient in SQL and PL/SQL.
• Minimum 6+ years’ experience with hands-on PL/SQL development on Oracle 12c/18/19c.
• Minimum 3+ years’ experience with logical/physical data design.
• Experience supporting transactional application development teams is required.
• Experience supporting .NET application development teams is preferred.
• Experience with Oracle 19c preferred.
• Excellent analytical and time-management skills; ability to prioritize and multitask.
• Bachelor’s degree in a technical field such as Computer Science or Information Systems or equivalent combination of education and experience is required.

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 database.
• Maintain database configurations in compliance with release management and change management policies.
• Perform 2nd-level escalation of support tickets.

Skills

SQL

PL/SQL

Oracle 12c/18/19c

Agile SCRUM

Analytical skills

Education

Bachelor's degree in Computer Science or Information Systems

Tools

.NET

Oracle 19c

Job description

They want a true back-end PL/SQL Developer. This role will be doing lots of new development, working on an enterprise application that is built in .NET. Looking for a candidate with 6 years of hands-on dev experience with PL/SQL and Oracle 12c/18/19c. 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.

Essential Functions

• 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 database
• Maintain database configurations in compliance with release management and change management policies
• Perform 2nd-level escalation of support tickets

Qualifications

• Must be proficient in SQL and PL/SQL
• Minimum 6+ years’ experience with hands-on PL/SQL development on Oracle 12c / 18 / 19
• Minimum 3+ years’ experience with logical/physical data design
• Experience supporting transactional application development teams is required
• Experience supporting .Net application development teams is preferred
• Experience with Oracle 19c preferred
• Excellent analytical skills, time management skills, and the ability to prioritize and multi-task are required.
• Bachelor’s degree in a technical field such as Computer Science or Information Systems or equivalent combination of education and experience is required.

Requirements

back-end PL/SQL Developer, .NET, PL/SQL and Oracle 12c/18/19c