SUMMARY

• Over 8+ years experience in the Information Technology field, with comprehensive hands - on expertise in development, production database administration and database application development.
• Repeatedly demonstrates the ability to apply technical skills for the achievement of tactical and strategic business solutions, and also leverages managerial and interpersonal skills to motivate, direct and inspire project teams.
• With experience in both Finance and Healthcare across a wide variety of systems and companies from large to small, I am seeking a new challenge to call upon my technical skill set.
• Experience as Oracle DBA (11g/10g/9i/8i) on different Confidential -UX, Sun Solaris, Linux, AIX, and Windows 2000/NT environment.
• Experience in full life cycle of database administration. Worked both as a development and a 24x7 Production Support DBA.
• Experience in Oracle Real Application Clusters (RAC) Installation, administration, troubleshooting and Performance tuning in 10g and 11g.
• Extensive hands-on and managerial experience in the design, construction and deployment of data warehouse systems.
• Worked on data warehouse tools. Involved in defining staging area Metadata, Data Mart, defining & populating the Enterprise Model warehouse, Incremental Data loading
• Extensive experience in installing, upgrading and applying patches to various versions of oracle (11g/10g/9i/8i). Duties included raising Oracle SR support to deal with bugs and issues associated.
• Expertise in Upgrade and Migration of oracle database to higher version and other platforms using Oracle Data Migration Assistant.
• Installed and configured Oracle 10g (10.2.0.2) Database on Confidential -UX and Linux advance Server on Development, Test and Production boxes.
• Involved in disaster recovery planning, detailed out the processes and procedures of implementing disaster recovery, implemented database backups and Disaster recovery strategies using RMAN.
• Experience in performing Hot and cold backups with and without RMAN. Automated RMAN scripts using cronjob to perform daily backups.
• Expertise in database creation, tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, and configuring servers.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database.
• Experience in Performance Tuning (I/O, Memory & SQL/PLSQL Tuning) using EXPLAIN PLAN, TKPROF, and STATSPACK.
• Monitoring and Management of various Database Components (Logical & Physical) like Tablespaces and Segments for space management.
• Experienced in troubleshooting traditional export/import and datapump export/import.
• Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.
• Creating high level and detail design for applications. Creating and execution of test cases/test plans. Executing test cases and test scripts for data validations.
• Experience in Operational data store, data cleansing, backup and restoration strategies.
• Highly motivated individual and good team player.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Operating System: Confidential -UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP

Database: ORACLE 8i/9i/10g/11g,SQL Server (2008,2005,2003)

High-Availability: RAC (9i/10g/11g), Data Guard (Physical and logical standby setup)

Tools: & Utilities: OEM (Oracle Enterprise Manager), RMAN (Recovery Manager), Export/Import, SQL*Loader, SQL *Plus, TOAD, Data Guard, Putty, Statspack, Opatch, Winscp3, Virtual Network Computing with PC Anywhere and VNC.

Languages: SQL, PL/SQL, C, shell scripting, Html, Java, and JSP

PROFESSIONAL EXPERIENCE

Confidential, OH

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA (9i/10g/11g) on Linux, Sun Solaris, Confidential - Unix, AIX and Windows servers.
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance and managing data lifecycles.
• Involved in extracting data from source & interface systems data warehouse system ( ETL process ) using DTS & SQL Loader.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems.
• Monitored and tuned databases and SQLs using tools like Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack. Installed and configured OEM GC and intensively used for Diagnostic & tuning activities.
• Maintain the scheduling, distribution, and refresh for reports, views, and OLAP Performance tuning and support of application servers Defining and managing database connectivity to multiple sources and target databases.
• Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Handled large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) Grid control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Performed migration of databases, schemas, objects and data from 9i to 10g databases and single node to cluster databases using traditional export and Datapump.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 11g/10g,SqlServer2005,2008 Confidential -Unix 11i v3, Solaris 10,RHEL 5, AIX 5.2, MS Windows,RMAN, OEM

