Oracle PL SQL Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Collabera LLC, is seeking the following. Apply via Dice today! Job Title: Oracle PL SQL Developer Location: Jerseycity ,NJ /Addison,TX (Onsite Interview , Local candidates only ) Work Arrangement:3days in Office (Hybrid ) Client Industry: Banking Duration: 12 -18 months Contract Schedule: Monday to Friday About The Role We are hiring an Oracle PL SQL Developer Day to Day: • Develop and deploy scalable data warehouse architectures to support enterprise data needs. • Write, maintain, and optimize complex Oracle PL/SQL code, including packages, procedures, functions, and triggers while tuning queries, tables, and indexes using execution plans and AWR reports. • Build and maintain high-performance ETL frameworks to support data ingestion, transformation, and integration across systems. • Design conceptual, logical, and physical data models and manage database structures including partitions, indexes, CDC, and data lifecycle processes. • Analyze datasets to identify trends and insights while collaborating with business and technology stakeholders to translate requirements into technical solutions, data mappings, and design artifacts. • Assist with building ad hoc and operational reports and support data testing, validation, and quality assurance for applications and data workflows. Must Haves: • 12+ years of hands-on experience designing and implementing scalable data solutions in large-scale data warehousing environments. • A10+ years of experience developing complex Oracle PL/SQL code and performing DBA-related responsibilities including database performance tuning and optimization. • Strong ability to analyze Oracle execution/query plans and AWR reports to identify performance bottlenecks and implement improvements through query, table, and index optimization. • Proficiency designing conceptual, logical, and physical data models for enterprise data warehouse solutions. • Proven experience building high-performance ETL pipelines and frameworks with robust error handling and scalability. • Strong working knowledge of database partitions, indexes, change data capture (CDC), data purging, and data virtualization. • Experience performing data analysis, data exploration, and validation while working closely with business stakeholders to gather requirements and translate them into technical solutions and data workflows. • Experience working in Agile teams and collaborating with cross-functional stakeholders to deliver scalable data solutions. Plusses: • Experience with data visualization tools such as Tableau (preferred) or Power BI. • Experience with Python, Hadoop, or modern data processing technologies. • Exposure to Generative AI or Machine Learning concepts. • Financial Services or Banking industry experience. Hourly Rate: 65$-68$ per hour This range reflects base compensation and may vary based on location, market conditions, experience, and candidate qualifications. Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: medical insurance, dental insurance, vision insurance, 401(k) retirement plan, life insurance, long-term disability insurance, short-term disability insurance, paid parking/public transportation, (paid time, paid sick and safe time, hours of paid vacation time, weeks of paid parental leave, paid holidays annually - AS Applicable) About Us At Collabera, we don t just offer jobs we build careers. As a global leader in talent solutions, we provide opportunities to work with top organizations, cutting-edge technologies, and dynamic teams. Our culture thrives on innovation, collaboration, and a commitment to excellence. With continuous learning, career growth, and a people-first approach, we empower you to achieve your full potential. Join us and be part of a company that values passion, integrity, and making an impact. Ready to Apply? Apply now or reach out to Pritam Palai at for more information. We look forward to speaking with you!