I.Prabu Athithan

adze9v@r.postjobfree.com

+1-302-***-****

Oracle Database Architect with 13+ Years of Experience

Skills: Supercluster, Exadata, Goldengate, RAC, Performance tuning, Migration, Upgrades, Data guard, PostgreSQL, AWS, Oracle Cloud, WebLogic, MySQL, OEM, Grafana, ELK Stack

Supercluster M7- Managing and Administration of RAC nodes, resizing grid disks from cell storage and applying QFSDP Patch, bug fix patch on storage cells.

Exadata X9M-2 Elastic Rack, X5-2 Eighth Rack, X3-2 Quarter Rack - Managing and Administration of RAC nodes and KVM’s, upgraded grid, database from 11.2.0.3 to 11.2.0.4, removal and adding of database nodes, applying ExaDBBP bundle patches,

Exadata – Non-Exadata migration.

PostgreSQL - Installation, configuration and administration of 9.6,10,14,15, Streaming replication, Switchover, Switchback, Upgrade from 9.4 to 11.0 and 11.0 to 15.0, configuring repmgr for automatic failover and HAProxy for load balancing.

RAC-Installation, configuration and administration of Oracle 10gR2, 11gR2, 12cR1,12cR2,18c,19c databases for (RAC/Non-RAC Databases), adding and removal of node from the cluster, Reconfiguration of cluster nodes, Windows OFS.

ASM- Configuration, administration of ASM disk groups, adding and dropping disks, migrated ASM disks from HDD to SSD.

Data guard- Configuration, administration of data guard 10gR2, 11gR2, 12cR1, 12cR2,19c which includes switchover, failover, DR drill activities, FSFO, DG broker, Roll forwarding standby database, Active data guard, Snapshot standby databases.

Cloud- Creation of VCN, Compute VM, databases on Oracle IaaS, Dbaas, Migration of databases oracle 11g, 12c, MySQL 5.6 to RDS, AWS EC2, Oracle Cloud.

Migration- Database Migration from Oracle 10g,11g, 12c,19c databases on Linux/Solaris/Windows/AIX platform using expdp/impdp, RMAN, data guard, golden gate technologies, Exadata to Non-Exadata migrations.

Cross- Platform Migration- Performed cross platform migration using Transportable Tablespace XTTS between Solaris SPARC 11.4 to Oracle Linux 7.2 and Solaris SPARC 11.4 to AIX 7.2.

Upgrade- Upgraded databases from 10gR2-to-10gR2 Patch set 5, 11gR2 to 11gR2 Patch set 4, 11gR2 to 12cR1, 12cR2 to 19c on RAC database and data guard environments, rolling upgrades using physru.

ELK – Deployed Elasticsearch cluster 7.14 and ELK stack for databases centralized logging.

Patches- Applying bug fix, rolling patches for grid and databases 11g,12c,19c for RAC/Non-RAC environments and golden gate 11g, 12c, WebLogic 10g

WebLogic- Installation, configuration and administration of Web logic 10.3.6, 11g FMW for forms & reports and 12c Infrastructure.

Performance Tuning- Expertise in Tuning Memory, SQL query, Tuning Disk IO Usage, SQL trace, AWR, ASH, ADDM, Troubleshooting using hang analyze 3, 4.

Restore & Recovery – Clone, restore and recovery of databases using RMAN backups, TTS, duplicate, recovery from block corruption, tablespaces, control file, redo logs.

Data-pump - Managing the logical backup of the databases, schemas, tables using Data Pump for data refreshes from Prod DB to Dev/QA. s

Security- TDE for column encryption, Audit, Wallets, FGA control, Database vault.

Team Player- Working on L3 tasks. Providing RCA, Client responsibility, handling P1 issues and teams

Golden gate Administrator’s Role & Responsibilities: (9 Years’ Experience):

Installation, configuration and administration of Oracle 12c golden gate on 11g,12c RAC databases.

Installation of golden gate veridata 12.2, configured with veridata server and Agents.

Configured XAG agent and action scripts for high availability on RAC databases.

Performed Zero downtime migration on Premises to Oracle Cloud IaaS using Golden gate 11g & 12c.

Configured Uni & Bi directional table replication using Oracle Golden gate 11g & 12c and Microservices architecture.

Configured Golden gate extract for DML & DDL replication.

Applied PSU Patch for 12c Golden gate for bug fixes.

Upgraded Oracle Golden gate from 11.2.0.1.16 to 11.2.0.1.33 for bug fixes.

Downgraded golden gate from integrated to classic capture method.

Adding tables & resynchronization tables in existing golden gate configuration.

Troubleshooting and fixed Golden gate errors using Log dump Utility.

