Ganesh N.

About Ganesh N.

Expert On-Prem and Cloud Database Administrator, Database migration specialist, Cloud Administrator, Database Architect, Automation expert having over 22 years of experience in Information Technology, and has worked on various platforms. •Expert skills in Database Capacity planning and handling more than 100+ TB of Databases•Expert skill in Oracle High availability features like RAC (Maintenance, Installation, and setup), Active Data Guard, RMAN, ASM, Streams, Physical Standby, Logical Standby, SQL Server, Always ON,Database Cloning•Expert skills in Implementing Replication and Advanced Replications Environments•Expert skills in the Installation of Oracle Software on Linux, Solaris, AIX, and HP-UX Servers•Expert skills in Performance Monitoring & tuning, Backup, and Recovery of Databases•Expert skills in Capacity Planning, and hardware Sizing of Database servers.•Extensive performance tuning experience, specializing in instance tuning.•Experience in designing and implementing Oracle databases, and migrations to the oracle, including systems architecture, database design, schema design, implementation, and tuning.•Expert Skills in managing database servers in 24/7 environments and ensuring that each server has 99% uptime. •Experience as a Team Leader for the Production DBA team ensuring all production tickets will be resolved on time as per SLA.•Experience in T-SQL, PL/SQL, UNIX, Ansible, TerraForm shell scripting•Worked extensively on Database production environments for Insurance, banking, finance, and telecom sectors•Experienced in Provisioning On-Premises and cloud resources Infrastructure as Code (IAC), Cloud Migration Strategies, Applications, and Database consolidations using automation scripts developed in Ansible and Terraform and deploying them using CI/CD PipelinesSpecialties: Oracle and SQL Server DBA, Oracle 10g, 11g,12c,18c RAC on Linux, Solaris, AIX, HP-UX Servers, Oracle Streams, Advanced replication, Backup and recovery, RMAN, ASM, Upgrade, Migration, Performance tuning expert, 12c New Multitenant Architecture, Project Manager, SQL Server 2012 to 2019, SQL Server Always ON, Replication, Mirroring, and Log ShippingCloud Databases: Azure SQL Server, Azure SQL Server Managed Instances, Azure SQL Server VM, Azure PostgreSQL, MongoDB Atlas, Amazon RDS -Oracle, Amazon DynamoDB, Amazon DocumentDB, Amazon Aurora, Amazon Redshift, OCIAzure SQL: Availability Sets, Availability Zones, and Azure Site Recovery Amazon RDS: Multi-AZ (Availability Zones)Backup & Replication : RMAN,Delphix,Qlik.Rubrik,Netbackup

Experience

1. Cont

   Arch Capital Group Ltd.

   Dec 2012 — Present

   Lead Database Platform Migration projects from AIX – P series Servers to RHEL V-BLOCK 500 Series Servers using XTTS and Oracle Golden Gate• Lead Heterogeneous database Oracle to SQL server, SQL Server to PostgreSQL, SQL Server On-Premises to Azure SQL Server Managed Instances, Oracle On-Premises to Amazon RDS for Oracle, SQL Server, Oracle to Amazon DynamoDB, Oracle to PostgreSQL (Amazon Aurora)• Maintaining Multi TERA BYTE 4-Node Production (OLTP) RAC Databases with 2 Node Active-Data Guard. • Defining and implementing Database Backup and recovery strategies for Oracle and SQL server databases using Oracle RMAN and Veritas NetBackup.• Database Performance tuning and monitoring, Troubleshooting, and Issue Resolution.• Creating and recommending database indexes and SQL profiles to improve the performance of slow-running queries using OEM Grid Control.• Golden Gate Installation, Configuration, Administration, and Troubleshooting the GG Processes.• Oracle, SQL Server databases, Oracle OEM Installation, Upgradations, Configuration, Setup, and Patch Installations.• Setting up Replication environments in Oracle using Oracle Golden Gate, Database Cloning, Active Data Guard, Streams, and Materialized Views.• Applying quarterly Oracle Grid Infrastructure (RAC) and RDBMS PSU and CPU Patches• Oracle RAC Database Administration, Active-Data Guard, and Performance Tuning.• Automating the Database related tasks using DevOps Automation Task using Ansible, Power Shell, Jenkins GIT, Docker, and other Tools.

Education

• Bharathidasan University

  MCA, Computer Applications

  2000 — 2003

• Andhra University

  B.Com, Commerce

  1997 — 2000