Apply Now

(Sr./Lead) Application Developer I (II)

Audubon, PA, US • Posted 4 hours ago • Updated 4 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

📊 Calculating match score...

Job Details

Skills

Project Coordination
Technical Writing
Customer Satisfaction
Business Systems
Estimating
Technical Drafting
Documentation
Auditing
Unit Testing
Test Cases
Query Optimization
Software Development
Requirements Elicitation
Systems Analysis/design
Production Support
Data Modeling
Business Requirements Gathering
Systems Engineering
Integration Testing
Mentorship
Application Development
Customer Support
Collaboration
Enterprise Integration
Continuous Integration
Continuous Integration and Development
Automated Testing
Software Release Life Cycle
Management
Management Information Systems
Stored Procedures
Debugging
Testing
Attention To Detail
Analytical Skill
PL/SQL
SQL
Oracle Exadata
Oracle
Performance Tuning
Data Processing
Database
Agile
Scrum
Computer Science

Summary

Flexible Work Arrangement: Hybrid
The (Sr./Lead) Application Developer is responsible for understanding the requirements of the business units and supporting project and support teams by implementing technical systems based on those requirements. This role focuses on designing, developing, enhancing, and supporting business-critical application systems with a strong emphasis on Oracle database development and PL/SQL. The developer works with project teams, support teams, database administrators, testers, architects, and business subject matter experts to ensure technical solutions meet business needs and are developed and implemented with high quality.
The ideal candidate will have extensive hands-on experience developing complex PL/SQL solutions, deep familiarity with Oracle databases, and proven experience working with very large tables and views. Experience with Oracle Exadata is a plus. The scope of responsibility includes project support, maintenance, production support, troubleshooting, technical documentation, code reviews, and mentoring other developers.

Essential Functions:
Customer satisfaction

Understand the development needs of the business units and establish a positive, service-oriented relationship by ensuring timely and accurate delivery of application systems
Learn the business - develop a solid understanding of the business functions and processes and implement solutions based on that understanding
Establish and maintain high client satisfaction levels
Document, track and resolve problems in client business systems

Solution delivery

Have primary responsibility for technical deliverables associated with application code development, including work estimates, detailed and technical design documentation, application code and associated documentation including documentation to fulfill audit requirements
Determine (Sr.) and document technical requirements for application systems, including system, module and unit design, unit test plans and test cases
Design, develop, debug, test, enhance, and support applications using Oracle PL/SQL and related Oracle database technologies
Develop and optimize PL/SQL packages, procedures, functions, triggers, SQL queries, views, database links, and other database objects
Work with very large Oracle tables and views, including query optimization, performance tuning, indexing considerations, and data access patterns
Support all phases of the software development lifecycle, including Requirements Gathering, Analysis, Design, Testing, Implementation, and Production support for PJM software systems.
Work with the database analyst/administrator to develop a data model appropriate to the application development solution
Develop, debug and test computer applications based on user requirements documentation, and on input from subject matter experts.
Debug, remediate and enhance existing computer applications based on documented variances and enhancement requests, and with guidance from subject matter experts.
Develop and maintain design documents to be used to develop applications.
Follow the approved methodology for application systems development and maintenance.
Respond, as necessary, to support calls in off-hours in order to support 24X7 applications.
Assist testing staff in developing product and integration testing approaches.
Assist business clients and work teams in integrating systems from external vendors
(Sr.) Mentor other staff members to ensure consistency in development approaches and in understanding of development processes
Identify and recommend application system solutions to business problems and enhancements to existing systems
Identify enhancements to application development standards and best practices.
Build and develop strong relationships with ITS's business clients by providing superior customer support as demonstrated by clearly owning, resolving and communicating issues and problems, and being responsive to needs, requirements, and deadlines
Collaborate with cross-functional Scrum or project teams, including developers, business analysts, testers, architects, database administrators, and business clients
Support application integrations with internal systems, external vendors, and enterprise integration platforms
Support the operation of a continuous integration environment, including development of automated test cases, build and release management support, and defect correction support as applicable

