Sign Up Sign Up Log In Sign Up
This job has expired and you can't apply for it anymore. Start a new search.

Senior Oracle PL/SQL Developer

Senior Oracle PL/SQL Developer
Position Location: Washington DC
Job Code: 1261
Number of Openings: 1
Description

Job Title:  Senior Oracle PL/SQL Developer

Location:  Washington, D.C.

Required Security Clearance : Public Trust

Required Certifications : None required

Required Education:  Master’s degree in the sciences or business, or industry-equivalent experience required.

Required Experience:  At least 5 years of experience in Oracle Database and Application Products.

At least 3-5 years of experience developing and tuning Procedural Language/Structured Query Language (PL/SQL) scripts including packages, procedures, triggers, types, blobs, and indexes. 

3-5 years of experience as an Oracle SQL, PL/SQL Developer including Oracle Forms and Reports.

Description:

The Senior Oracle PL/SQL Developer will work closely with database administrators, system administrators and developers to maintain and optimize existing Oracle products and packages.  Develops, implements, and maintains complex business, accounting, and management information systems.  Translates designs into computer software programs and code.  Tests, debugs and refines the computer software to produce the required product.  Prepares required documentation, including those required by the relevant System Development Life Cycle (SDLC) process.  Enhances software to reduce operating time or improve efficiency.  Works with Business Analysts and users to define existing or new system scope and objectives.  Performs modifications to and maintenance of operational programs and procedures. May assist users in the operations of the application, and support Tier 2/3 help desk activities.

Functional Responsibility:

The Senior Oracle PL/SQL Developer will provide the following:

  • Troubleshooting and debugging existing Oracle packages and PL/SQL scripts
  • Writing data cleanup scripts in such a way that changes can be backed out of if necessary
  • Provide day-to-day troubleshooting and investigation on Production issues, data fixes, and emergency code fixes 
  • Develop code fixes to resolve issues
  • Support quarterly releases into Production environment
  • Work with Database Administrator (DBA)s and System Administrators to isolate issues methodically and efficiently

Qualifications:

  • Experience in design, development, test, implementation and support of innovative and optimal data solutions.
  • Ability to test and tune PL/SQL and SQL code to improve performance.
  • Working knowledge of features such as query optimizer, execution plans, and indexes.
  • In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring).
  • Solid understanding of Oracle 11g / 12c: packages, procedures, functions, triggers, privileges and types, scheduler, blobs, indexes, Oracle's security model, virtual private database, partitioning.
  • Extensive use of PL/SQL packages, procedures, triggers, types, blobs, indexes.
  • Self-motivated. Strong organizational and analytical abilities.
  • Troubleshooting experience with the following products:
    • Oracle PL SQL
    • Oracle SQL
    • Oracle dbms scheduler
    • Oracle Real Application Clusters (RAC)
    • IBM AIX Korn shell scripts
    • Java
    • SQL Developer

Preferences:

·         Experience with integrating PL/SQL scripts with Lightweight Directory Access Protocol (LDAP) Authentication

·         Experience with Oracle Forms and Reports

 

 

EOE /M/F/Disability/Veterans




Are you a returning applicant?
Previous Applicants:
Email:
Password:

If you do not remember your password click here.

Back to Search Results

New Search


Powered By Taleo


Previous Applicants:
Email:
Password:

If you do not remember your password click here.

Company Name:
Security Clearance:
Public Trust
Location:
Washington, District of Columbia
Country:
United States
Salary:
Not Specified
Job Number:




Send me email alerts for similar jobs

JOIN US