SUMMARY:

• Over 12 years of experience in IT industry in Designing, Administration, Implementation of Oracle 8i /9i /10g/11g/12c Database on Unix/Linux and engineered systems like Exadata and Cloud Computing .
• Handled 4 projects as lead (Full Life Cycle implementation) of back end database configuration (Installation, Setup, Tune, Backups, Patching) and provide the full database tier support to all phases of software development (Development, QA and Production).
• Solid experience in managing Oracle in High Availability environments using Real Application Cluster, Data Guard, GolenGate and Cloning technologies.
• Experience with cloud hosting in SaaS environment for Fusion Application 11.1.1.3 and Oracle 11g/12c DB in Exalogic and Exadata 2.x/3.x.
• Setting up the real - time Replication using Oracle Golden Gate (replication and data migrations).
• Data Warehouse and Business Intelligence Projects (Architect, Design and Implementation)
• Managing Very Large Database with size up to 50 plus Terabyte size and with more than 12000 TPS.
• Database Performance Tuning using dynamic performance views, AWR, Explain Plan, SQL Diagnostic Pack,SQL TRACE, STATSPACK and different OEM utilities.
• DBA for Hyperion Essbase 9.3.x - 11.1.x
• Successfully implemented Oracle10g/11g(R2) on RHEL5/4/3, Solaris 9/10 and EMC CX3/CX4 series /Storage Tek / Hitachi AMS storage devices.
• Performed a lot of Database upgrades from Oracle 8/8i/9i/10g/11g to Oracle 12c.
• Managing RAC on multi-node cluster with Data Guard with active standby and switchover failover testing.
• 24x7 Production Support Experience and working with Oracle Support.
• Database backups and recovery using RMAN, Import/Export, Hot/Cold Backups, Data Pump tools.
• Proficient in developing PL/SQL program units using Stored Procedures, Functions, Packages and Triggers.
• Install, Configure and Maintain Hyperion EPM 9.3.x/11.1.1x including Shared Services, Essbase, Planing, HFM, FDM, FR, Workspace, ERPI and ODI.
• Well versed with client server environment & tools like SQL*LOADER and TOAD.
• Worked with DW ETL Tools like Informatica PowerCenter 7/8 and Oracle Data Integrator.
• Experienced with Business Intelligence tools like Business Objects, Hyperion, Oracle Analytics, Cognos.
• Widespread use of Shell scripts and other UNIX scripting tools like Awk, Sed and Perl for automation.
• Write Technical Documentation and Procedures for implementations and setups.
• Ability to interact effectively with clients/customers, Understanding their requirements and providing optimum solution and support.
• Excellent Analytical, interpersonal and communication skills.

TECHNICAL SKILLS:

Database: Oracle 8i/9i/10g/11g/12c with Real Application Clusters, Data Guard

Multi Dimensional DB: Hyperion EPM Essbase 9.3.x - 11.1.x

Cloud/SaaS: Exadata and Exalogic

Application Server: Weblogic 11g/12c

Business Intelligence: Oracle OBIEE 11g 11.1.x

DW and ETL: Informatica Power Center 7/8, Oracle Data Integrator

Replication: Oracle Streams (3 way Multi-Master), Golden Gate Replication

PL/SQL Development: TOAD, JDeveloper, SQL Developer

DB Monitoring Tuning: AWR, SQL Trace, Explain Plan, Wait Events, STATSPACK, TKProf, OEM GridLanguages: SQL, PL/SQL, JAVA, HTML, C, XML, Perl

Operating Systems: Windows Enterprise Servers Class, Sun Solaris 11, Linux (Redhat, SuSE)

BI/Reporting Tools: XML/BI Publisher, Analytics, Business Objects, Hyperion

ERD: Toad Data Modeler, ERWin, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

Principal Oracle DBA

Responsibilities:

• Manage, administrate more than 1600 Oracle databases on Exadata for SaaS Cloud environment.
• Setup and configure Oracle RAC with Data Guard for Oracle Fusion Applications and Custom OLTP Applications.
• Use Cloud Control 12c to support a large pool of applications and databases
• Migrated Multi TB of data from other OS platforms to Exadata 2/3.x in HA Configuration.
• Provide production support in SaaS Cloud fusion application and database support to more than 600 Active Customers.
• Create, deploy and manage PDBs in 12c CDB (multi-tenant architect) in multi-node cluster.
• Support the Customer, User and Developer and Application Users for Database related tasks.
• Work on Service Request and Bug related to the Fusion Apps SaaS environment.
• Monitor the database, host and storage related alerts using Cloud Control.
• Upgrade and Patch the databases for standards and fix the issues.
• Performance tuning using ASH/AWR/ADDM and custom health check scripts.
• Participate in Architectural design of database in physical and logical perspective.
• Manage Exadata Cell node for Cell Disks, Flash Disks and Grid Disks.
• Perform root cause analysis and advance troubleshooting for the unplanned database and applications outages and crashes.
• Perform varieties of database related task like Data Migrations, Data load and handling the database related requests.
• Trouble shoot critical database issue like ORA 600/ORA-7445/ORA-700.
• Draft the standard and documentation for install, setup and maintenance of complete Fusion landscape.
• Work in 24x7 environment covering mostly PST shifts and some weekend activities.
• Shell script automation for code deployment, integration, monitoring and system maintenance.
• Backup and recovery using RMAN on tape and image copies and on data domains.

