Email acwx2g@r.postjobfree.com
Address Cuepacs Apartment,
Jalan Thanmby Abdullah,
Brick Fields,Kuala Lumpur,
Malaysia 50470.
Phone +601********
Seeking Challenging assignments with an organization of repute
Professional Summary
A technocrat with over 7 years and 11 months of experience in Database Build, Administration, Client Servicing and Troubleshooting/Technical Production Support.
Presently associated with Tata Consultancy Service, Malaysia on behalf of PAN ASIA Consultancy as a position of Sr ORACLE DBA CONSULTANT- Technology position.
Adept in analyzing information system needs, evaluating end-user requirements, custom designing solutions and troubleshooting for complex information database management.
An effective communicator with significant experience working with steering committees and other project managers.
Core Competencies across organization
Technical
Operating system : Windows, Sun Solaris 9, 10, Linux RHEL 4, 5, AIX 5.3, 6.1, HP UX 11.
Database : Oracle 9i, 10g, 11g,12c
A. Organization: PAN ASIA, Malaysia (Present)
Client : Tata Consultancy Service From Oct ‘15 to till date
Project : Celcom Telecommunication
Description : Production Support.
TECHNICAL SKILLS
Project : Celcom – Sr.Oracle DBA Consultant
Client : Celcom
Database : ORACLE 11g, EBS-12R1
Environment : Oracle Enterprise Linux
Role : Oracle Apps Database Administrator
Key Skills : RMAN, exp/imp/datapump, Performance Tuning and EBS-production support,
Installation, upgradation
ROLES & RESPONSIBILITIES
Experience in forms, Apache load balancing, PCP for concurrent managers
Securing Oracle E-Business Suite Technical / Functional Components.
Oracle WebLogic Server Administration including configuration of Application services.
Built E-Biz Non-Production environment for multiple internal projects.
DMZ setup configured for Oracle Applications with reverse proxy
Implement and maintain database security
Create, document, and implement procedures related to solution build deployment
Analyzing database/instance performance
Database audit implementation to monitor login, user activity.
Establish application and end-user database access control levels
Perform database reorganization as required to improve database performance
Create Clone steps and documented it for provide to client.
Provide training to client’s support team on oracle application in term of administration.
Provide end-to- end support on oracle application.
Perform purging to Critical PROD databases on weekly basis.
Administrating 11g database with RAC and standalone environments.
Working 9i/10g/11g physical standby database.
Handling Production and Non-production Downtime co-ordinate with application and Server team.
Drive Weekly Deployment activity.
Monitored and analyzed system health and performance, maintaining documentation concerning status
Tune database queries
Monitor application related jobs and data replication activities
Application code deployments and purging
Performing database upgrade from 11.1.0.7 to 11.2.0.4 and Performed Oracle EBS upgrade from 11.5.10.2 to 12.1.3 and 12.1.1 to 12.1.3.
B. Organization: Hewlett Packard, Malaysia
Client : Database admin for Cathay Pacific Airways (CPA) From Oct ‘13 to Sep ‘15
Projec t : CPA Production Support & part of DB Build
Description : Worked as Team member in CPA which deals with Production support.
TECHNICAL SKILLS
Project : CPA DB-Run Services
Client : Cathay Pacific Airways
Database : ORACLE 9i, 10g and 11g
Environment : Windows, Linux, Unix, SunOS, AIX
Role : Database Administrator
Key Skills : RAC, ASM, DataGurad, Upgrade, Patching, Cloning, Migration, Backup and
Recovery, RMAN, exp/imp/datapump, Performance Tuning, Unix Shell Scripting
ROLES & RESPONSIBILITIES
Production support 24/7.
Determination of type of oracle server setup.
Installation of Oracle Database servers (ASM, clusterware, grid and database software installation).
Good knowledge and lot of hands-on experience in implementation of database servers (includes HA setup like RAC, grid and data guard).
Implementation of RAC database on ASM storage with node addition and deletion.
Handling upgrade and patching of RAC databases.
Handling node eviction and multiplexing clusterware files.
Moving the RAC DB instances from non ASM to ASM and viceversa.
Grid Infrastructure installation and configuration.
Installation and configuration of ASM in all the servers.
Patching the binaries with the latest PSU patches and Bundle patches.
Patching the cluster software and database home with rolling upgrades.
Creation of Database in all type of servers.
Configuration and administration of Data guard.
Execution of scripts, user creation and management.
Backup and restore using RMAN utility.
Database migration using RMAN in various scenarios between miscellaneous platforms.
Cluster configuration verification using Cluvfy utility.
Database upgrade from 10.2.0.4 to 10.2.0.5, 10.2.0.5 to 11.2.0.1 and 10.2.0.5 to 11.2.0.3.
Cluster upgrade from 11.1.0.6 to 11.1.0.7.
Worked on various scenarios of restore from tape independently.
Scheduling backup policy and writing Unix shell scripts for scheduling automated backup.
Exporting and importing data in database using Data Pump utility.
Deploying the scripts in database on the advice of application team.
Working on End User requests in the database.
Regular monitoring of all DB environments (RAC, data guard & single instance).
Implementing OEM grid server and installation of agent in servers.
Configuring server and database monitoring for all servers and database in OEM.
Testing switch over and switch back in the servers in DR site and primary site.
Database refresh in various servers using RMAN (both single instance & RAC setup).
Installation of oracle client in the application server and also adding up tns entry and setting up database connectivity.
Materialized view data replication and identify and rectify the potential bottlenecks of performance degradation for finding cause of query slowness and implement the workaround for tuning the query.
Troubleshooting the problems and issues and finding a workaround and avoiding down time for all the environments.
Hands-on experience in working on DR-drill activity various times and ensuring that activity is completed perfectly.
Knowledge and handling on set up oracle Goldengate b/w miscellaneous platforms in real time Environments.
Knowledge and handling on MSSQL administration Server 2008,2012,Postgres and MYSQL DB
C. Organization: Cognizant Technology solution LTD, Chennai
(First 9 months on behalf of Magna Infotech)
Client : AstraZeneca Pharmaceuticals Apr ‘11 to Aug ‘13
Project : AZ DB Production Support & part of DB Build
Description : Worked as Team member earlier in AZ which deals with Production support and build
activities
TECHNICAL SKILLS
Project : AZ-MW-DB-Run Services
Client : AstraZeneca
Database : Oracle 9i, 10g and 11g
Environment : Linux, Windows, SunOS, AIX
Role : Database Administrator
Key Skills : Data Guard, EXP/IMP, Data pump, RMAN Backup/Recovery
Migration and RAC
ROLES & RESPONSIBILITIES
Worked on various scenarios of restore from tape independently.
Installation of Oracle Database servers(ASM, cluster ware, grid and database software installation).
Good knowledge and lot of hands-on experience in implementation of database servers (includes HA setup like RAC, grid and data guard).
Patching the binaries with the latest PSU patches and Bundle patches.
Patching the cluster software and database home with rolling upgrades.
Configuration and administration of Data guard.
Execution of scripts, user creation and management.
Backup and restore using RMAN utility.
Cluster configuration verification using Cluvfy utility.
Database upgrade from 10.2.0.4 to 10.2.0.5, 10.2.0.5 to 11.2.0.1 and 10.2.0.5 to 11.2.0.3.
Cluster upgrade from 11.1.0.6 to 11.1.0.7.
Scheduling backup policy and writing shell scripts for scheduling automated backup.
Exporting and importing data in database using Data Pump utility.
Deploying the scripts in database on the advice of application team.
Working on End User requests in the database.
Regular monitoring of all DB environments (RAC, data guard & single instance).
Implementing OEM grid server and installation of agent in servers.
Configuring server and database monitoring for all servers and database in OEM.
Testing switch over and switch back in the servers in DR site and primary site.
Database refresh in various servers using RMAN (both single instance & RAC setup).
Database migration using RMAN in various scenarios between miscellaneous platforms.
Materialized view data replication and identify and rectify the potential bottlenecks of performance degradation.
Hands-on experience in working on DR-drill activity various times and ensuring that activity is completed perfectly.
D. Organization: Temenos Ind Pvt LTD
Client : DB- Deutsche Bank Nov ’08 to Apr’11
Project : Temenos Internal DBA
Description : Worked as Team member which deals with Development & Testing support.
TECHNICAL SKILLS
Project : Everbank
Client : Everbank, US
Database/Environment : Oracle 9i,10g Unix/Windows flavours
Role : Database Administrator
Key Skills : Providing support as L1, User ticket handling, Dataguard
Setup, EXP/IMP, Data pump, RMAN
ROLES & RESPONSIBILITIES
Creation of Tablespaces, data files, users etc., for the project requirement.
Controlling the users operations by limiting the memory spaces and grant the necessary roles, privileges and profiles to the users.
Performed regular RMAN backups to safeguard from User errors and Media failures.
Creation of clone database using RMAN for testing.
Using TKPROF, STATSPACK to find ways to improve the database’s performance.
Creation of Clone database for the test database environment using RMAN.
Logical Backup of Databases using Export and Import Utility as well as using Datapump.
Recovery of lost objects and datafiles.
RMAN Backup and recovery strategies.
Datafile Consistency using DB Verify.
SQL Loader.
Implementation of DATAGUARD Physical Standby.
Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.
Transportable_Tablespaces.
Recovery Catalog using RMAN.
CLIENT SERVICING
Managing customer service operations for rendering and achieving quality services.
Responsible for resolving customer complaints on performance bottlenecks.
Providing value added customer services by attending customer queries and issues.
Certifications & Trainings
Certified on ITIL V3 – Foundation.
Completed Oracle certified professional for 10g.
Attended technical vendor training on Oracle 11g grid infrastructure administration in CTS
Attended technical vendor(Oracle Corp) training on MSSQL administration in HP
Attended technical vendor training on Oracle Goldengate in private sector.
Attended technical vendor(Oracle Corp) training on PostgreSQL administration in HP
Academic
Qualification
Institute/University
Year of Passing
Percentage of marks
B.E
(I.T)
Diploma
DCE
HIGHER SECONDARY
(State board)
S.S.L.C
( State board )
Nandha Engineering College
( Anna University)
Thiru Ramakrishna Nallami Polytechnic College, Dharapuram
M.S.N.Hr Sec School, Dharapuram
M.S.N.Hr Sec School, Dharapuram
May 2008
Apr 2005
Mar 2003
Mar 2001
70
83
72
84
Date of Birth: Jan 29th, 1986