Job openings for pl sql technical lead in chennai

We are looking for a technical lead with 8+ Yrs exp who should have Coordinated with team in understanding the business requirements and delivering the deliverables to the business users. Design, develop, and support PL/SQL, ETL processes for loading data from external as well as internal systems using SQL Loader and External tables.

Roles and Responsibilities:
• Should have hands on experience and be able to guide the team of developers
• 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) .
• Interacted with Business Analysts and Users for gathering and analyzing the Business Report requirements.
• Requirements gathering for the Interfaces and custom programs development through meetings with functional team and business users.
• Analysis (Business and Technical) of existing system with objective of improving & optimizing the system performance.
• Handled a project where it involved building a process for BEx Team. Required Skills:
• Should have sound experience with calling API thru PLSQL procedures and able to debug API code & test API utilizing Postman
• Should have good exposure to Linux/Unix, Shell Scripting & XML