Manager Oracle

Lokesh Gupta

Email : ***********@*****.*** [pic]

Mobile: +91-783*******

Address: I-147-A, Street #11,Garwali Mohalla Laxmi Nagar, Delhi-92

OBJECTIVE

I am seeking a position within the Information Technology department with

an international perspective.Seeking a position to utilize my skills and

abilities in the industry that offers professional growth while being

resourceful, innovative and flexible. I want to give my 100% to become an

asset to the company.

SOFTWARE PROFICIENCY

Languages : PLSQL, Oracle Application Express (APEX), Java, SQL

Databases : Oracle 9i(9.2.0.4.0), 10g(10.2.0.3),

11g(11.1.0.7,11.2.0.1) (RAC)

Operating System : Windows, IBM AIX(5.3), HP-UX(11.23),Oracle Enterprise

Linux (5.1)

Tools : DB Designer, IBM MQSeries, Altova Database

Spy, XmlSpy, Erwin

Web Technologies : XML, HTML

Application Server : Oracle Weblogic server

Domain : Retail Banking

DATABASE ADMINISTRATOR

Database administrator(DBA) with experience in designing, coding, testing

and supporting next-generation database solutions in Oracle enterprise and

SQL Server environments. Proficient in an assortment of technologies,

including Oracle 9i/10g,11g, JDBC, Oracle Web logic Server, Java, XML,

Windows and Linux . DBA skills include:

Oracle 10g Database Administration Administration/Installation/upgradation of

Performance Tuning & Capacity Oracle databases.

Monitoring Basics of Oracle RAC & ASM

Data Security, Backup & Recovery,, Oracle Application Express(APEX)

rman scripting for backups, administration and Development

Standby/Failover SQL Tuning in an Oracle Environment

implementation and Administration

PROFESSIONAL EXPERIENCE

Oracle India Pvt. Ltd. (Noida,INDIA): Current Employer

A key member of responsible Database team of Oracle India Pvt. Ltd. On

product Oracle Identity Manager in Oracle server technologies group.

Working as Database Engineer handling plsql development and database

administration.

Oracle Financial Services Software Ltd. (Mumbai,INDIA): 1.9 Years

A key member of very independent, innovative and DBA team of Oracle

Financial Services Software Ltd.

Responsible for Creation, Administration, Maintenance and Tuning of

Databases of banking solution Oracle's Flexcube Retail Banking.

EXPERIENCE SUMMARY

DBA experience: Involved in installation, upgradation, Patching, production

support, in house server handling, performance and tuning of Oracle

database.

Installation and Configuration of Oracle Products like Oracle Grid Control,

Enterprise Manager, and Oracle Database Vault for Database management.

Used AWR, Statspack and RDA repots for analysis, monitoring and tuning

purpose.

Prepared Physical StandBy Database Environment for world's top most Bank to

qualify it for Oracle FLEXCUBE.

FLEXCUBE Implementation, Support to all Development and testing Projects

under FLEXCUBE Retail Group.

Installation and Administration of Oracle Flexcube Application Server

(Oracle Weblogic)

Unix administration: Administration of in house and Benchmark server for

Oracle Database on Operating Systems like IBM AIX(5.3),HP-UX(11.23) and

Oracle Enterprise Linux(5.1).

Creation and Management of MQ's for Oracle Flexcube.

Benchmark exposure: Involved in the creation, Maintenance and Tuning of

database setup required for Benchmarking of Oracle Flexcube.

Data Expansion: - Generated data of around 1 TB using tool called JDET

