SUMMARY

• Over 8 years of hands on experience on Oracle (8i/9i/10g/11g) Oracle database Administration, RAC Administration, Schema implementation, Tuning, Backup, Recovery, Cloning and Performance monitoring.
• Experience in supporting medium (GB size range) to very large databases (TB size range)
• Responsible for both managing and supporting all Production, Development and Staging instances of Oracle Version’s 8i, 9i, 10g & 11g.
• Configured and maintained Real Application Clusters environment for high availability and scalability.
• Configured Automatic Storage Management (ASM) for 10g RAC databases for reducing disk contention and providing centralized management for Disks.
• Experience in implementing Automatic Storage Management for simple storage interface.
• Experienced in installation and administration of 11g and10g RAC databases
• Experience in DB Upgrade from 9i to 10g /11g.
• Cloning of 11g, 10g and 9i Oracle software's from Golden copies to development, test and production environment for clean Database patching and upgradations.
• Configuring and Administration of Real Application Clusters (RAC) using SRVCTL and CRSCTL utility
• Experience in configuring Data Guard 9i, 10g and 11g Primary and Physical Standby Databases.
• Experience in configuring and managing backup & recoveries through RMAN utility.
• Experience in writing various Shell/PERL Scripts for automation and monitoring of databases.
• Experienced in database migration using Transportable Table spaces. .
• Oracle Database capacity planning, space management and storage allocation.
• Experienced in Hot /Cold Backup& Recovery andCloning of databases using RMAN.
• Experienced in performance monitoring/tuning/troubleshooting.
• Worked on Data transferring with export/import utilities for schemarefreshes Prod to Dev
• Experience in Oracle import / export utility, SQL* Loader and performance tuning by using SQL Trace / TKPROF / Explain Plan.
• Knowledge in INV/OM/BOM/PO/AP/AR/GL/HR/ Payroll/iRec/ Customer Support Modules.
• Performed Applications DBA activities on different platforms like Red Hat Linux, HP - UX, Sun Solaris and AIX
• Communicate and interact with Oracle Corporation Support, Development and other technical staff on a daily basis to report problems and patch issues and working towards resolving the same

TECHNICAL SKILLS

Operating System: MS Windows 98/2000/NT/XP/Vista,7,8 ; HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6,5, 8, 9, 10, AIX 5.1, 5.2, Red Hat Linux 2.1, 3.x, 4.x, 5.x

Programming Languages: SQL, PL/SQL, C++, Unix Shell Scripting, Java

RDBMS: RAC, Oracle 8i/9i/10g/11g, SQL Server 2008

DBA Utilities: OEM, DBCA, Data Pump, Export/Import, SQL*Loader, TOAD.

DR Technologies: Oracle Data Guard and Broker, Oracle Golden Gate, Oracle Streams

Backup & Recovery Tools: RMAN, Flash Recovery

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, 10046 TRACE, AWR / ADDM / ASH

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Oracle Database Administrator

Responsibilities:

• Actively involved in physical standby configuration for production and Dev/QA single instance and RAC databases. Converted single instance database to 2 node RAC database.
• Archive production data from partitions based on BU online retention policy to support capacity management and prevent database growth.
• Lead in oracle track knowledge transfer from Fox to HCL during transition of operations to HCL, co-ordinate, support and build knowledge base for off-shore operations team. Created/updated knowledge transfer document/runbooks, processes to abreast all members of oracle database track.
• Deploy production changes working in accordance with application team, setup/plan pre-deployment strategy, rollout/rollback plan in case of unsuccessful deployment.
• Setup maintenance jobs using cron, autosys scheduling tool and database jobs. Monitor database on daily basis with respect to database growth, performance and security. Maintaining database level security using permissions, privileges, oracle wallet and application specific requirements.
• Dev/QA/Staging database refresh from production using RMAN, cold refresh, schema level and export and import. Migrated databases to different servers, operating system and mount points/directories. Upgrade databases, oracle clients on application servers.
• Recover databases, schema, tables from backup as per business and applications requirement and following downtime schedules. Set schema level refresh jobs through cron and Autosys jobs.
• Plan, execute and performed re-org of production database tables improving performance significantly. Provided on-call support to production, dev/QA databases, database backup and Daily refresh staging database.
• Install oracle database software, client, create/drop/retire databases, locate root cause for an incident or issue.
• Co-ordinate and manage shift handover between regular business shift and second shift. Monitor, manage oracle database operation incident/change/task queues, assigning resource for database related activities.
• Support multiple severity issues and working accordingly with Oracle Support, raising and updating SR/TAR and handling call with Oracle engineer.

Environment:Oracle 9i/10g/11g, RHEL4, Sun Solaris 9/10, EMC and Veritas BCV/SAN Storage, RMAN, TKPROF, RAC and Physical standby, PL/SQL, SQL *PLUS and Symantec Netbackup 6,7

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Installed, configured and maintained Oracle 11g R2 on Linux also Upgraded from Oracle 10g to 11g
• Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Very good Knowledge on 11g New Features.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among the servers.
• Involved in configuration of Golden Gate
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Experienced in dealing with Query execution plan, SQL trace, TKprof.
• Used Data pump to perform schema/table refreshes
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Worked with offshore team to transfer any outstanding issues as per the schedule.

