SUMMARY

• Over 7+ years of experience as an Oracle Database Administrator, having hands on experience in Development, Production environments Implementation and Testing of Relational Database Management systems for Business solutions.
• Installed Oracle database server on SOLARIS, HP - UX, AIX, WINDOWS NT, LINUX, UNIX and migration of oracle server from 9i to 10g and 10g to 11g applied oracle patches.
• Migrated single instance databases to multimode 10g, 11g RAC environments for high availability and load balancing.
• Installed, configured and maintained single node/multi nodes instances with RAC, ASM.
• Hands on experience in Data guard, Grid control, streams, replication.
• Expertise in Oracle Grid control installation, monitoring and maintenance.
• Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Data pump, Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Data guard, database cloning, refresh and patch management.
• Established Disaster Recovery for Oracle 11g RAC database.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, UNIX Shell Programming.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql’s for better performance.
• Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.
• Experience with Oracle Application Server 10g and Oracle Weblogic 11g .
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), Crystal reports and PL/SQL Developer.
• Have knowledge on ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases.
• Knowledge on Golden Gate Unidirectional and bidirectional replication.
• Involved in setting up the configuration of Golden Gate director.
• Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.
• Skilled in database upgrades 9i to 10g R2 and 10g to 11g.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experienced in Oracle Support processes for technical requests through Metalink and other support procedures.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat, Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP/07 Windows server 2008

Data Bases: Oracle 11g, 10g/9i, Oracle 10g Real Application Clusters (RAC), SQL Server 2000/2005/2008

Software Applications: Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), STATSPACK, ERWIN, IBM CDC(Change Data Capture), Clusters, Veritas Backup, Golden Gate, SQL Loader.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting.

Web Tools: HTML.

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Oracle Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle 11gR3/10gR2 on Red Hat LINUX 6.3 and Windows platforms.
• Install, upgrade and maintain Oracle 10g2, 11gR2 on RHEL 6.3 and Windows 2003.
• Initiated 10g new feature implementations such as Automatic Storage Management, RAC, Flashback features, DBMS Scheduler, ASSM and ASMM to improve performance and manageability.
• Implemented the Oracle 10g, Physical Data Guard in Maximum performance mode for production system in case of disaster recovery, maintained primary and standby databases.
• Applied Patches on RAC, Standalone, Standby databases based on the requirements.
• Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
• Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
• Experience on working with data guard physical/logical standby databases.
• Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
• Database Refreshing / Replication from production to testing using Exp/Imp.
• Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
• Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
• Planned and configured disk layout, mount points and capacity requirements for servers.
• Provided maintenance of user accounts, privileges, profiles and roles.
• Implemented the major migrations like DB2 to Oracle Using CDC tool, MY-SQL to Oracle using SQL-Developer tools in data ware house environment.
• Involved with OLTP relational databases system analysis, design, implementation and management.
• Involved in setting up of Golden Gate environment.
• Experience in setting up Dataguard 11g environment with MAA.
• Administered (10g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
• Supported off-hour on call support for database related issues.
• Created logical and physical design installed and upgraded databases.
• Experienced in Installation of OEM Grid Control 12c.
• Documented the Standard Processes for peers to follow.

Environment: RHEL 6.3, Oracle 11gR3/10gR2, RAC, SQL-Developer, OEM 12c, DATAGUARD, RMAN, Golden Gate, Data Pump, Diagnostic and Tuning Advisors, Change Data Capture(CDC) IBM tool.

Confidential, St.Louis

Oracle DBA

Responsibilities:

• Installation and creation of 10g and 11g databases for Testing, Development and production.
• Configured ASM for Oracle database files
• Creating and Managing Tablespaces with different block-sizes to prevent row chaining
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate database.
• Developing and Implementing Disaster Recovery (DR) Plan.
• Setup of Standby Database using Data guard for faster Disaster Recovery.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Daily Health Check Up of the Database using statspack, AWR, ADDM.
• Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Taking periodic Backup of the Database and the software using RMAN and VERITAS Netbackup
• Written shell scripts for digitization the process.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Automation of Startup Shutdown on all Production and Development Database.
• Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.

Environment: Oracle 10g, 11g, RAC, Sun Solaris 5.10, AIX 5.1, 5.2, HP-UX, Toad, ASM, ERWIN, GRID, AWR, ADDM, OEM, Data Guard, RMAN, Shell Scripting.

Confidential, NJ

Oracle DBA

Responsibilities:

• Upgrade/Migration of Databases from Oracle 9i to 10g Cross platform migration from different platforms.
• Installation, setup and configuration of DATA GUARD.
• Implementing Database Security, Management of role-based security.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Applying Patches like cpu patch sets and applying Oracle DST Patches on Oracle database.
• Experience in ORACLE SERVER ADMINISTRATION. Created Users, Implementing Backups, Cloned the Databases, Backing up and Refreshing ORACLE Database.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Review of Database logical and Physical design.
• Performed Data Migration as a part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Management of table space growth, monitoring data files additions, extent growth. Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
• Provided 24X7 supports for all the production and development databases.

Environment: RedhatLinux, IBM-AIX, Windows2000/2003, Oracle9i/10g/11g, RAC, Dataguard, Oracle Streams, Toad v10, PL/SQL, SQL*Loader, Oracle Warehouse Builder, ODBC, ASM, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup.

Confidential

Oracle Jr.DBA

Responsibilities:

• Backup scheduled Script creation and Standardization. Performed Database Installation and up gradation.
• Experience in working with cold and hot backups and recoveries.
• Installation and creation of databases.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Setting up new development and QA environments and involved in deployments and migration. Cloned databases for development and testing. Refreshed Dev &QA databases from production.
• Customized database backups for Disaster Planning and implementation.
• Creating profiles and attaching them with users, performing hot and cold backups.
• Performed database tuning for daily loads and slow response issues by refining queries.
• Used STATSPACK, TKPROF utilities for Tuning and analysis.
• Recovery of database from media failures, dropped accidentally and data block

Environment: ORACLE 9i, SQL, PL/SQL, Cronjob, Import/Export, UNIX AIX 5.1, Windows NT.