SUMMARY:

• Over 8 years of extensive experience in IT with full System Administration, Analysis & Design, Software Development Implementation and Maintenance in Client/Server architecture, Erwin, RMAN, TOAD, RAC, Cloning, Statspack, AWR, Grid Control, OEM, Performance Tuning, Migration, Data Guard, Standby ASM, Oracle Streams, Oracle Golden Gate, OLAP/OLTP, Informatica Power Center, RED HAT, UNIX, Sun Solaris, AIX, HP - UX, Windows NT/2000/2003, Oracle 8i/9i/10g/11g/12c.
• Over 8 years of experience with Oracle 8i, 9i, 10g, 11g,12c Installation on Linux, Sun Solaris, IBM AIX, HP-UX and Windows NT/2000/2003.
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Optimization, Networking, Troubleshooting.
• Experienced in setting up/installation and configuration of release 11g R1/R2 RAC with ASM and Raw Devices and 11g CRS.
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB) of size 8 TB
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Experience in Automatic Storage Management (ASM) in 10g & 11g.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing. knowledge and experience of managing Oracle 9i and 10g RAC environments using the OEM Grid Control tools. Planned and implemented high availability solutions using Oracle 10g RAC, Standby Database using Oracle Data Guard.
• Experience in 11g features like Database Replay, Partitioning, Schema Management, Transaction management, Caching and Pooling, Resiliency, Case sensitive passwords, Virtual columns and Security.
• Experience in configuring Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues.
• Experience in bi-directional replication from source to target Database using Golden Gate.
• Experience in Platform migration from SOLARIS to AIX.
• Migration of Database from RHEL 4 to Sun Solaris and applying patches whenever required.
• Proven ability of providing production support for 24X7 on multiple databases.
• Experience in user managed Hot/Cold Backup and Recovery on Oracle 9i, 10g, 11g Databases.
• Experience in Hot/Cold Backup and Recovery of databases using RMAN.
• Experience in duplicating the database using RMAN for test backups and recovery procedures.
• Experience in creating scripts for automating online daily backup for databases.
• Experience in 11g new features: Active Datagaurd, configuring Snapshot standby database.
• Experience using Oracle 10g Flashback on Database, Drop & Table features.
• Working experience in both OLTP and Data warehousing environments.
• Worked with OLTP and OLAP database modeling
• Worked with z/OS 1.12 and OEM Grid Control to implement and maintain database functionality.
• Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive.
• Good Knowledge in using operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT.
• Experience in creating and scheduling jobs through OEM.
• Experience in maintaining Database Security using auditing.
• Experience in providing support for development and testing environment.
• Performance Tuning for Optimized results using Explain-Plan, SQL Trace, STATAPACK/AWR, TKPROF and ADDM REPORTS.
• Experience in Implementing Streams, ODI, Data Pump, Export and Import utilities.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD. Comfortable with SQL, PL/SQL, and developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views.

TECHNICAL SKILLS:

Tuning/Monitoring: RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB Cloning, Standby Databases, RMAN 9i/10g/11g, TKPROF, EXPLAIN PLAN, STATSPACK

DB Management: TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) Grid control (RAC).

Databases: Oracle 8i, 9i, 10g, 11gR1, 11gR2, 12c, MySQL, SQL server

Programming: Unix Shell Scripting, PERL, Bourne, Korn, PHP, JavaScript, SQL, PL/SQL, HTML, DHTMLC, C++, FORTRAN 77/80.

Operating Systems: HP-UX 10.x/11.x, AIX 4.3.x/5.1/5.2/5.3, WINDOWS NT/2000/2003 Server, RED HAT LINUX 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10, VMware ESX Server 3.0.x/3.5.0.

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

