Shiv Kumar

About Shiv Kumar

IT Professional having 8+ years of IT experience • Has been associated with 4 complete software development life cycle implementation involving Analysis of Business Application systems through End User Interaction and Observation of Business Processes, Coding as per System Specs, Unit and System Testing of code • Experience in managing OLTP database systems. • Good experience with data marts, ETL and data quality analysis • Extensive experience with Logical and Physical Database Modeling • Experience using Oracle 19c/12c databases on Unix/Linux/Windows platforms. • Proficient working experience in SQL, PL/SQL (Client and Server side Procedures, Functions, Packages, Objects, Triggers). • Experience with batch programming on Oracle using unix korn Shell scripting • Experience in Optimization techniques include cost based technique and analyzing the tables for gathering the statistics using EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, OEM custom scripts troubleshooting oracle databases using sqltrace utilities. • Experience with Oracle Database performance-tuning services for customers with Performance Tuning using AWR, Statspack, creating indexes, materialized views to tune queries. • Experience in loading data from flat files using external tables, SQL*LOADER. • Experienced in Data migrations using Export/Import.

Experience

1. Senior Oracle Database Administrator

   Technology Mindz

   Jun 2022 — Present · IN

Education

• Indira Gandhi National Open University

  Master of Computer Applications - MCA

  2012 — 2018

• Punjabi University

  Bachelor’s Degree

  2006 — 2009