PROFESSIONAL SUMMARY

• 8 years of experience in ORACLE DBA.
• Worked as an ORACLE DBA (8i/9i/10g/11g) on UNIX environments like Linux, Sun Solaris, AIX and Windows 2000/NT
• Experienced in full life cycle of database administration in Oracle. Worked as a Development Support DBA in Oracle.
• Provided database related services to their development & QA environments.
• Designed logical and physical Data Models using ERWIN.
• Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
• Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
• Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks.
• Expertise in database migration, database testing and implementation
• Efficient in SQL query optimization using explain plan, Utlbstat/Utlestat, gathering statistics, pinning the objects, Running scripts.
• Extensively worked with Oracle Application Server.
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting, and configuring servers.
• Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers.
• Expertise in Configuring Data guard and Data broker.
• Experience in replication of the database and implement it for high availability.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.
• Experience in Logical backup using and full/ partial export/import and Data Pump.
• Extensive work experience in a database migration project team, serving in both an advisory and technical capacity
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Extensively worked with SQL Base database and UDB.
• Good Communication skill.
• On call technical support for 24x7 mission critical production databases. Willing to work beyond regular hours.

TECHNICAL SKILLS

Operating System: Linux (RHEL), Sun - Solaris, AIX, Windows 2000,NT

Databases: Oracle10g,9i,8i, Oracle 11g, Oracle RAC

Tools: SQL*Loader, SQL*Plus, Erwin, Oracle export/ import utilities, OEM, RMAN, TOAD, Data Guard, SQL Trace, DBMS Stats, STATS PackLanguages: SQL, Shell Scripting, PL/SQL Programming, PL/SQL, SQL Server Stored Procedures

PROFESSIONAL EXPERIENCE

Confidential, Chicago,IL

Sr. Oracle Application DBA

Responsibilities:

• Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Project and Version management using PVCS Version Manager and Checking DDL,DML’s and Stored procedures in PVCS.
• Database Builds Handling and migrations from CUT (DEV)-ETE (QA)-DR (deployment readiness) and Production .Propagates synchronized database builds to different channels in pre-production environments.
• Created master build script for data migration for DR and Production and providing scripts to infrastructure DBA’s.
• Archiving large tables and provides access to business and also increase the performance on archiving tables.
• Managing, Monitoring and optimizing the performance of the databases on a periodic basis using AWR, ADDM reports and providing recommendations.
• SQL tuning and Application Performance monitoring.
• Responsible for tunning of long running query’s by creating B-Tree and BITMAP indexes.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Capacity Planning for both OLTP and Data mart - Allocating system storage and planning future storage requirements for the existing and new databases.
• Proactive performance monitoring by implementing UNIX scripts and automated jobs (Grid) for alerts.
• Refreshing databases and Migration of databases from various environments for Testing, Development work.
• Performance testing (Stress testing) of third vendor applications for DB parameter settings, capacity planning (Memory, Space, CPU) and SQL tuning.
• Table Reorganization and recalculating/sizing the storage parameters for database objects to reduce fragmentation.
• Performance Tuning at DB level, OS level and Object level.
• Implementing Archiving Strategy for Partitions on a yearly basis.
• Implementing Partitioning methodology for FACT tables and managing LOCAL and Global Indexes.
• Created Archiving Strategy for archiving CDS data to flat files.
• Created an RMAN catalog databases and wrote an RMAN backup script for backing up more than 5 production databases and few development databases.
• Recovered data files from block corruption using RMAN.
• Reduced production outages by implementing best practices of patch management, purge/archival, code optimization and applied rolling patches such as PSU and CPU on RAC after testing on DEV, QA and Staging.
• Good knowledge in Oracle utilities including export/import, SQL*PLUS. Data loading using SQL Loader.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Created Archiving Partitioning Utility.
• Automating Partitioning of Fact Tables & Purging Audit Tables.
• Backup & File transfer Solutions for Fast growing databases.
• Created/implemented Partitioning Maintenance Scripts.
• Setup SOX auditing on financial tables using Oracle FGA (Fine grain Auditing).
• Implemented AQ (Queues Tables & Procedures) for job scheduling orchestrator (In-house app).
• Monthly Maintenance Week for Reorganizing database and Clearing/Purging Old files/Data.
• Done storage management of Tablespaces, Rollback/Undo segments & Data segments by writing scripts on different data dictionary tables. Managed Space, Monitoring Free Space, and Chained Rows etc.
• Daily monitoring of ALERT log & Trace files of the database.
• Migrated the Databases from non ASM to ASM.
• Separating of tables and indexes on different locations, reducing disk I/O contention etc. applications tuning of database using Explain Plan, TKPROF, SQL Trace, Analyze, Hints.

