Oracle PL-SQL Developer - Performance Tuning (5-8 yrs)

Job Profile : Oracle PLSQL Developer.

Location : Hyderabad/ Chennai.

Experience : 5+ in PLSQL.

Working Days : 5

Roles and Responsibilities :

- Design, develop and maintain tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.

- Extensively worked on creating database objects including tables, indexes, views, sequences, packages.

- Worked with Bulk Collections for bulk load processing.

- Involved in code walk through and review sessions with the development team.

- Extensively done performance tuning of oracle databases by rewriting optimized SQL queries.

- Worked on Partitioning large tables using rollback tablespace, range partitioning and created indexes on various tables to improve query performance.

- Extensively worked on SQL commands including all DDL (Data Definition Language), DML (data manipulation language), and DCL (Data Control Language).

Required Skills :

- Should have more than 4 years of strong experience in Performance Tuning.

- Good exposure to Linux/Unix, Shell Scripting & XML.

- Good experience in using WinSCP & Putty.

- Flexible working hours (able to work in shifts, if needed).

- Must have hands on experience in coding.

- Developed Advanced PL/SQL packages, procedures, triggers, functions, cursors and collections to implement business logic using SQL developer.

- Generated SQL scripts for data validation, data conversion and manipulation and materialized the views for remote instances.

- Wrote conversion scripts using SQL, PL/SQL procedures, functions and packages to migrate data from one database (SQL Server) to Oracle platform.