DBA Admin

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 1TB, Solaris Fire 440, Fire 880, Oracle 9i/10g/11g/12c, HP Integrity Rx 8640,NetApp, RHEL 5, SQL * Plus, OEM, Erwin Data Modeler.

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4) & 11g Release 1(11.1.0.6,11.1.0.7, 11.2.0.1 and 11.2.0.3) upgrades on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11g upgrades
• Handled successful implementation of POC for 12c Database.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Implemented Golden Gate and developed procedures for Replication.
• Responsible for upgrading Golden Gate 9.5 to Golden Gate 10.0.
• Involved in installing of 11g RAC on Linux environment.
• Installed ASM environment and migrating database from NON-ASM to ASM.
• Used Flashback Technology-Query on Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Monitoring and administering RAC databases using srvctl utility
• Coordinated with .Net programmers and SQL Server developers to design the flow of operations to ensure proper synchronization between the database and the front end in both connected and disconnected modes.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Net8 Configuration for Clients Connection.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM).
• Load balancing, databases/schema/table re-organization using Quest Live-Reorg for faster performance.
• Analyzed the user requirements and designed partitioned tables for improving performance.
• Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.
• Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups.
• Exported data’s from all Units are imported at Central Office for Management review about the Units.
• Data replication between units has been done.
• Involved in performance testing on applications.
• Created database objects and managed the permission access on the objects with necessary security.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE
• Daily Health Check of the Database.

:

Confidential, Berkeley, MO

ORACLE DBA

Environment: IBM AIX 5.3, Sun Solaris 2.6/7/8/9/10, Red Hat Linux 5.0/6.0, Oracle 9I/10g/11g, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 9.2.0, Oracle 10g GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Toad 8.6, Oracle Application server 10g, APEX 2.0/2.2,Sybase, SQL server

Responsibilities:

• Involved in 24x7 support for 8TB, 4 Node production RAC database with on-call pager
• Installation and creation of 11g and 10g databases for Testing, Development and Production
• Installed Golden Gate 10.4 on Solaris development tool.
• Implemented 10g/11g Data guard with one physical database
• Extensively worked with DML Triggers.
• Installed, upgraded Golden gate for Oracle database and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across heterogeneous environments.
• Capture, Propagation, Apply using Golden Gate.
• Assist Programmers and Developers with Oracle problems.
• Made use of the REF CURSORS in stored procedures for report generation.
• Designed, configured and maintained backup and recovery policies including RMAN backups. PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption
• Extensively worked with ASMCMD for managing ASM environment.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Extensively used AWR, ADDM for database performance statistics.
• Migrated all applications and database servers to AIX 5.3 and RedHat AS 5.0 Linux running Oracle 10gRAC with ASM Storage and 10g Application servers. Linux servers running OCFS 2.1. And RedHat Advanced server 2.1 and 3.0.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack
• Worked with OIDCTL, a command line utility tool for starting and stopping the OID server
• OEM / GRID (OGC) installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Extensively used Oracle Application Server 10g, in deploying and integrating enterprise’s applications
• Planned and performed the database migration from SQL Server to Oracle.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Transformed logical database designs into physical databases.
• Build and implement test, quality assurance, and production databases and environments.
• Coordinated strategies to move data between databases.
• Monitored database space requirements and adjusted for future needs
• Composed maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Resolved data integration issues.
• Enforced standards for data usage and population.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Able to work effectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment. Solid skills and discipline for Change Management practices processes.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.

Confidential, Austin

Oracle DBA

Environment: Oracle 8i, 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1), AIX 5.2, 5.3 RS6000, SQL*LOADER, Solaris 3500, Solaris 10, Dell 5560 with Xeon Processors.

Responsibilities:

• 24x7 Oracle Production Database Administration.
• Proactively monitoring the database.
• Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
• Hot / Cold backups of the database through RMAN.
• Configured and installed Oracle ASM volume manager, and replaced VERITAS volume manger software for the enterprise.
• Migrated several terra bytes of data into Oracle 10/11G ASM disk groups from EMC san into Symmetrix storage volumes.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Performed Cloning/Refresh to setup Test and Development database.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Relplicated database using shareplex.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning/exp/imp to setup identical databases in the production and development environments.
• Worked on operating system command line utilities like SAR, TOP, MPSTAT, VMSTAT
• Monitored performance and availability of the VIS application a high-availability web-based application running Oracle9i RAC on HP-UX cluster with EMC SAN.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Maintaining, Building and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Confidential, Pittsburgh, PA

Oracle DBA

Environment: Oracle 8i, 9i, RHEL, EMC Storage, Solaris, TOAD, SQL*LOADER, OEM.

Responsibilities:

• Part of a 6 member DBA team. It was involved in 5 production databases and 11 development/test databases.
• Providing 24x7 on call support for the business critical production RAC databases.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Applied bug patches according to the Oracle Critical Patch alerts.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Performance tuning for optimized results using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Involved in Capacity Planning, Hardware configuration for Oracle 10g RAC Environment.
• Involved in Performance tuning using tools like Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to be run.
• Responsible for handling some critical errors like ORA-600 by creating SR’s with Oracle Tech Support.
• Developed shell scripts to monitor and maintain the Oracle database.
• Create table spaces, tables, and users for custom applications.
• Experience in Enterprise Manager 10g, Virtual Private Database, Transportable table spaces and scheduler.
• Fully utilizes CASE tools to develop, or modify, physical database designs from logical designs, using the logical design, discussion with the Data Analyst, application development reviews.
• Implemented Real Application Clusters (RAC) setup, configuration and cluster interconnection of 5 instances with server side load balancing using Automatic Storage Management (ASM).
• Performed the Oracle DDL, DML operation.
• Proactively monitoring the database.
• Hot / Cold backups of the database through RMAN, Hot backups & BCV’s
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning/exp/imp to setup identical databases in the production and development environments.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.

Confidential

Jr. Oracle DBA

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, Database Tools/Utilities, STATSPACK, TKPROF, UTL SMTP, EMC ERWIN, SQL*LOADER.

Responsibilities:

• Database cloning/exp/imp to setup identical databases in the production and development environments.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Involved in a 7 member DBA team.
• Load data from OLTP systems into data warehouse databases.
• Installed and configured Oracle and Oracle Products on Linux and Windows Environments.
• Monitored for unusual conditions in database against contention, load throughput and cache utilization.
• Performed database Logical backups using export, import and Data pump.
• Performed database Recovery using physical, logical and RMAN backups.
• Testing of Backup’s and Documenting backup strategies. Created scripts for automating online daily backup for databases and for automating data loading from flat files.
• Monitored regularly whether primary and standby databases are in synchronized and clearing the backed up archive log files after confirming that they are applied on the standby database.
• Monitored the database objects growth, managing the extents growth and de-fragmenting the objects, which are running out of maximum extents. Monitoring the excessive fragmentation of table spaces and taking remedial steps.
• Starting the reporting database using the standby database data files and standby control file.
• Daily activities include monitoring batch application for performance and space requirements and tuning the system to optimize space and performance.
• Monitored & tuned the performance of database and SQL statements.
• Collecting the statistics using Explain Plan and TKPROF, studying the report.txt during performance slowdowns. Collecting the statistics of tables and indexes by analyzing for cost based optimizer mode.
• Used SQL LOADER for dumping data into database from Legacy Systems and Flat files.
• Shell scripting in Korn Shell for monitoring heartbeat of the database, disk utilization and paging dba with errors in alert log file.
• Worked with DW team for loading data to warehouse databases.
• Performed Table space Management and Rollback table space Management.
• De-fragmentation of database objects.
• Involved in migration of the databases in Oracle 8i from Windows to Linux.
• Monitor and tune Database, SQL statements performance using OEM, STATSPACK, TKPROF, and EXPLAIN PLAN.
• Cloned environments to create patch test, development and QA environments.
• Other activities like applying RDBMS patches, security patches, proactive monitoring of databases.