Oracle PL/SQL Developer — High-Volume DB & Performance

Kaygen, Inc.; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Free Healthcare Insurance

401(k) Retirement Plan

Free Life Insurance

Sick Time Off

Mentorship Program

Certifications

Referrals

Family and Wellness benefits

Continuous Growth and Career Develp.

Job summary

Kaygen, Inc. seeks an experienced Oracle PL/SQL Developer to design and optimize database logic for high-volume transactional systems. You will implement complex SQL, develop stored procedures and data models, and ensure robust performance tuning.

The role emphasizes on-site work at alternate locations with a focus on delivering enterprise-grade Oracle solutions. Strong PL/SQL skills and experience with SQL Developer/TOAD are essential.

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

Advanced SQL Development

Query Optimization and Performance Tn

Execution Plan Analysis

Data Modeling (Logical and Physical)

SQL Developer / TOAD

Git and Agile methodologies

Tools

SQL Developer / TOAD

Job description

Kaygen, Inc. seeks an experienced Oracle PL/SQL Developer to design and optimize database logic for high-volume transactional systems. You will implement complex SQL, develop stored procedures and data models, and ensure robust performance tuning.

The role emphasizes on-site work at alternate locations with a focus on delivering enterprise-grade Oracle solutions. Strong PL/SQL skills and experience with SQL Developer/TOAD are essential.