SUMMARY:

• Expert in all aspects of architecting a database, designing High Availability systems for 24*7, and administration functions including physical database design and implementation, RDBMS install and configuration on Red Hat Linux, Sun and Windows.
• Expertise in High Availability (HA) / High Performance solutions using Real Applications Clusters (RAC) with Automatic Storage Management (ASM), Online Transaction Processing (OLTP) and Decision Support System (DSS), Data warehouse Systems (DW), Distributed Database System and Replication and Very large Database (VLDB).
• Worked as Oracle DBA for 24*7 Production and Development databases. Simultaneously handled up to 70 databases Production and Development Instances providing L1 - L3 support, 300 databases providing L2 support. Experience on different versions of Oracle Database from 8.1.6.0 to 10.2.0.2 on different operating systems like Linux, Solaris, HP-UNIX and windows.
• Install and Configure Oracle Grid Control 10.2.0.1 and Management Agents.
• Very Strong in upgrading Oracle Databases from Oracle 8.x to Oracle 9.x, Oracle 9.x to Oracle 10.x and applying patches and patch sets for Database.
• Implemented hot and cold backups using RMAN, Veritas NetBackup, Standby databases using Data Guard (DG), tuning archive log transfer in Data guard for Datacenter migration. Data transfer and load using utilities like exp/imp, expdp/impdp, SQL * Loader, External Tables.
• Experience in database instance and application tuning and using various tuning methodologies like reactive tuning, proactive tuning, stress testing.
• Experience in performance tuning of various Oracle components like SGA, Redo logs, Rollback segments, Table spaces, IO, SQL Query optimizations and PL/SQL tuning, latches and locks and associated UNIX kernel parameters, configuration and tuning of INIT parameters and Parallel Query Tuning.
• Developed monitoring and tuning scripts using V$ views, DBA views, Statspack, OEM, Explain Plan, SQL Trace / TKProf, AWR, ADDM, SQL tuning advisor, SQL access advisor for tuning and troubleshooting SQL Queries and DML statements. Used different type of partitioning for large tables.
• Followed the Change Control/Change Management policies laid down by the Organizations. Used Remedy, IpRadar, Service Center and TARs for the same.
• Wrote Standard Operating Procedure Manuals, Installation Guides, Disaster Recovery scenario manuals and other documentation needed.
• Mentoring developers in writing optimized SQL and PLSQL code. Working with oracle product support to resolve critical issues, Control Change Management for database changes.
• Provided L1 support for SQL server database 2000. Experience on Oracle Applications 11.5.5 like administration, patching and cloning.

TECHNICAL SKILLS:

HARDWARE/OS: HP superdome, Sun Servers, Sun Solaris 5.8, Red Hat Linux AS 2.1, 3.0, Windows 2000 Server, HP UNIX.

SOFTWARE: Oracle8.x, Oracle9.x, Oracle10.x, SQL*Plus, SQL*Net, Net8, PL/SQL, RMAN, Import/Export, Oracle10gRAC with ASM, Oracle Data Guard, Oracle Partitioning, SQL*Loader, OEM, Grid Control, Auto Trace, DBVERIFY, Oradim, DBCA, Toad, SQL Server 2000.

LAST READING: Oracle Tuning - The Definitive Reference Rampant, Oracle 10g Data Warehousing 10g - Digital Press, Oracle 10g Grid & Real Application Clusters - Rampant, Oracle Data Guard - Rampant.

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Production Oracle DBA

• Provide support for 60 Oracle instances running Oracle 9.2, 10.2 databases ranging from 60GB-5TB on Sun Solaris and 50 Oracle instances running Oracle 9.2 on Windows.
• Install Oracle Grid Control 10.2 on Sun Solaris, Configure databases in Grid Control, Setup Metrics and Policies for databases and hosts, Create Notification Rules and Monitor all the Oracle Databases using Grid Control. Troubleshoot Oracle Management Server errors, identify bugs in existing environment, apply patches, and perform maintenance operations on management repository.
• Upgrade Test and Production Oracle Databases from 9.2 to 10.2. Apply interim patches for bug fix and patch sets.
• Ensure RMAN backups are happening regularly, Backup databases using RMAN cold and incremental. Segment and Table reorganization for optimal storage and performance using manual methods and using segment advisors.
• Determine redo Generation Rate for setting up Data Guard using physical Standby Database across WAN. Data Center Migration. Tune different phases of Data Guard like archive transmission to utilize maximum bandwidth using parameter like max connections, Capturing changed data using Asynchronous Hotlog Change Data Capture (CDC).
• Tuning Oracle databases using OEM tools like SQL Access Advisor, SQL Tuning Advisor, Automatic Workload Repository (AWR) and Automatic Database Diagnostic Manager (ADDM). Identify index and materialized views using SQL Access Advisor for newly developed applications.
• Performing Data warehouse operations like Loading Data into Warehouse using SQL*LOADER into temporary table, Exchange table with table partition, Rebuilt indexes and Gather Statistics after loading data.
• Deploying Application patches, Troubleshoot and fix problems while deploying Application patches.
• Execute Service Requests like creating users, assigning roles etc, Writing procedures to automate DBA jobs and scheduling reports. Used Remedy for Change Control Management.
• Install Oracle Database Software, Install different database options like JVM, OLAP etc, and Apply patch sets and create databases, Install Oracle Agent for Grid Control Monitoring.
• Troubleshoot all Oracle Database Related problems.
• Provide on call DBA support on rotation basis.

Environment: Oracle Database 10.x and 9.x, Oracle Grid Control, Data Guard, Datacenter Migration, Sun Solaris, Windows, Remedy, Subversion.

Confidential, Reston, VA

Oracle DBA

• Provide support for 290 instances running Oracle 9.2, 10.1, 10.2 databases ranging from 300G-6TB on Sun Sparc Solaris 5.8.
• Install different versions of Oracle 9.x, 10.x.
• Install Oracle Patches from 10.2.0.1 to 10.2.0.2, Apply Critical Patch Upgrade (CPU) Q2 and Q3, back port patches.
• Upgrade Oracle Databases from 9.2.0.6 to 9.2.0.7 and 9.2.0.7 to 10.2.0.1.
• Create, Configure New Oracle Database instance for Production, Acceptance, Development and Testing.
• Configure Netbackup for New Oracle Server Build.
• Monitor COLD, HOT and Incremental backup failures, fix the problem and ensure backups are happening successfully. Implemented Block Change Tracking (BCT) Incremental backups and Incremental Merge backups for faster completion of backup and faster recovery of Oracle 10g data warehouse databases. Check errors in BCV log files on media server in case of any BCV backup failures. Data Transfers from different environments using data pump (expdp and impdp).
• Worked on different types of partitioned options like Range, Hash and List. Created partitioned tables and global and local indexes.
• Monitor Change Control Requests, review the tickets and execute the instructions after getting proper approvals from different business units.
• Used PCM (Remedy) for Change Control Management.
• Co-ordinate with different teams like UNIX, Backup and Server Support for activities like VCS freeze/unfreeze clusters BCV backups etc.

Environment: Oracle 10.x, Oracle 9.x, Sun Sparc Solaris 5.8, Autosys, SRDF BCV backups, PCM 3.0, Netcool.

Confidential 

Senior Oracle DBA

