Bakkiyaraj Athimoolam

DevOps Engineer

Wrocław, Dolnośląskie, Poland16 yrs 11 mos experience

Highly Stable

Key Highlights

Over 15 years of experience in database administration.
Expertise in Oracle and PostgreSQL environments.
Proven track record in database migration and performance tuning.

Stackforce AI infers this person is a highly skilled Oracle and PostgreSQL Database Administrator in the Fintech industry.

Contact

Skills

Core Skills

Postgresql Database AdministrationOracle Database AdministrationOracle Database MigrationDatabase Refresh Management

Other Skills

AnsibleData GuardData MigrationData PumpDatabase DesignDatabase administrationDatabase migrationDatabase performance tuningDatabase refreshExadataGrafanaGrid ControlHigh AvailabilityIBM AIXLinux

About

Having 15+ years of diverse, rich and insightful experience in large Financial and Banking Organization including over 12+ years of working in International Environment (IE) with a strong technology as an Oracle Core 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 ExadataX5-2 ,X8-2 & X9M-9/2 OVM,XM10,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). Specialties: * Oracle 10g/11g/12c /19c RAC experience * Oracle Database 9i,10g,11g,12c &19c * Exp/imp on Oracle 9i * expdp/impdp on Oracle 10g,11g,12c & 19c * OEM Grid Control * RMAN * ASM * TOAD * DATAGUARD * Oracle ZFS Storage Appliance. * Oracle Exadata X5-2 machine * Oracle Exadata X8-2 &X9M-2 machine * OID knowledge * ODA Experience * SMU utility and clone db with ZFS storage * ZLDRA Experience * Oracle VM-OVM * PostgreSQL

Experience

Ubs

Infrastructure Engineer

Oct 2024 – Present · 1 yr 5 mos · Wrocław, Dolnośląskie, Poland · On-site

As a PostgreSQL DBA, including hands-on operational expertise in managing production databases
Proven experience in managing large-scale PostgreSQL environments with replication, clustering, or partitioning
Deep understanding of PostgreSQL architecture, extensions, and tools
Expertise in SQL query optimization and debugging
Strong knowledge of Linux environments, including shell scripting and system-level
Proficient in Shell scripting

PostgreSQLSQLLinuxShell scriptingPostgreSQL Database Administration

Credit suisse

3 roles

Senior Oracle DBA

Jul 2019 – Sep 2019 · 2 mos

Senior Oracle DBA

Senior Oracle DBA

Oct 2016 – Nov 2016 · 1 mo

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 Administration with ZFS storage.
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.

Oracle OIDDatabase migrationPerformance tuningShell scriptingOracle Database Administration

Senior Oracle DBA as AVP

Apr 2015 – Jan 2025 · 9 yrs 9 mos

Knowledge of about Oracle OID.
Familiarity with infrastructure as code tools such as Ansible, Terraform.
Knowledge of about MS-Azure Fundamental.
Create/manage Oracle SR and support team in issue resolution
Experience with Perl, and Unix Shell Scripting for custom monitoring and automation ·
Hands-on experience database version from Oracle 9i to 19c on Linux, AIX and Sun.
Hands on experience Test Master clone with PROD db and create sparse clone for DEV env.
Hands on Experience Exadata X5-2, ODA Servers & X9M-2
Have been supported, involved and migrated several projects within Bank, handled all database related tasks alone and delivered the project to customer on time.
Database migrated 11.2.04 & 12.2.0.1 to 19.0.0 version on standalone via in-place upgrade.
Experience with Patch/Upgrade and release management (database, storage node, server, network, Oracle Exadata) ·
Develop and maintain system documentation related to your Oracle Exadata and software configuration ·
Exadata feature enablement, monitoring, review and update placement strategy · Working knowledge on Exadata 5 and above platforms.
Hands on Experience on Exadata, Cell Storage, Compute Nodes, Real Application Cluster, IB & RoCE Switches.
Experience on reading Exadata Health Check Report (exachk), Performance tuning, AWR, ASH, ADDM, Explain Plan etc.
Strong experience in Oracle Core Database administration and monitoring including Exposure to Performance of Exadata.
Hands on knowledge of Oracle Enterprise Manager (OEM).
Experience with RMAN database backup and recovery using ZFS and Data Domain.
Excellent understanding, installing, administering and working knowledge of Oracle 9i through 19c databases ·
Experience in configuring and managing Oracle RAC, Clusterware, Grid infrastructure, Oracle ASM, OEM and GoldenGate
Hands-on with Oracle Database migration/upgrade using different methodologies Data Pump & RMAN Transportable Tablespaces.

Oracle OIDAnsibleTerraformMS-AzurePerlUnix Shell Scripting+6

Wipro

2 roles

Senior Oracle DBA

Promoted

Mar 2013 – Mar 2015 · 2 yrs

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.

Oracle 11gOracle 10gDatabase performance tuningShell scriptingData GuardOracle Database Administration

Oracle DBA

Jun 2011 – Feb 2013 · 1 yr 8 mos

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.

Oracle 9iOracle 10gDatabase administrationShell scriptingOracle Database Administration

Business integra inc

Oracle Database Administrator

Mar 2009 – Jun 2011 · 2 yrs 3 mos · Chennai Area, India

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.