Oracle PL/SQL Developer

We are hiring an Oracle PL/SQL Developer, * 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.

• 8-10 years of hands-on experience designing and implementing scalable data solutions in large-scale data warehousing environments.
• 8-10 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.

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)

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.