Top 38 Oracle pl sql developer Jobs in Pennsylvania

Senior Database Developer / Engineer (SQL Server to Oracle Migration
Core Alliance Group —Pittsburgh, PA
- Temporary
- In-person
- Senior level
- 10 years
Quick Apply
Senior Developer (Oracle ERP)
Wesco —Pittsburgh, PA
- $81,753 - $110,366 a year
- Urgently hiring
- Remote
- 6 years
- System design
- Bachelor's degree
- Health insurance
- Dental insurance
Software Engineer II *** EST Preferred - Hybrid in Horsham, PA
Lexis Nexis —Horsham, PA
- $71,600 - $119,400 a year
- Full-time
- Hybrid work
- Computer science
- Computer Science
- Software troubleshooting
- Disability insurance
- Health insurance
SOFTWARE DEVELOPER (Oracle)
DVI Technologies —Allegheny County, PA
- Full-time
- Mid-level
- Travel
- Software development
Software Engineer II *** EST Preferred - Hybrid in Horsham, PA
LexisNexis —Horsham, PA
- $71,600 - $119,400 a year
- Full-time
- Hybrid work
- Computer science
- Computer Science
- Software troubleshooting
- Disability insurance
- Health insurance
JAVA DEVELOPER
Software Merchant —Wayne, PA
- Oracle
- Mid-level
- US work authorization
Web & SQL Developer
City of Philadelphia —Philadelphia, PA
- $80,000 - $87,000 a year
- Email
- Microsoft Access
- Computer Science
- Mid-level
- Wellness program
- Paid holidays
Quick Apply
2d
M-12.10-Oracle Apex developer (788519)
FHR —Harrisburg, PA
- Contract
- Remote
- Software troubleshooting
- Senior level
- 10 years
Quick Apply
Oracle EPM Developer
DEW Softech Inc —Allentown, PA
- Full-time
- Remote
- Oracle
- 5 years
- Mid-level
Quick Apply
Computer Programmer
Unica Group —Mechanicsburg, PA
- Computer Science
- Mid-level
- Office
Software Engineer Lead (ETL)
PNC Financial Services Group —Pittsburgh, PA
- $86,250 - $158,125 a year
- Full-time
- Oracle
- Office
- 3 years
- Wellness program
- Health savings account
SOFTWARE DEVELOPER
Software Merchant —Wayne, PA
- Oracle
- Mid-level
- Office
SOFTWARE DEVELOPER (Java)
DVI Technologies —Allegheny County, PA
- Full-time
- Oracle
- Mid-level
- SQL
Software Engineer Sr - JAVA/Linux/API/SQL/AML
PNC Financial Services Group —Pittsburgh, PA
- $55,000 - $132,500 a year
- Full-time
- Office
- 3 years
- Java
- Wellness program
- Health savings account
Sr. Software Developer
Vanator —Fort Washington, PA
- $50 an hour
- Contract
- Office
- AWS
- In-person
Quick Apply
Eagle Developer
Visvero, Inc. —Pittsburgh, PA
- Full-time
- 7 years
- Computer Science
- System design
Software Engineer Lead (ETL/Regulatory Risk & Compliance)
PNC Financial Services Group —Pittsburgh, PA
- Full-time
- Office
- 3 years
- Bachelor's degree
- Wellness program
- Health savings account
Principal Software Engineer
CVS Health —Pennsylvania
- $144,200 - $288,400 a year
- Full-time
- Remote
- Oracle
- High school diploma or GED
- Bachelor's degree
- Health insurance
- Dental insurance
8d
Software Engineer Lead - Java, Spring boot, Kafka
PNC Financial Services Group —Pittsburgh, PA
- $67,500 - $172,500 a year
- Full-time
- Azure
- Oracle
- System design
- Wellness program
- Health savings account
Senior Angular Developer
ValueBase Consulting —Pittsburgh, PA
- $65 an hour
- Computer science
- Oracle
- Computer Science

I want to receive the latest job alert for oracle pl sql developer in pennsylvania

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

oracle pl sql developer jobs near pennsylvania

Java Developer jobs in Pittsburgh, PA

Principal Software Engineer jobs in Pennsylvania

Software Engineer jobs in Wayne, PA

Senior Software Engineer jobs in Fort Washington, PA

Oracle Developer jobs in Harrisburg, PA

Senior Developer jobs in Pittsburgh, PA

Software Engineer jobs in Allegheny County, PA

Computer Programmer jobs in Mechanicsburg, PA

SQL Developer jobs in Philadelphia, PA

Senior Database Developer jobs in Linthicum, MD

Senior Part Time jobs in Fort Lauderdale, FL

Senior Database Developer jobs in Plano, TX

Senior Database Developer jobs in San Antonio, TX

Senior Database Developer jobs in San Diego, CA

Brightview Senior Living jobs in Columbia, MD

Java Developer jobs in New Jersey

Java Developer jobs in Glen Allen, VA

Java Developer jobs in Greensboro, NC

Java Developer jobs in Atlanta, GA

Java Developer jobs in Naperville, IL

Senior Database Developer / Engineer (SQL Server to Oracle Migration

Core Alliance Group -
Pittsburgh, PA

Quick Apply

Job Details

Temporary | Contract

Qualifications

Performance tuning
Stored procedures
Database migration or upgrading
Integration testing
SSIS
System tuning
PL/SQL
T-SQL

Full Job Description

Job Title:Senior Database Developer / Engineer (SQL Server to Oracle Migration)

Location: Pittsburgh, PA

Duration :6 Months Contract

Role Summary
We’re looking for a senior database engineer with strong experience in SQL Server, Oracle,
and SSIS/SSRS to support a critical migration initiative. This is a hands-on role focused on
converting database logic, handling dynamic SQL, migrating data, and ensuring the system
runs reliably on Oracle while maintaining existing ETL processes and reports.

Key Responsibilities
Database Migration & Conversion
 Work on end-to-end migration from SQL Server to Oracle
 Convert schemas, tables, indexes, views, and functions to Oracle-compatible formats
 Identify and resolve platform-specific differences between SQL Server and Oracle
 Ensure database design aligns with Oracle best practices

Stored Procedure & Query Conversion (Core Area)
 Convert complex T-SQL stored procedures and queries into PL/SQL
 Work extensively with dynamic SQL conversion and refactoring
 Handle differences in:
o Transactions and error handling
o Temporary tables and session-level objects
 Refactor logic where direct conversion is not feasible
 Ensure converted code is stable, optimized, and easy to maintain

Data Migration
 Support migration of large datasets with controlled downtime
 Design and implement efficient data movement strategies
 Validate and reconcile data between source and target systems
 Handle edge cases to ensure data accuracy and completeness

ETL & Reporting (SSIS / SSRS)
 Work on existing ETL and reporting layers with no major redesign

 Update and validate:
o Connection managers to point to Oracle
o Inline queries and stored procedure calls
 Ensure compatibility of ETL workflows and reports with Oracle backend
 Perform end-to-end validation to confirm processes run as expected

Performance Tuning
 Analyze and optimize query performance in Oracle
 Compare behavior between SQL Server and Oracle execution
 Trouble shoot issues observed after migration
 Tune indexes, execution plans, and database design as needed

Testing & Validation
 Support unit, integration, and system testing cycles
 Help identify and fix issues discovered during testing
 Work closely with QA and business teams to validate outcomes

Cutover & Production Support
 Participate in migration rehearsals and production cutover
 Support deployment and provide hyper care after go-live
 Troubleshoot and resolve production issues quickly

Required Skills & Experience
 10+ years of experience in database development/engineering
 Strong hands-on experience in:
o SQL Server (T-SQL, stored procedures, dynamic SQL, SSIS, SSRS)
o Oracle (PL/SQL, performance tuning)
 Solid understanding of differences between SQL Server and Oracle
 Experience working on database migration or modernization efforts

Nice to Have
 Experience with large-scale data migration

 Familiarity with tools like Oracle Data Pump, Goldengate, or similar
 Exposure to ETL and reporting tools (SSIS, SSRS)
 Experience in financial or regulatory systems

What We’re Looking For
 Strong focus on logic-driven conversion, especially dynamic SQL handling
 Comfortable working in critical migration paths with dependencies
 Strong troubleshooting and analytical mindset
 Ability to collaborate across DBA, development, and QA teams

Success in This Role Looks Like
 Stable and performant Oracle environment post-migration
 Smooth migration with no disruption to ETL and reporting
 Clean cutover and quick stabilization during hyper care

Work Location: In person

Quick Apply

Refine Your Search

oracle pl sql developer jobs in pennsylvania

Senior Database Developer / Engineer (SQL Server to Oracle Migration

Senior Developer (Oracle ERP)

Software Engineer II *** EST Preferred - Hybrid in Horsham, PA

SOFTWARE DEVELOPER (Oracle)

Software Engineer II *** EST Preferred - Hybrid in Horsham, PA

JAVA DEVELOPER

Web & SQL Developer

M-12.10-Oracle Apex developer (788519)

Oracle EPM Developer

Computer Programmer

Software Engineer Lead (ETL)

SOFTWARE DEVELOPER

SOFTWARE DEVELOPER (Java)

Software Engineer Sr - JAVA/Linux/API/SQL/AML

Sr. Software Developer

Eagle Developer

Software Engineer Lead (ETL/Regulatory Risk & Compliance)

Principal Software Engineer

Software Engineer Lead - Java, Spring boot, Kafka

Senior Angular Developer

I want to receive the latest job alert for oracle pl sql developer in pennsylvania

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected