• Preparing scripts for migration, adhoc data report generation as per client’s requirement.• Reviewing peer’s script via Crucible collaborative code review tool by Atlassian.• Independent temporary db design through sqlite.• Worked with version control system on Git and tools like SourceTree commit and push the code.• CA Agile Central tool as a project management and Service Now for process workflows.• Experienced in Splunk, Power BI for data analysis and… Show more • Preparing scripts for migration, adhoc data report generation as per client’s requirement.• Reviewing peer’s script via Crucible collaborative code review tool by Atlassian.• Independent temporary db design through sqlite.• Worked with version control system on Git and tools like SourceTree commit and push the code.• CA Agile Central tool as a project management and Service Now for process workflows.• Experienced in Splunk, Power BI for data analysis and visualizations.• Expertise in scripting in MariaDB and SSRS and basic javascript usages.• Knowledge in Google Cloud Platform fundamentals. Show less

Experience in leading data migration-related activities including: source-to-target data mapping, data cleanup, writing conversion scripts, executing the migration script, creating exception reports, testing, and verification of migrated data.Involvement with teams on stored Procedures and any other DB related activities like Fine tuning of DB queries, stored Procedures.

• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.• Use Collections like variable arrays, nested tables for the production monitoring… Show more • Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.• Use Collections like variable arrays, nested tables for the production monitoring automation scripts.• Self-started volunteer mentoring guidance to achieve goals for junior team members.• Provided assistance and suggestion to improve the production support for smoother routine activities.• Design, develop and maintain oracle database schema, 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.• Performance improvement, bug fixes, issue analysis, data accuracy , automation of program, Weekly data analytical report generation. Show less

• Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.• Partitioned large tables using range partition technique.• Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.• Worked with DBA team in creating Shell Scripts for invoking SQL scripts and scheduled them using crontab.• Experience in analytical function and refcursors.• Optimizing the existing application , improving the performance of database queries and providing… Show more • Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.• Partitioned large tables using range partition technique.• Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.• Worked with DBA team in creating Shell Scripts for invoking SQL scripts and scheduled them using crontab.• Experience in analytical function and refcursors.• Optimizing the existing application , improving the performance of database queries and providing smooth and fast delivery to the clients.• Supporting and developing the application with help of Oracle SQL and PL/SQL performance tuning features.• Resolving production issues with SLA and work with onshore offshore teams Show less

• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.• Extracted data from the XML file and loaded it into the database.• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA… Show more • Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.• Extracted data from the XML file and loaded it into the database.• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.• Experience in DatabaseApplicationDevelopment, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete SystemDevelopmentLifeCycle.• Extracted data from the XML file and loaded it into the database.• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL.• Coordinated with the front-end and designing team and providing them with necessary stored procedures.• Implementing suitable data model for the application database using Data Modeler.• Creating dev and test schemas and maintaining required SQL and PL/SQL scripts and performing daily backups using export utility.• Usage of bulk collect and PL/SQL tables for faster and better performance, thus by reducing context switching between SQL and PL/SQL engines.• Tuning existing codes by usages of ANSI SQL instead of unwanted looping and PL/SQL programs, usages of indexes, and oracle hints.• Creating jobs/ schedulers for daily reports.• Setting up of spatial metadata, spatial geometry indexes and spatial queries in the SQL quries. Show less