Name: EKANT THAKKAR
Designation: Senior Analyst (6B)
Email_id: acp7sg@r.postjobfree.com
Phone: +919*********
Job Objective:
To work in a challenging environment where my skills as Oracle applications DBA can be fully utilized and my skills enhanced in Database Design, Development and/or a Maintenance Support Team role. Believe in continuous learning, growth and cross cultural development. Possess excellent oral and written communication with professional in interpersonal skills.
Professional Profile:
4 years 06 month experience as an Oracle Apps DBA .
Cloning of oracle apps instances 11I, R12.1.3 & R12.2 .
Installation of R12.2.0 and upgrading to R12.2.4
Migration of Database to ASM storage.
Monitoring and maintenance of database.
Up gradation of database from 11.2.0.1 to 11.2.0.4 using DBUA
Restoring Database using Recovery manager(RMAN)
Patch management and analysis.
Plan and control system downtime for maintenance work
Administer Oracle databases
Sysadmin (creating users, responsibilities, etc.)
Communicating with Oracle for SR and providing solutions to the team members
Carried out other ADADMIN activities like re-linking, recompiling apps schema, etc.
Administration of Oracle database and ASM instances on RAC.
Monitoring Tables, Indexes, etc
Maintaining the performance of Database & Application.
Support development & test environments.
Done performance tuning activities like Index Rebuilding and Purging.
Documentation of technical design and developments. Maintaining the database.
Preparing RCA (Root Cause Analysis Documents) for P1/P2 Incidents.
Knowledge of preparing of documents like QEV/CBN, SOP & SOD for audit purpose .
Done Baseline Implementation as per Oracle Slandered for Oracle 11g Database
.
IT Skill Set:
RDBMS : Oracle10g, 11g.
Languages : SQL
Operating System : SUN Solaris, IBM AIX, Linux
Other Tools : SQL*Plus, TOAD, Enterprise Manager (EM), SQL Loader, Discoverer 10G
ERP : Oracle Applications E-Business Suite 12.2.4,12.1.3, 11.5.10.2
Other Knowledge : Monitoring knowledge of ASM, RAC and Oracle 11g,
EMCA, DBCA, Recovery manager (RMAN)
Areas Of Expertise:
Primary Function
Oracle Applications DBA
Secondary Roles
Systems Administration
Technical Support
Application Development
End User Training
Employment History:
Employer
IBM INDIA PRIVATE LIMITED
Client
SBI CAPITAL & INDUS TOWER
Project
ERP TRANSFORMATION PROJECT
Role
Oracle Apps DBA
Team Size
1
Duration
02' Jan 2015 to till Date
Platform
Oracle RDBMS 11.2.0.3(11g),
Oracle E-Business Suite 12.2.4
Employer
Oracle India Private Limited
Client
Oracle OnDemand Clients
Project
Oracle OnDemand
Role
Oracle Apps DBA
Team Size
1 7
Duration
Nov‘12 to till Date
Platform
Oracle RDBMS 11.2.0.1.0(11g),
Oracle E-Business Suite 11.5.10.2, 12.1
Employer
Wipro Infotech
Client
HDFC Bank Pvt Limited
Project
HRMS/GL
Role
Oracle Apps DBA
Team Size
1 (APPS DBA)
Duration
JUN‘12 to Oct’12
Platform
Oracle RDBMS 11.2.0.1.0(11g),
Oracle E-Business Suite 11.5.10.2, IBM AIX 6.1,
Employer
Wipro Infotech
Client
Uninor Telecommunication
Project
ERP
Role
Oracle Apps DBA
Team Size
3 (APPS DBA)
Duration
SEP‘10 to JUN’12
Platform
Oracle RDBMS 11.1.0.7.0(11g),
Oracle E-Business Suite 12.1.0.1, Sun Solaris 5.10
JOB ROLE /RESPONSIBILITY :
Clone instances to sink test and development environments with production.
Monitoring Daily GL Process and gathering statistics.
Providing DBA support to End Users during Month End, Quarter End And Year End Closing Activity
Part of POC for EBS 11.5.10 Oracle Database 11g Migration to EXADATA BOX in HDFC project .
Apply patches on E business Suite test, production instances.
Up gradation of database from 11.2.0.1 to 11.2.0.4 using DBUA
Migrating database to ASM Storage.
Troubleshooting database connectivity/locking issues.
Administering all objects; including tables, indexes, views, sequences, packages and procedures.
Supporting Development teams.
Enforcing and maintaining database constraints.
Database storage management.
Creating database links, password files, etc.
Managing Database and Application Users.
Providing training to users Oracle.
Database Performance tuning actions like Index rebuilding, Purging etc.
Knowledge in Enterprise Manager Configuration and monitoring database using it.
Application of Database CPU patch on Test Environment.
Preparing RCA (Root Cause Analysis document) for P1/P2 Incidents.
Knowledge of preparing of documents like QEV/CBN, SOX & SOD for audit purpose .
Baseline Implementation as per Oracle Standard for Database 11g
Baseline Implementation as per IBM standard for IBM AIX 6.1
Working Knowledge of Discoverer 10g & 4i
Working knowledge of SQL /PLSQL
Educational Qualification:
B.E. in Information Technology from R.C.E.T (Affiliated to Chhattisgarh Swami Vivekananda Technical University) BHILAI in the year 2010 with 72%.
Personal Profile:
Name : Ekant Thakkar
Nationality : Indian
Marital Status : Single
Date of Birth : 28th Oct 1988
Email Id : acp7sg@r.postjobfree.com
Declaration:
I hereby declare that the above mentioned particulars are true up to my knowledge and I bound to the authenticity of above mentioned information.
Date : 16-MAY-2015 Ekant Thakkar
Place : NOIDA