Job
Description
Programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Awareness of version control for databases Strong in PL/SQL, RMAN backups, recovery, Golden Gate, and data pump. Proficient in SQL tuning, AWR, and optimization. Full migration lifecycle activities including, but not limited to detailed analysis, design, development, test, user acceptance test support and production implementation. Identifying and correcting performance issues, reviewing systems and error logs, storage management, backups, job monitoring, optimization efforts, data integrity analysis and resolving database contention issues. Experience working in Agile environments Good To Have Oracle APEX and Red Hat Linux skills would be good to have.
