SQL DEVELOPER | MAXXTON INDIA TECHNOLOGIES PVT. LTD. | DEC 2017 - PRESENT• Developed Stored Procedures, Functions, Packages, Triggers, Views and SQL Scripts using PL/SQL.• Built complex queries using SQL and wrote stored procedures using PL/SQL• Did query optimization to make it perform better by reducing its cost (SQL query tuning).• Performed DBA activities like session monitoring, session tracing, granting privileges.• Worked on patching test, production… Show more SQL DEVELOPER | MAXXTON INDIA TECHNOLOGIES PVT. LTD. | DEC 2017 - PRESENT• Developed Stored Procedures, Functions, Packages, Triggers, Views and SQL Scripts using PL/SQL.• Built complex queries using SQL and wrote stored procedures using PL/SQL• Did query optimization to make it perform better by reducing its cost (SQL query tuning).• Performed DBA activities like session monitoring, session tracing, granting privileges.• Worked on patching test, production environments.• Housekeeping of database.• Managed database capacity planning, operations and maintenance, failure analysis and recovery procedures for production databases• Written framework to manage execution of scheduled scripts and monitoring. • Designed ER diagram using SQL Developer, to set the logical and physical relationships of database.• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.• Debugging and Fixing Production Data.• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.• Worked on data migration from one client to another client using DB Link.• Actively involved in interacting with front end Java developers, and gathered User Requirement and Specifications• Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance. Show less

• Write script as per client needs to populate and extract data to and from db.• Figure our recurring scripts and convey it to Product Management team to make it part of software.• Communicated with clients to understand requirement and translate it to SQL scripts.