Environment: Oracle 11g/10g,HP-UX UNIX RHEL 5.x, ASM 10.2.0.4, CRS 10.2.0.4, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Toad, VERITAS Net Backup.

Confidential, Miami, FL

Oracle Database Administrator

Responsibilities:

• Worked on to gather requirements for Database upgrades from 10g to 11g. Creating the database, tables, table spaces, data objects, setting privileges, indexes, user logins, password (security).
• Creating new databases, configuring backups and maintaining the databases. Tune the databases and SQL queries. Backups using vendor specific tools and Oracle utilities like RMAN. The tuning & indexing database & schema for efficient query execution plan. 24/7 support for 200+ Production/Development/Testing databases. Used Explain Plan, TKPROF, and SQL Trace to tune database applications
• Improve performance by selectively reorganizing and defragmenting databases objects. Create and maintain the standby database to minimize damages caused by the downtime of the production database.
• Write shell scripts to implement strategies for backup.
• Provide Primary CARE DBA support for Oracle Applications and Administration, Configuration and Maintenance of RAC (Real Application Cluster) and Non-RAC Databases. Work within the production support team and maintain operational consistency and efficiency.
• Provide input to Project and Enhancement teams to define database storage structures (table spaces) after application developers have designed an application. Implementation of reviewed changes to production databases. Developed some UNIX Shell scripts to automate database operation and database monitoring.
• Used Export/Import to do table level and full database defragmentation. Provided on-call production database support. Creating Indexes and Monitoring Performance. Data loading using SQL Loader (from Text files to Database). Perform Daily Logical backups using exp.
• Perform RMAN operations (Incremental Backups). Helped developer to install Oracle Client, troubleshoot and establish connection to Oracle database. Performed SQL Tuning by using explain plan and TKPROOF.
• Daily Monitoring Database and Table spaces Growth & Monitoring Space Availability at operating System.

Environment: Oracle 10g, Sun Solaris, RAC, Toad 9.5, Erwin7.1, PL/SQL, SQL*LOADER, SQL PLUS, UNIX shell scripts.

Confidential, IL

Jr Oracle Database Amdin

Responsibilities:

• Created and maintained various databases for Production, Development and Testing using Oracle 9i, 10g.
• Active member of the on-call team to support Clients of different Applications relating to our team 24/7, to keep the High critical systems running.
• Used RMAN to configure various operations in Data Guard.
• Monitoring the performance of Redo Transport Services.
• Worked on rolling patching on a 2 node 10g database.
• Cloned database from PRODUCTION to create TEST and DEVELOPMENT.
• Created and managed tablespaces monitored the datafiles space, resizing and adding new datafiles etc.
• Monitor long running queries, error logs, Schedule tasks, database activity, eliminate Blocking and Deadlocks user counts and connections/locks etc.
• Managing database security, creating and assigning appropriate roles and privileges to users depending on the user activities.
• Developed Oracle backup and recovery scripts using RMAN utility.
• Monitoring Cold, Hot and RMAN backup scripts of the databases supporting different applications.
• Validating and testing daily backups and coordinating with the customers during maintenance activities and system reboots.
• Used AWR, ADDM and for trouble shooting performance issues.
• Performed Database Reorganization regularly for removing row migrations and fragmentation using export and import utilities. Worked on tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.
• Transported the tablespace from production database and plugged-in it in development database for the usage of developers.
• Attended the technical presentations/demonstrations from the vendors, evaluated the vendor products against the business needs and recommended the most efficient & cost effective solution.

Environment: Oracle 9i,10g on RAC, Oracle Enterprise Manager, Oracle Grid control, Redhat Linux, HP-UX, PL/SQL, TOAD and SQL *Plus.

Confidential

Database admin

Responsibilities:

• Installation, configuration, and maintenance of Oracle 8i and 9i on Linux - RedHat environment.Create and Maintain Roles and assign necessary privileges to users according to business rules. Implemented Database Backup (Physical & Logical) and Recovery strategy. Configuring TNSNAMES.ORA and LISTENER.ORA for Client-Server connections. Monitoring Alert Logs
• Creating & Maintaining Tablespaces.Choosing different types of data storages (Locally Managed Tablespaces, IOT and partition tables) and indexes in order to have good performance for SQL and DML.
• Tuning Oralce9i database server using tools dynamic, dictionary views, Statspack, Utlbstat, Utlestat, Diagnostic and tuning packages. Created & Configured RMAN recovery.
• Backing up the production database, synchronizing the standby database by responding to any physical changes in the primary database.Work as part of a team and provide 24*7 support when required

Environment: Oracle 8i, Oracle 9i, Linux - RedHat Platform

Confidential

Oracle Database Admin

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development Oracle 9i Databases.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery.
• Involvement in all phases of the project life cycle.
• Responsible for troubleshooting hardware and software issues.
• Responsible for Operating System Installation and updates.
• Responsible for updating the database with the information received from various vendors.
• Analyzed the structures using Analyze command.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Taking Backups on scheduled time and Monitoring Scheduled Backups.
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloned Environments to create Patch Test, Development and QA Environments.
• Partitioned large tables to increase the performance.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Resolving technical issues and Troubleshooting.

Environment:Windows 98/XP/NT, UNIX, Oracle 9i, RMAN, Data Guard, CRONJOB, TKPROF, EXPLAIN PLAN, MS Office.