Job Title: Sr. PL/SQL Developer
Location: Brooklyn, NY 11201
Company: PruTech Solutions, Inc.
About Us:
Established in 1997, PruTech is committed to innovative problem-solving, solution creation, and fostering strong client partnerships. Serving a diverse array of industries, from government to finance, retail, and manufacturing, PruTech operates from strategic locations including New York City, Washington DC, North Carolina, and boasts a nearshore office in Mexico City and multiple offshore offices in India.
With over two decades of experience in Information Technology and system integration, PruTech offers a comprehensive suite of services to meet evolving technological needs:
- Project-based system integration
- Custom software solutions
- Package implementations
- Consulting and advisory services
- Big data and analytics
- Nearshore and offshore services
At PruTech, we are dedicated to shaping the future of technology and driving success for our clients through innovative solutions and strategic partnerships.
JOB DESCRIPTION:
- 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
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin.