Work Location: Chennai / Hyderabad
Notice Period: 30 Days or less
PLSQL Developer
Job Description:
We are looking for a PLSQL developer with 6 Yrs exp.
Roles and Responsibilities:
Design develop and maintain tables standard views materialized views synonyms
unique indexes nonunique 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 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.
Shift timings 1.30 Pm to 10.30pm (Ist)
cognos,winscp,tableau,shell scripting,ai,mainframe,.net,angular,tables,rollback tablespace,android,data control language,oracle databases,sql,ai technologies,blockchain,cloud adoption,plsql,ai based applications,putty,sql server,dcl,cyber-security,data validation,ddl,data conversion,shift timings,java,oracle,xamarin,dml,iot,as400,joog,cursors,sql scripts,sql developer,sql commands,range partitioning,data manipulation,wms,xml,bulk collections,linux/unix,pl/sql,erp