(Oracle's Java data Expansion tool)

Generated and Analyzed AWR and RDA reports required for monitoring and

tuning purpose.

Load Balancing and Failover Testing on Benchmarking setup..

Oracle Applications: Developed a project estimation Web application in

Oracle Application Express (APEX) for OFSSL.

Project estimator is a web application used to estimate efforts required to

complete a project in number of days. It was developed in Oracle APEX with

business logic in Oracle Plsql.

Exposure to storage: Conceptual knowledge of RAID, LUN, Volume Manager,

Disks (Physical and Logical) and Storage Layout.

Development experience: Written PL/SQL codes for Flexcube Retail Banking to

implement some logic like Purging, Automation of Calendar and Mail etc.

Database Modeling: Developed and Designed data model for Oracle FLEXCUBE

Loans Module on Oracle 10g Database using DBDesigner, Erwin, and Database

Spy.

PROJECT DETAILS

1. Benchmarking

Description FLEXCUBE 3.2 Benchmarking for HDFC on 4 Node RAC

Server in HP Labs Bangalore and Japan.

Role DBA,Oracle Developer, XML(Created XML scripts for

data generation using Oracle JDET (Java Data

Expansion Tool ),Oracle weblogic Administration for

flexcube

Client India' top most private bank.

Skills Used Oracle 11g(11.1.0.7) Database, PL/SQL, Oracle

Enterprise manager(OEM), AWR, RDA, Eclipse, JAVA,XML

and HP - UX (11.23) Servers for Database, Windows for

FLEXCUBE Branch Servers Unix.

Contribution As a team member in FLEXCUBE Development and Support

Team, I was involved in development, Performance

Tuning, Enhancement and Bug fixing and introduced

JDET for Data Generation and Expansion for the HDFC

Benchmarking :

Development and creation of HDFC Benchmarking

database.

Worked on Data Expansion by using Oracle JDET tool

(Java Data Expansion Tool ).

Introduced Oracle JDET for the first time for Data

Generation for the FLEXCUBE.

Oracle Enterprise Manger Grid Control set up with

Oracle Flexcube for Client presentation.

Analysis and monitoring of database through Oracle

Enterprise Manager (OEM), Automatic Workload

Repository (AWR), RDA.

Main role was Administration of Oracle 11g Database

and Data Expansion for performance tuning and

monitoring.

Team Size 9

2. Performance and tuning

Description Performance and tuning for FLEXCUBE 3.1.

Role DBA and Software Developer

Client World's Top most bank

Skills Used Oracle 10g Database, PL/SQL, Oracle Enterprise

manager(OEM), AWR, RDA,Eclipse, JAVA,XML, IBM AIX

5.3 and HP - UX(11.23) Servers for Database, Windows

for FLEXCUBE Branch Servers Unix, for version

maintenance.

Contribution As a team member in FLEXCUBE Development and Support

Team, I was involved in development, Performance

Tuning, Enhancement and Bug fixing and introducing

various security features for FLEXCUBE Barclays

release. It also involved monitoring of some jobs. My

job role involved :

Development and creation of PT database.

Created Physical Standby Database (Data Guard) for

Qualification of Oracle Flexcube.

Resolved database issues for development, Testing and

production teams for Flexcube development.

Analysis and monitoring of database

Setup for the various Performance Test, Module

Testing (MT Rounds), Integration Testing (IT Rounds),

System Testing (ST Rounds) Environments.

3. FLEXCUBE 3.1 development

Description FLEXCUBE 3.1 development for client specific

Enhancement.

Role DBA and Oracle Developer

Client Top Most Bank of Europe

Skills Used Oracle 10g Database, Oracle 10g Databse Express

Edition (XE),PL/SQL, Oracle Enterprise manager(OEM)

, AWR, RDA, IBM MQ, Eclipse, JAVA,XML IBM AIX 5.3 and

HP - UX(11.23) Servers for Database, Windows for

FLEXCUBE Branch Servers Unix, Putty SVN for version

maintenance.

Contribution As a team member in FLEXCUBE Implementation and

Support Team, I was involved in development,

Performance Tuning, Enhancement and Bug fixing. My

job role involved :

Development and creation of database.

Resolved database issues for development, Testing and

production teams for Flexcube development.

Development of new code and database objects related

to purging module.

Analysis and monitoring of database usinf AWR and RDA

reports.

RMAN Backups.

Setup for the various Performance Test, Module

Testing (MT Rounds), Integration Testing (IT Rounds),

System Testing (ST Rounds) Environments.

4. FLEXCUBE 3.0 development

Description FLEXCUBE 3.0 development for BDI (Bank Danemon Of

Indonesia).

Role DBA Oracle,PLSQL Developer,App server setup(Weblogic)

Client Top Most Bank of Indonesia

Skills Used Oracle 10g Database, PL/SQL, Oracle Enterprise

manager(OEM), AWR, RDA, IBM MQ, Apache Tomcat

Developer,Eclipse,

JAVA, IBM AIX 5.3 and HP - UX (11.23) Servers for

Database, Windows for FLEXCUBE Branch Servers Unix,

Contribution As a team member in FLEXCUBE Implementation and Support

Team, I was involved in development, Performance Tuning,

Enhancement and Bug fixing. My job role involved :

Resolved database issues for development, Testing and

production teams for Flexcube development.

Development of new code and database objects related to

Automation of Calendar and Mail.

Performance tuning for client by identifying the network

bottleneck because of DLLINK on branch database side by

removing DLLINK.

Managed (OEM), Automatic Workload Repository (AWR), RDA.

ACADEMIC QUALIFICATION

2004 to 2008 Bachelor in Information Technology

Aggregate : 80%

Guru Gobind Singh Indraprastha University, Delhi

2003 to 2004 Senior Secondary (CBSE)

Aggregate : 77.2%

D.A.V. Public School, Delhi

2001 to 2002 Higher Secondary (CBSE)

Aggregate : 75%

D.A.V. Public School, Delhi

TRAININGS/PROJECTS

Attended two months IN-House training In .NET

from HCL

Designed a Telecom Project in VB.net.

Attended two months training in Internship

CRRI(Central Road Research Institute)

Designed a Leave Management System for CRRI

Designed an ATM system in JAVA at College level

CO-CURRICULAR ACTIVITIES

Active participant in cultural activities including debate and dance.

Managed and coordinated many events organized in the school.

Got a merit certificate from NIIT for national aptitude test in 2007.

Got a merit certificate at college level.

Won first prize in news reading and comic writing competition at school

level.

Active participant in Republic Day Parade on Rajpath in 1999.

Active participation in promotional video for Microsoft Imagine cup 2008

Anthem.

ACHIEVEMENTS

Scholarship in Sanskrit.

Certification : Oracle Certified Associate (OCA in 10g)

OFSS Finance Professional

PERSONAL DETAILS

Father's Name Mr. Subhash Chand Gupta

Sex Male

Language Known English, Hindi

Phone# 011-********,989-***-****

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

Hobbies / Interest Playing Cricket and

basketball, Reading

Motivational Books and

Swimming.

DECLARATION

I hereby certify that the above written particulars are correct to the best

of my knowledge and belief.

Lokesh Gupta

Contact this candidate