Oracle Developer

Dexian; Rapid City (SD); Hybrid; USD 64,000 - 104,000; Full time

Job summary

Dexian is seeking an experienced Oracle database developer for a hybrid role based near Pennington, NJ. You will build and tune Oracle databases, and craft stored procedures, packages, functions and complex queries.

The ideal candidate has 6–10 years of hands-on Oracle development, strong SQL/PLSQL skills, and the ability todebug production issues and validate data with reconciliation scripts. Java/JDBC experience is a plus.

Qualifications

• 6-10 years of hands-on Oracle database development experience.
• Strong proficiency in Oracle SQL and PL/SQL.
• Experience creating and working with stored procedures, packages, functions, and complex queries.
• Strong knowledge of SQL performance tuning and execution plan analysis.
• Experience debugging database code and resolving production issues.
• Ability to analyze data discrepancies and develop validation and reconciliation scripts.
• Knowledge of Oracle database connectivity and troubleshooting.
• Working knowledge of Java and JDBC is preferred.
• Experience troubleshooting Java applications that interact with Oracle databases is preferred.
• Strong analytical, debugging, and problem-solving skills are preferred.

Responsibilities

• Develop Oracle databases and work with stored procedures, packages, functions, and complex queries.
• Tune SQL performance and analyze execution plans.
• Debug database code and resolve production issues.
• Analyze data discrepancies and create validation and reconciliation scripts.
• Troubleshoot Oracle database connectivity and, where applicable, Java applications that interact with Oracle databases.

Skills

Analytical thinking

Debugging

Problem solving

Education

None

Tools

Oracle

SQL

PL/SQL

Java

JDBC

Job description

Salary: $64,000 - 104,000 per year

Requirements:

• 6-10 years of hands-on Oracle database development experience.
• Strong proficiency in Oracle SQL and PL/SQL.
• Experience creating and working with stored procedures, packages, functions, and complex queries.
• Strong knowledge of SQL performance tuning and execution plan analysis.
• Experience debugging database code and resolving production issues.
• Ability to analyze data discrepancies and develop validation and reconciliation scripts.
• Knowledge of Oracle database connectivity and troubleshooting.
• Working knowledge of Java and JDBC is preferred.
• Experience troubleshooting Java applications that interact with Oracle databases is preferred.
• Strong analytical, debugging, and problem-solving skills are preferred.

Responsibilities:

• Develop Oracle databases and work with stored procedures, packages, functions, and complex queries.
• Tune SQL performance and analyze execution plans.
• Debug database code and resolve production issues.
• Analyze data discrepancies and create validation and reconciliation scripts.
• Troubleshoot Oracle database connectivity and, where applicable, Java applications that interact with Oracle databases.

Technologies: JavaOracleSQLMore:

We are recruiting for a role based in Pennington, New Jersey, with a hybrid schedule of three days onsite and two days remote.

Dexian provides staffing, IT, and workforce solutions, with more than 12,000 employees and 70 locations worldwide. Formed in 2023 through the merger of DISYS and Signature Consultants, we connect talent, technology, and organizations through our brands, which include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development, Dexian IT Solutions. We are an equal opportunity employer and recruit and hire qualified candidates without regard to protected characteristics.

last updated 43 week of 2026