Overview
Skills
Job Details
Key Responsibilities:
Design, develop, and optimize PL/SQL stored procedures, functions, packages, triggers, and scripts to support key business applications.
Write, test, and tune complex SQL queries for efficient data retrieval, transformation, and business reporting.
Develop automation scripts in Python to streamline ETL, batch jobs, and workflow processes involving Oracle databases.
Work with Linux/Unix environments for deployment, scheduling, and automation of database-related tasks.
Collaborate with software engineers and analysts to integrate PL/SQL and Python processes into broader application solutions.
Perform database performance tuning, troubleshooting, and query optimization.
Analyze, document, and improve existing workflows, data models, and database solutions for scalability and integrity.