You will design and develop Oracle database architectures and manage complex data environments.
Responsibilities
- Design and develop database architectures using Oracle 12c and 19c.
- Write and optimize advanced SQL and PL/SQL for data processing.
- Perform database performance tuning and debugging to ensure efficiency.
- Manage data transformation and processing using Informatica and data warehousing principles.
- Automate workflows using Python, Unix Shell Scripting, and Autosys job scheduling.
Required Skills
- Hands-on experience with Oracle 12c and 19c database design and development.
- Expertise in advanced SQL and PL/SQL.
- Proficiency in Python programming.
- Strong Unix and Shell Scripting skills.
- Proven experience in database performance tuning.
- Experience with Informatica and data warehousing tools.
- Experience using Autosys or similar job schedulers.
- Practical application of Agile principles.
- Minimum 15 years of relevant professional experience.