Oracle apps dba
Resume:
M. KARTHIKEYAN **-
Mail : ****.*******@*****.***
Objective
To work in a challenging and exciting position using my skills and
experience as an Oracle Apps DBA on challenging projects involving
extensive use of Oracle technology.
Experience Summary
* Having around 10.5 years of experience in Oracle domain in which nine
years of experience in Oracle applications database administration.
* Experience in working complex and critical environment with over 1500
ERP,non ERP and DWH instances.
* Experience in Data Center Movement activities for various DB
migration.
* Experience in Disaster Recover Scenarios.
* Experience In Installation and configuration of Oracle 11i and 12
Instances.
* Have experience In Installation, Upgradation, Migration, Single and
Multi Node Cloning, SSO, WF Setup and all kind of User related
Issues.
* Have Involved in multiple Cross platform migration and Upgradation
activities.
* Experience in configuration of PCP Load Balancer and fail over of appl
services.
* Having experience in installation of 10g RAC with ASM and RAW
Partitions.
* Having experience in cloning of RAC Ebiz Envt
* Experience in configuration of Standalone db instance with ASM/Raw (
Non RAC)
* Having knowledge to administer the Oracle Clusterware.
* Have very good experience in major PPA analysis and applying on ERP
environment.
* Experience in working with ticketing tools like Remedy & Monitoring
tool EMAN.
* Strong knowledge and experience in data growth Analysis and Capacity
Planning.
* Experience in system administration activities like user security,
registration for Forms/Reports, setting up Concurrent Manager
schedule.
* Have involved in multiple Bridge Activities for P1/P2 Databases and
Provided L1/L2 Support for various remote clients.
* Having knowledge to write shell scripts.
* Involved as a team member in full Life Cycle of the Manufacturing and
HRMS and PA Implementation Projects.
* Interacting with application developers to support testing,
development and perform upgrades to Production environment.
* Result oriented & committed to meet the goal.
* Experienced in working in tight schedules and shifts
Certifications
Oracle Certified Professional Database Administrator (OCP) in oracle
8i
Oracle Certified Professional Database Administrator (OCP) in oracle
10g
Oracle 11g Essentials Database Specialist Certified Professional.
Technical Skills
Operating System Redhat Linux ES, OEL, Cent OS 4.x/5.x, Solaris 5.x
RDBMS Oracle 10g, Oracle 9i, Oracle 8i, 8.x and Oracle 7.x
DB Tools OEM, Emgrid, TOAD, TORA, Quest Central
Oracle Tools Exp/Imp, Data Pump, Loader,
Statspack,AWR,DBV,Tkprof,Net8,Lsnrctl
ERP Oracle 11i Ver 11.5.7 to
12.0.4,FNDLOAD Utilities,
Discovery, OAM
Loader (Testing)Tools Data Factory, Data Loader.
Education
* Master of Computer Applications (MCA) from Madurai Kamaraj University
(1997-2K)
* Bachelor of Computer Science (B.Sc) from Madurai Kamaraj University
(1994-1997)
Professional Experience
A. Working at Mphasis Pvt Limited, Chennai as a Senior Principal
Infrastructure Engineer from Sep '11 to Till Date.
Role : Oncall Support for Prod & Non Prod envt.
Client : Bingo Bakeries, Ahold Netherland ( Nov'11 to Feb'12)
* Worked for Ahold Project-EU at Project Initial stage (Nov '11 To Feb
'12) for Documentation and EBiz Cloning.
* Involved in development of technical procedures, scripts and
associated documentation.
* Resolve incidents and problems. Communication of same to stakeholders.
* Communicate to stakeholders via standard methods (e.g. orally, email,
ticket system).
* Provide day to day and project support for Oracle Applications. This
includes but is not limited to: patch analysis and deployment, cloning
and database tuning.
* Regular cloning and refreshing of Oracle Application in multi tier
model and single tier model.
* Applying application and database patches.
* Monitoring databases using OEM.
* Automating day to day activities and Monitoring using SHELL, PERL and
PL/SQL scripts.
* Has worked extensively on various Oracle EBS testing including Load
testing, stress testing activities while implementing new changes.
* Had successfully upgraded 11.5.10.2 EBS and 10.2.0.4 database to
12.1.3 and 11.2.0.3.
* Installation and upgrading of Oracle Software in Development and
Production Environments.
Setting up Oracle Data guard to synchronize DR database with
production database.
* Cloning production database in development and UAT environments.
* Troubleshooting of database/software for bugs and applying patches as
required.
* Assist and advice in database design at development team.
* Configuration of Database parameters for optimal performance.
* Monitoring Databases for fragmentation and storage management.
* Configuring Database periodic backup using OEM and Tivoli Storage.
* Recovering Real time Databases using RMAN, Manual and Import
Utilities.
B. Worked at Bhawan Cybertek (BCT), Chennai as a Sr Apps DBA from Jun'09
to May '11
Role : Maintenance / Remote Support of Prod and Non Prod Instances.
Client : Middle East Clients(OMIFCO,DM, Darvish), US Client( Aviat )
Responsibilities :
* Migrated 11i ERP ( Prod & Non Prod), Non ERP Prod (8i,9i,10g ) / Non
Prod Instances as part of Data center Movement activities from SJ to
RTP ( US)
* Implemented Oracle 10g Data Guard for Production Server Migration.
* Worked as a Major Role for HRMS & PA Project Go -Live. Having
Experience to apply Major Tech Stack Chang patches ATG6 & ATG7, HRMS
Year-end Patches, PA Patches, Critical Patches .
* Installation and configuration of third party Vertex Sales TAX Q
Patches on Ebiz.
* Experience in Oracle 10g EM Grid and Agent Installation.
* Configured Wallet and TDE ( Transparent Data Encryption) for HR
Tables.
* Setting up Node Trust ( SSH ), GPG Setup between Linux and Windows.
* Security Tightening for Cloned Instances to protect sensitive HR Data.
* Implemented COBIT Audit Control ( DS05, DS10, DS11 & AI05) Standards
on Ebiz
* Defined weekly backup strategy and automated Cold Backup of ERP and
Non ERP Instances thru Cron.
* Having experience to take B2B / SOA Application Level Backups.
* Experience in installation and Configuration of Stand Alone Discovery
Instance for Ebiz Prod and Test Instances.
* Have configured Workflow Notification Mailer thru OAM on Prod.
* Providing support for application team members, resolving issues on
ticket basis.
* Standardized Clone Document for Single and Multi Node Setup.
* Preparation of Archivelog and Backup Validation report to management.
C. Worked at Wipro Technologies, Bangalore as an Employee from Aug '07
to Jun '09
Role : Oncall support / Maintenance of ERP and Non ERP Systems for Sony &
Cisco Clients
Client : Sony ( Japan), Cisco (US)
Responsibilities :
* Have worked in JAPAN through Sony Corporation for Production Support.
* Providing Oncall support for P1/P2 Databases thru Bridge, Pages,
Alerts
* Handling Alerts from Emgrid, Oracle EMAN Monitoring system, Cron.
* Having Experience in handling multiple pages from various production
servers.
* Single or Multi Node cloning ( Shared or Non Shared ) on Rac or Non
RAC Includes 11i, R12 ( 12.0.4 ) for Test, Dev, Stage and UAT Envts.
* Setting Up External Server Configuration In DMZ Zone.
* Setting up PCP, Fail Over Activities in 11i, R12 Instances.
* Fixing Block Corruption, Reorganizing Tablespaces, Tables or Indexes
* Handling DG / DR Issues.
* Involving In Backup / Recovery Issues
* Handling Performance Issues especially Slowness Programs or Long
running programs and suggesting solutions to appl team members.
* Installation of 11i, R12 in Single or Multi Node System
* Troubleshooting in Form/Web,/CM Servers
* Communicating Clients thru Netmeeting/Internal Chat Systems to
identify or provide suggestion/ fix for an Issue.
* Working Multiple Issues ( User issues) in parallel as per Case thru
Alliance or SRT Ticketing system.
* Granting Requested Privileges, User Creation for Users as per policy
* Exporting Schemas or Tables to other databases based on User request.
* Proactive Monitoring the database thru EMAN, Cron Scripts
* Involving in CR ( Change Request ) Activities as scheduled.
D. Worked at USi AT & T Tech, Bangalore as an employee from Dec '06
to Jul'07.
Role : Shared Projects support for 11i Versions on Solaris, HP and
Linux Platforms.
Clients : Multi Client Shared support.
Responsibilities :
* Working with Functional & Technical Team to resolve issues.
* Applying DB (oneoff), Security Patches and all apps related patches.
* Monitoring db thru Tivoli and Troubleshooting Database issues.
* Oracle 8i, 9i and 10g database creation and Upgradation.
* Involving in Single & Multi Tier Cloning.
* Troubleshooting CM & other tech issues.
* Raising and Following TAR Upgrades.
* Customer interaction, if required.
* Involving Bridge activities for Sev Issues.
* Following SAS -70 Standards Like Security Issues and proper updation
of Case/SR
E. Worked at Oracle Corporations, Bangalore as an On Demand Consultant /
Contractor
From May '06 to Dec'06 thru Inet Frame Technologies.
Role : Migration & Upgradation for Apac / Emea Clients to Linux
Platform.
Clients : Multi Client Shared support.
Responsibilities :
* Interaction with Dev Team /Customers for Problem Troubleshooting.
* Creating and Managing all oracle Databases required for Dev / Test
and Prod Usage.
* Installing and configuring applications as required.
* Installing and patching (CPU and Security Related patches) on
Oracle.
* Pre-patch Analysis and applying application patches (Includes MP)
and upgrades as required.
* Performs patching/fixing, upgrading services for customers when
needed.
* Installation/Upgradation of Discoverer, WF Mailer Setup as
required.
* Reviewing of change requests (including configuration changes,
patch management, proactive and preventive maintenance).
* Initiating, testing, documenting, and managing Oracle application
Technical Assistance Requests (TAR) to resolution.
* Interacting with various teams for migration process and handling
various Oracle Internal Tools.
* Problem analysis/troubleshooting, monitoring and tuning application
and internal database performance.
* Participating in the planning and direction of applications
strategy to ensure alignment with overall technical and company
objectives.
* Technical delivery of upgrades and technical assistance to team
members.
* Participating Test, Dev, Prod Dry Run and Production Migrations.
F. Worked at Sharadha Terry Products Prv Ltd, Coimbatore as an apps dba
From Jun '04 to May '06
Role : Implementation and support of Oracle Applications ( 11.5.9 )
Clients : Sharadha Terry Products.
Responsibilities :
* Installation of Apps 11.5.9 on Redhat Linux AS 7.2 and 7.3
* Installation, configuration and Upgradation of database
* Creating Test and Production environment.
* Application user creation and Responsibility assignment to enforce
security.
* Managing and monitoring concurrent jobs and application users.
* Troubleshooting Concurrent Issues.
* Troubleshooting application related technical problems.
* Registering Printers, Custom Forms and Reports, setting profile
options and registering printer in OS and Apps.
* Maintaining application and database security by applying relevant
patches.
* Providing technical support to Dev Team and functional members.
* Performing ongoing tuning for database instance.
* Doing capacity planning for database and servers.
* Tracing long running jobs/reports and troubleshooting the same.
* Carried out monthly/weekly Maintenance of database such as
defragmentation of Tablespaces, Rebuilding indexes, rearrangement
of segments in different disks
* Uploading item master using exp/imp, Data loader and interface
Tables.
* Planning for backup/recovery of database.
* 24/7 Sysadmin Activities and support.
* Monitoring and following up TAR's raised with oracle.
G. Worked at Mass Facility Cards Pvt Ltd, Madurai as a Programmer from
Jan'03 To Apr04
Role : Maintenance of Legacy database ( oracle v7.0, VB 6.0) and
applications.
Personal Details:
Name : M. Karthikeyan
Father's Name : V. Mahalingam.
DOB : 18-05-1976
Sex : Male
Marital Status : Married
Passport : valid upto Dec, 2020
Address for Comn : 57, Ramakrishna Raj Nagar Main Road
Madipakkam
Chennai - 600091, Tamilnadu, India.
Place : Chennai (M.KARTHIKEYAN)
Contact this candidate