Kumaresan M

Software Engineer

Kolar, Karnataka, India9 yrs 6 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Expert in Oracle Database Administration and Performance Tuning.
Proven experience in Disaster Recovery Infrastructure Design.
Skilled in Golden Gate replication and upgrades.

Stackforce AI infers this person is a Database Management Specialist with extensive experience in Oracle technologies.

Contact

Skills

Core Skills

Oracle Database AdministrationPerformance Tuning

Other Skills

Disaster Recovery Infrastructure DesigningRMANDatabase Upgrade and patchingOracle RACDataguardGolden GateTransportable TablespaceRACPatchingDatabase CloningOracle Software InstallationDatabase ManagementRAC ConfigurationPatch ManagementOracle ASM

Experience

9 yrs 6 mos

Total Experience

3 yrs 2 mos

Average Tenure

4 yrs 6 mos

Current Experience

Walmart

Oracle Database Administrator

Nov 2021 – Present · 4 yrs 6 mos

Oracle Database Administration, production support, Disaster Recover Infrastructure Designing, RMAN, Database Upgrade and patching, Troubleshooting performance issues.
Managing Oracle database administration functions involving Installation and configuration of Oracle server and client software, Creating database designs as per project requirement and infrastructure availability.
Creation and maintenance of standby databases (logical/physical). Implementing Dataguard broker using DGMGRL with fast start failover setup.
Implementing Database Backup strategies using RMAN and performing Database recovery.
Upgradation of Databases (9i to 11g, 9i to 10g, 10g to 11g) and cross-platform migration of oracle databases using Transportable Tablespace.
Application of Oracle security (CPU and PSU) patches, bug fix patches.
Supporting Oracle RAC installation and maintenance.
Performance Tuning tuning using STATSPACK, EXPLAIN PLANS, SQL TRACE, TKPROF, AWR, ASH and ADDM reports. Excellent troubleshooting skill at database level.
Setup golden gate replication for BI reporting.
Fixing Golden gate issues.
Golden gate upgradation from 11g to 12c.
DB Switchover involving Golden gate.
DB migration from standalone to RAC along with Golden gate.
Performance tuning of Golden gate replicat processes.

Oracle Database AdministrationDisaster Recovery Infrastructure DesigningRMANDatabase Upgrade and patchingPerformance TuningOracle RAC+2

Ipsoft

Oracle Database Administrator

Feb 2011 – Nov 2013 · 2 yrs 9 mos · Bangalore

Support almost all kind of oracle environments with 2-5 Node RAC, standalone and RAC standby’s.
 Databases from oracle 8i to oracle 11g on Linux/Solaris/HPUX.
 Performed RAC, DG and 11gR2 RAC (Grid Infra) installations/configuration.
 Configured Active Data Guard in 11g RAC/standalone
 Worked on several Outages to quickly bring back the prod environment online with minimum downtime.
 Performed upgradation and patching activities, applied base patches as well as PSU’s.
 Have configured 11gR2 grid infra with RAC/standalone and have installed both 11g/10g RDBMS over it.
 Have configured ASM using both ASMLIB disk paths as well as direct LUN’s.
 Knowledge on Golden Gate and its implementation.
 Have fixed table/index fragmentation issue.
 Performance tuning of the database..
 Database cloning ( RMAN duplicate/ Manual )
 Maintaining standby databases and applying incremental backup’s when archive logs are missing at the primary site.
 Performed switch over of databases during DR drill.
 Managing Cold and Hot Backups, database export and imports & perform database maintenance.
 Other regular Day to Day DBA activities like space management, handling user requests, acting on monitoring alerts, deployments and weekend maintenance activities.
 Coordinate with onsite DBA’s, attend client meetings and transitions.

Oracle Database AdministrationRACDataguardPatchingPerformance TuningDatabase Cloning

Saic

Junior Oracle Database Administrator

Nov 2006 – Feb 2009 · 2 yrs 3 mos · Bangalore

 Installation of Oracle software.
 Handling user raised calls.
 Creating tablespaces and managing it.
 Resolving Ora-7445/Ora-600 error.
 Applying CPU and Patchset.
 Recovery of dropped objects and datafiles.
 Sarbanes Oxley remediation.
 Space management of database.
 Trouble block corruptions.
 Rebuilding standby databases.
 Taking export and import. as per the client requirement.
 Configuring RAC services as per the request.
 Installing and configuring Database and ASM.
 Flashing back table and database in case of any logical corruptions encountered at the database level.
 Preparing space exhaustion report.
 Database upgradation.
 Configured DR with dataguard broker.