Sathish Kumar Shanmugam

Phone: +1-832-***-****

E-Mail: ad4r8m@r.postjobfree.com

LinkedIn URL:https://www.linkedin.com/in/sathish-kumar-shanmugam-6873b19/

DATABASE AND GOLDENGATE ADMISTRATOR + CLOUD ARCHITECT

AWS-Oracle-Azure Cloud +Statistical Analysis +Solution Focused

Personable, detail-oriented, database Administrator with a solid background in database management. High experience in managing multiple servers in multiple-instances environment, backup/restore troubleshooting and proactive maintenance. Adept at deliveringcomprehensive application and operating system support to diagnose and resolve unique recurring problems. Outstanding ability to manage multiple projects working within strict deadline. Strong technical knowledge of database architecture optimizes and maintains system functionality performance and recoverability. Excellent written and oral communication and presentation skills.

Oracle Core DBA with over 16+ years’ experience in maintaining Oracle Database running on UNIX/LINUX (Sun Solaris- HP-UX- AIX- RHEL - OEL), Windows, Azure, and AWS Cloud Technologies.

SELECTED HIGLIGHTS

Knowledge and 4+ Years hands on experience in AWS (EC2-S3-RDS -VPC-Rout53 and DMS) and certified in AWS Certified Solutions Architect – Associate & AWS Certified Database – Specialty

Knowledge and 2+ Years hands on experience in Azure Services (Virtual machines, SQL Databases, SQL Managed Instance, Virtual Networks, Storage Account & Azure Data Factory)

Involved MSSQL Server Migration from AWS to Azure SQL Managed Instance.

Knowledge on Oracle Cloud Infrastructure (OCI).

Performed disaster recovery testing and brought in high available replication features such as Dataguard and Oracle GoldenGate to ensure business-readiness following server failure.

Prioritized and resolved outstanding defects and system problems, ensuring accuracy and SLAs were met.

Deployed a proactive monitoring system to resolve issues before they impact end users. ~ 25% of the problems were captured and fixed before they turned out to be incidents.

Upgraded 5+ Oracle RAC & Standalone databases from 11g to 12c.

Upgraded 9+ Oracle RAC & Standalone databases from 12c to 19c

Led a team of 7 core and application DBAs, responsible for the day-to-day operations.

Improved vital processing jobs by reducing process duration by 30%

Eliminated months of production server issues by systematically troubleshooting and resolving the problem with no further downtime.

Extensive knowledge on database administration for Oracle 19c, 12c and 11g- with experience in very large-scale database environment and mission critical large OLTP systems.

Operational Support experience in Oracle 19c/12c and 11g GoldenGate Administration.

Involved with installation and maintenance of Oracle 11g RAC & 12c and standby database for High Availability and Disaster Recovery purpose.

Hands on experience in Oracle 19c, 12c and 11g RAC implementation & administration (Oracle Clusterware setup and configuration- RAC installation using ASM- Grid Installation).

Good experience RAC Clusterware administration- Configuration and Patching.

Extensive experience in Dataguard configuration- implementing and maintaining Physical standby databases.

Good experience in PATCHING AND UPGRADATION. Expertise in upgrading Oracle Development and Production databases from 10g to 11g & 11g to 12c/19c

Experience in Flash-Back Technology.

CORE COMPETENCIES

Information Technology Performance Analysis Cloud Computing

Database Administrator Process Improvements Backup / Recovery

Design Specification Database Security High Availability

GoldenGate Disaster Recovery Oracle Enterprise manager 12c/13c

RAC Administration Dataguard Administration Patching & Upgrade

Snowflake AWS Jenkins

EDUCATION

B.E. (Computer Science Eng.) 2005.

TECHNICALCERTIFICATION

Microsoft Microsoft Certified: Azure Administrator Associate

AWS Certified Database – Specialty – 2022

AWS Certified Solutions Architect – Associate - 2019

Oracle Certified Professional –Oracle Database Administrator 11g

Oracle Certified Expert – Oracle Real Application Cluster 10g Administrator

TECHNICAL SKILLS

Database : Oracle 19c,12c, 11g & 10g

Cloud Computing : AWS, Oracle, and Snowflake

Oracle Engineered Systems : Exadata

