Masood

UNIX & UNIX SHELL SCRIPTING:-

• UNIX Shell Scripting Using Multiple Shells (KSH, sh, bash, csh).
• Well-versed with UNIX/LINUX command-line interface (CLI) and CLI command tool like service, sysctl, etc.
• Well-versed with UNIX architecture. Essentials Unix Commands and File/Directory related command such like as (password, cal, touch, file, wc, sort, cut, grep, dd, sed, awk, write, wall, read, test, ulimit, chmod, cut, sort, ls, cat, mkdir, rmdir, cd and Unix administration commands - different flavored OS.
• Backup of file systems of UNIX (Solaris) Using tar, zip, etc. to automate backup through shell script.
• Automation tools (crontab, at and batch, scripts). Fair experience on Shell Scripting should be able to write, change & modify scripts and debug scripts.
• Process Management(ps, ptree, pargs, pfiles, jobs, pgrep, psrinfo, psradm)
• Excellent experience in scheduling jobs UNIX and oracle jobs.
• Extensive knowledge of UNIX Commands.Good Knowledge in VI Editor (VI, cat, ed, ex).
• Good Knowledge in grep, sed, awk, find, prstat, vmstat, Rostand top.
• Knowledge of UNIX (Solaris) Admin. Performing Mounts and Unmounts. Solaris Operating System Installation. Package Administration.
• Excellent Exposure to work on Solaris and Linux OS.

Oracle (SQL/PLSQL) :-

• Good experience with Oracle and SQL.
• Good Knowledge of Writing Complex Joins and Subqueries in SQL.
• Working Knowledge of Oracle Partitioning. Knowledge of SQL Tuning and Oracle Performance Tuning.
• Knowledge of Oracle Optimization and Indexes (Bitmap, Btree, function-based, virtual index).
• Good knowledge of External table, SQL *Loader export-import (EXPDP/IMPDP & EXP/IMP).
• Oracle memory architecture.
• Perfect Knowledge of SQL Such as - Using DDL, DML, DCL, TCL Statements to Create and Manage Tables.
• Displaying Data from Multiple Tables, Managing Schema Objects, Privilege on Schema objects
• Managing Objects with Data Dictionary Views, Retrieving Data Using Subqueries, etc.
• Using Constraints (Primary Key, Unique Key, Check, Not Null, foreign Key).
• Good Knowledge of Oracle Database Administration.
• Oracle Memory structure. Work experience in managing databases in UNIX and Linux environments.
• Work Experience of Managing Schema Object, data, and Concurrency. Knowledge of Oracle Optimization and Indexes.