Over 15+ years of an IT experience in Snowflake Development with AWS and Python, DBT, Oracle PL/SQL Development,DBA and GCP Architect. Managed 24
7 Production Database Support and Development roles. Good experience in creating objects like Tables, Views, indexes, synonyms. Writing SQL, PL/SQL Scripts as per the requirements. Good in Database performance tuning like Index HINT, Creating Partitions, Bulk collect, Status gathering etc. Extensive experience in developing Stored Procedures, Functions, Packages and Triggers. Hands on experience writing PL/SQL Programs using Implicit cursor and Explicit cursor. Worked with PL/SQL collections like Varray, Nested tables and Associative Arrays. Creating users, roles and monitoring the database performance. Installing and creating oracle database and schemas and database import and export using expdp and impdp tools. Building the primary and standby databases setup. Hand – on experience on backup and restore using RMAN utility. Experienced in resolving the backup failures.