Resume

Sign in

Database Customer Service

Location:
Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia
Posted:
October 06, 2016

Contact this candidate

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



Contact this candidate