SUMMARY

• Over 20 years of IT experience with 7 years of experience as Oracle Production/ Development/ Data Center Database Administrator handling different versions of Oracle from 9.x to 11g R2 on various platforms.
• 24*7 production support and on call rotation.
• An accomplished Database Architect with demonstrated success designing and implementing database solutions that improve business functionality. Possess a diversified technical background with Enterprise System Solution. Proven ability to implement technologies that decrease costs, increase performance and positively affect the bottom line.
• Expert in Backup and Recovery, Performance Tuning, Data Guard, Real Application clusters (RAC), Data Architecting, Database Design, Capacity Planning, Replication, Partitioning, Migration and Connectivity to foreign databases like MySQL and SQL Server using transparent gateways and other aspects of database administration.
• Proficient in NT and all flavors of UNIX.
• Proficient in Oracle RDBMS - including SQL, PL/SQL and all areas of database Administration.
• Performed backups, recoveries, installations, database performance tuning, tuning applications, database monitoring and operating system configurations.
• Proven experience in upgrading and migrating mission critical RAC and non-RAC databases both manually and using DBUA
• Extensively worked on RAC implementations. Planed SAN storage layouts, tuned kennel parameters. Installed CRS and DB software, created RAC databases in ASM storages on RedHat Linux servers for Oracle Portal database
• Tested RAC failover (node, interconnect, etc), adding and removing nodes from the cluster.
• Managed cluster resources, modified resource settings for HA solutions.
• Maintained RAC configuration including but not limited to vip management, relocated services, add/delete/modify objects ec.
• Experience in data (hot and cold) backup and recovery procedures.
• Experience in schema management, tablespace, datafile and extent management, as well as user and privilege management.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges.
• Comfortable with both command-line and GUI interface.
• Possess strong UNIX skills; intermediate administration skills.
• Possess excellent written and oral communication skills.
• Very strong Data Guard skills. Configured disaster recovery site with physical standby database for high availability using Oracle
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import).
• Manage Backup and Recovery Program for all Oracle Databases. Install, implement and configure RMAN.
• Experience with installing, patching and maintaining Oracle Grid Control.
• Experience with Tuning Tools like Oracle Enterprise Managers (OEMs), SQL analyzer, top session, top SQL, Performance Manager, etc., Statspack, TOAD. For SQL tuning using Explain plan, TKPROF, SQL TRACE, 10046 event, Optimizer modes, using Optimizer hints, Gathering statistics, using statspack, AWR, ADDM ASH reports etc.
• Performance Tuning of test and production database, monitoring system. Tuning and diagnosing of database performance by query Optimization and trace facility Monitoring users, free spaces, table spaces and indexes.
• Installed and configured 10g RAC on LINUX platform using ASM disks for storage.
• Written complex queries and stored procedures using sql *plus and monitored databases using TOAD.
• Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.
• Performed data loads using SQL*Loader, Export, Import for backing certain tables.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, OOPS, JAVA, Visual Basics, PeopleTools

Script and Markup Languages: Unix bash shell programming, HTML, Windows Batch filesInternet Web Servers Apache, Java Web Server (1.1.3,2.0)Oracle Web/Application Server (3.0,4.0,9iAS)Familiar with Weblogic and Websphere

OS & Administration: RHEL, Sun Solaris, AIX, HPUX, Windows, Mainframe

Database: Oracle 8x, 8i, 9i,10g, 11gR1/R2

PROFESSIONAL EXPERIENCE

Confidential, Bolingbrook, IL

Production DBA Support Engineer

Responsibilities:

• Installing, Monitoring, Upgrading Oracle 9i to 10gR2 to 11gR1/R2
• Develop RMAN scripts for backup and recovery of databases.
• Work in Oracle 10G and setting up 2 node RAC on LINUX platform for the development environment.
• Write monitoring/health check scripts to alert the team of database uptime/downtime status and sizing issues, whichensured availability 99.99% of the time.
• Provide development and production support, including on call requirements.
• Excellent communication skills and the ability to work independently or in a team environment.
• Design, document, implement and maintain all disaster recovery procedures which result in no data loss.
• Perform daily operational duties/security for all users of the databases.
• Resolve database performance issues, database capacity issues and other distributed data issues (OLTP).
• Ability to work in a stressful environment while handling demanding internal and external clients.
• 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.

Environment: Oracle 8i/9i, Sun E450/4500, Oracle Enterprise Manager, Solaris, HP UNIX, PL/SQL, TOAD and SQL *Plus.

Confidential, IL

Oracle DBA

Responsibilities:

• Created 3 production physical standby databases and 9 non-production physical standby databases.
• Successfully configured multiple standby databases for a production database. (standby from standby)
• Worked with Real Application Cluster (RAC) databases.
• Installed, created and configured 8i, 9i and 10g databases and Clients.
• Install and configure Oracle software.
• Refresh schema level and full level production to non-production databases.
• Designed the database schema and create any necessary database objects.
• Ensured database security is implemented to safeguard the data.
• Work closely with developers and system administrators to ensure all database needs are being met.
• Applied patches or upgrades to the database as needed.
• Used SRVCTL utility for managing multiple instances and nodes.
• Responsible for having multiple OCFS locations in RAC environment.
• Managed and multiplex Voting Disk and OCR file for maximum RAC availability.
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Perform Backup and Recovery thru RMAN.
• Written RMAN scripts for purging out applied logs at standby databases.
• Performance Tuning of database, SQL tuning for Application
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan
• Physical and Logical database design.
• Database sizing, Capacity Planning.
• Mapping of old data fields to new model data fields for data migration
• Estimate System/Database performance.
• Worked very closely with development team
• Application Database connectivity using ODBC and Oracle Net configuration.
• Created number of UNIX shell scripts for various tasks.
• Performed various UNIX Administration tasks.
• Performed Export/Import thru Data Pump.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.

Environment: Oracle 8i/9i,10g on RAC, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP Unix, PL/SQL, TOAD and SQL *Plus.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• 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.
• Applied Quarterly CPU (CRITICAL PATCH UPDATES) on the entire database farm.
• Performed Export/Import through Data Pump.
• 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.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Installed, migrated, configured and tested Oracle 10g databases in various environments.