PROFESSIONAL SUMMARY:

• An Overall of 15 + years of industry experience spanning roles from System Admin, Oracle Database Admin, Team Lead, On - Site Coordinator, OEM Architect.
• Have experience in Oracle Database and management server version 8i,9i,10g,11g,12c on Unix Platform with Expertise at Managing, Implementation, Upgrade, Migration, Production 24/7 support, daily maintenance task, Patching, and Cloning of Oracle Applications & Oracle RDBMS, Backup Recovery & Performance Tuning.

TECHNICAL SKILLS:

Oracle Management Server: 11g grid control Implementation, 12c cloud control implementation, 12cR2 to R3 to R4 to R5 upgrade, Plugin deployment, OMS system, agent and plugin patching, EBS 12.2.3 discovery, SOA Composites 1.7 discovery, Setting up access and notification through Admin groups, Dynamic Groups & External Roles, Multi OMS system using Load balanced url.

Oracle Database: Dataguard (Active, Physical & logical), AWR/ Statspack, ASM, ADDM, RAC, TKPROF/Explain Plans, RMAN, Auditing, Patching (Opatch), Clusterware, Datapump, Export and Import, Disaster Recovery, Upgrade 9i to 10g, 11g, Performance Tuning, Space Management, TAR Support.

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

Oracle Management Server Architect

Responsibilities:

• Working with multiple teams like the DBA, System Admin, Network, Oracle EBS & SOA to optimize the monitoring solutions provided to them.
• Keeping the system updated with the latest version and patches to provide Enterprise level monitoring for all the application and Infrastructure owned by Confidential Appliances and Lighting.
• Implementing Real User Experience Interface for end user experience monitoring.
• Working with Oracle support to expedite solutions provided by them for various bugs and issues with their products.
• Providing monitoring solution for all the new implementations in the infrastructure team.
• Agent installation & troubleshooting, Plugin Deployments, target discovery.
• AMP 12.1.034 Plugin upgrade and EBS 12.2.3 discovery. SOA 1.7 Discovery
• Oracle Database Administration experience in variety of different environments like Sun Solaris, AIX, Linux, HP-Unix and Windows.
• Installation, Configuration, Troubleshooting Oracle Databases (11g/10g/9i/8i) on Unix/Windows platforms.
• Expertise in database upgrades from 9i to 10g and 11g, database recovery techniques and implementation of those recovery techniques to ensure business continuity.
• Experience in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Expertise in using 10g, 11g features like Data Pump, Flash-Back Recovery, ASM, AWR, ADDM and Active DataGuard.
• Apply CPU patches and BUG patches on the database.
• Good experience in Logical and Physical Database Design, Backup and Recovery procedures.
• Proven ability to adapt to demanding schedules and changing priorities
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Strong analytical and problem solving skills with ability to work within team environment and independently when needed.

Confidential, San Ramon, CA

Team Lead, Oracle DBA Team

Responsibilities:

• Leading a team of 23 DBA’s located at San Ramon, New Orleans, Singapore, Goferville, Chennai Supporting multiple locations like Concorde - CA, New Orleans - LA, Sao Paulo - Brazil, Goferville - France, Singapore and Japan.
• Explored the option of setting up a near Shore development center in Sao Paulo, Brazil.
• Suggested a Rural Development Center within US and formed a team in Louisville, KY.
• Recruited Fresh Graduates and trained them and deployed them in DBA team as part of cost cutting measure for Chevron.
• Plus all the technical responsibilities in the above project.

Confidential, Rochester, NY

Sr. Oracle DBA

Responsibilities:

• Partner with architects of different other engineering / application teams to engineer complex technical product in order to provide palpable business solutions to various business divisions as a part of DBA Engineering project activities.
• Architecting Oracle Fail safe environments for site critical databases, including configurations, failover testing, tuning, creating standards etc.
• Oracle streams implementation/administration for live reporting server, database consolidation, zero downtime migration.
• Optimizing the downtime for maintenance by coordinating with the different application teams involved in the maintenance activity.
• Strictly followed Change Control/Change management procedures as laid down by the organization in a highly qualified environment.
• Plus all the technical responsibilities in the above project.

