Sql Oracle

Ramesh Kumar Sharma

Email – ******.*********@*****.***

ORACLE PL/SQL Developer

Modbile No. - +91-879*******

I

would like to take up a challenging career in the field of SQL/PL-SQL Developer. And want to work

in an environment which highly explores current technologies and advance my talents to the best

potential.

Oracle Skills

• Strong Knowledge Of SQL,PL/SQL Programming.

• Having Good Knowledge of ADVANCED PL/SQL Programming.

• Good practice In Oracle (9i,10g,11g) Database.

• Experience In Developing ETL i.e. Extract Transform Load Using Oracle Database.

• Good In Database Designing. (Referential integrity - Primary Key, Foreign Key,

Constraints etc).

• Strong Knowledge In Developing Functions,Exception Handling, Procedures,

Packages In PL/SQL To Implement Business Logic.

• Good Hand On Creating database objects Like Views, Indexes, Sequences,Tables.

• Deep understanding of data dictionary view like user_source,user_triggers

user_procedures,user_constraints,user_tables,user_objects,user_indexes,

user_cons_columns,user_sequences, user_synonyms.

• Good Knowledge of Cursor(Static,Dynamic),Trigger To Manipulate data.

• Good knowledge of implementing DML,DDL,Insted of, Compound Triggers.

• Hands On Use of inbuilt packages like utl_file,dbms_scheduler, dbms_job,

dbms_output etc.

• Having knowledge of bulk load, Authid, Wrapping of procedure

• Having Basic knowledge of External Procedures, Calling Java Functions, and C Shared

Objects.

• Working Knowledge Of Joins i.e.(Left / Right outer join, self join, inner join, cross

join).

• Having Good knowledge of Virtual Private Database (VPD)

• Good practice in Collections(Varray,Nested table,Associate array) .

• Having Knowledge of LOB’s(CLOB,BLOB,NCLOB,BFILES).

• Having Basic Knowledge of ORACLE DATABASE ARCHITECTURE.

Unix / Linux Skills

• Strong Knowledge of UNIX / Linux, Windows Operating Systems.

• Good Knowledge of RedHat Linux 6 Installations And Administration.

• Knowledge of Oracle Installation on Redhat Linux 6,5.4

• Having good knowledge of Unix commands (grep,mail,cat,ftp,ssh,scp,chmod,find).

• Knowledge Of User Administration Commands

(useradd,usermod,userdel,passwd,groupadd,groupmod,chown,chgrp).

• Hands On Crontab For Job Scheduling.

• Configure Server on RHEL – DNS, DHCP,TELNET,LDAP,SSH, FTP, SAMBA

. NFS, SMTP, APACHE,SYSLOG,VNC,NIS

Academic Qualification

• Oracle Certified Associate (OCA)

• Redhat Certified System Administrator(RHCSA)

Certification No. 120-032-347

• Redhat Certified Engineer(RHCE)

Certification No. 120-032-347

• B.Tech(IT) in 2011 with 63% from Rajasthan Technical University

• H.S.C in 2007 with 59% from RBSE

• S.S.C in 2003 with 58% from RBSE

Other Skills

• Languages : SQL, PL/SQL, C, C++.

• Databases : ORACLE (9i,10g,11g), SQL Server, MS - Access .

• Tools : SQL * PLUS, isqlplus, SQL * Loader

• Operating System : RedHat Enterprise Linux 6/5, Windows Xp, Vista,Windows 7.

Project

• Title :Data Migration Project.

• Environment :RedHat 6, Oracle 11g, SQL PLUS, SQL Loader,

PL/SQL,SQL, Shell Scripting.

• Team Size :05

Description :

The project is an ETL (Extract Transform and Load) project.

Which loads around 2 millions orders into orders and order detailstable. While loading orders in

the table proper error handling is done using PL/SQL code. Errors are reported to manager in a

consolidated email. This emails are sent through a shell script through an automated job

scheduled to run on unix platform using cron scheduler.

Responsibilities :

• Development of ETL Program to Extract Transform Load Data

Into ORACLE Database.

• Managing Extenal File and Directory to load Data .

• Implementation of Proper Indexing Strategy To Improves Performance Of SQL Queries

• Functions, Procedures and Packages in PL/SQL Used To

Implement Business Logic.

• Handled Data Quality Issues During Data Extraction and Loading Process.

(using Exception Handling,SQL Loader,Bad file, Log files).

Hereby I declare that all the above details given are true to the best of my knowledge.

Ramesh Kumar Sharma

Contact this candidate