Characteristics and Qualifications:
Required:

Bachelor's degree in Computer Science, Management Information Systems or equivalent work experience

At least 5 years of experience Extensive experience developing applications and database solutions using Oracle PL/SQL.

Deep familiarity with Oracle databases, including SQL queries, tables, views, indexes, stored procedures, packages, functions, triggers, database links, and related database objects.
Experience working with very large Oracle tables and views in enterprise or high-volume environments.
Experience troubleshooting, tuning, and optimizing complex SQL and PL/SQL code.
Experience developing, debugging, testing, enhancing, and supporting business-critical applications.

Ability to produce high-quality work products with attention to detail
Ability to visualize and solve complex problems
Ability to apply analytical and mathematical solutions
Experience in developing applications using Oracle PL/SQL
Experience with DBMS concepts (including SQL queries, tables, views, DB links, etc.)

Preferred:
Experience with Oracle Exadata.
Experience with Oracle performance tuning in large-scale database environments.
Experience supporting applications that rely on high-volume data processing, complex views, large joins, and performance-sensitive database operations.
Experience working in Agile/Scrum teams
MS, Computer Science
Experience with PJM operations, markets, and planning functions

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.

Dice Id: pjmint
Position Id: 318de4c2d5a4c7e04eb4125663e95cf0
Posted 4 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Hybrid in Oaks, Pennsylvania

•

Yesterday

Role: Sr. PL/SQLDeveloper Location:Oaks,PA (In-Person Interview Required) Need to candidate who can work onsite from Day 1 (onsite hybrid 3 days onsite a week) SkillsRequired: 58+yearsofhands-onexperiencewithOraclePL/SQLdevelopment. Strongexpertisein:PL/SQLprogramming,Storedproceduresandquerytuning,SQLperformanceoptimization,Functions,triggers,packages. ExperienceworkingwithOracle11g/12c/19c. SolidunderstandingofRDBMSconcepts,indexes,partitions,anddatabaseutilities. Abilitytounder

Easy Apply

Third Party, Contract

Depends on Experience

Senior SQL Developer

Phoenixville, Pennsylvania

•

2d ago

Senior SQL Developer Oaks, PA Contract Need candidate to work onsite from Day 1 (Hybrid) Highly preferred Local and nearby candidates. Experience: 09+ years Skills Required: Strong SQL ProgramingExperience with Oracle PL/SQL as there is some work related to migration from SQL to OracleExperience with both maintenance & production support as well as development activities. Strong exp. with Business Objects report creation/maintenanceExperience with Power BI.Strong exp. with SSIS (SQL Server In

Easy Apply

Contract, Third Party

60+

PostgreSQL Developer

Trenton, New Jersey

•

Today

PostgreSQL Developer Location: Trenton, NJ (Hybrid Candidates must work 3 days a week ON-SITE) Contract Duration: 12+ Months An onsite interview is required for this job. Interview process: After your candidate has been approved, they will receive an automated screening questionnaire that they must complete. The client requires an onsite interview. Strong communication skills are required. Job Description We are looking for a PostgreSQL Developer to design, build, and maintain healthcare dat

Easy Apply

Full-time, Contract, Third Party

PostgreSQL Developer-Locals // NJ

Hybrid in Trenton, New Jersey

•

2d ago

Job Description We are looking for aPostgreSQLDeveloper to design, build, and maintain healthcare data integrations across systems using PostgreSQL and Oracle, ensuring seamless data interoperability between internal and third-party health systems. This position will beFull-Time and Hybrid (3 days in-office) in Trenton, NJ. This is a 1+ year contract engagement. An onsite interview is required for this job. What Youll Do Design and develop key modules within our client''s system Collaborate w

Easy Apply

Full-time

Depends on Experience

Search all similar jobs

More jobs at PJM Interconnection in Audubon, PA

(Sr./Lead) Application Developer I (II)

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs