SUMMARY:

• Over 6 plus years of experience as Oracle DBA of the following

TECHNICAL SKILLS:

• 9i/10g/11g R2
• RAC,
• ASM,
• Data Guard,
• Grid Control,
• Oracle GoldenGate
• RMAN
• Disaster Recovery
• Database Installation
• Server Builds
• Migration
• Upgrade
• SQL Server
• Export / Import
• Materialize View Servers
• SQL tuning
• Deployments
• Working with Developers on best practices
• Working with Storage Admins
• Working with Project Managers
• Working with Team Members
• Working with Oracle Team on ongoing issues.
• Instance Tuning
• Worked on Performance Tuning of application.
• STATSPACK, SQL Loader, ASH, AWR, ADDM, SQL Advisor
• SQL
• Hot/Cold User Managed/RMAN Backups
• Comfortable with both GUI and CLI
• Installed RHEL and many flavors of Linux like CentOS, Fedora and OpenSuse.
• 24/7 On - call
• Very comfortable with TOAD.
• UNIX shell scripting.
• Database Patching
• OEM

PROFESSIONAL EXPERIENCE:

Confidential, Solon, OH

Oracle DBA

Role & Responsibilities:

• 24x7 Production Database administration
• Installed, configured and managed 11g R2 RAC databases
• Established Disaster Recovery for 11g R2 Clustered database using Oracle Data Guard.
• Upgrade databases from 9i, 10g to 11g R2
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Create and manage Enterprise Manager jobs, alerts and notifications
• Analyzed and wrote various Stored procedures, Functions, Triggers to be created at the backend database to cater for the entire application
• Created and managed ASM instance and ASM disk groups
• Installing ASM environment and migrating database from NON-ASM to ASM
• Configured Oracle networking for 11g RAC
• Worked on several Shell scripts to maintain the database activities
• Configured the Flash Recovery Area
• Configured the RMAN with CommVault for backup and recovery
• Created shell and Perl scripts for automated tasks
• Monitor performance through Grid control and executes performance tuning, in particular, balancing application needs on shared platforms.
• Created a backup strategy, transaction log strategy & management, disaster recovery planning using Oracle's Data Guard
• Used Transportable tablespaces (TTS) for moving large volumes of data between Oracle databases.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Created and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.
• Build Grid control for Monitoring 40+ database.
• Provided technical troubleshooting and give consultation to development teams.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Implemented basic replication through Materialized Views.
• Involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Initiated cronjobs to review alert logs and dump files to check for any ORA- errors.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning. REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of STANDBY database using DATAGUARD.
• Conducting sizing & capacity planning for Oracle databases.
• Applied High priority, security patches downloaded from Meta link
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLA
• Performed block recovery using RMAN. Performed backup validations using RMAN.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: PL/SQL, SQL, SQL*Plus, Oracle 8i,9i, 10g, 11g; RHEL, AIX, Windows NT/2000, HP UX,TOAD, Grid Control, GoldenGate, OEM, SQL Developer

Oracle DBA

Role & Responsibilities:

• 24x7 Production Database Administration support
• Installed, configured and managed Oracle 10g RAC
• Configured Oracle networking for RAC
• Installation and creation of 9i and 10g databases for Testing, Development and Production.
• REFRESH/CLONING of Database and applications for development, testing
• Installation and Maintenance of STANDBY database using DATAGUARD.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Experience in troubleshooting the ORACLE streams.
• Configured RMAN backup for 10g RAC database
• Monitoring 10g RAC performance
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for the Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g, 10g to 11g using Database
• Configuring and using the Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Setting up Oracle Standby Data Guard.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes.
• Provided System support for both development and 24*7 production environments.
• All the daily database administration tasks including backup and recovery thru RMAN,
• Import/Export, grants and roles etc.
• Monitor production and non-production 40 database thru Grid Control.
• Optimized queries and generated graphical SQL results from Grid Control. Starting and shutting down and configured agents for various different maintenance tasks
• Installing, Monitoring, Upgrading Oracle 9i/8i/8.0
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production databases.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Perform Backup and Recovery thru RMAN.
• Full fill developers request to refresh schema's on a daily basis.
• Resolved db performance issues.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.

Environment: Oracle 10g RAC/9i, SQL, RHEL 4, AIX 5.2, Shell scripting, SQL Server 2000/2005