APPLICATION PROGRAMMER V/ ORACLE PL/SQL DEVELOPER

$135,200 - $145,600/Yr

BCforward - Jersey City, NJ

Full-time - Mid Level

Jersey City, NJ

5,001-10,000 employees

Professional, Scientific, and Technical Services

About the position

The Application Programmer V/Oracle PL/SQL Developer position at BCforward involves designing, developing, maintaining, and testing software solutions in an agile environment. The role requires collaboration with the development team and business partners to ensure successful delivery and implementation of application solutions. The developer will be responsible for hands-on coding and must deliver projects on time and without defects, focusing on Oracle PL/SQL and database management.

Responsibilities

• Develop/modify PL/SQL and SQL Views in Oracle
• Create new tables and modify existing table structures
• Perform performance tuning and understand explain plans
• Implement normalization, renormalization, and star schema
• Develop stored procedures, database triggers, and SQL queries
• Work independently with minimal supervision

Requirements

• Strong experience with Oracle version 11.x and above
• Proficient in Procedures, Functions, Packages, Views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections, objects, and writing complex queries
• Familiarity with version control tools (SVN/Bitbucket)

Nice-to-haves

• Experience with Informatica
• Knowledge of Python

Benefits

• Major medical insurance
• Health Savings Account (HSA)
• Dental insurance
• Vision insurance
• Employer-provided group life insurance
• Voluntary life insurance
• Short-term disability
• Long-term disability
• 401k