Sr. PL/SQL Developer

Hybrid in New York, NY, US • Posted 1 hour ago • Updated 1 hour ago

Full Time

No Travel Required

Hybrid

$65+

Prutech Solutions

Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

Cloud Computing
Unit Testing
PL/SQL
SQL
Performance Tuning

Summary

About Us:

Founded in 1997, PruTech is dedicated to problem-solving, creating solutions, and maintaining strong partnerships with its clients. PruTech serves a diverse list of clients in different industries from government to finance, retail, and manufacturing. PruTech has offices in New York City, Washington DC, North Carolina, and two nearshore offices in Mexico City and India.

With over 20 years of Information Technology and system integration experience, PruTech provides multiple ways to assist organizations with future technology requirements including:

Project based system integration
Custom software solutions
Package implementations
Consulting and advisory services
Big data and analytics
Nearshore and offshore services

Sr. PL/SQL Developer

This is a hybrid role (3 days onsite) and requires availability for in-person interviews. The position focuses on advanced Oracle SQL/PLSQL development, performance tuning, reusable database objects, and exposure to ORDS / API integrations.

Oracle database development life cycle, including data modeling, architecture design, SQL/PLSQL development, unit testing, and production support.
Good exposure of new Oracle version’s inbuilt functions and features.
Create, enhance, and maintain reusable database objects.
Perform SQL query optimization and tuning to maximize speed and scale.
Apply working knowledge of Oracle REST Data Services (ORDS) and API Gateway Cloud for database integration and API management.
Demonstrate deep expertise in PL/SQL programming, covering:
Advanced data types – BLOBs CLOBs, cursors, and exception handling. Collections and merge statements
Analytic functions, Index, views, and materialized views. Table functions, stored procedures, functions, and packages. Database triggers and dynamic SQL.
External tables and object programming. SQL built-in functions, joins, and aggregate functions. Comprehensive performance tuning techniques

PruTech abides by the requirements of 41 CFR 60-1.4(a), 60-300.5(a) and 60-741.5(a). All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10117953
Position Id: 8873654
Posted 1 hour ago

Company Info

About Prutech Solutions

PruTech is an established Business Support and Information Technology consulting company with over 10 years experience in successfully partnering with private and public sector organizations. We provide the best quality and value to our clients in various industries, which include Finance, Pharmaceutical, Healthcare, Retail and Government. We help our clients achieve tactical and strategic goals by working closely with them in the areas of IT Consulting & Staffing, Customized IT Solutions, Temporary Staffing and Offshore Development Services.

Since our inception in 1998, PruTech management has strived to provide innovative solutions and exceptional staff for numerous Business Support and IT projects. With our strong recruiting expertise and in-depth experience, our responsiveness to the clients' needs is comparable to the best in the industries we serve. We always exceed client expectations in finding the best qualified professionals within the time frame and budget specified for a task.

Careers

Go to company profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.