Gomathi R Email & Phone Number

Chennai, Tamil Nadu, India

Having Experience in migrating the procedure from aurora database to Aws Redshift Database using Postgresql. Used Joins and sub-queries to simplify complex queries involving multiple tables and also optimized the procedures. Querying, creating stored procedures and writing complex queries and TSQL join to address various reporting operations and also random data requests. Experience in temporary table creation. AWS Redshift performance tuning and optimization by using correct distkey (even, key or all) and sortkey (single sortkey, compound sortkey, interleaved sortkey). Fine-tuned Stored Procedures using Execution Plan in SQL for better performance. Query Tuning and Performance optimization and Implementing Work Load management.  Having experience in Performance monitoring and Optimizing Indexes tasks by using Redshift Performance Monitor

Coimbatore, Tamil Nadu, India

• Created DB objects such as Procedures, Functions, Packages, Triggers,Sequences, Views and Indexes.• Checked Impact Analysis Document for prod/UAT issues.• Ensured all work is carried out and documented in accordance with required standards, methods and procedures.• Participated in debugging.• Involved in developing complex PL/SQL procedure to handle errors andexceptions.• Working in Oracle forms 11g,12c.