Professional Summary

• 8+ years of experience, as an Oracle DBA with expertise in 8i/9i/10g/11g installation, maintenance and administration including capacity planning, database security, backup and recovery for oracle 8.x, 9.x, 10.x, 11.x using RMAN.
• Worked on advanced queuing, developing disaster recovery strategy, configuring oracle stream, performance tuning of OLTP databases.
• Experience in Oracle Parallel Server and Maximum Available Architecture using Real Application Cluster and Golden Gate implementation.
• Expertise in technical consultation for the design, development and implementation of enterprise data strategies, data warehouse and RDBMS (Oracle 8i, 9i, 10g and 11g)
• Very strong experience in Physical and Logical Data Modeling, relational data, Erwin, ETL.
• Thorough understanding of data warehouse principles, star schema designing and deployment, designing summary layer to be used for reporting tools like crystal reporting, transform database models and entities into database objects.
• Experience in installing software, maintenance, backup and recovery for Sybase ASE 12.5 and MS-SQL 7.0
• Pro active. . Motivated. Goal-oriented. Problem Solver.
• Excellent Team player, Strong leadership, A good Mentor , good communication and interpersonal skills.
• Willingness to learn and adapt new emerging software technologies.

Education

Degrees

• BS. Electronics and Instrumentation

Certifications

• Oracle Certified Programmer, Feb 2007.

Training

• Oracle Apps 11i.
• Oracle Workflow and User Management.
• Oracle 9i RAC concepts.
• DR setup and implementation.
• Logical Modelling of OLTP and OLAP databases
• PCMM Level-5 process training.

Languages:

ASP,PL/SQL programming, Unix Shell Scripting

Oracle:

Oracle 11i instances(1.5.5-11.5.10),10g discoverer, Oracle Application Server 9iAS and Oracle Application Server 10g,Oraclr Release 12

RDBMS:

Oracle 11g,10g,9i, 8.1.7, 8.0.6, Real Application Clusters (RAC) 9i-11g, Data Guard, RMAN, HP Service Guard, VERITAS Cluster Server, Oracle Failsafe, OID/LDAP, SQL Server 7.0.,

Modules:

Oracle HRMS, Financials, Purchasing

Operating Systems:

HP Unix 11I(11.11), Linux, AIX, Windows 2000 Professional, Windows NT, Sun Solaris 5.8, SCO-Unix, Windows NT/2000, UNIX System Support

Hardware:

HP Super Dome and HP L-Class Server and HP MCService Guard Cluster

Tools:

Oracle Enterprise Manager (OEM), Oracle Statspack, Toad/SQL Navigator, Quest Spotlight, Oracle Autoconfig and maintenance wizard, Winrunner,

Config. Mgmt.:

Visual Source Safe, Clear Case.

Experience

Title:

Senior Oracle DBA

Client:

Confidential,Cupertino, CA

Dates:

May 2010 – Till Date

Project:

Oracle Database Administration

• Installed and Upgraded multi terabyte oracle database from 10gR2 non-RAC to 11g RAC on Red Hat Enterprise Linux and AIX for SAP applications interfacing having multi million user interface.
• Planned and defined processes for new implementations.
• Analyzed rdbms patches and advised on course of action.
• Analyzed and advised application development team on query optimization and overall performance enhancement.
• Responsible for Providing DBA support for mission critical and very large (in Terabytes) 24/7 production instances, cloning test and development instances from production environment, capacity planning for existing production and non-production instances and forecasting space requirements.
• Extensive experience in diagnosis, root cause analysis, impact analysis and solutions for problems in production.
• Extensive knowledge and experience in performance tuning of oracle 9i,10g,11g non-RAC and RAC instances
• Was Responsible for crating a proven and tested plan to re-organize database objects to optimize space utilization and performance improvement
• Implemented 10g and 11g Data for critical production instances.
• Successfully implemented and maintained oracle grid control through OEM 10.2.0.5
• Learnt SAP Basis Administration to understand the SAP interface tools with oracle database like MOPatch,brtools, brbackup,brspace,brarchive etc.
• Implemented Strategies for Backup and Recovery through RMAN for oracle 9i/10g and integrated with IBM Tivoli Storage Manager.
• Performed extensive research on Maximum Availability Architecture and Exadata
• Migrated databases from clustered filesystem to ASM in 11gR2.
• Upgraded oracle database from 9.2 to 10gR2 RAC and converted to UTF8(Unicode) characterset with CSSCAN and CSALTER.
• Installed, maintained and patching of GoldenGate products. Designed and implemented backup and recovery policies for GoldenGate.
• As a senior DBA have been responsible to mentor junior dbas.

