SUMMARY:

• Oracle Database Administrator with 10 years of experience in the Database Installation and Production System Support in Oracle 9i/10/11g including RAC, GRID INFRASTRUCTURE, ASM, Data - Guard environment, OEM, GRID CONTROL, RMAN, SQL, PL/SQL, Query tuning, Backup & recovery.
• Upgrade, patching (PSU/CPU/One-off/bug patches in standalone and Cluster/RAC/GI environment).
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, troubleshooting and Shell scripting.
• Maintain database documentation and update as needed.
• Proficient with physical & logical standby database (Data Guard).
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, Tivoli, VERITAS Net Backup.
• Focused in managing & resolving issues in alignment with the customer SLA.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Awarded by Confidential for Project Delivery Excellence.
• 24x7 on call rotation schedule.
• Experience in troubleshooting and resolving database problems

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, and Oracle 7.x

Oracle Products: OEM (Oracle Enterprise Manager), GRID CONTROL, Data Guard, RAC, GRID Infrastructure, RMAN, ASM, SQL Loader, Data

pump.:

Languages: SQL, PL/SQL, and Shell scripts

Operating System: AIX, HP-UX, SUN Solaris, LINUX, Windows 2000/NT/XP, UNIX, Red Hat Linux, MS DOS.

Other Tools: TOAD, VERITAS, Net Backup, Tivoli Storage Manager.

PROFESSIONAL EXPERIENCE:

Confidential, DALLAS, TX

ORACLE ADVANCED DBA

• Performed Oracle RAC/DB installations, configurations, version upgrades and PSU/CPU patches apply.
• Performed Cloning of Oracle RAC, RDBMS & DATABASE (ACTIVE & BACKUP).
• Worked on Oracle 10g & 11g Standalone, Data Guard, and clustered environment.
• Installation, configuration and maintenance of ASM on Oracle 10g/11g.
• Upgrade and Patch Oracle databases to fix bugs and other issues.
• Performed Oracle installation, data guard setup, backup set & monitoring script and responsible for performing subsequent data refreshes.
• Analyze data and provide performance recommendations for improving response times for dot.com during peak times.
• Extensive usage of Oracle 11g GRID CONTROL for database, DATA GUARD switchover/failover, application tuning including implementation of SQL profiles.
• Performed Oracle database upgrades and patching (PSU/CPU).
• Performed data refreshes using RMAN duplication and Export/Import.
• Wrote shell scripts for monitoring, backup, archive sweep and data refreshes.
• Performed capacity planning for new implementation of Oracle OBIEE.
• Created physical standby databases for new implementation.

Confidential, DUBUQUE, IA

Oracle DBA

• Configure and manage standby database & FSFO using Data guard.
• Provide expert level database administration, enterprise infrastructure and standard oracle server administration (24x7) as Operational/Production.
• Daily database administration tasks including troubleshooting Data-Guard and RAC issues.
• Capacity planning, storage allocation and space monitoring using UNIX Shell Scripts.
• Monitor Incident ticket queue and troubleshoot and resolve database incident within SLA.
• Perform Root Cause Analysis on Oracle Database issues.
• Implemented DRP (Disaster recovery plan) for critical databases
• Utilize appropriate Change Management process and tools
• Perform automated startup and shutdown of the in-scope database.
• Consolidate/migrate several Oracle databases to single Linux server.
• Upgrade and Patch Oracle databases to fix bugs and other issues.
• Monitored daily backups using RMAN and Export/Import.
• Establish refresh jobs for test databases using Export-Import and RMAN DUPLICATE option.
• Worked on rotation as a 24x7 on-call DBA and handled many critical production issues.

Confidential, CHICAGO, IL

Oracle DBA

• Responsible for migration, up gradation from oracle 8i to 9i on Windows 2000/Solaris
• Designed and Installed the Oracle 8i, 9i database on Solaris cluster.
• Responsible for pre-install analysis, activities, and installation of 8i, 9i software on server and clients and post-install testing and analysis.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Created Locally Managed tablespace for better space management and less fragmentation of data.
• Installed and configured Oracle Data guard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• Installed & Configured VERITAS Net Backup for Oracle on Unix.
• Monitoring and optimizing the performance of database.
• User creation and implemented Security administration by creating roles, views andgranting the necessary system and object privileges for users.
• Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning of the database.
• Allocating system storage and planning future storage requirements for the database system.