SUMMARY

• Highly motivated, deeply driven Oracle Database Administrator with 7+ years of experience.
• Expertise in Oracle Database Administration, Database Architecture.
• Expertise in leading the teams for maintenance of 24X7 high - availability applications.
• Dealt with development and production 11g/10g/9i/8i databases in variety of environments including Sun Solaris, Red hat Linux IBM-AIX, HP-UX, Microsoft Windows 2000/NT Servers and Linux.
• Experience with Oracle 11g/10g/9i/8i Installation, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
• My Skill set includes defining, developing, and modifying database systems, building the logical design model of a database, administering databases.
• Experience in meeting schedules and budgets, working with developers in performance tuning design.
• Experienced in using 10g features Datapump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Oracle Cluster ware installed to provide infrastructure for RAC and configured 3 node Oracle 10g RAC with ASM.
• Expertise in Oracle Data Guard, Cloning of Database.
• Expertise in Backup and Recovery activities using RMAN utilities.
• Load data from OLTP systems into data warehouse databases.
• Installed and configured the oracle10g RAC on RED HAT Linux AS4 and have migrated databases in different platforms to same single centralized database server.
• 11gRAC, 10gRAC, 9iRAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Experience in Managing/working oracle Golden Gate installation and configuration.
• Experience in installation and configuration of GoldenGate11g to support data replication in Oracle Database environment.
• Experience in installing and configuring Golden Gate 9.5.
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experienced in utilizing Golden gate replication technology for ORACLE Upgrades.
• Experience in implementing 10g Grid monitoring application to monitor the Oracle Applications and Database.
• Experience in creating and managing Standby database using Data guard.
• Created the Migration Scripts for the migration from old system to new system.
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance tuning.
• Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
• Up gradation and Migration of Database from 10g to 11g and applying patches whenever required.
• Expert in configuration of Hardware Clusters Environment.
• Experience in disaster recovery environments configuration in 24*7 environments using 9i Data Guard, 10g data guard.
• Performed numerous data refreshes from Prod to Non-Prod for Application bug fixes and performance testing using RMAN Duplicate/ DATAPUMP.
• Worked extensively with configuring database backups in RMAN environments using TSM, Net backup and Commvalut backup utilities.
• Extensive experience with AWR, ADDM, ASH STATSPACK, ORADEBUG, HANGANALYZE, PSTACK, TRUSS.
• Extensive experience with DBMS API’S and V$VIEWS, TOAD, Quest Spot Light, BMC Patrol and 10g Grid.
• Installation, Configuration and deployment of Oracle 10g database and Real Application Clusters (RAC) on multi nodes with Automatic Storage Management (ASM), VCFS, OCFS
• Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Extensive experience with proactive monitoring the databases using 10g Grid Control Monitoring.
• Expertise in using Golden Gate to support data replication in the Oracle database environment.
• Exposure to MS SQL Server 2005 Installation, Configuration, Maintenance, Backups & Restores, Security Management, DTS import/export, Performance Tuning.
• Strong Object Oriented Analysis (OOA), Design (OOD) and Programming (OOP) skills.
• Expertise in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.

TECHNICAL SKILLS

Operating Systems: Unix, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 4.3, 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x,5 and Windows 98/2000/XP

Databases: Oracle 11g/10g RAC/9i/8i, Microsoft SQL Server 2005,2008

DB Utilities: Grid Control, 10g Data Pump, SQL Loader, oracle Data Pump Data guard, Export / Import, TKPROF, Statspack, Export/Import.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH REPORTS.

Languages: SQL, PL/SQL, C,C++,UNIX Shell Scripting, Perl, XML,HTML., Java

Tools: Oracle Enterprise Manager, TOAD 8.5, SQL Developer, Putty, F-Secure Client, Hummingbird, SQL*PLUS, SQL- Navigator, ERWIN, Golden gate, MS Visio, Database Replay, Log Miner and Flashback data Archive, RMAN.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Oracle Database Administrator

Environment: Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1) 11g (R1&R2) AIX, RS6000, SQL Tools, Solaris 3500, Solaris 10k,OEM Grid control, RMAN, RAC,Data Guard.

Responsibilities:

• Involved in 35 production databases and 65 development/test databases.
• Working on AIX with OEM Grid control to maintain the database effectively.
• Proactively monitoring the database.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine tuned further.
• Actively involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Implementation and configuration of OEM Grid on Oracle Server for maintenance and monitoring data.
• Setup and configured Oracle Physical Standby database (Data Guard) for disaster recovery as well as to offload the running of huge reports.
• Generated and analyzed STATSPACK, AWR, ADDM reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Database cloning/exp/imp tables to setup identical databases in the production and development environments.
• Performed Cloning/Refresh to setup Test and Development database.
• Create and maintain users, roles and privileges & Auditing Triggers.
• Upgrade/Migrated the production and development databases from 9i to 10g, 10g to 11g.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans while working with oracle structure.
• Setup and configured 2 node Oracle 10g RAC with ASM.
• Maintaining, Building and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Transformed logical database designs into physical databases.
• Build and implemented test, quality assurance, production databases and environments.
• Coordinated strategies to move data between databases.
• Monitored database space requirements and adjusted for future needs.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Composed, maintained and monitored compliance to standards and practices.
• Assisted IT Analysts on technical database issues and features.
• Resolved data integration issues.
• Ensured data is being maintained effectively by monitoring data maintenance.
• Performed version upgrades and patch installs.
• Automate Logical Backups using export/import, data pump on applications through grid control.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Extensively worked with ASMCMD for managing ASM environment.

