Ashok Gupta

Years of Experience in Oracle Training

7

Years of Experience in Unix Shell Scripting Training classes

7

Teaching Experience in detail in Unix Shell Scripting Training classes

• Over 7 years of extensive experience in advanced Oracle PL/SQL programming, writing complex SQL queries, query optimization, UNIX commands and shell scripting and solid relational database skills in software development including: design, coding, documentation and testing SDLC. • Extensive hands on experience in Oracle PL/SQL development (Oracle 10g, Oracle 11g, Oracle 12c) e.g. creating complex standalone and packaged procedures, functions, packages, triggers, sequences, types, Indexes, views, materialized views, collections, objects, records, Bulk Collect, oracle jobs, dynamic SQLs, Ref cursors, using SQL loader, using functionalities of DBMS_SMTP for developing e-mail routine. • Experienced in forming complex SQL queries that leverage advanced built-in functions, analytical functions etc. • Exception handling using various Oracle built-in functions and user defined exceptions. • Hands on experience in Oracle SQL and PL/SQL Code Optimization and database modelling. • Hands on experience in basic DBA activities like creating schemas(users), reset database password, giving various access permissions to schemas (users) like execute, create, update database objects privileges etc., worked on tablespace and datafiles; creating database links; using various in-built oracle data dictionaries and packages in database development and DBA tasks etc. • Involved in maintenance and customization of the existing database objects as per requirements. • Extensive hands on experience in UNIX commands and shell scripting with vi editor. Developed UNIX shell scripts as per projects requirements. • Good exposure in UNIX commands including all the main commands like who, ls, cd, cat, pwd, man, cut, cp, scp, mv, grep, find, sed, chmod, mkdir, more, sort, ps, su, kill, ftp, mail, passwd, tail, head, cal, wc, rm, rmdir, pr, mail, telnet, vi, zip, unzip, print, tee, tr, paste, uniq, awk etc.