Manish Patel

Phone: 847-***-****

Email: acfxbz@r.postjobfree.com

Dedicated professional with extensive experience supporting production and development environments

as an Oracle Database Administrator. Effective team player with excellent communication, analysis and

problem solving skills. Outstanding project and team leader; able to coordinate and direct all phases of

project-based efforts while managing, motivating, and guiding teams. Exceptional corporate citizen;

actively helping the department and the company to go from good to great.

OBJECTIVE

To obtain a challenging position that will enable me to utilize, develop and enhance my skills.

ABT Electronics: 2007-2014

SUMMARY OF QUALIFICATIONS

• 7 years of experience managing and supporting 24x7 production and development

environments as an Oracle Database Administrator

• Experience in Oracle software installation, configuration and patch application

• Experience in upgrading Oracle software to higher versions > 10g -> 11g

• Good knowledge of Oracle Architecture

• Experience with database tools like OEM, TOAD, SQL*Plus, Explain Plan, TKPROF,

STATSPACK, ADDM, SQL*Loader, Export/Import, Data Pump

• Implementation of 10g OEM Control for database monitoring and alert notification

• Experience with Data Guard setup and configuration with RAC

• Experience with database backup, cloning and schema refresh

• Expertize in database Migration and Consolidation

• Remote database connectivity management using tnsnames, OID LDAP and Names Server

• Good understanding of UNIX Kernel parameters

• Good working knowledge of VI editor

• Generate and analyze Oracle STATSPACK Reports

• Ability to work on multiple projects and with multiple development teams simultaneously

• Automation of day-to-day DBA tasks using SHELL scripts and CRON jobs

• Expertise in troubleshooting the problems related to databases and applications

• Manage onsite and offshore co-ordination and communication

• Good working knowledge of RMAN

TECHNICAL SKILLS

Platform/OS: Sun Solaris, HP-UX 11.0, LINUX, Tru-64, Windows

Databases/RDBMS: Oracle 11g, 10g,

Tools/Utilities: TOAD, 10g OEM Console, SQL*Plus, Explain Plan, TKPROF, STATSPACK, ADDM,

RMAN,SQL* Loader, Export/Import, Data Pump

Programming/Languages: UNIX Shell Programming

Installation

Install Oracle 11g, 10g, and upgrading databases to higher version

Install and configure Oracle 10g DataGuard with RAC, OEM

Maintenance/Support

Provided 24X7 on-call support to maintain all databases in production and development

environments

Database maintenance, upgrades, and patches releases

Manage database users and security

Implemented ORACLE TDE

Support job processing, scheduling, real-time management, troubleshooting and

storage configuration

Capacity Management for existing databases

Day to day database administration tasks

Good Knowlege of Oracle Gateways for connectivity to DB2 and SQL server

Handled client escalations related to database activities

Cloning Database from production to development

Physical and Logical backups using RMAN

Standby database setup and maintenance

Utilized Oracle Metalink for technical support

Write extensive SQL/PL-SQL code for business needs

Implement Triggers,sequences,functions.

Monitoring

Proactive database monitoring using custom built sql/PL-SQL and unix scripts

Fine-Tuning

Identify, trace and tune SQL queries for better performance

Generate AWR, ADDM and ASH reports

Database and application developer’s problems troubleshooting

Application and SQL query tuning to help development team

Helped application development team in tuning and testing queries

Parallel query execution

Proper setting of Kernel parameters

Tablespace fragmentation checks and reorganization of tables

Communication/Documentation

Design, Document, implement Database Maintenance Plan

Document processes and procedures for reuse

Improved standards and guidelines for database changes and application development

Adhered to predefined deliverables and SLA’s

Managed onsite and offshore co-ordination and communication

BCP

Design, Developed, Document, Implement and Monitor Backup and Recovery Operations (Using

RMAN)

Responsible for Disaster Recovery plan

EDUCATION

Bachelor in Economics Loyola College, Chennai, India.

Oracle Certification: OCA and OCP

Visa Status: US Citizen

Contact this candidate