Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vignesh T

Oracle DBA
CHENNAI,Tamil Nadu

Summary

A goal-oriented IT professional with 9+ years of experience in Oracle Database Administration, looking for association with a progressive organization that gives scope to increase my knowledge and skill with new updates to utilize my extensive knowledge and experience in managing and maintaining. Strong focus on team collaboration to achieve project goals and adapt to evolving technical requirements. Reliable team player with commitment to high standards and delivering impactful results.

Database professional with extensive background in Oracle database management, offering blend of technical expertise and strategic insight. Known for collaborative approach and ability to drive results in dynamic environments. Reliable team player with knack for adapting to changing project requirements. Skilled in performance tuning, data recovery, and database security.

Overview

11
11
years of professional experience
7
7
years of post-secondary education
3
3
Languages

Work History

Oracle DBA

HCL Technologies. Ltd.
02.2021 - Current
  • Company Overview: Project: GlaxoSmithKline plc (GSK)
  • Creating users, allocation to appropriate table space, quotas with necessary system and object privileges and roles based on requirements
  • Changing archive location before data import activity starts at application end and change it back to original location after its completed
  • Creating new tablespaces, adding, or resizing datafiles in existing tablespace and resizing big file tablespaces as per the requirements.
  • Applied oracle recommended quarterly PSU/BP patch apply in 11g/12c/18c/19c databases
  • Having experience in 12c,18c and 19c database creation using Zero Touch Tool (GSK inbuilt)
  • Created the shell script and configured in crontab for housekeeping oracle mount points
  • Having experience in CA monitoring tools. Configured the monitoring setup in CA tool for newly created databases.
  • Enabling and disabling blackout in CA monitoring and OEM before and after the activity respectively
  • Performed both Enterprise Edition and Standard Edition oracle software installation of 12c,18c and 19c
  • Performed database cloning and database refresh using RMAN
  • Having experience in upgradation from 12c to 18c and 19c using auto upgradation Tool Zero
  • Resolved FRA archive issues when high data import from application end
  • Performed schema and database decommission in both UNIX and windows database servers
  • Performed oracle database upgradation from using manual method, DBUA and auto upgradation
  • Analyzed and resolved the archive gap issue between Primary and standby database synchronizations
  • Assisted in the migration of legacy systems onto modern platforms, ensuring smooth transitions without affecting business continuity or user experience.
  • Trained junior DBAs in best practices for Oracle database management, improving overall team performance.
  • Diagnosed and resolved critical database issues promptly, minimizing the impact on business operations.
  • Streamlined database operations for efficient use of resources, applying patches and upgrades when necessary.
  • Implemented disaster recovery plans to safeguard against unexpected events, minimizing potential losses.
  • Reduced downtime by proactively monitoring system health and identifying potential problems before they escalated.
  • Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
  • Enhanced data security by implementing backup and recovery strategies, ensuring minimal data loss.
  • Experience in creating Normal/emergency/standard change and presenting in CAB for approval process
  • Experience in updating global TNSNames.ora file using LDAP and performed TNS rollout using the Zero-Touch and Appsmith tools.
  • Having experience in Access management such as Cyberark, PAMS and EIS unix access management
  • Project: GlaxoSmithKline plc (GSK)

Oracle DBA

Flex Pvt. Ltd.
CHEN
05.2020 - 11.2020
  • Installation of oracle12c&19c Database on Linux and windows operating system(Using GUI).
  • Monitoring scheduled RMAN backup jobs and performing DRP testing of backups in test server.
  • Refreshed schema’s from production database to pre-prod.
  • Database links were created to access the data from remote databases.
  • Analyzing database performance by running AWR report.
  • Applying patches and performing upgradations.
  • Fail - over done in data guard due to Primary failure in testing environment.
  • Checking MRP process which applies the redo data into standby data base and handling data guard sync issues.
  • Processing the change request as per the client request.
  • Resolved archive-log gap in standby data base using RMAN incremental backup.
  • Configured and managed Data guard Physical Standby Data base for high availability and checking synchronization between primary database and physical standby database.

Oracle DBA