Confidential, OH

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA (10g/11gR2) on Linux, Sun Solaris and AIX servers.
• Installed and administered Oracle Real Application clusters (RAC 11gR2) on a 3 node Linux cluster using Veritas Cluster File System (V.C.F.S).
• Responsible for Installing, upgrading, Implementing and supporting oracle 10g R1/R2 and 11g R1/R2 databases.
• Involved in Installing and maintaining of Sun Solaris(SVE) Active/Passive Cluster on Oracle 11gR2.
• Developing PL/SQL code, day to day DBA activity including the monitor and allocate storage space for data, Creation of the different databases environments for development, Testing & productions & Audit database usage, Tune the database.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Assisted in implementing Oracle Financial Services Analytical Applications Infrastructure (OFSAAI - Reveleus & Basel products.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Worked on troubleshooting issues with full export and import.
• Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day-to-day management of the databases.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Extensively worked in the performance tuning of the programs.
• Tuning SQL statements using Explain Plan and STATSPACK. Optimized SQL statements for maximum performance by using TKPROF and EXPLAIN PLAN
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Identified heavy resource consuming transactions/jobs to all request, developers to tune the components OEM Automatic Workload Repository Snapshots.

Environment: Oracle 11g/10g, Confidential -Unix 11i v3, Solaris 10,RHEL 5, AIX 5.2, RMAN, OEM.

Confidential, NV

Oracle DBA

Responsibilities:

• Worked as an Oracle DBA (9i/10g/11g) on Linux, Sun Solaris, Confidential -Unix, AIX and Windows servers.
• Installed and administered Oracle Real Application clusters (RAC 10gR2) on a 4 node Linux cluster using Oracle Cluster File System (O.C.F.S) and Automatic Storage Management (A.S.M).
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance. and managing data lifecycles.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems.
• Monitored and tuned databases and SQLs using tools like Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack. Installed and configured OEM GC and intensively used for Diagnostic & tuning activities.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Migrated 22 production databases to new environment with in estimated downtime.
• Perform Logical backup using and full/partial export/import and Data Pump.
• Worked on troubleshooting issues with full export and import.
• Proactively managed the databases; set up notifications/ alarms using shell scripts for managing any exceptions in day-to-day management of the databases.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.
• Tuned oracle databases and applications using Tuning Tools like OEM GC, Cost optimizer, SQL analyzer, AWR, ADDM, ASH, Explain plan and SQL TRACE.
• Extensively worked in the performance tuning of the programs.
• Identified heavy resource consuming transactions/jobs to all request, developers to tune the components OEM Automatic Workload Repository Snapshots.

Environment: Oracle 11g/10g/9i/8i, Confidential -Unix 11i v3, Solaris 10,RHEL 4, AIX 5.2, RMAN, OEM, Windows 2000 Servers.

Confidential, OH

Oracle DBA

Responsibilities:

• Worked as an Oracle Production DBA (9i /10g/11gR1) on Confidential -Unix 11.x, AIX 5.2 and Solaris 10 servers.
• Installed and administered Oracle Real Application clusters (RAC 10g) on a 2 node Linux cluster using Oracle Cluster File System (O.C.F.S) and Automatic Storage Management (A.S.M).
• Performed Tuning, coding and Monitored OEM.
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Used EXPORT/IMPORT to do table level and full database defragmentation.
• Involved in Oracle partitioned tables and applied patches as per the requirements of the client and upgraded the Oracle and DBMS software.
• Upgraded the database from Existing Oracle 9i to Oracle 10g.Tune the application queries and identify the resource,database and design issues.
• Modify and implement new changes without affecting the functionality of applications and end-users for reporting server.
• Involved in the Migration of database from 9.2.0.6 to 10.2.0.1.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and Korn shell, Unix shell Scripting.
• Knowledge on stand-alone database using Oracle Data Guard feature for High availability configuration. Implemented Oracle Enterprise Manager Grid Control and configured agents.
• Database administration activities including Tablespaces allocation, user enrollments and database re-organization.
• Extensively worked on identifying high load sql statements and troubleshooting to find underlying causes and took appropriate actions to improve performance.
• Ensuring that adequate recovery procedures are in place, based on: Database backups being done and verified.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.

Environment: Oracle 11g/10g/9i, Confidential -Unix 11i v3, Solaris 10, AIX 5.2, RMAN, OEM, Windows 2003 Servers.

Confidential, Denver CO

Oracle DBA

Responsibilities:

• Worked as a Performance Tuning Oracle DBA (9i &10g) on Solaris 10, AIX 5.2.
• Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.
• Created a script to check the status of running database.
• Improved a number of monitoring scripts that improve database performance and disk space utilization.
• On the results of Index monitoring scripts, dropped unused Indexes and moved couple of Indexes to new tablespace.
• Developed a script to sort the most I/O i.e. read and write operations performed by the Data files.
• Modified and updated the Performance tuning scripts.
• Administered Oracle repository for data modeling and database design.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.
• Tuning SQL statements using Explain Plan and STATSPACK. Optimized SQL statements for maximum performance by using TKPROF and EXPLAIN PLAN.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.

Environment: Oracle 10g/9i, Solaris, AIX 5.2, TOAD.

Confidential, Omaha, NE

Oracle DBA

Responsibilities:

• Worked as Oracle DBA (10g) on Confidential -UX 11i v3.
• Installed and configured Oracle Database Software 10g.
• Upgraded the database from Existing Oracle 9i to Oracle 10g and Migration of database (from 9.2.0.5 to 10.2.0.1).
• Designed and implemented backup and Disaster recovery strategies with RMAN.
• Worked in advanced recovery methods like PITR. Logical backup using full/ partial export/import and Data Pump.
• Integrated the Backup status reporting for the entire database in the enterprise to enable the web reporting using Oracle SQL, PL/SQL and UNIX shell Scripting.
• Implemented stand-alone database using Oracle Data Guard feature for High availability configuration.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Worked with Oracle partition tables and applied patches as per the requirements of the module.
• Used Oracle replication as databases for read only snapshots to maintain local copy of master tables in OLTP systems.
• Also done Patches for upgrading Oracle and DBMS software.
• Used SQL* loader to move data from legacy systems.
• Used PL/SQL (Stored procedures, triggers, packages), SQL* PLUS, SQL* LOADER, Explain Plan, and SQL tuning of Oracle database.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) . Tuned database for optimum performance.
• Configured Oracle Streams (Advanced Replications) and exchanged data between two databases in remote locations.

