Oracle PL/SQL Programmer

Job Role: Oracle PL/SQL Programmer

Duration: 6 months+

Location: Onsite in Rockville, MD – No Relocation candidates

Visa: USC, GC only

Interview: 2 rounds one of them will be onsite

Note: Need non proxy candidate.

Background: national criminal search, county criminal search, sex offender registry, social security IDTrace, restricted/denied/excluded parties list check, and E-Verify – AND Drug Test!! No exceptions

Top 3 skills/ How are they applied?

• Looking for ideally 6 years of hands-on Dev with PL/SQL, Oracle 12c/18/19c
• Data Design and Supporting transactional application development
• Good collaborative communication
  
  

General Summary Of Position

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
  
  

Non-essential Functions

• Participate in special projects
• Assist in development of training materials, user documentation, etc.
  
  

Qualifications

• 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 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.
  
  

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.