Oracle Developer

Info Way Solutions LLC
Princeton, NJ, United States
4 days ago
Apply on www.adzuna.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
8 years minimum
Working hours
Regular working hours
Job source

Tech stack

Unit Testing Code Review Databases Information Engineering Data Integration Data Integrity Extract Transform Load (ETL) Database Design Software Debugging Oracle Databases Oracle SQL Developer Performance Tuning
+9 more
Query Optimization SQL Stored Procedures PL-SQL SQL Databases Enterprise Data Management Freeform SQL Database Optimization Analytic Functions Indexer

Job description

We are looking for an experienced Oracle Developer with strong expertise in Oracle SQL and PL/SQL development. The candidate will be responsible for designing, developing, enhancing, and maintaining database applications, optimizing complex SQL queries, and supporting enterprise data processing systems., * Design, develop, and maintain Oracle database applications.

  • Write complex SQL queries, PL/SQL stored procedures, functions, packages, and triggers.
  • Perform database performance tuning and query optimization.
  • Analyze execution plans and improve SQL query efficiency.
  • Develop and maintain database objects, including tables, views, indexes, and materialized views.
  • Work with large volumes of structured data and complex database transactions.
  • Develop and support ETL processes and data integration workflows.
  • Troubleshoot database-related issues and resolve production defects.
  • Collaborate with application developers, business analysts, and data engineering teams.
  • Participate in code reviews, unit testing, deployment, and production support.
  • Ensure data integrity, security, and database reliability.

Requirements

Experience: 8+ years (suggested target; confirm with official requirement), Experience in banking, financial services, investment management, or capital markets is highly preferred., 1. Strong experience in Oracle SQL and PL/SQL.

  1. Hands-on experience with stored procedures, functions, packages, and triggers.
  2. Strong understanding of Oracle Database architecture.
  3. Experience in SQL query optimization and performance tuning.
  4. Experience with complex joins, subqueries, analytical functions, and indexing.
  5. Knowledge of database design and data modeling.
  6. Experience with ETL processes and data integration.
  7. Strong debugging and problem-solving skills.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.adzuna.com
Prepare application

Good distractions

Loading talks and stories from around this role…