Oracle Developer (Semi-Senior)

Description

Job Summary: We are seeking a Semi-Senior Oracle database specialist with solid experience in PL/SQL, query optimization, and problem resolution. Key Highlights: 1. Solid experience in advanced PL/SQL and Oracle query optimization 2. Proficiency in database schema design and data normalization 3. Creating and maintaining auxiliary table scripts and triggers for auditing Required Level: Semi-Senior — minimum 2 years of solid hands-on 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 of query optimization and performance tuning (EXPLAIN PLAN, indexes, partitions if applicable). ● Experience debugging and resolving issues in triggers and stored procedures. ● Proficiency in database schema design and data normalization. ● Experience with version control for SQL scripts (Git, branching, merges) . ● Desirable: ability to document scripts and dependencies in a standardized manner to ensure maintainability. Key Responsibilities: ● Create and maintain auxiliary table scripts and triggers for data auditing ● Design and execute historical data cleanup scripts for 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. Employment Type: Full-time Salary: S/.4,500.00 - S/.5,000.00 per month Work Location: On-site employment