




Required Level: Semi Senior: at least 2 years of solid experience in Oracle PL/SQL and query optimization. Technical Profile: ● Oracle database specialist. ● Solid experience in advanced PL/SQL: triggers, stored procedures, functions, packages. ● Knowledge in query optimization and performance tuning (EXPLAIN PLAN, indexes, partitions if applicable). ● Experience in debugging and troubleshooting triggers and stored procedures. ● Proficiency in schema design and data normalization. ● Experience in version control of SQL scripts (Git, branching, merges) . ● Desired: ability to document scripts and dependencies in a standardized manner to ensure maintainability. Key Responsibilities: ● Create and maintain scripts for auxiliary tables and data auditing triggers. ● Design and execute scripts for cleaning historical data in auxiliary tables. ● Perform unit testing and functional validations in Dev and QA environments. ● Participate in performance testing in QA, ensuring optimal execution times. ● Document scripts, dependencies, and validation results. Job type: Full-time Salary: S/.4,500.00 - S/.5,000.00 per month Work location: Onsite employment


