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 recoveryfor 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, transformdatabase 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.

Computer Skills

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.
• 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 LocationCupertino, 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,San Jose, 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

Title:Senior Oracle Database Administrator

Client:Confidential,Lexington, KY

Dates: June 2006 June2007

Project:Oracle Database Administration

• Responsible for defining and implementing netbackup policy.
• Creation, cloning and upgradation of databases.
• Involved actively in schema management and performance tuning of databases.
• SQL tuning of the application packages.
• Troubleshooting RMAN backup and recovery related issues.
• Troubleshooting performance loopholes.
• Developed backup strategy and validation, includes documentation of backup processes, testing backup processes and validating successful recovery from backup.
• Worked on integrating Veritas netbackup with the RMAN backup.
• Worked extensively with SOX auditors for the SOX level auditing of the organization.
• Participated in data designing and modeling of schemas for baseline projects.
• Involved in Disaster recovery planning and setup.
• Oracle 9i Real Application Cluster installation.
• Performance tuning for Oracle Real Application Clusters.
• RMAN implementation.
• Oracle backup and recovery solution design.
• Use of Statspack and explain analysis.
• Calculating the disk space and memory requirements.
• Designed databases using ERWIN.
• Planning Logical Volume (Raw device) allocation.
• Performance tuning, SQL tuning & Optimization using bit map indexes and load balancing.
• Experience with use of Oracle Data Guard.
• Planning, Allocation and Monitoring of storage requirements.
• Maintained Oracle RAC systems, and reporting using Grid control.
• Exported data using export/import and SQL loader and usage of OEM tools.
• Performed database and Peoplesoft application (SQR, SQL Plus, PL/SQL) tuning; creating customized indexes to enhance data access as required. * Gathered response timed statistics for various departments and processes and performed database tuning.
• Experience resolving Peoplesoft application problems by creating/analyzing Peoplesoft/Oracle 9i/10g trace files.
• Sybase 12.5 installation, configuration, tuning and backup. Responsible for backup planning of database,Tran Log and Thresholds.
• Configured SQL server for maximum performance .
• Played key role for cross-platform migration of Sybase databases.

Environment

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

Title: Senior Oracle Database Administrator

Client: Confidential,Lexington, KY

Dates: Jan 2006 June 2006

Project: Oracle DBA Support for VIOC POS Data Migration

• Prepared strategy and plan for migrating data from one legacy system to the other.
• Involved actively in schema management and performance tuning of databases.
• SQL tuning of the packages used for migration of data.
• Rebuilding of indexes and Cost estimation of queries.
• Lock monitoring, diagnosing and troubleshooting performance loopholes.
• Developed backup strategy and validation, includes documentation of backup processes, testing backup processes and validating successful recovery from backup.
• Participated in design discussions to support project and baseline work.
• Created and executed stored procedures and triggers with PL/SQL.
• Supported development effort by providing SQL statement tuning and optimum data loading techniques.
• Migrated data from MS SQL Server database to Oracle database.
• Loading data using SQL Loader.
• Developed triggers to carry out advance validation.
• Performed database re-organization as required for performance optimization.
• Database capacity planning by monitoring online storage, growth and file system space.
• Installing and setting up management server and enterprise manager.
• Installing and configuring oracle on Unix and NT servers.
• Design, develop and maintain database integrity including dictionaries, monitoring standards, access/security, performance and server functionality.
• Installed and configured Oracle Enterprise manager for database monitoring.
• Mentored the migration of Microsoft SQL Server 7.0 to Solaris Oracle 9i, doing schema re-engineering, conversion of TSQL stored procedure to Oracle PL/SQL, transformation of all MS-SQL data tables to Oracle.
• Knowledge and understanding of the P2ES architecture.

Environment:

Oracle 8i,9i,10g .SQL *Loader, Oracle RDBMS 10g, 9i, DBartisan, OEM, SQL*Loader, Export/ Import, RMAN and PL/SQL, Unix shell sctipt.

Title:Oracle Database Administrator Oracle System Administrator

Client:Confidential,Norway

Dates:Oct 2004 Jan 2006

Project: Oracle Database administration

