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