Golden gate on Heterogeneous databases and Big Data:

Configuration and administration of golden gate from SQL server 2008 to Oracle 11g for table replication.

Installation, configuration of Golden gate 12.3 for big data on HDP 2.6.

Configured golden gate from Oracle 11g to MySQL 5.6 for table replication.

Configured tables replication from Oracle 12c, MySQL 5.7, SQL 2016 to Hbase on HDFS using golden gate 12c.

MySQL/PostgreSQL/SQL DBA’s Role & Responsibilities: (2 Year’s Experience):

Installation, configuration and administration of MySQL 5.6,5.7,8.0 on Linux and Windows environments.

Installation, configuration and administration of PostgreSQL 9.4,10.6 on Linux and Windows environments.

Installation, configuration and administration of SQL server 2008, 2012, 2016 on Windows environments.

Configured and implemented MySQL 8.0 Master Slave replication, Innodb Cluster for High Availability.

Migrated tables data from Oracle to MySQL 5.7, 8.0 using Sqlyog and AWS Schema Conversion Tool.

Experience on migration MySQL 5.6 from Windows to Linux environments.

Migrated tables data from Oracle to Postgresql 9.6 using ora2pg.

Experience in implementing HA using Log shipping for SQL server 2008.

Configured database gateway from Oracle 11g to SQL server 2012.

Hadoop Admin’s Role & Responsibilities: (Testing, UAT, Production with 6 Month’s Experience):

Installation, configuration and administration including HDFS, Hbase services using Hortonworks Ambari 2.6.

Installation, configuration of Hadoop 2.9.1 HDFS for Single node cluster.

Configured property files including core-site.xml, hdfs-site.xml, mapred-site.xml, yarn-site.xml.

Installation, configuration of Sqoop 1.4.7, Hive 2.3.3, Hbase 1.2.4.

Experience in exporting the data from RDBMS to HDFS using Sqoop.

Technical Skills:

Operating System

Red-hat 6,7,OEL 6 & 6.5,7, 7.2, 7.9 Windows Server 2012,Sun Solaris 11.3, AIX 6.1, 7.2

Oracle Databases

Oracle 10gR2,11gR2,12cR1&R2,18c,19cRAC & Standalone

Cloud Databases

Oracle Cloud Infrastructure IaaS, DbaaS, AWS RDS, EC2, Sify.

Admin Tools

OEM 10g,11g, AWS Cloud Control, Oracle Veri data 12c

Application Server

Oracle Fusion Middleware 11g & 12c, 10g IAS Server, Weblogic 10.3.6

Replication Tools

Oracle Golden Gate 11g, 12c, Golden gate Adapter 12c for Big Data

Performance Tuning

SQL Tuning Advisor, SQL trace, Explain Plan, AWR, ADDM, ASH

Database Gateways

Gateway for SQL server 11g

Migration Tools

AWS Schema Conversion Tool, Ora2pg, SQL Developer, SQL Yog

Backup Tools

RMAN, Expdp, Impdp, Export, Import

Security

Audit,TDE, Wallets, Fine grain Auditing, Vault

Other Databases

MySQL 5.6,5.7,8.0.13, PostgreSQL 9.4,10.6,12,14,15,SQL Server 2008,2012,2016

Hadoop Framework

HDP 2.6,Hadoop 2.9.1,Hive 2.3.3,Sqoop 1.4.7,Hbase 1.2.4

PROFESSIONAL WORK EXPERIENCE & PROJECTS

Company: ANB, Casper, WY (February 2023 – July 2023)

Role: Oracle Database Architect

Migrating Oracle databases from HP-UNIX to X9M Exadata using XTTS.

Migrating and Upgrading Finacle database from 11g to 19c using Goldengate downstream capture.

Managing X9M-2 Exadata, KVM’s, Compute nodes and Storage cells.

Handling Performance issues and major escalations on core banking database.

Managing PostgreSQL databases, Performing Switchover and database upgrades.

Configuring Repmgr and HAProxy for PostgreSQL databases.

Configuring Grafana, Prometheus, pgscv for database monitoring.

Goldengate replication between Oracle 19c to Postgres 12 heterogenous database.

Project Name:

Finacle Upgrade

Environments

Operating Systems: Oracle Solaris SPARC 11.4, Oracle Linux 7.9, HP-Unix

RDBMS: Oracle 11gR2,19c and Postgresql 11, 12.

Goldengate:19c

Dataguard:11gR2 RAC,19c RAC

Exadata: X9-M Elastic Rack HC 18TB

Company : Wipro (September 2019 – February 2023)

Role : Lead Oracle Database Administrator L4