Environment: Oracle 11g/10g/9i, Solaris, Aix, PL/SQL, DATAGUARD, Import Export, TOAD, OLTP, LDAP, RMAN, JIRA, Remedy, Shell Script.

Confidential, St.Louis, MO

Oracle DBA

Responsibilities:

• Worked with a team of DBA’s to migrate multiple corporate databases & application from 10g to 11gR2, with post go-live stabilization.
• Proficient in implementing and maintaining Database Security (Users, Roles, Privileges), space management (logical structures such as tablespaces and rollback segments) and auditing of users.
• Installed, Configured Oracle 10g RAC Cluster for a 6 node multi instances hybrid cluster.
• Performed Oracle RAC Cluster ware Installation of 10g (10.2.0.4) Cluster Ready Services on 6 nodes Configuration, RAC Database Creation, Node Administration.
• Responsible for Exporting and importing database using Data Pump.
• Involved in implementing Load balancing and testing failover on 6 node RAC Database.
• Wrote scripts to improve the performance of importing indexes.
• Created Materialized views on big tables and enabled the AUDITING on few tables in production.
• Responsible for implementing cold/hot/logical backup procedures using shell (LINUX) scripting and also using RMAN. Developing, testing & implementing strong backup and recovery strategy. Also responsible for monitoring backups.
• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.
• Extensively worked in various areas of Dataguard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
• Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.
• Good knowledge in basic and advance replication using Oracle Streams.
• Implemented, and configured 10g grid control and 11g grid control on RHEL.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Worked on performance and tuning on SQL queries wherever it is required.
• Experience in using 10g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.
• Managed Oracle SR / tars, research application bugs, apply patches, data-fixes to resolve application, user functional issues.
• Created Partition’s, estimated stats on one partition and copied the stats to remaining partitions using dbms stats.
• Provided 24*7 supports with an on call pager.

ENVIRONMENT: Oracle 10.2.0.4, OEL 5.3, HP-Unix 11.11, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, DataPump, TOAD

Confidential, Hartford, CT

Jr.Oracle DBA

Responsibilities:

• Building RAC Database & Single Instance Database Instances for comparative analysis in Capacity/performance Environment.
• Node Addition & RAC database Maintenance using crsctl, Grid etc.
• Actively Participated in the Hardware/Processor & Storage (Netapp) Configurations for RAC systems.
• Installation/Configuration of various Oracle Server/Client Products in Windows, AIX and Solaris.
• Database Components Install to create XML DB and Oracle Text in PROD instances.
• Backing and restoring the database using RMAN utilities, Data pump and Filers backup.
• Designed and implemented hot backups using a combination of incremental, differential and full backups using SQLBacktrack (Dev),RMAN and Filer Snapshots.
• Creation, maintenance, and administration of databases under UNIX and Windows environments.
• Building and Managing Datawarehouse Environments for the Workflow systems.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL
• Worked on performance tuning for Oracle Real Application Clusters (RAC).
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration and security protocols for the database.
• Involved in checking and managing table space growth, monitoring the data file growth and extents.

Environment: RDBMS 9i, 10g, Solaris 8 (SPARC), SUSE Linux 9.2, AIX 5.1, Windows 2000/XP, TOAD, OEM, EXPALIN PLAN, TKPROF, EXPORT/IMPORT, SQLLDR, RMAN, NETCA.

Confidential

Jr.Oracle DBA

Responsibilities:

• Involved in 24x7 production database maintenance and on-call support.
• Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment. Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Instance cloning done to create test and training environments.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Environment: Oracle Server 9i/8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting