PL/SQL Developer

PL/SQL Developer

Location: Philadelphia, PA (Hybrid)

Contract Duration: 12+ months

About the role:

• 7 plus years of backend focused Development using PL/SQL.
• MUST be expert level, strong dev 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 chop combo to engage the biz and IT

Timeline to start/fill: ASAP

• Interview Process (how many rounds and any details). 30 min TEAMS IV - 2 rounds. Technical in nature

Full Spec:

• This backend developer will work on existing mission critical applications utilizing various technologies such PL/SQL, ETL and TSQL development.
• 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 on the backend, so requires strong troubleshooting and collaboration skills.
• The developer should be a team player and excellent communicator and must be able to work with source control with multiple simultaneous branches.

Reminder On The Role:

• we need a STRONG Sr. PL/SQL with TECH results. App Dev with PL/SQL SME!
• Must have strong comm skills, tech discussions are clear and concise
• expert PL/SQL Dev, but must bring tools like TOAD and SQL Plus
• TSQL as well
• Must be local/ready for onsite in Philly --- will be remote/hybrid

FULL SPEC / updated for Backend DEV:

• PMT IT Application Development requires an additional 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.

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 remotely and/or on-site Requirements
• Proven experience as a PL/SQL Application Developer using Toad, SQL Plus (minimum 5 years)
• Ability to create 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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.