OBJECTIVE

• Over all 8+ Years of IT experience in Oracle Technology, seeking an opportunity for professional growth and increased responsibility towards handling challenging projects in an organization with a vision towards the future, induce an atmosphere conducive to the sharing of ideas, learning, and growth as emerging technologies grow, and build highly motivated and committed team and there by contributing to the group to a higher and higher degree technically and technologically.

SUMMARY

• Oracle Database Administrator with around 8+ years’ experience in installing, configuring, administering and managing oracle databases & implementing solutions like high availability (HA), data guard, Oracle streams and golden gate.
• Installation and administration of Oracle 12c/11g/10g/9i on OEL, RHEL, Windows, UNIX, Solaris 10 & IBM AIX V 5.3.
• Ability to understand and perform the enhancement based on client’s requirement.
• Excellent interpersonal and strong analytical, problem - solving skills.
• Experience and exposure to oracle Utilities and Tools like OEM,, TKPROF, STATSPACK, EXTERNAL TABLE, IMPORT-EXPORT, Data pump, flashback, AWR,ADDM,ASH
• Performed Migration and Upgrade of 20+ databases to 11g and 10g
• Up-gradation of databases applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle RAC with ASM & OCFS2 file systems on multi node systems, 12c, 11g, 10g and 9i in different operating systems according to OFA for OLTP and Data Warehouse environment on Very Large Databases (VLDB).
• Experience on oracle 12c/11g/10g/ASM/RAC and up-gradation of standalone databases to RAC environment.
• Extensive experience in installation and implementing OEM and setup of Oracle Grid Control.
• Configuration of Automatic Storage Management (ASM).
• Extensive experience with Database Cloning and Refreshing pre-production/development databases with prod/pre-prod databases.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
• Experience on Oracle golden gate Homogeneous/ Heterogeneous environments and implemented (uni/bi) directional replication.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental).
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Implementation of Flashback Technology.
• Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, and SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING
• Installed OSWATCHER & PROCWATCHER for monitoring OS resources on RAC nodes
• Experience on Oracle monitoring tools including Oracle SQL*Forms monitoring, Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Skilled in writing PL/SQL Procedures, Packages, Functions and Triggers.
• Experience using Erwin as a Data Modeling tool.
• Experience designing the DW model and the physical structure.
• 24*7 on-call production database support and maintenance including remote database support.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2000, 2005

Oracle Products: Golden gate, Streams, Oracle (Grid Control), OEM (Oracle Enterprise Manager), Oracle Fail-Safe (OFS), RMAN, SQL*Loader, DATA PUMP, APEX, ASM

Programming Languages: SQL, PL/SQL, JAVA, C, C++

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP Professional, Windows 2003 Professional

Other Tools: VERITAS Cluster Manager (Java Console) v3.5, TOAD, Erwin, Putty, SecureCRT, Oracle Streams, Quest Share Plex, Rational Suite-Clear Quest, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Sr. Database Administrator

Responsibilities:

• Provides DBA support for 24/7 online production system support for Both Oracle/SQL database.
• Maintains and upgrades both production and development databases for users/clients. Performs database clone, refresh and restore.
• Installed oracle RAC 10.2.0.3.0 and 11.1.0.6.0 and 11.2.0.3 OCFS/NFS/HACMP/ASM on AIX 5L with two node.
• Schedules and performs RMAN NetBackup.
• Researches, documents and applies quarterly security patches for Oracle RDBMS and Oracle Application Server including J2EE/WebCache, Report and Portal/BPEL in production, integration and development environment.
• Participates Data Guard maintenance and testing to ensure data high availability.
• Creates and updates database inventories. Prepares and documents systems, databases, servers and environments.
• Participates in client/project meetings for need assessment and design review.
• Creates, documents and implements standards and modeling to monitor and enhance the capacity and performance of the database. Programs and writes codes as necessary.
• Develops data import and export routines to automate data loading.
• Develops back-up and recovery procedures and data archive/purge procedures. Creates supporting technical documentation.
• Provides leadership and work guidance to less experienced personnel.

Confidential, Minneapolis, Minnesota

Sr. Database Administrator

Responsibilities:

• Up gradation of database for 9i to 10g, 11g.
• Applying one off bug patches, quarterly CPU patches, DST patches using OPatch utility.
• Day to day monitoring of database, maintenance, troubleshooting, resolving incidents on ticketing system.
• User management issues involving control user access to resource and information by allocating the right privileges.
• Managed Space issues involving resizing table spaces, data files
• Administration of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures One-Off Patch Installation.
• Purging of Oracle trace files & trims alert.log, listener.log files on regular basis.
• Interacting with Oracle for Technical Support. (SR)
• Day to day monitoring of database, maintenance, troubleshooting, resolving incidents on ticketing system.
• User management issues involving control user access to resource and information by allocating the right privileges.
• Managed Space issues involving resizing table spaces, data files
• Administration of all database objects, including tables, clusters, indexes, views, sequences, packages and procedures Provides leadership and work guidance to less experienced personnel.

Confidential, SFO, CA

Database/System Administration

Responsibilities:

• Maintained and administrated more than 200 Oracle 10g, 9i and 8i databases and SQL Server database 2000 in development, integration and production environment at Confidential Ltd. .
• Maintained and troubleshot Application Server in middle tier and application E-Business Suite. Supported application development effort.
• Installed oracle RAC 9.2.0.4 OCFS on Red hat Linux 2.1 with four node.
• Researched, documented and applied quarterly security patches for Oracle RDBMS and Oracle Application Server including J2EE/WebCache, Report and Portal/BPEL in production, integration and development environment.
• Participated in client/project meetings for need assessment and design review.
• Designed, developed, implemented and maintained database for internal and external users/clients. Created supporting technique documentations.
• Scheduled and performed RMAN NetBackup and database clone refresh and restore.

Confidential

Database/System Administrator

Responsibilities:

• Supported and maintained computer system, networking and software implementation.
• Designed, implemented and developed database/ Laboratory Information System.
• Provided DBA consultant for 24/7 online banking systems.
• Implemented Oracle 9i Data Guard and ensured the data high availability.
• Performed RMAN backup and tested various RMAN recovery scenarios.
• Monitored and tuned databases to optimize the performance and satisfy the availability requirements of multiple applications using SQL Tuning Advisor (STA).
• Performed database backup and recovery to ensure data high availability.
• Analyzed and tuned the database to identify potential database issues such as response delay and locking contention with tools like Statspack, EXPLAIN PLAN, and TKPROF.