Confidential, Plano, TX

Oracle Database Administrator

Environment: Oracle 8i/9i/10g/11g RAC/stand alone databases, HP-UX v11i, HP 700 Series, Sun 3500,3800,6800, Sun Enterprise 450 & 880, T2000, Solaris 9.0/10.0/11.0 , 10g/11g Data Guard, ASM 10g/11g, 10g Data pump, Export/Import, Physical Backups, Oracle Enterprise Manager, 10g/11g Grid Control, Autosys and DBArtisan.

Responsibilities:

• Provided 24x7 on call support for all the production and development databases.
• Responsible for Database Administration of Oracle RAC 10g/11g and non RAC databases on ASM with size of databases varying from 20GB to 10TB.
• Managed Physical & Logical standby databases in RAC and non-RAC environments.
• Implemented 10g/11g Data guard with one physical database.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• PL/SQL, Performance Tuning, Application Tuning and Monitoring.
• Implemented 11gR2 Data Guard using RMAN duplicate.
• Managed Oracle Grid control 10g and configured Data Guard for OMR in Linux environment.
• Performed Oracle database upgrade from 10g to 11g in Linux RAC environment.
• Worked with sysAdmin to configure Veritas Cluster Server Global Cluster Option (VCS -GCO) and coordinated Disaster recovery, fire drill for critical applications.
• Extensively used AWR, ADDM for database performance statistics.
• Performed Oracle database upgrades from 10g to 11g in Solaris RAC environment.
• SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.
• Worked with OIDCTL, a command line utility tool for starting and stopping the OID server.
• OEM / GRID (OGC) installation and configuration for monitoring and performance tuning.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Implemented and supported Oracle RAC 10gR2.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Installed, configured and maintained ASM enabled RAC 10g database.
• Implemented streams and Logical standby replication.
• Responsible for configuring Streams.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Performed Cross platform migration using transportable table spaces and RMAN.
• Extensively used Oracle Application Server 10g, in deploying and integrating enterprise’s applications.
• Configured schema level logical backups (data pump) in 11g OEM Grid Control.
• Install and configure Oracle Golden Gate and Veridata, debugging Golden Gate issues such as abend.
• Worked extensively on Autosys in configuring, deleting, preparing and editing JIL for jobs, moving jobs in Crontab to Autosys.
• Extensively worked on configuring OEM grid control agent on new servers, registering new databases in 11g OEM Grid Control and automated RMAN and data pump backups in 10g/11g OEM Grid Control.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Performed Oracle Database upgrades from 10gR2 to 11gR1 & 11gR2 in RAC environment.
• Upgraded databases from 10. .2.05 and 11.2.0.1 to 11.2.0.2.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues.
• Involved in Creating, configuring Access Control List (ACL) for 11gR1, 11gR2 databases.
• Checking database performance on a regular interval, which includes checking various log files.
• ASM implementation & maintenance.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Extensively on Oracle 10g, 11g grid control (OGC), Putty, sql*plus, RMAN, Data Pump.
• Configured and automated RMAN backups through Grid Control.

Confidential, SAN FRANCISCO, CA

Oracle Database Administrator

Environment: Oracle 9i/8i, SQL, RMAN, SQL* Loader, SQL* Net, SQL* Plus, UNIX, Statspack, Export / Import, AIX.

Responsibilities:

• Managed and supported 30+ Oracle databases.
• Create or clone the Oracle Instance and Databases on ASM. Perform database cloning and re-location activities.
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources and password security.
• Managing Users, Privileges and Roles.
• Install Oracle software and patches.
• Upgrading the 8i databases to 9i including data guard.
• Upgrading the Database from lower version to higher version.
• Tune SQL statement against database and its objects.
• Write script to monitor the database with shell and PL, SQL code or SQL PL, SQL code such as procedure, function, and package.
• Added, modified or removed users, roles and privileges, profiles, and other data accesses.
• Performed Windows Server and UNIX system administrator tasks as part of maintenance.

Confidential

Associate software Engineer

Environment: SQL *Plus, Oracle 8i, PL/SQL, Windows-NT, Sun Solaris.

Responsibilities:

• Installation of Oracle 8i on Sun Solaris.
• Developing PL/SQL programs for data manipulation.
• Installation of Oracle client tools and establishing connectivity to databases
• Creating table spaces, tables, indexes, users, etc.
• Cloning databases and partitioning tables.
• Providing assistance in physical data modeling.
• Managing security.
• Sizing database objects for effective space management and optimal performance.
• Created different Unix Shell scripts to help stress analysis tasks.
• Managed the existing databases by applying new required release modification to existing database structure and applied new Oracle patches as required.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

Confidential

Associate SQL Developer/Administrator

Environment: Oracle 8i, PL/SQL, PowerBuilder 5.0/4.0, Windows NT/3.11

Responsibilities:

• Provided support for all the databases as an operational database administrator.
• Installed and configured Oracle 8i database.
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, and backup and recoveries.
• Responsible for optimizing the queries and application tuning.
• Created roles, profiles and privileges and assigned roles to users.
• Execute physical database changes required by applications
• Strong Knowledge of Creating Public Synonyms, DBlinks, Ref Cursors, Parameterized Cursors.
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Analyze, design and implementation of the Database for e-commerce system.
• Implement “Stored Procedures and Triggers” based on business plans using PL/SQL.