Sr. PL/SQL Developer
This is a hybrid role (3 days onsite) and requires availability for in-person interviews.
9 MetroTech Center, Brooklyn, NY 11201
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
Job Details:
- Oracle database development life cycle, including data modeling, architecture design, PL/SQL 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.
Never miss an opportunity! Create an alert based on the job you applied for.