Oracle PL SQL Developer
Role details
Job location
Tech stack
Job description
We are hiring an Oracle PL SQL Developer Day to Day: o Develop and deploy scalable data warehouse architectures to support enterprise data needs. o 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. o Build and maintain high-performance ETL frameworks to support data ingestion, transformation, and integration across systems. o Design conceptual, logical, and physical data models and manage database structures including partitions, indexes, CDC, and data lifecycle processes. o 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. o Assist with building ad hoc and operational reports and support data testing, validation, and quality assurance for applications and data workflows.
Requirements
o 12+ years of hands-on experience designing and implementing scalable data solutions in large-scale data warehousing environments. o A10+ years of experience developing complex Oracle PL/SQL code and performing DBA-related responsibilities including database performance tuning and optimization. o Strong ability to analyze Oracle execution/query plans and AWR reports to identify performance bottlenecks and implement improvements through query, table, and index optimization. o Proficiency designing conceptual, logical, and physical data models for enterprise data warehouse solutions. o Proven experience building high-performance ETL pipelines and frameworks with robust error handling and scalability. o Strong working knowledge of database partitions, indexes, change data capture (CDC), data purging, and data virtualization. o 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. o Experience working in Agile teams and collaborating with cross-functional stakeholders to deliver scalable data solutions. Plusses: o Experience with data visualization tools such as Tableau (preferred) or Power BI. o Experience with Python, Hadoop, or modern data processing technologies. o Exposure to Generative AI or Machine Learning concepts. o Financial Services or Banking industry experience.
Benefits & conditions
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)