Confidential, Rochester, NY

Sr. Oracle DBA

Responsibilities:

• Responsible for 24*7 supporting more than 30 Oracle databases (10g/9i) running on Aix 5.x, HP-UX 11i wherein the major chunk of the databases hold data of OLTP, DSS and other enterprise applications as a Database
• Implemented, administered, reorganized and subsequently tuned all Oracle databases (development - production) databases with datacenter migration from Pittsford, NY (oracle 9i on HP UNIX) to Georgetown, TX (oracle 10g on AIX Unix) that save the company an estimated $3 million a year.
• By Implementing the Advance Security Wallet Manger on oracle 10g database, solve many audit and application connectivity issue.
• Successfully migrated Oracle 9i databases to Oracle 10g databases
• Responsible for analyzing and designing the process to implement the oracle patch sets available in Oracle.
• Responsible key member in designing/testing/implementing enterprise level move from user-managed backups to RMAN on Oracle 10g environments.
• Configured database cloning to copy production to other prod copy (for adoc report purpose) using Business Continuity Volumes (BCVs).
• Responsible for Validating Database integrity, security, auditing through SOX twice years to ensure the databases are FDA compliant.
• Involved in performing Disaster Recovery drills twice a year for all production systems using BCV splits of remote standby databases and tape recovery for non-BCV enabled systems.
• Maintaining strong working relationship with customers (UNIX, storage, developers and team leads).
• Prepare validation documents for database setup (installation, configuration, operation, etc.) in a FDA regulated environment.
• Plus all the technical responsibilities in the above project.

Confidential, Santa Clara, CA

Oracle DBA

Responsibilities:

• An active member in upgrading & migrating 9i databases to 10g for both OLTP and data warehouses.
• For data-mart design, Implemented Oracle Stream (Advance replication) on oracle 10g.
• Involved in creating, maintaining and refreshing required Oracle instances/databases for development, test and production environments.
• Provided DBA support to the application development and acceptance team, both onsite and offshore for loading and testing data in 10g databases.
• Implemented Oracle's Advanced Features such as Partition table, Partition Index, Function Based Indexes
• Was responsible for setting up standards for database maintenance and monitoring.
• Responsible for Report generation, monitoring disk usage, keeping systems healthy for the production environment.
• Implemented changes into the existing cron jobs as per the business needs.
• In conjunction with the security administrator established and managed user access, along with designing and implementation of user environments, also establishing enterprise level security standards.
• Extensively used metalink for resolving technical issues, opening SR and use collaborative support for database related issues.
• Responsible for documenting important scripts and administration of server environment.
• Responsible for conducting weekly meeting, tele/video conference with clients, development teams both onsite as well as offshore.
• Plus all the technical responsibilities in the above project.

Confidential

Oracle DBA

Responsibilities:

• Responsible for providing on call production support for 24x7 databases running on oracle 9i.
• Performed day-to-day DBA activities like patching, performance tuning, space management, backup & recovery, query optimization, testing and implementation.
• Responsible for installation and configuration of oracle 9i over Aix and Windows platforms.
• Worked through all the stages of SDLC and was involved in requirement analysis.
• Responsible for doing the capacity planning.
• Implemented replication among the distributed sites using materialized views.
• Performed Database Cloning to create TEST and DEV instances
• Responsible for development of database schemas based on project requirement, database setup & configuration
• Responsible for optimizing instance performance and throughput so as to keep in pace with SLA.
• Implemented table and index partitioning for enhancing the query performance for demanding applications.
• Supporting development team with in SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.
• Involved in implementing and managing backup & recovery strategies using user managed process.
• Responsible for scheduling backup scripts in cron to run on timely basis according the strategy.

Confidential

System Administrator

Responsibilities:

• Troubleshooting desktop issues for the users.
• Setting up the network for the users
• Installing windows and setting up hardware for the users.
• Managing the hardware asset for the company.

Confidential

Design Engineer

Responsibilities:

• Designing mechanical drawings using Auto CAD and Cosmos.
• Replicating physical machineries design using Auto CAD for fabrication unit.
• Carrying out impact analysis on machine parts for calculating it durability and wear and tear.