Resume

Sign in

Bakkiyaraj Athimoolam - Senior Oracle DBA

Location:
Wrocław, Lower Silesian Voivodeship, 55, Poland
Salary:
>150000
Posted:
August 28, 2017

Contact this candidate

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



Contact this candidate