Wipro Technology Pvt. Ltd.
07.2019 - 04.2020
  • Company Overview: Client - KVB
  • Installation of oracle12c&11g Database on Linux and windows operating system(Using GUI).
  • Processing the change request as per the client request.
  • Monitoring scheduled RMAN backup jobs.
  • Refreshed schema’s from production database to pre-prod.
  • Database links were created to access the data from remote databases.
  • Analyzing database performance by running AWR report.
  • Applying patches and performing upgradations.
  • Switch- Over and Fail - over activities on quarterly basis to test database disaster recovery.
  • Configured Data guard physical standby database using RMAN active cloning in testing database.
  • Checking MRP process which applies the redo data into standby data base and handling data guard sync issues.
  • Resolved archive-log gap in standby data base using RMAN incremental backup.
  • Configured and managed Data guard Physical Standby Data base for high availability and checking synchronization between primary database and physical standby database.
  • Client - KVB

Oracle DBA

MG INFOMATICS PVT LTD
10.2016 - 03.2019
  • Company Overview: PROJECT II – (Image Freight &Logistics)
  • Installation of oracle10g&11g Database on Linux operating system(Using GUI).
  • Processing the request as per the client requirments.
  • Monitoring scheduled RMAN backup jobs.
  • Refreshed schema’s from production database to pre-prod.
  • Database links were created to access the data from remote databases.
  • Analyzing database performance by running AWR report.
  • Fail - over done in data guard due to Primary failure in testing environment.
  • Checking MRP process which applies the redo data into standby data base and handling data guard sync issues.
  • Resolved archive-log gap in standby data base using RMAN incremental backup.
  • Performed Oracle Data base performance-tuning services with EXPLAIN PLAN.
  • Configured and managed Data guard Physical Standby Data base for high availability and checking synchronization between primary database and physical standby database.
  • PROJECT II – (Image Freight &Logistics)

Oracle DBA

MG INFOMATICS PVT LTD
01.2014 - 09.2016
  • Company Overview: PROJECT I– (Wilken Wireless)
  • Monitoring and tracking the Mails on regular basis.
  • Performing overall Health check of databases and backup report.
  • Monitoring the database for Memory and I/O utilization and report if any abnormalities.
  • Monitoring the growth of Database, Table space and Disk level.
  • Creating Users/Schema with quota maintenance and roles and privileges.
  • Maintaining and adding the data files in the ASM disk/Local file system.
  • Performing ADHOC backups Using RMAN.
  • Backup on Tables, Table spaces, Schemas using Expdp/ Impdp and Data Pump.
  • PROJECT I– (Wilken Wireless)

Education

B.E. - EEE

SKR ENGINEERING COLLEGE
01.2009 - 01.2013

HSC -

ST. JOSEPSH MATRIC. HR. SEC. SCHOOL
CHENNAI
01.2007 - 01.2009

SSLC -

ST. JOSEPSH MATRIC. HR. SEC. SCHOOL
01.2006 - 01.2007

Skills

Oracle Database Administration (10g, 11g, 12c, 19c)

Oracle RAC

ASM

Data Guard

Oracle Enterprise Manager (OEM)

Backup and Recovery (RMAN, Rubrik)

Performance Tuning and Optimization

Database Security and Auditing

Unix/Linux/AIX/Solaris Administration

undefined

Timeline

Oracle DBA

HCL Technologies. Ltd.
02.2021 - Current

Oracle DBA

Flex Pvt. Ltd.
05.2020 - 11.2020

Oracle DBA

Wipro Technology Pvt. Ltd.
07.2019 - 04.2020

Oracle DBA

MG INFOMATICS PVT LTD
10.2016 - 03.2019

Oracle DBA

MG INFOMATICS PVT LTD
01.2014 - 09.2016

B.E. - EEE

SKR ENGINEERING COLLEGE
01.2009 - 01.2013

HSC -

ST. JOSEPSH MATRIC. HR. SEC. SCHOOL
01.2007 - 01.2009

SSLC -

ST. JOSEPSH MATRIC. HR. SEC. SCHOOL
01.2006 - 01.2007

Similar Profiles

CREATE PROFILE
Vignesh TOracle DBA