Handling P1 tasks and performing L3 activities includes upgradation, migration, patching, performance issues switchover/switchback, node addition/deletion.

Provides hands on technical expertise to senior technical level & for L2, L3 Team.

Managing L2 and L3 Team and guiding during critical tasks.

Involving on MI calls, RCA submission and handling client escalations.

Domain connects with Delivery/Clients, sharing recurring incidents along with pro-active recommendations.

POA validation, Problem ticket analysis, Risk logging for critical and SIP for live database environments.

Project Name:

GSMC/SNXT Shared DBA Projects

Client

(1)- Equitas Bank.

(2)- LVB Bank.

(3)- PNB Bank.

(4)- Arvind Retail.

(5)- Mahindra & Mahindra

(6)- Adani Ports

(7)- HDFC Bank

(8)- Atheeb Telecom

(9)- DLB Bank

Environments

Operating Systems: Oracle Solaris SPARC 10.3, 11.3, Red hat Linux 6.5,7, Oracle Linux 7.1.AIX 7.1

RDBMS: Oracle 11gR2,12cR1,R2,19c

NoSQL: Elasticsearch

Goldengate:12c, Veridata 12c

Dataguard:11gR2 RAC, 12cR1&R2,19c

Exadata: X5-2 Eighth Rack HC 8TB, X3-2 Quarter Rack HC

Super Cluster : SuperCluster 1 M7 Elastic Rack X5_HC 8TB 1HCA

Company : JMR Infotech (October 2017 – July 2019)

Role : Senior Engineer-Oracle DBA/Golden gate Consultant

Project Name:

(1)- Core banking, Internet banking, Card, Management systems.

(2)- Data warehouse.

(3)- Cloud Migration

Client

(1)- AZIZI Bank.

(2)- Myanmar Apex Bank.

(3)- Acleda Bank.

(4)-Afghanistan Bank.

Environments

Operating Systems: Oracle Solaris 11.3, Red hat Linux 6.5, Oracle Linux 7.1.

RDBMS: Oracle 11gR2,12cR1,R2,18c (RAC/Non-RAC Databases), MySQL 5.7,8.0.13, Postgresql 10.6, SQL server 2008,2016.

Weblogic: Weblogic Infra 12c.

Goldengate:12c, Veridata 12c

Dataguard:11gR2 RAC, 12cR1&R2, DBvisit 8.

Hadoop: HDP 2.6,Hadoop 2.9.1,Hive 2.3.3,Sqoop 1.4.7,Hbase 1.2.4.

Tools/utilites: OEM12c, RMAN, Datapump.

Cloud: Oracle IaaS, Dbaas.

Company : Information Dynamics (April 2015 – October 2017)

Role : Oracle Database Administrator

Project Name:

(1)- Shipping and Logistics.

(2)- Travel.

(3)- Retail.

Client

(1)- T.S.Lines.

(2)- Sharaf DG.

Environments

Operating Systems: Red hat Linux 6,6.2, Oracle Linux 7, Windows 2008,2012.

RDBMS: Oracle 10gR2,11gR2,12cR1 (RAC/Non-RAC Databases), MySQL 5.6, Postgresql 9.4,9.6,

SQL Server 2008,2012.

Weblogic: Weblogic 10.3.6, 10g IAS.

Goldengate:11g, 12c.

Dataguard:10gR2, 11gR2 RAC,12cR1, DBvisit 6.

Tools/utilities: OEM11g, RMAN, Datapump, AWS Schema conversion tool, Log mining, Database gateways, Database links.

Cloud:Oracle, AWS RDS, EC2, Sify

Company : Hewlett Packard (Dec 2014 – April 2015)

Role : Oracle RAC Administrator

Project Name:

COA

Client

Centre for Railway Information Systems.

Environments

Operating Systems: Red hat Linux 6, Windows 2008, 2012.

RDBMS: Oracle 10gR2 (RAC).

Tools/utilites: OEM11g, RMAN, Datapump.

Company : Best software solutions (Jun 2010 – Dec 2014)

Role : Oracle Database Administrator

Project Name:

(1)- ERP

(2)-Payroll

Client

AJM Group of Companies

Environments

Operating Systems: Red hat Linux 5.5, Windows 2008, 2012.

RDBMS: Oracle 11gR2 (Standalone).

Tools/utilites: RMAN, Datapump.

EDUCATIONAL DETAILS

MBA Systems Management from Madras university, Chennai, in (2014).

BSC Computer Science from Vels University, Chennai, in (2010).

CERTIFICATION

Oracle OCA with 100% from Oracle Corporation, Chennai, in (2016).

OCI Cloud Architect Professional 2021

Contact this candidate