Environment: Oracle RAC 11gR2/12.1.2, Data Guard, Oracle Golden Gate, Oracle Weblogic 11g, Exadata2/3, Exalogic, RMAN and shell scripting.

Confidential

Sr. Oracle Database Administrator

Responsibilities:

• Design, Implement and setup Oracle MMA (Maximum Availability Architecture) for new merged businesses in University system.
• Setup and implement the Oracle RAC for Active-Active, Data Guard (Physical Standby) for DR.
• Install the RAC with Data Guard as active standby for reporting in 11gR2.
• Migrated Multi TB of data from Solaris to Exadata 2 in HA Configuration.
• Provide production in SaaS Cloud fusion application and database support to more than 60 clients.
• Support the Developer and Application Users for Database related tasks.
• Prided production support, on-call 24x7 support.
• Setup the policies for DB upgrades and CPU and PSU patches application..
• As part of Architect team review and recommended the best practices for Business Continuity.
• Evaluated different replication solution included the Golden Gate, SharePlex and Oracle Streams for very critical and high available environment.
• EM Grid Control agent configuration on DBs and Application Servers.
• Configure the RMAN for Database Backups.
• Using RMAN Duplicate Database Command for Cloning the DB Tier.
• Performance Tuning the database using AWR/ADDM, Explain Plan, Tkprof, Trcanlzr etc.
• Setup Sitescope and OEM alerts for Production and Critical Systems.
• Attend the crisis calls for databases issues and resolve the database performance related issues.
• Open Oracle SRs when needed and help to resolve the issues for Oracle DB as well as business users.
• Implemented 3-way Multi Master Oracle Streams Replication.
• Tested and implemented the Oracle 11R1/R2 databases and setup the GoldenGate real time data sync.
• Install Hyperion EPM 11.1.1.x, setup Shared Services with LDAP. Manage the workspace.
• Manage and Administer the Essbase 9.3/11.1.1x Databases with Planning, HFM.
• Configure the FDM with ERPI as EBS R12 as source system using Oracle ODI 10g.
• Migrate and refreshing the Essbase, HFM, Planning applications using LCM as well as manually.
• Backup and restore of Essbase Application and Databases using EAS. Manage the essbase.cfg and Essbase security file.
• FDM Adapter configuration for Target and Source system.
• Install and configured the Hyperion Financial Reporting with HFM and Essbase.
• Write the clean house scripts using shell for log rotation and purging.

Environment: Oracle RAC 10g/11g, Hyperion EPM 11.1.1.3, Oracle Streams, Oracle GoldenGate, Oracle Application Server 10.1.3.x, AIX 5.x, Sun Solaris 10, Linux 5, UNIX Shell Scripting, UNIX CRON jobs, RMAN

Confidential

Sr. Oracle DBA Architect

Responsibilities:

• Manage multiple Oracle RAC database configured with Data Guard through Grid Control and through SSH and 70 plus databases in Production.
• Implemented the High Availability through Real Application Cluster Oracle 10gR2.
• Setup the DR with Physical Standby Data Guard at Co-Location.
• Setup and Manage AQ Advance Replication in RAC environments to handle high volume transactions (avg 500 TPS).
• Setup and Configure Grind Control (OMS) and install the agents.
• Install and configure Hyperion EPM 11.1.1.x, setup Shared Services with LDAP. Manage the workspace on Weblogic 9.2.
• Administrate and maintain the middle tier server Oracle Application Server 10g (SOA) in clustered environments, SSO, OID, Web Cache and Load balancing.
• Production Databases on 4 node RAC clusters 10g R2 .
• Perform database upgrades and CPU application.
• System is interfaces with SOA Technologies (Oracle SOA Suite and JCAPS) to integrate with Legacy system as well as third party business operational tools (Seibel Integrator, ePay etc)
• Data warehouse was deployed using SAN Replication technologies and ETL process with Oracle Data Integrator for Business Intelligence.
• Business Intelligence and Reporting is implemented using BI Publisher, Discoverer for Standard Reports. For Ad hoc Reporting Hyperion and Oracle Analytics is used.
• Implemented/Integrate and monitor BPEL and ESB services on Oracle Fusion Middleware.
• Tuning SQL with Explain Plan and Toad SQL Optimizer tool.
• Space management, Logical Backups, RMAN Backups.
• Data Modeling and Schema design using ERWin (forward and reverse engineering).
• Daily, weekly system and DB server maintenance like cleaning the old archives, validating the backups, monitoring Alert Logs & Trace file and Application Logs, managing the security at user level and at application level.
• Generate the reports as requested by the management.
• Perform database loads using SQL Loader for production and training.
• Using SAR, TOP, NETSTAT, IOSTAT, VMSTAT and OSWatcher to monitor the OS.
• Manage and monitor the database object like Java classes, Packages and compiling the invalid objects as per application demand.

Environment: Oracle RAC 10g, Hyperin EPM suite, Oracle EBS 11i, Sun Solaris 9,10, Linux,SQL\PL-SQL, UNIX Shell Scripting, UNIX CRON jobs, RMAN, ERWin,SQL Loader

Confidential, San Mateo, CA

Oracle DBA/Architect

Responsibilities:

• Work involved enhancements to the existing Database system. Up gradation of Databases were required in the billing and financial applications.
• Design and Implementing Very Large Oracle 10g Databases in High Availability Architecture using Real Application Clusters.
• Install, Configure, and Create RAC CRS and Database Instances by using Response files (silent installation) and SRVCTL commands
• Successfully implemented Adding/Deleting RAC nodes, TAF, Load Balance
• Setup Data Guard for production RAC Database in Physical Standby Architect.
• Setup and documented Data Guard Fail-Over/Switch-Over/Read-Only scenarios in RAC
• Tuning Oracle Wait Events/Latches-Enqueues/Memory(SGA, PGA, Buffer pools) by using (AWR), ASH, Buffer Cache Advisors, and Statspack, tuning
• Configured Redundant NICs at Linux (Bonding) and NetApp (vifing)
• Implemented Scripts to collect DB, Hosts, and Storage stats for capacity planning
• Implemented NetApp Snapmirror VSM (Volume Level Snapmirror), QSM (Qtree Level Snapmirror) and Snapshots for Oracle DRS
• Performance monitoring and tuning of oracle database using AWR reports.
• Monitoring and Tuning OS (RHEL 4) using vmstst, iostat, netstat, sar reports etc.
• Tuning Linux system level parameters for Oracle RAC such as HugeTLBs(vm.nr hugepages), NFS tcp slot table entries, net.core.rmem max, and net.core.wmem max
• Tuning NIC Cards by setting Full Duplex mode and speed to 1000MB/s to improve the performance
• Shell scripting for automating, monitoring and performing routine database jobs.
• Backups using vendor specific tools and oracle utilities like RMAN.
• The tuning and indexing the database and schema for efficient query execution plan.
• Modification of some existing front end Java web applications using PL/SQL and JDBC.
• Database Normalization with ERWin.
• Involved in bug fixing reported from QA and End users.
• Provide development and production support related to database.
• Troubleshoot performance problems regarding databases, applications and tools in systematic way. Took consideration on all the components, database and application server load, I/O activity, network latency, database wait events and slow query to identify the problem timely. Team with System, Network administrator and Engineers to resolve problem quickly.
• Application tuning using SQL Tuning methodologies (EXPLAIN PLAN, SQL Trace, TKPROF).
• Involved in Post production Support, work involved supporting Apps, support in Triaging.

Environment: Oracle 10g RAC (R1, R2), RHEL3/4, SQL\PL-SQL, UNIX Shell Scripting, MySQL, UNIX CRON jobs, ER WIN 5.1, Windows Server 2003, J2EE, XML Publisher

Confidential, San Francisco, CA

Database Architect/Oracle DBA

Responsibilities:

• Setup new Solaris servers and install the Oracle Apps 11i.
• Real Application Clusters 9i designing and implementation.
• Setting up network environments using TCP/IP, DNS, SMTP and configuring Net8 and Oracle Naming Services.
• Monitoring, Backups and Tuning using Oracle Enterprise Manager
• Oracle Expert and Diagnostic Pack
• RMAN, SQL Loader, Export/Import
• Designing and developing applications UI using Oracle Developer (Forms6i).
• Writing the applications for the customers using shell scripts, Java, JSPs, JDBC and XML to manage and populate the database.
• Integrating multi-tier Enterprise Application involving Oracle DB Server and Application Servers.