SUMMARY:

• 7+ years of IT experience with 6 years of experience as Oracle Production/Development/Data Center Database Administrator handling different versions of Oracle from 9i to 11g on various platforms.
• Experience in high availability RAC environment (2 node, 3 node and 4 node clusters) and upgrade of the standalone databases to 11g R2 RAC environment.
• 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, Data Architecting, Database Design, Capacity Planning, Replication, Partitioning, Migration and Connectivity to foreign databases like Sybase and SQL Server using transparent gateways and other aspects of database administration.
• 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 .
• 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 hot and cold backup and recovery procedures.
• Experience in schema management, tablespace, datafile and extent management, as well as user and privilege management.
• Comfortable with both command-line and GUI interface.
• Possess strong UNIX skills; intermediate administration skills. 24/7 on-call support.
• 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 RMAN
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import and Data Pump)
• 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.
• 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.

SKILLS:

Operating Systems: HP-UX 10.x, 11.x, Sun AIX, RHEL and Windows 95/98/ME/NT/200x.

RDBMS: Oracle8i, Oracle 9i,Oracle 10g, 11g ASM, Oracle 10g Real Application Cluster (RAC), Data Guard.

Languages: SQL, PL/SQL, C, Bash shell.

Tools: RMAN, OEM, Enterprise Manager Console, SQL*Loader, EXP, IMP, data pump (expdp, impdp), SQL Developer, TOAD, putty, Secure CRT.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

EXPERIENCE:

Confidential, Addison, IL

DBA Support

Environment: Production and Non-Production on Linux/HPUX and NT.

Responsibilities:

• Includes 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 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.

Confidential, Downers Grove, IL

Environment: Production and Non-Production on Linux/HPUX and NT.

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.
• Formulate optimal application SQL using Grid Control and v$queries.
• 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.
• Automated various tasks thru crontab.
• Written Backup and Recovery scripts using RMAN
• Performed Export/Import of Oracle 8i/9i and 10g Databases thru command line as well as performed import export interactively.
• 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.
• Applied various database and Application patches
• Used Grid Control for Backup and Recovery tasks.
• Solved database connection issues using Oracle Net Services.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Configured Agents on different platforms to communicate with Gird Control.
• Configured and maintain Grid Control Repository.
• Configured Listener from multiple homes in one server.
• Provided full DBA support for Oracle Applications in Production, Test and Development environments
• Worked very closely with ORACLE for Data Guard implementation and other major issues.

Confidential, Ann Arbor, MI

DBA Support

Environment: Production and Non-Production on Linux/HPUX.

Responsibilities:

• Responsible for administration and supporting Oracle database on Sun Server.
• Installed, upgraded, migrated and configured Oracle 8.06/8.17, 9i database.
• Installed and configure Oracle 10.0.1 on Sun SPARC/Solaris 8 64 bit server for development.
• Configure RAC environment for multiple sets of 4 database instances in Oracle 10.2.0
• Configure ASM for Oracle 10G R1 installation with RAW devices which include clustered file system for RAC.
• To create Development/Test databases, create schema, users, create database objects, security management etc.
• To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 9.0.2 on SPARC/Solaris 8 - 64 bit server
• To upgrade Oracle 8.0.6 on Solaris8 - 32 bit server to Oracle 10.0.1 on SPARC/Solaris 8 - 64 bit server
• Performed database tuning with Sqltrace, tkprof.
• Set up and maintain automatic hot standby database for disaster recovery
• Cloned Database and transfer data between Production and Development database
• Estimated database capacity managed system disk space and system resources.
• Implemented hot backups and recovery procedures using RMAN.
• Setup Oracle Enterprise Manager and STATSPACK to support monitoring and performance diagnosing
• Created scripts to monitor database alert activities, growth, and key performance indicators.
• Created scripts to automate and standardize various database maintenance tasks.
• Provided guidance to developers on data design, query tuning and security issues.
• Designed and implemented disaster recovery and backup/restoration procedure using Shell scripts
• Provided technical troubleshooting and give consultation to development teams.