Oracle Database Specialist

Role: Oracle Database Specialist

Location: NYC (Manhattan, Brookyn, Bronx, Queens, Staten Island)

Work mode: Onsite

Database Development: Write and optimize advanced Oracle PL/SQL and SQL Server T-SQL stored procedures, functions, and triggers.

Data Integration & Reporting: Design and deploy ETL pipelines using SSIS and build structured reports via SSRS.

Data Modeling: Architect scalable OLTP and OLAP structures using logical and physical modeling practices.

Performance Tuning: Diagnose and resolve bottlenecks using Execution Plans, Profilers, and AWR reports.

5+ years of dual experience in database administration and development.

Expertise in Oracle RDBMS and MS SQL Server.

Strong proficiency in PL/SQL, T-SQL, SSIS, and SSRS.