SUMMARY

• Around 7 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 RedHat Linux, Sun Solaris, IBM AIX, and WINDOWS NT / 2000 / 2003.
• Oracle Database Administration on 24x7 critical production and large databases Oracle 11g RAC, 10g RAC& 9i.
• Experience in variety of operating systems of UNIX/LINUX and WINDOWS.
• Worked on various Oracle Solutions like Data Guard, RAC, RMAN, OEM Grid Control.
• Experience in databaseinstallation, configuration, upgrades, and Performance Tuning.
• Good knowledge on Oracle technology architecture and Real Application Clusters.
• Worked on various 10g & 11g features like ADDM, AWR, OEMGrid Control Monitoring, Data Pump, ADRCI etc.
• Hands on experience wif 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.
• 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, TKPROF, 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 wif 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, 10g to 11g
• Knowledge on Oracle Support processes for technical requests wif 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 wif ability to work wifin 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, Red Hat Linux, AIX, HP-UX, Windows

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, GoldenGate, Streams, Oracle Data Integrator

DatabaseModeling: ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Database Administrator

Environment: Sun Solaris, AIX, HP-UX,RedHat Linux Oracle 11gR2 RAC, 10gR2 RAC, 9.2.x, Shell Scripts, Toad, OEM, ERWIN

Responsibilities:

• 24 x 7 Production Oracle Database support and administration.
• Involved in the implementation of High Availability solutions wif Oracle 11g RAC and Standby Databases (Oracle DataGuard)
• Built and supported multiple node Oracle 11gR2 RAC
• Added nodes to existing 11gR2 RAC.
• Cross platform database migration - Migrate databases from Solaris to AIX.
• Upgraded databases from 10gR2 and 11gR2.
• Provide recommendations on database and application architectural changes for new and redesign projects.
• Logical database design, Physical database design.
• Capacity planning and bench marking.
• Partitioned tables for better performance and manageability.
• Good understanding and expertise in supporting vendor developed products.
• Work closely wif 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.
• Shell script development for backup automation, custom monitoring.
• Optimizing the SQL statements for optimum performance by using SQL TRACE, AWR, ASH, TKPROF, ADDM, EXPLAIN PLAN and STATSPACK.
• Work closely wif application and business teams to understand the requirements and provide solutions.
• Written SQL, PL/SQL programs (Functions, Procedures, Packages and Triggers.
• Continuous Performance monitoring and tuning of the databases and applications.
• Applied High priority, security patches
• Documented and automated procedures for disaster recovery tests.
• Backup and Recovery using RMANand conventional cold, hot and logical backups.
• Involved in standard database patching, monitoring and maintenance.
• Work closely wif Off Shore team to handle work load and production support.
• Cloned / Refreshed Database environments for development and testing.
• Created scripts to monitor and manage the databases.

Confidential, Eden Prairie, MN

Database Administrator

Environment: Sun Solaris, AIX, RHEL, HP-UX, Windows, VM Ware Oracle 11gR2 RAC, 10gR2, 9.2.x, GoldenGate, Toad, OEM, ERWIN

Responsibilities:

• 24 x 7 Production Oracle Database support and administration.
• Involved in the implementation of High Availability solutions wif Oracle 11g RAC and Standby Databases (Oracle DataGuard)
• Built and supported multiple node Oracle 11gR2 RAC
• Added nodes to existing 11gR2 RAC.
• Cross platform database migration - Migrate databases from Windows to Linux.
• Reviewed existing architecture and provide recommendation for improvements.
• Automated various database maintenance tasks to reduce on-call pages.
• Developed scripts for backup automation and custom monitoring.
• Worked wif 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 wif all critical application teams to resolve performance issues during peak times.
• Identified bugs and worked wif 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 wif the implementation team to develop a standard oracle database and server setup checklist.
• Written SQL, PL/SQL programs (Functions, Procedures, Packages and Triggers.
• Reviewed and recommended changes to the current database Backup Architecture.
• Refresh Dev, Test, Pre-Prod databases from Prod on a regular basis.
• Cloned database from production to development and testing.

Confidential, Northbrooke, IL

Database Administrator

Environment: AIX, RHEL, Windows, Oracle 11g, Oracle 10g RAC, 9i

Responsibilities:

• 24 x 7 Production Oracle Database support and administration.
• ImplementedHigh Availability solutions wif Oracle RAC and Standby Databases (Oracle DataGuard)
• Handling day-to-day activities.
• Applying Database Patches from time to time.
• Upgrade Database from 9i to 10g, 10g to 11g
• 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 wif 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: Sun Solaris, Windows, Oracle 8i, 9i, 10g

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.
• Written SQL, PL/SQL programs (Functions, Procedures, Packages and Triggers.
• Performing all daily Maintenance tasks. Interacting wif Oracle Customer service as and when required.
• Writing scripts for the system and database for the effective functionality and report generation.