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