Oracle Apps DBA
Resume:
Vijay Anand Arya
E-mail address:
*****.********@*****.***
*****.****@*****.***
PR CIS
> 5 years and 04 months of experience in Oracle Apps, Oracle Database,
Database Tools (SQL, TOAD), Oracle EBS Suite 11i and R12, basic
working knowledge in Oracle Weblogic and Oracle Retail.
> Joined Infosys Technologies Ltd. as a Software Engineer (fresher) in
2007.
> Joined Oracle India Pvt Ltd in 2013 and currently working as Analyst.
> B.TECH in Electronics and Communication Engineering from Govind
Ballabh Pant University of Agriculture and Technology.
> Significant exposure of working in an international business
environment.
> Extensive knowledge in Oracle Apps.
> Working knowledge in Oracle Weblogic.
> An effective communicator with excellent relationship building &
interpersonal skills. Strong analytical, problem solving &
organizational abilities. Possess a flexible & detail oriented
attitude.
TECHNICAL SUMMARY
> 5+ Years of Experience in IT industry.
> Extensive experience in working on various versions of Oracle
databases.
> Experience in implementing various versions of Oracle Applications
> Experience in Oracle Apps 11i, R12 Installation and Administration.
> Extensive Knowledge and experience in working on Oracle Apps 11i /
R12.
> Extensive knowledge and Experience in working with Oracle On Demand.
> Working knowledge in Weblogic 11G
> Expert in various DBA activities like Installation, Monitoring,
Cloning, Patching, Performance Tuning and other activities
> Extensive Knowledge in Multi O/S.
> Experience in shell scripting
> Working knowledge in Oracle Retail Domain (CO, RMS, SIM, POS, RIB, BO)
> Excellent Technical and Communication Skills.
IT SKILLS
1. Operating Systems:- Linux, Windows Server 2008
2. Languages:- SQL, PL/SQL, Shell Scripting
3. Relational Databases:- Oracle 10gR1, Oracle 11gR2, Oracle 10g,
4. Tools:- TOAD
5. Other Oracle Related Technologies :- Oracle E-Business Suite 11i and
Release 12, Oracle Retail
PROFICIENCY FORTE
Project Operations
< DBA support, implementation and documentation.
< Deployment
< Low level design
Application Design & Development
< Understanding the technical & functional specifications.
< Providing post-implementation, enhancement and maintenance support to
client for application and database.
ORGANIZATIONAL EXPERIENCE
Significant Highlights:
< Awarded STAR Performer for my role.
< Have delivered in multiple projects with no/minimum defects
< Have mentored new members to the team.
< Have been instrumental in taking trainings and guiding people to learn
Database and/or Application technologies.
TECHNICAL SKILLS
ERP Administration -Oracle Apps 11.5.10.2
-Oracle Apps R12
-Weblogic 11G
-Oracle Retail
Programming Languages -SQL, PLSQL, Shell Scripting
O/S -Oracle Linux, Windows Server 2008
RDBMS -Oracle 10g,Oracle 11g R1 and R2
Database Tools -Toad
KEY PROJECTS UNDERTAKEN
Project 1(2008-09):
Organization : Infosys Limited, Pune.
Designation : Software Engineer
Project Scope :
Creation of Oracle Reports using Oracle
Reports 6i Builder for implementation in
Oracle Apps 11i. Creation Of New Components
(Custom Packages and procedures with added
functionalities to meet business requirements)
Testing: Preparation of Test Cases and
unit-testing of the components.
Technologies Used : Oracle E-Biz Suite 11i, Oracle Database 10g
My Role : (i) Gathering requirement from Client &
preparing technical specification Documents
and setup docs for client's use.
(ii) Design Various Rdf reports on Order
Management modules.
(iii) Doing changes in existing standard
reports & adding Changes to as a part of
enhancement.
(iv) Creating Pl/SQL Packages and procedures
as per the requirements.
(v) Knowledge Transfer to & from other team
members in project.
Project 2(2008-09)
Organization : Infosys Limited, Pune.
Designation : System Engineer(Oracle DBA)
Project Scope :
Support and Administration of Oracle Database
on Windows platform.
Take nightly backup of the Database.
Upgrade the Database to from 10.2.0.2 to
10.2.0.4.
Technologies Used : Oracle Database 10g, SQL
My Role :
(i) Full DBA support from offshore in
shifts.
(ii) Handling DEV and UAT environments.
(iii) Take nightly back of the Database.
Project 3(2009-11)
Organization : Infosys Limited, Pune.
Designation : Senior Systems Engineer (Oracle Apps DBA)
Project Scope :
Support and Administration of Oracle Database
on an Oracle On Demand Environment.
All DBA related Support tasks.
Installation of Oracle database and Apps.
Cloning
Patching
Troubleshooting.
Technologies Used : Oracle EBS 11i, Oracle Database 10g, SQL
My Role :
(i) DataBase administration on an Oracle On
Demand Environment.
(ii) Handling DEV and UAT environments.
(iii) Application and Database patching
(iv) Application Cloning.
(v) Defining Custom Concurrent Managers and
other Sys Admin tasks.
(vi) Regular Apps DBA Task and Support.
(viii)Mentoring Junior resource.
Project 4(2011-12)
Organization : Infosys Limited, Pune.
Designation : Senior Systems Engineer (Oracle Apps DBA)
Project Scope :
Implementation and Support project for making
the Retail client go online.
Technical scope:
All DBA related Support tasks.
Installation of Oracle database and Apps.
Cloning
Patching
Troubleshooting
Technologies Used : Oracle EBS R12, Oracle Database 11gR1, SQL
My Role :
(i) Full DBA support from offshore as well
as odd-hour support at times.
(ii) Handling DEV and SYSTEM TEST
environments.
(iii) Installation of Oracle Apps R12.
(iv) Patching- AD Patches, RUP patches,
OPatches
(v) Cloning
(vi) Database/application support
(vii) Handling Deployments
(ix) Troubleshoot problems with concurrent
managers, Apache, and database performance
(x) Knowledge Transfer to other team members
in project.
(xi) Mentoring Junior Resources.
Project 5(2012-13)
Organization : Infosys Limited, Pune.
Designation : Senior Systems Engineer(Oracle Retail DBA)
Project Scope: Implementation and Support project.
All DBA related Support tasks.
Patching
Oracle On-Demand
Designing the LLD for higher environments.
Technologies Used : Oracle 11GR2, Weblogic 11G, Oracle Retail
Products Release 13
My Role : (i) Preparation of low-level design document
for higher environments such as Production,
Disaster Recovery, etc.
(ii) Full DBA support for Oracle database and
Retail products.
(iii) Handling deployments for Retail Stack
(RMS/SIM/RIB/CO/BO) and Retail
Point-of-Service
(iv) Setting up multiple store in
POS(Installation of ORBO and ORPOS 13.4)
(v) POS server and Client installation
(vi) Requesting and follow-up of Service
Requests and RFC to Oracle.
Project 6(2013-2014)
Organization : Oracle India Pvt Limited, Bangalore.
Designation : Analyst
Project Scope: Production Support.
Technologies Used : Oracle DB 11g with Applications on 11.5.0.2.0
My Role : (i) Full Apps DBA support for Oracle EBS.
ACADEMICS
Degree / Institute / Board / Current Percentage
Standard School University Year & of Marks
Semester /
Year of
Passing
Class X St mary's ICSE 2000 75.83
Convent Inter
College.
Class XII St mary's ISC 2002 74.00
Convent Inter
College.
B. Tech Govind Ballabh Electronics and 2003-07 06.24 CGPA
Pant University Communication.
of Agriculture
and Technology.
PERSONAL DOSSIER
Date of Birth : 2nd April 1984.
Permanent Address : Lucknow,
Uttar Pradesh.
Contact this candidate