ARUN KALAISELVAN Email :
**********@*****.***
Professional Summary:
> A professional with 6 years of experience in the field of Oracle Database
Administrator in Banking Domain
> Hands-on experience on installation/up-gradation/migration/patching,
capacity planning, performance tuning, backup/recovery of Oracle
Databases
> Experience in handling production, development and test environment
support on various platforms such as IBM-AIX,HP-UNIX, Sun-Solaris,
RedHat Linux, zLinux and Windows
> Experience in installation, Configuration of 11gR2/10g RAC, ASM, Grid
Control, RMAN, and handling very large databases
> Experience in implementation and support for high availability solutions
such as Oracle Data Guard, ASM, Real Application Clusters (RAC) and
Shareplex
> Experience on cross platform migration such as HP to AIX, SUN to AIX,
RedHat Linux to AIX environment using various RMAN features and data pump
> Experience on implementing VERITAS NetBackup for the various backup
strategies
> Experience on handling OEM Grid control for several DBA activities
> In-depth knowledge of Oracle database architecture and Primary components
> Good Domain knowledge in Banking
> Experience in direct interaction and problem solving with client
> Excellent communication, interpersonal and strong analytical skills,
Documentation & Problem-solving skills with customer service oriented
attitude. A very good team player, self motivated, dedicated in any work
environment
Educational Summary:
> Bachelor of Technology in Computer Science and Engineering
Certifications:
> Completed OCP (Oracle Certificate Professional) in Oracle Database 10g
administrator certified professional
> Completed OCA (Oracle Certificate Associate) in Oracle PL/SQL developer
certified associate
Achievements:
> GEM Award - Recognized as GEM of the Quarter for outstanding performance
in BAU support presented by Citibank
Core Competence:
Databases : Oracle 9i/10g/11g/11gR2
Operating System : IBM-AIX, HP-UNIX, Sun-Solaris, RedHat Linux, zLinux and
Windows
Languages : SQL, PL/SQL, UNIX Shell Scripting
DB tools & utilities : RAC, GRID, ASM, RMAN, DG, OPatch, Exp/Imp, Data
Pump, AWR,
SQL*Loader, TOAD, SQL Developer
Professional Experience:
Citibank (Jun'10 - Nov'12)
Role : Senior Oracle DBA
Project : Regional DBA Operation
Roles and responsibilities:
> Maintained and supported over 1,500 databases on several Unix flavors and
windows environment
> Installed and Configured 11gR2 Grid infrastructure and Integrated with
11g/10g RAC database on new server(IBM-AIX) in development and production
environment
> Installed and supported on Oracle 9i/10g/11g databases along with various
high availabilities like GRID, RAC, ASM, Data Guard and Shareplex on
several Unix flavors and windows environments
> Setup and supported HA solutions Standby servers, Data Guard Setup,
Configured Oracle Data Guard using physical standby database, active data
guard and snapshot standby
> Implemented RMAN Backups, Creation of catalog database in development and
production environment
> Experienced in Migrating databases from VERITAS file systems to ASM
> Experienced in upgrading databases from lower to higher version of oracle
such as 10g to 11g, 9i to 11g
> Experienced on database cross platform migration using data pumps, RMAN
transportable tablespace, RMAN duplicate between various environments
such as HP-Unix to IBM-AIX, Sun-Solaris to IBM-AIX, RetHat-Linux to IBM-
AIX etc
> Cloned an Oracle database using RMAN duplicate, Cold and Hot cloning
> Installed and implemented Shareplex to replicate data for various
business needs
> Implemented and automated regular VERITAS NetBackup in Unix environment
> Regular Security patching on oracle products and interim patching for
various bug fixes on database products such as VTM, JVM, Numa and One-off
patches
> Provided support using Oracle Enterprise Manager Grid Control and Agents
> Fine-tuned the performance of the database and SQL
> Creation and managing Standalone and RAC databases, tables, views,
indexes and other database objects
> Worked with several team members such as application, platform,
middleware team to sort out the critical issues
> Worked with Oracle Support to resolve technical bug with various
workaround by creating SR using Metalink
> Provided On-call standby database support on rotational basis
HCL Technologies, Chennai (Jun' 07 - May' 10)
Role : Oracle DBA
Client : AEGON Insurances, Netherlands
Project : AEHome (Banking Domain)
On-site : 1 year at Netherlands
Roles and responsibilities:
> Maintained over 150 databases on HP-Unix, IBM-AIX and windows
environment
> Installed and configured Oracle 9i and 10g databases
> Installed Oracle 10g RAC, Standby Databases for high availability and
disaster recovery/reporting purpose
> Patched oracle databases using OPatch Utility (VTM, JVM, Numa)
> Created table spaces, users, profiles, roles according to legacy systems
> Experienced in Implementing RMAN backup with Recovery catalog
> Experienced in taking logical backup by using oracle
utility exp/imp and Data Pump
> Experienced on Oracle's Flashback technology to recover database
> Monitoring & Managing the Tablespace and increase the Size whenever
required
> Granting and monitoring user access rights and privileges through SQL
Roles
> Monitoring and Optimizing the performance of the database and SQL
> Experienced in SQL query, PL/SQL package, function, stored procedure,
triggers to implement business logics of Oracle databases
> On-call Support 24/7 Production, Queue monitoring