Engineer Management
Resume:
Swetha Voora
******.*****@*****.***
Summary
Over 2+ years of industry experience as ORACLE DBA worked extensively in production and development
environments .
A good team player with excellent communication and interpersonal skills
Professionally prospect to work in line with clients and winning clients confidence.
Adaptable to work in any kind of environment and to take up challenges.
ACADEMIC QUALIFICATIONS:
Bachelor of Technology (ECE) - Jawaharlal Nehru Technological University-Hyderabad
Extensive knowledge on Oracle Architecture.
Hands on experience on Oracle Binaries installation and database creations.
Familiar with management of table spaces and users with respect to roles.
Experience in taking logical backups using exp, imp and expdp, impdp utilities.
Experience on Hot backup, cold backup and backups using RMAN utility.
Experience in working with ASM.
Participated in database up-gradations, Cloning.
Good Exposure of SRVTL and CRSCTL command utilities
Monitoring the performance and analyzing using AWR, ADDM reports and Execution plans.
Good Knowledge on Oracle 12c New features.
Good knowledge on Linux and shell scripting.
Tech Mahindra LTD,Hyderabad,India Duration: Feb 2012 – Aug 2014
Client:Bio-Rad Laboratories
Role: Systems Engineer
Responsibilities:
24/7 Production support for critical and highly visible databases. Worked on database Monitoring, Database backup using expdp and RMAN, Database refreshes and restorations
Implemented database refresh/Schema refreshes using full EXPORT/IMPORT.
Managing Daily Backups of Production database.
Worked on Standby databases
Worked on OEM grid 10g,11g
Worked on oracle database patching
Very good technical skills in RMAN, Performed database recovery and restorations as per client requirements
Worked on object management in database involving tables rebuild and index creations to improve performance.
Worked with oracle support for ORA-600 errors and ORA-4031 errors for memory related issues
Worked on user management which involves user creations and granting appropriate roles to users, Tablespace creations and datafile addition and undo retention issues and redolog resizing to avoid frequent checkpoint issues
Performed database clones using expdp and RMAN
Gathering stats on tables on a peridocal basis to improve performance and Generating AWR Reports to resolve user performance issues and enabling trace for a particular session for debugging
Enabling audit at database level to avoid unprivileged access to database and to ensure security
Client:NISSAN NORTH AMERICA
Role: Systems Engineer
Responsibilities:
Working in 24x7 production environment and provided on-call and day-to-day support.
Resolving the tickets and working on OSS tasks.
Expertise in database up-gradations
Worked on migration of oracle databases from version 8i/9i/10g to 11g from windows to Linux platform.
Worked on configuring the ASM instances and setting up databases on ASM and non-ASM environments.
Performed database cloning and refresh on to test environment.
Applying security patches like CPU and PSU.
Taking Logical backups using Data Pump, IMPORT and EXPORT utilities.
Implementing and maintaining database security (create and maintain users, roles and assign privileges).
Creation of oracle objects as per application team's request.
Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
Understanding the execution plans of top sql statements by using execution plan.
Generating and analyzing AWR report for database performance monitoring.
Worked on Remedy Incident Management tool and Service now Tool for ticket management.
ACHIEVEMENTS.
Received best supporting team of the year award from NISSAN client consecutively FY 11-12 & FY 12-13.
Received several appreciations from clients and application teams for successful delivery.
Contact this candidate