Oracle PL/SQL Developer (Onsite Brooklyn, NY) Contract

Job Title: Sr. Oracle PL/SQL Developer (Onsite Brooklyn, NY)
Location: Brooklyn, NY (Onsite)
Position Type: Contract W2 or 1099
Contract Length: 6 12 months
Hours: 35 hours/week
Pay: Competitive hourly rate, based on experience
Travel: No travel required; onsite in Brooklyn, NY. In-person interview required.
Role Overview:
We're seeking a Senior Oracle PL/SQL Developer for a 6 12 month onsite contract in Brooklyn, NY. You'll own the full Oracle database development lifecycle data modeling, architecture design, SQL/PLSQL development, unit testing, and production support for mission-critical systems.
The ideal candidate has deep expertise with modern Oracle features and a strong track record of tuning complex SQL for performance and scalability.
Key Responsibilities:

• Design and develop Oracle database solutions, including architecture and data modeling.
• Create, enhance, and maintain reusable database objects (packages, procedures, functions, triggers, views, materialized views).
• Optimize and tune SQL/PLSQL for maximum efficiency and reliability in production.
• Develop using Oracle REST Data Services (ORDS) and API Gateway Cloud for database integration.
• Apply advanced PL/SQL programming techniques, including:
  • BLOBs, CLOBs, cursors, exception handling
  • Collections and MERGE statements
  • Analytic functions, indexes, views, materialized views
  • Table functions, stored procedures, triggers, dynamic SQL
  • Performance tuning, external tables, object programming
  • SQL built-in functions, joins, and aggregates
• Provide production support, troubleshooting, and performance tuning for critical Oracle workloads.

Required Qualifications:

• 5 7+ years of IT experience with proven expertise as a PL/SQL Developer.
• In-depth knowledge of Oracle databases and familiarity with recent Oracle versions/features.
• Strong analytical, problem-solving, and performance-tuning skills.
• Able to work onsite in Brooklyn, NY; in-person interview required.

Nice to Have:

• Experience with ORDS, API Gateway Cloud, and RESTful database integrations.
• Background supporting large-scale, high-transaction Oracle environments.

Please submit your updated resume and availability for an onsite interview in Brooklyn, NY.