EXPERIENCE SUMMARY

• Over 6.5 years of experience in Oracle Installation, Database Configuration and Administration, Backup and Recovery, Tuning, Database Migrations, Standby Database setup, and troubleshooting of various Oracle products / versions on different platforms covering Red Hat Linux, Sun Solaris, IBM AIX, and WINDOWS NT / 2000 / 2003.
• Oracle Database Administration on 24x7 critical production and large databases of over 7 - 9 TB in size using Oracle 11g, 10g & 9i.
• Experience in variety of operating systems of UNIX and WINDOWS.
• Worked on various Oracle Solutions like Data Guard, RAC, RMAN, OEM Grid Control.
• Experience in database installation, configuration, upgrades, and Performance Tuning.
• Good knowledge on Oracle technology architecture and Real Application Clusters.
• Worked on various 10g & 11g features like ADDM, Flashback, AWR, OEM Grid Control Monitoring, Data Pump, ADRCI, ACFS, etc.
• Hands on experience with Installation, Configuration, Migrations, RAC, Data Guard, Backup and Recovery using RMAN, Disaster Recovery Setup, Patching, Upgrading and administering VLDB on Oracle 11g/10g/9i.
• Experience in identifying performance bottlenecks on high volume transaction systems.
• Recovery of Databases (Recovering from media failure, Recovering tables dropped accidentally, Recovering data files, Recovering from block corruption, etc)
• Database performance tuning using STATSPACK, AWR, ASH, TKPROF, SQL Trace, Explain Plan.
• Well conversant in translating business requirements into creation of database objects: tables, indexes, constraints, packages, stored procedures, and functions using Oracle tools.
• Proficient with Database Cloning, Migration, Standby Setup, and Patching of Oracle Databases.
• Good programming skills in SQL, PL/SQL, and UNIX.
• Experience in Disaster Recovery setup to meet business requirements.
• Cloning and Refresh using RMAN.
• Upgrade of Databases from Oracle 9i to 10g and 11g
• Knowledge on Oracle Support processes for technical requests with meta-link.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Proven ability to adapt to demanding schedules and changing priorities.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Operating systems: Sun Solaris, Windows NT/2000, Red Hat Linux, AIX

Languages: C, C++, SQL, PL/SQL, Unix Shell Programming, Perl

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

Tools & Utilities: Export/Import, DataPump, SQLLDR, OEM, Toad, RMAN, TKPROF, AWR, ASH etc..

Database Modeling: Power Designer v12.x

PROFESSIONAL EXPERIENCE

Confidential, California, LA

Database Administrator

Environment:Sun Solaris 2.8/2.10, AIX 5.3, 5.4, 6.1, Sun & VCS Clusters,Oracle 11gR2, 10gR2 RAC, 9.2.x, Shell Scripts, Toad, OEM

Responsibilities:

• 24 x 7 Production Oracle Database support and administration.
• Involved in the implementation of High Availability solutions with Oracle 10g and testing on 11gR2.
• Built and supported multiple 2 Node Oracle 11gR2 RAC clusters on RHEL 5.6
• Added nodes to existing 11gR2 RAC cluster to expand from 2 to 4 Nodes.
• Support & Maintain 3 Node Oracle 10g R2 RAC and Data Guard.
• Cross platform database migration - Migrate databases from Solaris to AIX.
• Medium 200GB to Large > 4TB sized Database migration as a part of the Data Center hardware refresh.
• Upgraded databases from 10gR2 and 11gR2.
• Part of the team to test Oracle 11gR2 TDE (Tablespace Encryption) to encrypt “Data at Rest” for Security and PCI Compliance.
• Encrypted a database of size ~1TB with Oracle 11g TDE and migrated the database to ASM in parallel with minimal downtime and business impact.
• Installed multiple Oracle 11gR2 Grid Homes for using ASM on standalone Solaris & AIX servers.
• Migrated multiple databases from Non-ASM to ASM including Standby and Primary databases with minimal possible downtime.
• Implemented Oracle 10g, 11g Physical Data Guard and Streams 10g for data replication and High Availability based on the SLA and database usage requirements.
• Provide recommendations on database and application architectural changes for new and redesign projects.
• Good understanding and expertise in supporting vendor developed products.
• Work closely with the vendor to implement optimal database model and architecture for their application to achieve better performance as well as to meet the company’s security and compliance standards.
• Implemented Partitioning to improve performance, reduce maintenance and meet the business requirements for data retention.
• Developed generic scripts for Partition Maintenance Daily, Weekly, and Monthly to meet information life cycle management policy and application needs.
• Optimizing the SQL statements for optimum performance by using SQL TRACE, AWR, ASH, TKPROF, ADDM, EXPLAIN PLAN and STATSPACK.
• Work closely with application and business teams to understand the requirements and provide optimal database architecture to meet the SLA requirements.
• Actively involved in application load testing.
• Continuous Performance monitoring and tuning of the databases and application using OEM Tuning Pack, Diagnostics pack, etc.
• Database and Query tuning to improve database response time for each transaction and help applications process without any issues at higher TPS volumes.
• Applied High priority, security patches for audit and PCI Compliance
• Documented and automated procedures for disaster recovery tests.
• Work closely with System Administrators and implement Hardware Clusters VCS to provide high availability solutions for databases in Non-RAC environments.
• Good experience in Shell Scripting.
• Backup and Recovery using RMAN with external tape backup system.
• Provide updates to existing generic backup scripts to meet the requirements with changes done to the database architecture.
• Involved in standard database patching, monitoring and maintenance.
• Work closely with Off Shore team to handle work load and production support.
• Cloned / Refreshed Database environments for performance testing.
• Created scripts to monitor and manage the databases.

