PLSQL 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 troubleing ss
• ETL experience / transactions into the backend with PL / SQL (strong ss on integration of data from various sources)
• strong ss with TSQL Development (intermediate level)
• strong soft ss / 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 doents write functional code and unit test.
• Additionally the developer will be required to fix defects on the backend so requires strong troubleing and collaboration ss.
• 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 ss 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 backend software.
• This developer will work on existing mission critical applications.
• In this role the developer must be able to interpret business requirement doents 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 ysis
• 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 doentation as required
• Provide production support
• Available to provide third tier support to the help desk on igned weekends and holidays if needed.
• Ability to work remotely and / or onsite 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 plans and optimize queries and functions
• Ability to create complex DML and debug
• Excellent troubleing and communication ss
• 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

Must have strong comm ss, tech discussions are clear and concise - expert PL / SQL Dev, but must bring tools like TOAD and SQL Plus TSQL as well