SUMMARY

• Around 7 years of experience as Oracle Database administrator, having hands on experience in database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (8i, 9i, 10g, 11g) on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows 2000/2003/2008 Platform
• Experience in Configuring Single instance to multimode, Oracle Real Application Clusters (RAC), Automatic Storage Management (ASM), Data guard and Golden gate
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• Experience in working with Grid Control and Oracle Enterprise Manager (OEM). Grid Control for maintaining many databases together on separate servers.
• Experience as On-Call 24x7 production DBA support, system Storage Management (ASM).
• Expertise in Installing and configuring ASM and RAC for high availability databases.
• Performed Strategic Planning, Logical and Physical Data Modeling & Application Tuning.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities by Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM).
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Expertise Oracle Enterprise Manager (OEM), Grid Control, TOAD, RMAN.
• Cloned Database from Production to Test and Development and from Development to Production.
• Experience in migration of oracle database to higher version and installing patches.
• Exporting and Importing of dumps using expdp and impdp.
• Knowledge of new features in 11gR2, like Omotion, RAC-One Node and replication using Oracle Golden Gate.
• Experience on handling very large database (vldb).
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Resolved database network problems using Oracle Net Configuration Assistant(NETCA) and Virtual IP Configuration Assistant (VIPCA) and a very good team player, self-motivated, dedicated in any work environment.

TECHNICAL SKILLS

OPERATING SYSTEMS: HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003.

RDBMS: Oracle 8i/9i/10g/11g, Oracle 10g/11g Real Application Clusters (RAC),Golden Gate(GG), SQLServer2005

LANGUAGES: SQL, PL/SQL, C#, C, C++, XML, Perl scripting, Shell Scripting.

SOFTWARE/ APPLICATIONS TOOLS: OEM, DATAGUARD, Recovery Manager (RMAN), Datapump, STATSPACK, AWR, TKPROF, ADDM, ERWIN, Teradata, ETL, Clusters, VERITAS Backup, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD.

WEB TOOLS/REPORTING TOOLS: HTML, XML, Discoverer, DBI, BO, crystal reports.

PROFESSIONAL EXPERIENCE

Confidential, South San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Configuration, Installation and maintenance of Oracle 11g RAC databases including ASM and CRS.
• Performed upgrades from Oracle 10g to 11g and applied patches.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities. Implemented 10g RAC on a test basis.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Installation of Oracle database 10g software with RAC using Oracle Clusterware. Oracle Data Guard setup done for RAC. Installation of Oracle 10g management agent and grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning.
• Extensively used PL/SQL for designingpackages, stored procedures, functionsand databasetriggers.
• Created Cluster database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables.
• Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.

Environment: Operating Systems: IBM-AIX, SunSparcSolaris64bit, and Redhat Linux. RDBMS: Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, PL/SQL

Confidential, Irvine, CA

Oracle Database Administrator

Responsibilities:

• Installed Oracle 10g database on Sun Solaris, Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (10g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Haveworked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 4.3.3, HP -UX 11.23, Solaris, Windows XP, Oracle 9i/ 10g, RAC, OEM, Grid ControlRMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0

Confidential, NJ

Oracle DBA

Responsibilities:

• Administration of a 3 node RAC, configuring and monitoring daily backups, troubleshooting errors, to improve performance.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Creating new environments for data loading and manipulation for various states in the US, according to the specification provided by Century Link.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Involved in the documentation of every task involved in the recovery issues or backups.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without roadblocks.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Creation of various database objects including materialized views.
• Troubleshooting errors and using the expdp/impdp utiliy on a very regular basis for copying data across schemas.
• Running scripts and monitoring the load process to avoid roadblocks in ETL jobs running for a long duration.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.
• Monitored Database growth and provide Database capacity planning for applications expansion.
• Upgraded from 9.2.0.x to 10.2.0.x.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD, Solaris8,9.

Confidential

Oracle Database Administrator

Responsibilities:

• Installing Oracle 9i and upgraded it to latest 9i patch set on HP-UX 11.23.
• Migrating applications from non-clustered oracle 8i/9i databases to new 10g RAC Database environments.
• Monitoring and supporting Applications using OEM 9i Grid Control.
• Configured two node Oracle 9i RAC cluster.
• Created PARTIONING of its types like Range, List & Hash by the specific use.
• Implemented Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams.
• Registering Databases to RMAN Catalog.
• Planning and scheduling Backups, RMAN, taking Logical Backups.
• Experience in Export/Import and Datapump.

Environment: Oracle Grid Control, Oracle 9i, HP-UX 11.23

Confidential

Oracle Developer

Responsibilities:

• Upgrading, analysis and testing of the test and production database.
• Perform capacity planning required to create and maintain the database environments.
• Implemented Oracle New features like SPfile, Shared Severs, Locally managed Temporary tablespace, UNDO tablespace and RMAN
• Involved in Gathering the Requirements for creating data models for data analysis and reporting.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Assisted in Installing Application Server, Report Server and Database Server.
• Worked on PL/SQL (Oracle 9i, 10g), PL/SQL Developer/TOAD, Unix/Linux, Crystal Reports (Business Objects XI).
• Involved in importing the production data to lower environments for testing purpose.

Environment: Windows 98/NT/2000, HP-UX, Oracle 8i/9i, Toad V8.0, Net8, Database Tools/Utilities.