Oracle Products : OEM 12c &13c- Golden Gate 19c,12c and 11g

Operating Systems : RHEL 7- AIX- SOLARIS

Tools : SQL*Loader, SQL*Plus, TOAD, Grid Control.

RMAN, Export/ Import, Data pump, BMC Remedy, ServiceNow

Telnet Tools : PuTTy, Bitvise

PROJECTS HANDLED

Baxter International Inc (Chicago, Illinois, USA)

Stefanini (Guadalajara-Mexico)

DBU IT Administration –Cummins Inc. (USA)

IT IS Managed Services, Walgreens - Deerfield, USA

AT&T AMERICAS INFORMATION MANAGEMENT, AT&T Inc. (USA)

ROGERS, Rogers Communication Inc. (Canada)

SPACE (Service Process Automation and Control Engine), British Telecom Ltd (U.K)

PREMIA, Oriental Insurance co. Ltd - India

PREMIA, STAR Health Insurance Ltd – India

PROFESSIONAL EXPERIENCE

Kovan Technology Solutions – Houston – Texas April 2024 – Present

Sr. Oracle Database Administrator

RESPONSIBILITIES

Migrating current Linux environment to AWS EC2/RDS.

Experience in migrating MSSQL Server from AWS to Azure SQL Managed Instance.

Experience in migrating oracle database to AWS Aurora PostgreSQL.

Experience with monitoring tool such as Cloud Watch.

Experience using DMS (Database Migration Service), migrated database from on-premise to AWS Cloud EC2 and RDS (Oracle and Aurora ProsgreSQL)

Experience using DMS (Database Migration Service) for ongoing data replication. (Homogeneous & Heterogeneous Environment)

Oracle Golden Gate Design, Implementation on homogeneous & heterogeneous environment.

Oracle GG (Golden Gate) operational support activity like Configuring Extract, Pump and Replication. Experienced in troubleshooting of GG errors.

Experience in PATCHING AND UPGRADE activities.

Baxter International Inc - Guadalajara - Mexico – April 2021 – March 2024

Sr. Consultant IT

RESPONSIBILITIES

