Remote Oracle PL/SQL Developer | High-Volume Transactions

Kaygen, Inc.; Hoboken (NJ); Remote; USD 62,000 - 83,000; Full time

Benefits offered by this job

Free Healthcare Insurance

401(k) Retirement Plan

Free Life Insurance

Sick Time Off

Job summary

Kaygen, Inc. is seeking an experienced Oracle PL/SQL Developer for a remote, 10-month contract. You will design and optimize PL/SQL, develop stored procedures, packages, and functions, and support high-volume transactional systems.

The role emphasizes data modeling, performance tuning, and complex SQL development. You should be adept with code reviews and agile methods, use SQL Developer or TOAD, and collaborate in a fast-paced environment.

Qualifications

• Strong hands-on PL/SQL development experience.
• Expertise in building complex business logic in the database layer.
• Experience with high-volume transactional systems.
• Strong database design and performance tuning skills.

Responsibilities

• Develop and maintain Oracle PL/SQL solutions.
• Create and optimize stored procedures, packages, functions, triggers, and views.
• Design logical and physical data models.
• Write complex SQL and implement detailed business logic.
• Perform query optimization and database performance tuning.
• Troubleshoot production issues and support enterprise database applications.

Skills

Oracle PL/SQL

Stored Procedures

Packages

Functions

Triggers

Advanced SQL

Performance Tuning

Data Modeling

Git

Agile

Tools

SQL Developer

TOAD

Job description

Kaygen, Inc. is seeking an experienced Oracle PL/SQL Developer for a remote, 10-month contract. You will design and optimize PL/SQL, develop stored procedures, packages, and functions, and support high-volume transactional systems.

The role emphasizes data modeling, performance tuning, and complex SQL development. You should be adept with code reviews and agile methods, use SQL Developer or TOAD, and collaborate in a fast-paced environment.