Environment:

Oracle 9i /10g/11g database, Oracle 10g, Servers, AIX, Linux, RMAN, Veritas Net backup, Export/Import,PL/SQL., Remedy,OEM

Work Location

Cupertino, CA

Title:

Senior Oracle DBA

Client:

Confidential,Bangalore

Dates:

Dec 2008 – April 2010

Project:

Oracle Apps and Database Administration

• Successfully upgraded oracle database from 9.2 to 10gR2 and Oracle EBS application from 11.5.10 to R12
• Upgraded and Migrated multi-terabyte(30+ TB) databases from Solaris to Linux platform with character set conversion.
• Setup Oracle dataguard for Oracle 9i database..
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*TRACE AND TKPROF, STATSPACK. AWR, ADDM
• Worked on implementing shared ApplTop and OATM tablespace migration.
• Migrated RAC databases to ASM.
• Implemented High Availability solutions with Oracle 10g RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Oracle Streams.
• Experienced in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management, Virtual Private Database, Materialized Views, and Oracle Streams, partitioning of tables and performance impact.
• Written user and technical documents on Sybase ASE 12.5
• Created multiple perl and shell scripts to automate Sybase administration.
• Golden gate maintenance, administration and data replication.

Environment:

Oracle 9i /8i database, Oracle 10g, Servers ,10g dataguard,Linux,Solaris,Red Hat Linux

Work Location

Bangalore

Title:

Senior Oracle DBA

Client:

Confidential,San Diego, CA

Dates:

Mar 2008 – Dec 2008

Project:

Oracle Apps and Database Administration

• Upgrading oracle database from 9.2 to 10gR2.
• Planning and defining processes for new implementations.
• Analyzing oracle application and rdbms patches.
• Involved in query optimization and performance tuning.
• Cloning development and test environments from production environments.
• Providing DBA support for mission critical 24/7 production instances.
• Performance tuning of Oracle Parallel Server and Real Application Clusters and Transparent Application Failure. Also tuning of massively parallel oracle databases.
• Extensive performance tuning , instance tuning in Oracle 9i RAC and SQL optimization.
• Regular database capacity planning related to database growth and system utilization, trend analysis and predicting future database requirements.
• Validated backup, recovery and disaster recovery plans.
• Data Modeling, Erwin , E/R studio, Data Warehousing, Extract Transform and Load(ETL), Oracle Warehouse Builder.
• Responsible for Sybase Performance tuning for 30 Sybase Servers each worth of 10 GB data.
• Designed new data models and reverse engineered existing schema using perl/sybperl.
• Provided maintenance and enhancement programming for several applications running on Sybase.

Environment:

Oracle 9i /8i database, Oracle 10g, Servers, Windows XP, Sun Solaris, RMAN, Veritas Net backup, Export/Import,PL/SQL., Remedy

Work Location

San Diego, CA

Title:

Senior Oracle DBA

Client:

Confidential,CA

Dates:

July 2007 – March 2008

Project:

Oracle Apps and Database Administration

• Cross Migration of environments across OS Platforms.
• Oracle Apps on 9i RAC database support and maintenance (Size 680G) with avg 1000+ concurrent request processing per day for 3 separate instance for North America, Europe & Asia-Pacific.
• RAC Implementation/migration for non-Apps Oracle Databases from shared servers.
• Day to day administrative troubleshooting.
• Oracle database tuning for critical performance issues and Report related issues, primarily directed towards optimizer behavior, specific to RAC environment
• High end Performance Troubleshooting .
• Worked on standby databases for recovery.
• Responsible for Relational Database Design using Erwin and EOModeler.
• Unix Development, Staging and Production Environment setup.
• Backup/Restore Solaris, Linux, Windows, Oracle 9i/10g Database.
• Designed and setup the datamodel for Sybase 11.9. Installed,upgraded and configured Sybase ASE 11.x and replication servers on Sun Solaris and Windows NT.
• Involved in day-to-day monitoring,tuning,backup and refreshes of Oracle and Sybase databases.
• Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issues

Environment:

Oracle 9i /8i database, Oracle 10g, , Sun Enterprise Servers, Windows XP, Sun Solaris, RMAN, Veritas Net backup, Export/Import,PL/SQL., Remedy