Environment: Oracle 10g/9i, Confidential -UX 11i v3.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle Database Software 10g.
• Oracle 9i, 8i, OEM, SQL * plus, SQL * Navigator, DBA studio, imp/exp, RMAN, SQL, PL/SQL, SQL* loader, TKPROF, Oracle Tuning pack, Diagnostic pack, Red Hat Linux, and Windows 2000.
• Upgrading database from Oracle version 9i to 10g and migration of data.
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle.
• Involved in logical backup using and full/ partial export/import and Data Pump.
• Data modeling with extensive normalization activity.
• Data Migration (from 9.2.0.5 to 10.2.0.1) on AIX 5.1, which is made on a Linux Advance Server.
• Setting up Physical Standby Database environment using Data guard in Oracle 9i and 10g.
• Performance tuning of application by identifying the SQL, which are not written well; providing inputs to the application programmer; correcting and implementing the right components.
• Using RMAN for backup and recovery.
• Created Oracle partition tables and applied patches as per the requirements of the partitioning module and applied patches for DBMS software.
• Installing and troubleshooting Red Hat Enterprise Linux 5.0 for Oracle 9i and 10g .

Environment: ORACLE 9i,10g, Red Hat Linux Enterprise Server, AIX 5L 5.1, OEM, Window 2000 Server.