Involved in designing and deploying multitude applications utilizing almost all AWS stack (EC2, RDS, SNS, S3, EBS, CloudFormation, Route53, DMS (Database Migration Service) focusing on high-availability, fault tolerance.

Migrated current Linux environment to AWS EC2/RDS.

Experience in migrating MSSQL Server from AWS to Azure SQL Managed Instance.

Experience in migrating oracle database to AWS Aurora PostgreSQL.

Experience with monitoring tool such as Cloud Watch.

Experience using DMS (Database Migration Service), migrated database from on-premise to AWS Cloud EC2 and RDS (Oracle and Aurora ProsgreSQL)

Experience using DMS (Database Migration Service) for ongoing data replication. (Homogeneous & Heterogeneous Environment)

Oracle Golden Gate Design, Implementation on homogeneous & heterogeneous environment.

Oracle GG (Golden Gate) operational support activity like Configuring Extract, Pump and Replication. Experienced in troubleshooting of GG errors.

Experience in PATCHING AND UPGRADE activities.

Responsible for installing GI & Database, upgrading and configuring the Oracle RAC and standalone environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Create & Managing Database Structure, Storage Allocation.

Used RMAN for backup and recovery jobs.

Setup and configuration of Data guard Oracle Physical Standby.

Understanding of Snowflake cloud technology.

Experience with Snowflake Multi - Cluster Warehouses.

Build the Logical and Physical data model for snowflake as per the changes required

Define roles, privileges required to access different database objects.

Define virtual warehouse sizing for Snowflake for different type of workloads.

Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system which include loading nested JSON formatted data into snowflake table.

Stefanini - Guadalajara - Mexico – Feb 2020 – March 2021

Consultant - III

RESPONSIBILITIES

Involved in designing and deploying multitude applications utilizing almost all AWS stack (EC2, RDS, SNS, S3, EBS, CloudFormation, Route53, DMS (Database Migration Service) focusing on high-availability, fault tolerance.

Migrated current Linux environment to AWS EC2/RDS.

Experience with monitoring tool such as Cloud Watch.

Experience using DMS (Database Migration Service), migrated database from on-premise to AWS Cloud EC2 and RDS (Oracle and Aurora ProsgreSQL)

Experience using DMS (Database Migration Service) for ongoing data replication. (Homogeneous & Heterogeneous Environment)

Oracle Golden Gate Design, Implementation on homogeneous & heterogeneous environment.

Oracle GG (Golden Gate) operational support activity like Configuring Extract, Replication and Pump & troubleshooting GG errors.

Experience in PATCHING AND UPGRADE activities.

Responsible for installing GI & Database, upgrading and configuring the Oracle RAC and standalone environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Create & Managing Database Structure, Storage Allocation.

Used RMAN for backup and recovery jobs.

Setup and configuration of Data guard Oracle Physical Standby.

Cognizant Technology Solutions- Chennai- Tamil Nadu-India – May 2019 – Feb 2020

Manager-Projects

RESPONSIBILITIES

Oracle Golden Gate Design, Implementation on homogeneous & heterogeneous environment like Oracle, MSSQL and Teradata, FFW (Flat File Writer & JMS Java Messaging Service).

Oracle GG (Golden Gate) operational support activity like Configuring Extract, Replication and Pump & troubleshooting GG errors.

Experience in PATCHING AND UPGRADE activities.

Responsible for installing GI & Database, upgrading and configuring the Oracle RAC and standalone environment by creating multiple databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Create & Managing Database Structure, Storage Allocation.

Used RMAN for backup and recovery jobs.

Setup and configuration of Data guard Oracle Physical Standby.

TATA Consultancy Services Ltd- Guadalajara - Mexico Sep 2010 - May 2019

Assistant Consultant

RESPONSIBILITIES

Golden Gate production operational end to end support, Configuration and implementation.

Creates and maintains all databases required for development, testing, and production usage.

Performs ongoing performance tuning of the database instances.

Controls migrations of programs, database changes, reference data changes through the development life cycle.

Implements and enforces security for all of the Oracle Databases.

Setting up new database environment for Rogers core applications such as V21, SSP, IVR, CASH, PSMS and Amdocs products like CRM, WOM, SOM, ASMS, ARM, Amdocs-OM.S

Applying Hot fixes to development and QA Environment for all Maestro databases using Amdocs HF and Genesis tool.

Database cloning and application schema refreshes using Data Pump, traditional export/import and RMAN backup tool.

Database environments build for Maestro databases using Amdocs Genesis tool.

CPU, PSU quarterly patch apply to oracle databases

Providing support for UNIX ADMIN for O/S patch, firmware upgrades, datacentre migration, hardware upgrade.

Monthly index reorganizing, table partitioning, data purging for V21 and PSMS application databases

Database application support for development team

Troubleshooting the DB instance performance issues and tuning DB instances

Defect tracking through iQMS tool.

Backup jobs maintenance on all the database servers and ensuring backups are properly scheduled using DB GUI Tool.

OEM Grid control implementation and maintenance for Rogers ITS applications.

Implementing and monitoring scripts for the entire DB servers.

HCL Technologies Ltd- Chennai- Tamil Nadu- India - Sep 2008 - Sep 2010.

Lead Engineer

RESPONSIBILITIES

Database Day-to-day maintenance activities.

DB Housekeeping activities.

Database performance monitoring and tuning.

SQL Query tuning, view tuning.

Managing tablespaces and data-files.

Managing schema objects like tables, Indexes, Views, materialized view tables, db links.

Installation of Database Software and Patches

Online Index rebuilding and table defragmentation.

Managing Partitioned tables and Indexes.

Restoration using flash back concept

Managing schemas and user profiles.

Installing and Handling DATAGUARD (Physical)

Database Cloning.

3i- InfoTech Ltd- Chennai- Tamil Nadu- India - June-2007 - Sep 2008.

Consultant

RESPONSIBILITIES

Database Monitoring

Fix and Training database refresh

Handling raw devices, free space deficit problems

Analysing the root cause for various alerts raised and providing solution within the SLA period.

Proactive Performance tuning using stats pack.

Interaction with different teams in Oriental

Writing shell scripts to automate routine activities

Preparing weekly and monthly reports.

Installing and Handling DATAGUARD (Physical Standby)

Database Cloning

Configuring RMAN backup’s

Contact this candidate