Confidential, MN

Database Administrator

Environment:Sun Solaris 2.8/2.10, AIX 5.3, RHEL 5, HP-UX, VM WareOracle 11gR2, 10gR2, 9.2.x, GoldenGate, Shell Scripts, Toad, OEM

Responsibilities:

• 24 x 7 Production Oracle Database support and administration.
• Reviewed existing architecture and provide recommendation for improvements.
• Automated various database maintenance tasks to reduce on-call pages.
• Developed scripts for Automatic Trace and Dump File cleanup on all database servers.
• Developed scripts to automate Tablespace maintenance on all database using ASM storage.
• Worked with the planning and implementation teams to improve the existing Patching process.
• Provide support to multiple day to day issues reported by end-user.
• Worked closely with all critical application teams to resolve performance issues during peak times.
• Identified bugs and worked with Oracle Support to get the required patches.
• Support GoldenGate replication to and from Warehouse and multiple downstream databases.
• Recommended the use of Oracle Physical DataGuard over the in-house developed replication process.
• Worked closely with the implementation team to develop a standard oracle database and server setup checklist.
• Reviewed and recommended changes to the current database Backup Architecture.
• Refresh Dev, Test, Pre-Prod databases from Prod on a regular basis.
• Redesigned the existing refresh process for 10g Databases from Hot-Copy to use RMAN Duplicate and reduce the downtime.
• Used RMAN 11g Active duplicate to clone all 11g Production databases into Pre-Prod and Test environments.

Confidential, NJ

Database Administrator

Environnent:AIX, RHEL, Oracle 10g, 9i

Responsibilities:

• Installing and configuring Oracle Enterprise Edition and Clients on Unix Servers.
• Handling day-to-day activities.
• Applying Database Patches from time to time.
• Upgrade Database from 9.2.0.x and to 10.2.0.x
• Storage and space management including table spaces and data files.
• Monitoring Database for fragmentation and correcting them.
• Planning and implementation of Backup and recovery procedures and maintenance of Database.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Setup the remote connection to the users across various departments.
• Installation, Maintenance and Administration of Oracle for the developers & testers.
• Management of table space growth, monitoring data files additions, extent growth
• Remote Database Maintenance.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Implemented Physical Data Guard for high availability/disaster recovery purpose
• Support the development team to solve issues with the new enhancement releases.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.
• Involved in the process of tuning and refining queries of various applications.

Confidential

Database Administrator

Environment:Solaris, Windows, Oracle 8i, 9i

Responsibilities:

• 24 x 7 Production Oracle Database support and administration.
• Installation, Configuration, Upgrade, Patching of Oracle RDBMS.
• Responsible for installing, migrating and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Creating primary database storage structures.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Scheduling jobs through Oracle job Scheduler.
• Applied DB patches using OPATCH utility.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Designed/implemented table-partitioning Range, List, Range-List on large tables for optimal query performance.
• Capacity planning for storage space and hardware upgrade requirements.
• Using TKPROF, EXPLAIN PLAN, STATSPACK, and AWR for the performance tuning.
• Diagnose and troubleshoot Database problems and failures.
• Created various Shell Scripts for scheduling database backup as well as cleanup jobs for database audit and dump destinations.
• Maintained the batch processes using Unix Shell Scripts.
• Creation of Database Objects like Tables, Views, Synonyms, Sequences, Procedures, Packages and Triggers.
• Documentation and development of existing data-model.
• Attend ongoing meetings and change management reviews.
• Creating and refreshing materialized views.
• Created PL/SQL procedures (jobs) to automate some maintenance tasks.
• Performing all daily Maintenance tasks. Interacting with Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.