• Preparing instance strategy and capacity planning.
• Recommended on infrastructure requirements.
• Oracle installation, configuration and performance tuning of 9i and 10g databases on Solaris server..
• Logical backups and hot backups using shell scripts and incremental backups using recovery manager.
• SQL tuning, Memory tuning and I/O distribution were performed.
• Database cloning.
• Schema management and performance tuning of databases.
• RDBMS patch installation.
• System Administration of Oracle databases.
• Application of tools and database patches.
• Application of current level patches and upgraded the oracle database and oracle applications.
• Managing concurrent programs and requests, monitoring concurrent processing, setting priorities and determining the work shifts.
• Security classification of all the data related to HR and their accessibility through responsibilities and roles.
• Prepared data masking script to be used as a post clone activity to hide sensitive employee data.
• Worked extensively towards data security and data accessibility in application as well as the database level.
• General troubleshooting, which includes resolving database-locking conflicts, archiving and backup related problems. Solving problems encountered in applying database patches.
• Implemented best practices on database monitoring, administration and maintenance.
• Resolving issues related to Oracle databases processes and logging iTAR with Oracle.
• Monitor database space usage, reorganizing the database files for better performance.
• Tuning memory and I/O related problems. Tuning database buffers and log buffers. Tuning archiving process.
• Overlaying different test instances with production data (refreshing instances).
• Upgraded Oracle 8i to 9i as well as worked on converting database to Unicode.

Environment

Sun Solaris 5.8, Oracle 9i database, Oracle Application Server 10g, Oracle E-Business Suite 11.5.10, Sun Solaris 5.8, 10g Portal, Oracle RDBMS 10g, 9i, OEM, SQL*Loader, Export/ Import, RMAN and PL/SQL, Oracle 10g discoverer.

Title:Oracle Database Administrator,Oracle System Administrator

Client:Tata Confidential, Mumbai

Dates:Dec 2002 Oct 2004

Environment:Oracle 8i/9i database, Oracle 9iAS, Oracle E-Business Suite 11.5.5, Windows NT

Project:Oracle Applications & Database administration

• Oracle 8i and 9i installation, listener configuration, administration and cloning .
• Customized APIs to suite the business needs.
• Developed shell scripts to automate the monitoring of services and performance.
• Oracle Internet Directory set up, configuration and management.
• Managed user authentication, authorization and single sign on implementation.
• Installation and administration of 9iAS Release 2(J2EE type implementation).
• Oracle installation and migration to new releases.
• Database Backup and Recovery. Prepared strategy and plan for disaster recovery site implementation.
• Created and maintained several standby oracle databases.
• Set up and manage physical database structures, tables, indexes, clusters and partitions.
• Database cloning and Space Management
• Maintaining database security by creating roles, privileges, quotas and passwords.
• Object maintenance by optimizing Storage Parameters and rebuilding indexes.
• Monitoring and controlling the optimum use of rollback segments.
• Monitor and controlling user access to different database objects and system resources.
• Tuned different applications for inefficient SQL statements.
• Troubleshooting and Technical Support on Oracle databases and Oracle Applications.
• General troubleshooting, which includes resolving database-locking conflicts, archiving and backup related problems. Solving problems encountered in applying database and Oracle applications patches.
• Designing, deploying and maintaining data warehouse applications including star schema designing and summary layer creation.
• Resolving issues related to Oracle Applications processes by System Administration related setup, applying patch and logging iTAR with Oracle.
• Monitor database space usage, reorganizing the database files for better performance.
• Tuning memory and I/O related problems, database buffers, log buffers and archiving process.
• Developed shell scripts to monitor the processes and database performance.
• Overlaying different test instances with production data (refreshing instances).
• SQL Server 7.0 configuration and administration. Preparing strategy for the disaster recovery site implementation.
• Migration of 8i database from 32 bit to 64 bit.
• Experience in working with Oracle Corporation towards problem solving.
• Developed pro-active Unix Shell scripts for Alerting for Run-out-of space problems for tablespaces, Archive log’s, House keeping, SQL Tuning.

Environment

Oracle 8i/9i database, Oracle 9iAS, Oracle E-Business Suite 11.5.5, Windows NT, Sun Solaris 2.7, HP-UX 9000 11.0 , Enterprise Manager, Export/Import Utilities and PL/SQL,MySQL

Confidential, Hyderabad May 2002 Dec 2002

Title:Oracle Developer

Client:Maxis, Malaysia

Dates:May 2002 Dec 2002

Environment:Oracle 81, PL/SQL, ASP

Project:

• As an oracle developer involved in writing PL/SQL for the Oracle application.
• Writing triggers and stored procedures to be used by the App development team.
• Involved in various levels of Testing starting from Unit, Assembly, Integration and System, performance and stress testing.