SUMMARY:

• An Oracle DBA with 13 plus years of experience in oracle (8i,9i,10g,11g) 10g RAC, streams, data guard, installation, migration, designing, backup, recovery, scripting, performance tuning etc, spanning various industries like Finance, Healthcare, Telecom etc. in variety of environments like UNIX, LINUX, (Solaris, HP - UX, AIX), WINDOWS NT 4.0/2000/2003 in production as well as development databases.
• Experience in oracle 8i/9i/10g/11g, RAC 10g (ASM AND OCFS2) installation, administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting, database design, UNIX shell scripting and documentation
• Extensive Experience in installation, maintenance and tuning of Oracle 10g RAC software with ASM and OCFS2 file systems.
• Installed oracle database server on Solaris 8/9/10, HP-UX, Tru64 Unix, IBM AIX 5.2/5.3 Linux and Windows environment and migration of oracle servers between 8i, 9i,10g & 11g also applied oracle patches.
• Expert in implementing ORACLE STREAMS, and two types of standby databases supported by DATAGUARD, logical standby and physical standby databases.
• Expertise in implementing development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts.
• Proficient knowledge in RMAN backups (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery.
• Excellent knowledge in SQL, PL/SQL, Partitioning, and Data Modeling with utilities like ER/Studio, OLAP, logical and Physical Database design, procedures, Functions, Packages, Database triggers.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM & LEGATO Storage Manager
• Expertise in SQL*Loader, export/import and data pump import to load data into tables.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache and redo mechanisms.
• Expertise in SQL tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Sound knowledge of UNIX Shell scripting
• Expertise as On-Call 24x7 production DBA and application/development DBA and oracle support processes for technical requests
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work 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, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows 95/98/NT/2000/XP

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

RDBMS: Oracle 11g/10g/9i/8i

Tools: RMAN, OEM, Sql Navigator, Oracle Management Service(OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Datapump, Dataguard, VERITAS Net Backup, MS Access

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

Database Modeling: Erwin 4.1.2, rational rose, Visio

EXPERIENCE:

Confidential, Tampa, FL

Oracle DBA Lead

Responsibilities:

• 24x7 production support for several missions critical systems which utilize multiple Oracle 9i, 10g, 11g databases.
• Installation, maintenance and tuning of Oracle 10g RAC databases.
• Performed upgrades from Oracle 9.2.0.8 to 10.2.0.3 on Intel and HP boxes.
• Configured Streams to capture propagate; apply changes in multiple databases.
• Configured, administered and monitored a Streams environment using various tools like OEM console.
• Successfully migrated databases from Intel Boxes (Windows 2000, Windows 2003 servers) running oracle 9i over HP-UX Itanium boxes running oracle 10g and non-ASM instance to ASM instance.
• Setup, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Used shell scripting for automation of job scripts, for Startup and Shutdown, Health Check of Databases, Analyzing tables and Rebuilding Indexes.
• Worked on import/export, export data pump/import data pump and SQL Loader.
• Installed and Implemented Backup and Recovery Procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and Configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Extensive Performance Tuning, Memory(SGA) Tuning, Net backup, EMC(Time finder and SRDF), RAW Devices
• Downsizing and defragmenting the Very Large Databases by export/ import, cloning those using RMAN duplicate features and then upgrading them Oracle 10g.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Load Balancing, Databases/Schemas/Table Re-Organization for faster performance using export/import & Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Storage Management Managing space, Table spaces, Segments and Extents, Rollback Segments and Data Dictionary
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing and performance tools in physical/logical databases.
• Installed Oracle 10g Enterprise Manager (OEM)(Grid Control) for diagnosing and monitoring performance related problems and configured with Applications servers on databases.
• Designing the security and database access strategies using tools like ESM.
• Used ERP to plan how to use the resource effectively and to control and manage them.
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.

Environment: Oracle 11g/10g, Red Hat Linux 5.x, Solaris 10, Windows, HP - UX, Oracle 10gRAC/9i, TOAD, Sql-Navigator, PL/SQL, SQL*Loader, ODBC, OLTP, Telnet, OEM, Erwin 4.1.2, MS Access.

Confidential, Columbus, OH

Oracle DBA

Responsibilities:

• Up grade from Oracle 9.2.0.8 databases to Oracle 10.2.0.3
• Used shell scripting for RMAN and hot backup and recovery.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Implemented Backup using RMAN (Recovery Manager) as a media management layer.
• Have worked on building complex logical data models, reverse engineering and forward engineering using sophisticated modeling techniques and tools like Erwin and Visio.
• Improved the performance of database by creating and managing database objects such as tables, Indexes, Partition tables, Index Organized tables, material views and views.
• Performance tuning i.e. tuning RAC, applications, shared pool, I/O distribution, rollback segments, buffer cache to provide instance level performance tuning for Event Waits, Sessions, Physical/ Logical I/O and Memory usage.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Optimizing ETL procedures and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL Trace.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Consulting and advising with developers on the design of applications having complex database considerations, design custom database objects as required and recommended data access solutions that best fit the needs of the application.
• Used export/import for schema, table and database refresh.
• Implemented Range, List Partitions, Hash Sub Partitions, creating and refreshing materialized views.
• Write scripts for Creation of users, creation and assignment of roles analyze space requirements and maintain tablespaces and other database objects and also did the patch management for oracle upgrade.
• Handling large database environments (Data warehouse) using ETL tool and 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 tuning.
• Have done database backup and recovery using(cold backup/Hot backup/ logical)

Environment: Oracle 10g, 9i, Red Hat Linux, Solaris, HP-UX11, AIX, Windows NT/2000, TOAD 8.6, Erwin 4.x, Visio, Data Guard, RAC, RMAN,TKPROF,SQL-Trace

Confidential, Tulsa, OK

Oracle DBA

Responsibilities:

• Installed and Configured ORACLE 10g in LINUX environments.
• Designed the necessary table structures, tablespaces, users and their profiles using Enterprise Manager and SQL.
• Created materialized views.
• Granted and Revoked privileges and roles to the users on different objects depending on their work requirement and provided the necessary security to the database.
• Cloning of databases was done using RMAN and Enterprise Manager.
• Developed Unix Shell scripts to automate database maintenance and monitoring.
• Developed / modified Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement backups and performed failover and disaster recovery tests.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database reorgs.
• Performed database tuning using Explain Plan, Toad, and Enterprise Manager.

Environment: Oracle 9i on Solaris 9, Linux, Oracle Enterprise Manager (OEM), Toad

Confidential

Jr Oracle DBA

Responsibilities:

• Installed and Configured ORACLE 9i in Windows XP and LINUX environments.
• Understanding the existing Database Structure and suggesting the database reorganization.
• Created tables, views and other objects with appropriate tablespace sizes.
• Implemented features of Oracle 9i like Transportable Tablespaces, Locally Managed Tablespaces, Hot Standby Databases for fail-over situations, Multiple Archive-Log Destinations that support Hot Standby Databases etc.
• Performance tuning of Oracle 9i databases including optimization of Oracle init.ora, Oracle SGA, I/O balancing and memory tuning.
• Troubleshot and resolved many issues with SQL query performance for problems faced in the system like locking, slow response.
• Performed capacity planning and sizing of databases based on input from business.
• Partitioning of large tables.
• Recovered the database after loss of the non-system data file with Rollback Segments.

Environment: Oracle 9i, Sun Solaris, Windows XP, Linux, Toad, PL/SQL, Shell Scripting

Confidential

Oracle DBA & PL/SQL Developer

Responsibilities:

• Wrote UNIX/SQL scripts and integrating these as per the requirements.
• Wrote & implemented Backup Scripts with proper integration with Operating Systems.
• Day to day activities include interaction with Director, Managers for different departments, application developers, System Administrator, Testers & End Users.
• Also involved in taking proactive steps as and when required for development environment. Involved in formulating & enforcing Security for database servers for different types of users, creating and maintaining roles, looking into the log files, managing space on different servers.
• Helped the application developers in utilizing database server in best possible ways and cross co-workers, documenting the DBA related activities.
• Performed query optimization by choosing the optimal access plans for the execution of users queries
• Automated the written scripts on various database servers.
• Made required changes to meet the stringent response time requirements, and divided the load of data tables and indexes evenly on the different table spaces and disks.
• Set up machines for front end as per the needs of the project e.g. installing Visual Basic & Netscape Communicator and providing ODBC link to Oracle.
• Physical Database was designed and the necessary scripts were prepared for the actual database creation on the server.
• The schemas were created as per the project requirements.
• All the users were given the appropriate access rights after forming a security policy.
• Regular backup of the database. Offline once in a week, online daily.
• Used PL/SQL tables and records in transaction processing in the backend
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks
• Created different views as per the business needs
• Created materialized views and snapshots for high end application usage
• Created and used different types of sequences and indexes
• Worked with sub queries/Correlated sub queries on the database
• Involved in performance tuning and query rewrite
• Involved in writing UNIX shell scripts to run Oracle Processes
• Created database triggers, stored procedures and PL/SQL scripts.

Environment: Oracle 8i, Windows NT, Linux, Toad, SQL*Plus, PL/SQL