PL-SQL Developer

Job Profile : Oracle PLSQL Developer. Location : Hyderabad. Experience : 7 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. (ref:hirist.tech)

Location: hyderabad, IN

Posted Date: 5/13/2025