Senior Specialist - Data Engineering

Role description

Job Title Oracle PLSQL Developer

Role Summary

Experienced Oracle PLSQL Developer responsible for designing developing and optimizing database solutions supporting data processing and ensuring high performance scalability and data integrity in enterprise applications

Key Responsibilities

Design develop and maintain PLSQL procedures functions packages and triggers

Write efficient and optimized SQL queries for data extraction transformation and reporting

Perform performance tuning using indexing query optimization and execution plan analysis

Work on data modeling schema design and database normalization

Support ETLdata integration processes and batch jobs

Troubleshoot and resolve database performance issues and defects

Collaborate with application teams for data requirements and integration

Ensure data security integrity and governance compliance

Participate in code reviews testing and deployment activities

Maintain technical documentation and support auditcompliance needs

Required Skills

Strong expertise in Oracle SQL and PLSQL programming

Experience with packages cursors collections triggers and exception handling

Proficiency in query optimization and performance tuning

Knowledge of indexes partitions and execution plans

Experience with UnixLinux shell scripting preferred

Understanding of ETL processes and data warehousing concepts

Familiarity with version control tools Git SVN

Strong debugging and problemsolving skills

Knowledge of data migration and data validation techniques

Experience with automation or scheduling tools Autosys ControlM

Nice to Have

Exposure to cloud databases Oracle Cloud AWS RDS

Familiarity with data APIs integration services