• Provided 7*24 support for 60+ mission critical instances running Oracle 9.x, 10.x, RAC databases ranging from 100-600 GB. Also supported 3 instances of SQL Server database.
• Responsible for Physical and Logical Database Design.
• Installed, Configured and Monitored Oracle9.x, Oracle10.x Instance on Red Hat Linux Advanced Server (RHAS 3.0).
• Installed, Configured and Monitored Oracle 10.x 2-node RAC using file systems like Oracle Cluster File System (OCFS2) and Automatic Storage Management (ASM).
• Migrated Oracle Database from WE8ISO8859P1 to UTF8 for support of multi byte character languages.
• Planned and implemented robust backup strategies. Installed and Configured RMAN recovery catalog for RMAN backups, Veritas Net Backup for implementing Backup and Recovery.
• Installed and Configured Oracle Enterprise Manager (OEM), Tuned database instance, SQL with the help of TKProf, Explain Plan, Statspack, AWR and tools like Precise, Toad.
• Install, Configure and Monitor SQL Server 2000.
• Responsible for setting up database security and maintaining data integrity.
• Responsible for Planning Disaster Recovery procedures, implementing them and documenting the same. Participated in DR Drills. With the help of System Administrators Build the environment from scratch, document the discrepancies and note the time taken to bring it up and running.
• Responsible for recovery of database crash with minimum downtime and least impact to business.
• Deployed database patches, scripts for new release of applications on development, QA and production instance. Troubleshooting database errors while deploying applications.
• Used Service Center for Change Control/Change management.
• Wrote Installation manuals and other Technical procedure manuals.
• Developed SH/Awk scripts to automate cloning, data transfer for Oracle Database.

Environment: Oracle9.x, Oracle10.x, RAC, Toad, Red Hat Linux, Solaris, Service Center.

Confidential 

Sr Oracle DBA

• Provided 24x7 support for 140+ instances running Oracle 8.x-10.x ranging from 100 GB -1 TB on Solaris, Red Hat Linux and Windows.
• Install, upgrade and apply patches for Oracle Database, adding and removing oracle features like partitioning. Migrated database from Linux to Solaris using 10g new feature called transportable tablespace cross platform technology. Installed 64 bit Oracle databases and Configured 32 bit Oracle with SGA size greater than 1.7 GB. Successfully upgraded Oracle databases from 8.x to 9.x and applied security patches.
• Studied and analyzed few Oracle Databases and migrate them from Enterprise Edition to Standard Edition to save the cost of licensing.
• Managed physical and logical components of database. Managed Partitioned tables, indexes and function-based indexes.
• Clone production database for testing using RMAN cloning, recreating control file.
• Provided backup, disaster recovery, HA solutions to customer.
• Automated different types of backup like hot backup, RMAN incremental backup and testing backups using different recovery methods, data transfer using export and import, transportable table spaces. Migrated Dictionary managed tablespace to locally managed tablespace.
• Created and managed physical and logical standby database using oracle Data Guard, creating standby databases using RMAN. Performed Graceful switchover in Oracle 8.x database for hardware upgrades.
• Responsible for performance tuning - identifying performance degrading factors and taking corrective measures to improve database performance. The performance tuning efforts ranged from physical I/O tuning, memory cache optimization, Application Tuning included SQL Tuning, Cost Based and Rule Based Optimization, Normalization/De-Normalization, OS Tuning (I/O, memory, Locks and Latches etc).
• Responsible for SQL statement tuning using TKPROF, SQL Trace and EXPLAIN PLAN tools. Operating System specific kernel tuning and memory tuning, Database analysis using Oracle Enterprise Manager (OEM) for database performance tuning and dynamic view tables and self made SQL, PL/SQL code, Shell/AWK.
• Created capacity planning reports and database growth report which includes statistics like Load profile, Top 5 wait events and SQL, CPU, memory, IO etc along with recommendations which can further improve the performance of the system. Tuned Library cache latch contention using kgl latch count, spin count and buffer cache latch contention by setting db block hash latches and db block lru latches. Worked extensively on statspack report for optimizing database performance.
• Wrote shell scripts to capture system level statistics like CPU user and system usage, memory and IO, automating export import and cloning process.
• Reverse Engineering of database objects.
• Developed PL/SQL block using bulk select/update to update a large table of 4 GB for faster execution.
• Used OEM, STATSPACK, TOAD, DBArtisan and other Enterprise monitoring Tools for database monitoring
• Identified corrupted block using DBVERIFY and skipped the blocks as the blocks were belonging to log table.
• Configured auditing and automating audit/security alerts for financial mission critical databases.
• Wrote Standard Operating Procedure Manuals and other technical documents.
• Used IpRadar for Change Control management.

