https://pl.linkedin.com/in/bakkiyarajathimoolam
Career
Summary
Having around 9 years of diverse, rich and insightful experience in large Financial Organization including over 4.5 years of working in International Environment (IE) with a strong technology as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, migration and documentation.
Oracle Competence Specialization: Oracle resilience Architectures (Maximum Availability and High Availability Architectures), Oracle Exadata Database Appliance, Oracle Database Appliance (ODA), Oracle Performance Tools (Oracle diagnostic pack, tuning pack, Application Management Packs), Methodologies (Oracle Applications Implementation (AIM) Methodology), Engagement Expertise (Technical Architecture, & Database Administration, Database Up gradation, Database Installation & Performance Tuning, and Oracle enterprise manager (OEM).
Technical Summary
8+ Years Oracle DBA
Oracle db 9i, 10g,11g,12c rdbms, real application clusters (RAC), Exadata,ODA sql & pl/sql scripting, sql tuning, SQL*Loader, SQL*plus, object size, initialization parameters, backup recovery, imp/exp, RMAN, installation, migration, patches, indexes, physical database design layout, logical database layout, Replication, Refresh database, training for OU, creating schemas, db links, unix shell scripting, crob jobs, Data Gaurd standby DR databases.
Education
Academic Qualification
Master of Computer Application (MCA), Anna University -2008
Bachelor of Science (B.Sc), University of Madras -2004
Certifications
Certifications
Oracle Certified Professional (OCP) in 9i,10g,11g &12c
Oracle Certified Expert(RAC)Oracle 10g
Trainings
Trainings
Oracle Database 11g:RAC Administration in Oracle Corp –Jan ‘14
Oracle Enterprise Manager 11g: Grid Control Essentials in Oracle Corp –Jan ‘14
Oracle ZFS Storage Appliance Administrator in Oracle Corp –Apl’16
Technical Skills
Rdbms
Oracle12c/11g/10g/9i Oracle 10g (RAC, and Data Guard)
Database & OS clusters
Oracle Real Application clusters (RAC), RHEL clusters, IBM HACMP clusters
Operating Systems
Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
Languages
SQL, PL/SQL, C, C++.
Lifecycle Management Tool
Oracle Enterprise Manager (OEM) 9i,10g,11g,12c
Database Management Tools
SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump, TOAD,
Build Scripts
Unix Shell,perl Scripting
Presentation Tools
MS PowerPoint
Organization
Designation
From
To
Credit Suisse,Poland
Senior Oracle DBA
Apr 2015
Present
Credit Suisse,Zurich
Senior Oracle DBA
Oct 2016
Nov 2016
Wipro Technologies, Poland
Senior Oracle DBA
Feb 2013
Mar 2015
Wipro Technologies,India
Oracle DBA
Jun 2011
Feb 2013
Business Integra,India
Oracle Consultant
Mar 2009
Jun 2011
Organization
Credit Suisse,Poland, Wroclaw
Client
Credit Suisse,Zurich
Role
Senior Oracle Database Administrator
Responsibilities
Operations : Working in 24/5 DBA, technical and Infrastructure teams of 30 resources to support 24/7 DBA and administration activities as per business requirements on availability and routine backup recovery throughout the SDLC lifecycle .
System Maintenance and Support :On various server issues and Applications and database issues. Support the Whole team from offshore and onsite as per the Development requests
Performance Tuning : Memory Issues from OS, Database, Application level Tuning for the Performance monitoring issues,
Troubleshooting Issues of Oracle Databases and infrastructure issues.
Migration : Migrating custom codepacks and patches to production from Test and development and UAT instances. Refresh & Cloaning was the daily or quarterly based mandatory activity from production to Test and development and UAT instances.
Have been supported for specific project, handled all db tasks like clone, deployment, migration and db refresh PROD to PTA quarterly.
Database migrated 11.2.04 to 12.1.01 version.
Involved database refresh for DWH environment with VLDB .
Database was restored and created new database with size of 15TB with VLDB.
Knowledge of about Oracle OID.
Have been working and Hands-on experience following database version Oracle 9i,10g, 11g/12c on Linux,AIX and Sun.
Expert Oracle RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning.
Experience Oracle back-up, recovery, remote monitoring skills with hands-on experience on large (VLDB) and very dynamic environments.
Experience with Oracle Data Appliance on Linux with Virtual Machine.
Experience Exadata X5-2 Half Racks (HA) Administration and ZFS storage.
Experience ODA Servers with ZFS storage.
Experience on SMU(Snap Management Utility ) with ZFS Storage,Created snapshots backup and cloned db from it.Used RMAN backup script via SMU
Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Knowledge in ad hoc scripts using Perl and Shell.
Duration
27 Months
Organization
Wipro Technologies, Poland, Lodz
Client
Citi International bank,Brazil
Role
Senior Oracle Database Administrator
Responsibilities
Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Linux and IBM AIX environments.
Successfully migrated Oracle 10g (10.2.0.4) to Oracle 11g (11.2.4.0).
Involved in Installation and gird configuration of Oracle 10g,11gRAC using ASM.
24x7 remote support and on call Database support for Database developers and end-users.
Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management and Security Administration.
Created and Configured Physical Standby database for node RAC database using Data Guard.
Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
Managing and Writing Unix shell scripts for database administration, backup and performance monitoring.
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, AWR, ADDM and monitor the database performance on daily basis.
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
Cloning, duplicating databases and db or schema refresh full, schema and table level whenever needed.
Expertise in Oracle Enterprise Manager (OEM),agent and TOAD.
Duration
25 MONTHS
Organization
Wipro Technologies, India, Chennai
Client
Citi International,North America
Role
Oracle Database Administrator
Responsibilities
Managed 24/7 DBA & Technical support team of 18 resources.
24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
Implemented backup strategies using hot/cold, exp/imp used on the business requirement.
Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
Developing, Testing and Implementing backup and Recovery Strategy.
Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
Performed space management and performance monitoring.
Duration
21 months
Organization
Business Integra, India, Chennai
Client
World Bank,us
Role
Oracle Consultant
Responsibilities
Managed 24 / 5 DBA & Technical support team of 9 resources.
Responsible for administration and supporting Oracle 9i and 10g databases.
24x5 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
Managing Logical backups (Expdp/Impdp) on Prod and Non Prod databases.
Install Oracle 11gR2 Binaries on Linux and did POCs on Oracle 11g New Features (Expdp, Password Case-Sensitive and Active Duplication).
Rising and Follow up the SR on Oracle technical Support and implement the work around.
Duration
27 months
Personal
Details
Full Name
Bakkiyaraj Athimoolam
Marital Status
Single
Date of birth
30-July-1983
Personal
Skills
●Excellent interpersonal skills
●Eager to work both as a team and independently, to achieve common goals
●Always motivated to learn and advance
●High personal standard with attention to detail
●Good business acumen
●Enjoy working and dealing with people
●Excellent written and verbal communication
●Always used to reading oracle bolgs and keep learning new technology
Personal
Interests
●Life-long passion for Computing and Technology
●Interest in current affairs, politics, and general science
●Enjoy Cycling, Gym and Running regularly