Manager Oracle
Resume:
Name: Maheswari Senthilvelu
Oracle DBA
Personal Data:
Name : Maheswari S
Date of Birth : 26/05/1989
Nationality : Indian
Languages : English, Tamil
Email & Mob :***********@*****.** / +974-******** & +91-957*******
Language
Reading
Speaking
Writing
English
Good
Good
Good
Tamil
Good
Good
Good
ACEDEMIC QUALIFICATION
Bachelor of Science(B.Sc.)
Good Understanding of:
Database Creation, Software Installation & Configuration, Performance Optimization, SQL Tuning, Backup & Recovery, Administration, Security & Auditing, Data Guard, Data Dictionary Views & V$ Views, Indexes, Stored Procedures, Roles, Profiles, Job Scheduling, Flashback technologies, ASM-Automatic Storage Management, Server Alerts & Advisors, OMF, AWR, RAC-Real Application Clusters, Shell Scripts basics and Golden Gate, TDE,.
Tools & Utilities:
RMAN, Export, Import, SQL loader, DBCA, DBUA, NETCA, DATAPUMP, ASMCA, Enterprise Manager, ADDM, Tkprof, Toad, SQL Developer, Golden Gate, TDE, Ticketing Tool (JIRA), Monitoring Tool (NAGIOS), etc.
EXECUTIVE SUMMARY
A dynamic professional with qualitative experience of 5+ years as Oracle DBA. Experience in RAC Administration, Data Guard, ASM Administration & ASM Migration, Database Backup and Recovery RMAN in 10g,11g,12c, Patches, Migration, Upgradation, Performance Tuning, Shell Scripting, Golden Gate, TDE, Managing Ticketing Tools.
Professional Experience Summary:
Worked in Production, Development and Testing environment on Linux, Solaris & Windows platforms.
Good working knowledge on 10g, 11g& 12c RAC Installation and Database migration.
upgrade from lower version.
Good working Experience on RAC, Dataguard, RMAN & Logical Backup.
Good working Experience on ASM administration and ASM cloning.
Good working Experience on database Full Patching.
Good working Experience on Upgrade of 10g,11g,12c RAC.
Worked in 24*7 production environment and provided on-call and day-to-day support.
Good working Experience on Installation of RAC and Managing RAC Environment efficiently.
Good working Experience on Implementing and maintaining database security (create and maintain users, roles and assign privileges)
Good working Experience on Database tuning& performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
Good working Experience on Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Good working Experience on Monitored the production Oracle alert logs for database errors.
Good working Experience on Monitored system resource availability and responded to system memory and data issues.
Good working Experience on Implemented and maintained Oracle 10g,11g,12c Data Guard/standby databases for fail-over purposes.
Good working Experience with ‘graceful’ switchover and switchback between primary and standby databases.
Good working Experience of Installation, Patching, Migrations, Cloning and Up-gradations.
A good team player, problem solver, and quick learner with analytical Skills.
Interaction with Application & Development Teams to solve issues that is very critical.
Configure transparent data encryption (TDE)
Good working Experience of Configure and Monitoring Golden Gate
Good working Experience on Ticketing Tools.
SKILL SET
Technical
Operating Systems : WINDOWS Server 2005,2008,
Solaris and LINUX.
Software Productivity : ORACLE 10g, 11g, 12c
Office Productivity : Microsoft Office Suite 97/2000/2005,
MS Access, Front Page, Out Look etc.
CAREER PROFILE & HIGHLIGHTS
Wirecard India Pvt Ltd – Chennai Aug’18 – Apr’19
Oracle DBA
Clients
Wireca rd – Munich, Germany. Project Name: WDP
I was on Deputation in Aug -2018 to Apr-2019 supporting their mission critical databases.
Major Oracle Technologies Which is being used
Oracle Real Application Clusters
Oracle Restart for standalone Servers
Oracle ASM storage management configuration
Oracle Golden Gate replication
Oracle physical standby
Oracle RMAN Backup Configuration
Enterprise Manager Cloud Control for centralized Monitoring.
TDE Encryption
Managing Transaware Platform Databases in Production, Test & TEST. Ensure availability of databases on all environments 24/7 with SLA Target of 99.99.
Install and configure both RAC and single instance / standalone environments. Configure RMAN backups and Backups to tape.
Harden Database Environment based on PCI DSS audit requirements, Configure database Audit and Oracle database Encryption.
Perform research & Analysis and implement solution with latest database technologies for DBA Task Automation and Environment optimization.
Design and Build High availability and Disaster recovery solutions using Oracle Golden Gate and Golden Gate management.
Perform analysis on data to day environment issues like blockings and transactions time out using AWR reports and oracle enterprise management console and solve problems upfront.
Perform capacity planning weekly and monthly allocate proper space for LUNS upfront.
Support Production team for deploying new database constructs like packages and work on top of Jira problem tickets on various environment. Jira is the ticketing solution which Wirecard is using for both change request tracking, problems and incidents.
Elite IT Services India Pvt Ltd – Gurgaon Jan’17 – Aug’18
Oracle DBA
Clients
Bsnl Office, Trichy – Tamilnadu. Project ID:1225 Project Name: BSNL SZ DD
I was on Deputation in Jan -2017 to Aug -2018 supporting their mission critical databases Onsite.
Installation of Oracle 9i, 10G,11G,12C on Solaris & Linux platform.
Create and configure the database on 9i, 10G, 11G, 12C.
Dataware house and application based environment.
Creation of Table, View, Index, Constraints, Partition table, Partition Index
Make monthly report for Perform DB Lvel Stats gathering, %Growth of DB size, Concurrent Sessions, exp user_objects, Triggers, Tables, exp v$parameter name and values, Buffer cache hit ratio, librarycache Pin hits, Dictionary cache hit ratio, %Growth of Tablespace size.
Monthly update table rows.
Monitored Loading data from mediation and If found error take immediate action.
Tested every changes in Application level.
General database health check.
Check Alert Log errors and make necessary actions to rectify them.
Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Monitored the production Oracle alert logs for database errors.
Monitored system resource availability and responded to system memory and data issues.
Implementing and maintaining database security (create and maintain users, roles and assign privileges) and schema objects.
Using SQL Loader, Statspack, AWR, TKProf, NID, DBVerify, Toad.
Using Tkprof for Diagnosing SQL query performances.
Analysing the SQL Query using Explain plan.
Performing Backup and Recovery Using RMAN
Taking logical backup of Exp / Imp & Expdp / Impdp.
Performing Hot Backups and Cold Backups.
Schema Refresh using Export & Import
Database Cloning using Rman and User managed Backup.
Migration and Patches Installation.
Managing Shell Scripts.
Configure transparent data encryption (TDE)
Golden Gate installation, Configuration, managing & monitoring
IT System Administrator Solutions - ( Chennai) Aug’13- Dec’16
Oracle DBA
I was on Deputation in Aug -2013 to Dec -2017 supporting their mission critical databases.
Installation of Oracle 10G,11G& 12C on Linux & Windows platform.
Create and configure the database on 10G, 11G & 12C.
General database health check.
Check Alert Log errors and make necessary actions to rectify them.
Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Monitored the production Oracle alert logs for database errors.
Monitored system resource availability and responded to system memory and data issues.
Implementing and maintaining database security (create and maintain users, roles and assign privileges) and schema objects.
Using SQL Loader, Statspack, AWR, TKProf, NID, DBVerify.
Using Tkprof for Diagnosing SQL query performances.
Analysing the SQL Query using Explain plan.
Checking the Datafiles consistency using DBVerify Utility.
Performing Backup and Recovery Using RMAN
Taking logical backup of Exp / Imp & Expdp / Impdp.
Performing Hot Backups and Cold Backups.
Schema Refresh using Export & Import
Database Cloning using Rman and User managed Backup.
Migration and Patches Installation.
Creating Shell Scripting.
Configuration & Maintenance of Dataguard.
Maintained standby databases, in both local and remote locations, for fail-over purposes.
Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
Experience with ‘graceful’ switchover and switchback between primary and standby databases.
Installation of RAC and Managing RAC Environment efficiently on 10G & 11G.
Administration in Real Application Cluster.
Administration in Automatic Storage Management.
Configuration, managing & monitoring 12c Enterprise Manager Cloud Control.
Contact this candidate