Environment: Oracle8.x, Oracle9.x, Oracle10.x, Statspack, Data Guard, SQL, PLSQL, Toad, DB Artisan, Linux, Solaris, Windows, AIX, IpRadar.

Confidential 

Senior Systems Engineer

• Provided 24x7 support for 800+ oracle databases 8.x-9.x ranging from 50 GB-300 GB on different platforms like Solaris, Red Hat Linux and HP UNIX.
• Monitored 800 internal databases and ensure 24x7 availability.
• Installed, upgraded and cloned new database depending upon client requirement.
• Monitored different processes, file systems, backups, export and import operations, replication processes.
• Recovered a 500GB tablespace that was dropped by offline drop command.
• Escalating issues to Oracle Support via Metalink. Provide support information with events, system dumps and RDA. Follow-up with Tars and implementing patches/workaround provided.
• Develop UNIX shell scripts to administer the system and crontab scheduling for batch jobs. Built space management SQL scripts to prevent failures from rapid data volume growth.
• Used Remedy for Change Control.

Environment: Oracle8.x, Oracle9.x, Linux, Solaris, HP-UX, BLT Monitoring Tool.

Confidential

Oracle DBA / Apps DBA Technical

• Provided 24x7 support for 30 Oracle database 8.1.7.4 ranging from 500GB-2TB, Oracle Applications 11.5.5 on HP UNIX.
• Installed configured and support Test and Development databases running Oracle9.x on HP.
• Applied and Tested intermediate patches and bug fixes in test and production environment.
• Monitored blocking locks, temporary, rollback, space usage, load on concurrent Managers, concurrent requests.
• Monitored Standby database for recovery from user errors and disaster recovery purpose, Refresh/Cloning of reporting/test instance from production system.
• Backup Oracle Database Using hot backups, data transfer using export/import and SQL*Loader. Recovery using Data Unloader (DUL).
• Configured Statspack for production system and configured it to send email/SMS alerts for various statistics.
• Did reactive and proactive performance monitoring using SQL scripts, Explain Plan, TKProf, TOAD, Statspack OEM and other utilities.
• Analyzed and Tuned customized SQL and network parameters like SDU and TDU when data was transferred using DB links. Troubleshooting various performance problems.
• Reorganized large fragmented tablespaces, tables and indexes. This has reduced the size of database from 2TB to 1.4TB.
• Applied database and application patches using Adpatch utility and Kintana GUI.
• Performed periodic password change for database and application security.
• Developed Sh/Awk/Sed scripts to automate cloning of Oracle database and applications.
• Configured and implemented Read only snapshots and materialized views.

Environment: Oracle8.x, Oracle Applications 11.5.5, HP UNIX on superdomes, Kintana, Tars.

Confidential 

Jr. Oracle DBA

• Provided 24*7 support to clients in installing, configuring and managing databases and customized applications developed in Developer 2000 (D2K).
• Managed Logical And Physical Database Design.
• Frequent reviews of Database Object Sizing and Placement, indexing and View Management.
• Extensive use of SQL*Loader to upload data and Import/Export for transferring database from different locations.
• Implemented Hot, Cold and Logical backup and recovery procedures.
• Database Tuning using init parameters, optimizing rollback segment, redo configuration, defragmentation and I/O distribution.
• Extensive database Performance Monitoring and Tuning using Bstat/Estat reports and OEM.
• Assist Developers in writing optimized code for stored procedures, functions, triggers and cursors.
• SQL Tuning and Query Optimization using Autotrace, TKProf, OEM and Explain Plan.
• Provided L1 functional support for Sales and Marketing System (SMS) & Material Management System (MMS).
• Create new forms, reports and PRO*C programs depending upon client requirement.
• Involved in writing Standard Operating Procedures (SOP) for database Activities.

Environment: Oracle8.x, SQL*Reports, SQL*Forms, Pro*C, Windows 2000 Server, Visual Basic (VB).