Oracle Plsql Developer

Job Description:

PLSQL Developer

Job Description:
We are looking for a PLSQL Developer with 7 to 10 Yrs of relevant experience in Oracle Plsql.
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 objectsincluding tables, indexes, views,
sequences, packages.
• Worked with Bulk Collectionsfor 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 commandsincluding all DDL (Data Definition Language), DML
(data manipulation language), and DCL (Data Control Language).
Required Skills:
• Should have more than 4 years ofstrong 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 scriptsfor 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.
Shift timings- 1.30 Pm to 10.30pm (Ist) 0r 2Pm to 11pm (Ist)
Location – Chennai or Hyderabad