Oracle PL/SQL Developer

Oracle PL/SQL Developer

Long term contract position available in Philadelphia, PA. Remote work with occasional on-site visits required. Candidates need to take an online PL/SQL technical test. Visa sponsorship is not available (no CPT/OPT/H1B). Two interview rounds.

Local candidates within 1 hour of Center City Philadelphia, PA preferred.

Top Technical Skills:

• 7 plus years of backend focused development using PL/SQL. Must be expert level with strong development and troubleshooting skills.
• ETL experience/transactions into the backend with PL/SQL (strong skills on integration of data from various sources).
• Strong skills with TSQL Development (intermediate level).
• Strong soft skills/tech combo to engage the business and IT.

Job Description:

Oracle PL/SQL developer to create back-end software. This developer will work on existing mission critical applications. In this role, the developer must be able to interpret business requirement documents, write functional code and unit test. Additionally, the developer will be required to fix defects in legacy code. The developer should be a team player and excellent communicator and must be able to work with source control on multiple simultaneous branches.

Requirements:

• Proven experience as a PL/SQL Application Developer using Toad, SQL Plus (minimum 5 years).
• Ability to create queries, views, packages, functions, and stored procedures.
• Ability to work with collections.
• Ability to work with async processes.
• Interpret execution plans and optimize queries and functions.
• Ability to create complex DML and debug.
• Excellent troubleshooting and communication skills.
• Attention to detail is of the utmost importance.
• BS/BA in Computer Science, Engineering, or equivalent experience with at least 5 years of development experience.

Responsibilities:

• Participate in requirements analysis.
• Take direction from senior developers.
• Collaborate with internal teams to produce software.
• Write clean, scalable code.
• Unit test and prepare applications for deployment.
• Revise, update, refactor and debug code.
• Improve existing software.
• Create documentation as required.
• Provide production support.
• Available to provide third tier support to the help desk on assigned weekends and holidays if needed.
• Ability to work hybrid on-site.