SUMMARY:

• 14+ years of experience having specialization in Oracle Exadata, High Availability, Disaster recovery solution, Oracle system architecture, RMAN backup and recovery, upgrades, migration and database software patching.
• Implemented High Availability and Disaster Recovery solution to maximize database availability during planned or unplanned outages.
• Manage Oracle Exadata environment including coordination with Platinum support team for QFSDP along with application owners.
• Applying quarterly Oracle Database Appliance (ODA) patch bundle on ODA V1 BM.
• Applying quarterly PSU, BP, SPU patching on 11g and 12c (Non - CDB) for compliance.
• Provide detailed architecture, consulting, implementation and support for database availability.
• Backup and recovery of full and partial databases using RMAN.
• Performed periodic database backup, restore and DR test exercise.
• Database cloning using RMAN duplicate for POC and development work.
• Database migration and upgrades (9i to 10g, 10g to 11g and 11g to 12c).
• Designed a proof of concept environment to facilitate functionality testing and features, built a pilot environment, which mirrored production to do in depth testing for all customers, and provided a detailed migration plan to migrate the current production cluster to the new environments.
• Proactively monitor and fix database availability.
• Work with Oracle support to resolve critical issues that require Oracle software correction.
• Lead teams at onsite and offshore with 24 X 7 production support model.
• Collaborate with team members, peers, customers and management on processes, procedures, documentation and future directions with maintaining effective working relationship.
• Build and Mentor Infrastructure Management Support team.
• Ability to work on assigned tasks independently and executes with minimal direction.
• Provide after hours on call support in a team rotation.
• Conceptual knowledge of 12c Oracle Multitenant Architecture (container database - CDB).

TECHNICAL SKILLS:

RDBMS: Oracle 12c, 11g, 10g, 9i, 8i (Administration, SQL, PL/SQL), MS-Access 2000

Operating System: Linux, AIX, Sun Solaris, HP UX, iOS, FC 3.0, Windows 2000/NT Server/98/95, XP

Web Technology: Internet Information Services (IIS 5.0), ASP 3.0, VB Script, and HTML

Languages: Shell Script, C, C++, VC++ 6.0

Tools: OEM 13c/12c, Grid control, RMAN, TOAD 9.1, Oracle SQL Developer, Oracle Design Editor (9.0.4.6), Oracle JDeveloper (10.1.2.1.0 ), Visual Studio

Ticketing Tool: Service Now, RTC, Espresso, Kintana

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Sr. Oracle DBA

Responsibilities:

• Oracle Database migration from Exadata X3-8 to Exadata X5-8.
• Setup of cascaded Data Guard broker configuration during Exadata X3-8 to Exadata X5-8 migration.
• Database Backup and recovery manager for CalHEERS production databases.
• Responsible for managing tape backups, retention and their footprints.
• Applying quarterly Oracle Database Appliance (ODA) patch bundle on ODA V1 BM.
• Applying quarterly PSU, BP, SPU patching on 11g and 12c (Non-CDB databases).
• Database upgrade from 11.2.0.3 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2.
• Database (11gR2) migration from DNFS to Oracle ZFS storage appliance.
• Automated 12c upgrades reducing downtime, avoiding slippage of execution steps or manual error.
• Configured various security features like FGA, Database Vault, Auditing, wallet configuration, TDE
• Created database health check report in HTML format with 25+ metrics to monitor both production and non-production databases in single location.
• Database cloning for the development databases both using duplicate and RMAN backups.
• Implemented 11g and 12c new features in CalHEERS environment.
• Implemented Security features - Database Vault, TDE, Fine Grain Auditing
• Onshore coordinator for 10 members team in India.
• Conceptual knowledge of Oracle multitenant architecture (Container Databases - CDB)
• Role: Onsite coordinator, Senior Database Administrator, Backup Manager

Environment: Exadata X5-8, X3-8, X2-8, X86, Oracle 12c/11g, ZFS appliance, OEM 13c/12c, Ticketing Tools: Service Now, RTC/ALM i.

Confidential

Sr. Oracle DBA

Responsibilities:

• Managing huge number of databases having applications - iTunes, iCloud, iMessage, Siri, GameCenter and FaceTime.
• Creating new primary and disaster protection Active standby databases (ADG) configuration.
• Configuring data guard broker and real time failover (FSFO) setup for newly created database
• Switchover / Failover / Re-instate through data guard broker
• Production database cloning in development environment
• Performing lead activity in shift
• Troubleshooting data guard environment issues
• Managing failover, switchover and observer activities.
• Database refresh from production to test/dev environments.
• Follow-up with Oracle support on SR to resolve the ongoing issues.
• Applying patches - PSU/CPU/BP.
• Production Support for 24 X 7 environment.
• Role: Oracle Database Administrator

Environment: Sun Solaris, LINUX, Exadata, Oracle 11g/10g, APEX, Ticketing Tools: Espresso

Confidential

Sr. Oracle DBA

Responsibilities:

• Technology Lead worked at onsite - Toulouse, France.
• Establishing and streamlining IT organization process in collaboration with client representative.
• Build an Active Data Guard configuration - ADG (Physical Standby) & monitoring database availability.
• Database migration from 8i/9i to 10g, 11g using export-import utility.
• Database Manual upgrades from 9i to 10g, 11g
• New Database creation both SQL & Oracle databases as per AIRBUS standards.
• Database administration - Schema, Space, Session management, PL/SQL stored procedures
• Quarterly database patch apply.
• Database regular monitoring, performance tuning and troubleshoot slowness/error.
• Role: Onsite coordinator, Database Administrator

Environment: AIX, Sun Solaris, LINUX, Oracle 11g/10g / 9i / 8i

Confidential

Sr. Oracle DBA

Responsibilities:

• Experienced in installation of High Availability 11gR2 2-node RAC environment.
• Creation of ASM databases and oracle databases.
• Designed and Implemented the RMAN backup strategy.
• Participated & written High Level Design Documentation
• Participated & written Low Level Design documentation
• Role: Team Lead, Database Administrator

Environment: LINUX, Oracle 11gR2

Confidential

Sr. Oracle DBA

Responsibilities:

• Lead a team of 5 members DBA working for 24 X 7 production support.
• Single point of contact for all Oracle DBA issues for developers and end-users.
• L1, L2, and L3 support for application management of Oracle DBA activities.
• Creation of databases and database objects - tables, MV views, PL/SQL stored procedures.
• Configured auditing to monitor database actions from both database users and non-database users.
• Database Performance Tuning.
• User management, database space management (capacity management) and Session Management.
• Refreshing database/schema/tables using conventional and datapump export-import utilities.
• Ongoing database administration using OEM and customized scripts.
• Automated the addition of partitioning, purging old partitions.
• Aware of ITIL processes.
• Data loading/unloading using SQL Loader
• Role: Team Lead

Environment: AIX, Sun Solaris, Oracle 11g / 10g / 9i / 8i

Confidential

Oracle DBA

Responsibilities:

• Lead a team for both JAVA developer and DBA.
• Installation and configuration of Fedora Core 3.0, Oracle 10g software and creation of databases.
• Great depth of knowledge in planning and implementing physical and logical design, implementation and maintenance of Oracle database on Fedora core.
• Defined and implemented backup strategies and scheduled RMAN Oracle database backups.
• Automated database datapump export backups, start-up and shutdown databases, alert log monitoring.
• Implementation of Oracle 10g new features.
• Capacity planning - size, resource utilization, analyze peak period consumption, memory allocation
• Refreshing development/test databases from production using datapump.
• Responsible for creation of database users, objects like tables, views, PL/SQL stored procedures.
• Performed ongoing database administration, maintenance.
• Responsible for gathering business requirements, managing development and release cycles, and coordinating releases with other team members at client side.
• Responsible for all procedures for Human Resource, Payroll, Material Management modules.
• Role: Team Lead, Database Administrator, and PL/SQL Developer.

Environment: Fedora Core 3.0, Oracle 10g, JAVA

Confidential

Oracle DBA

Responsibilities:

• Production database weekly cold backup and offsite tape backups.
• Responsible for production oracle database logical backups.
• Responsible for user management, object space management, session management.
• Designed and developed web-based cost effective Dealer Management System (DMS) to track dealer’s activity and boost PIAGGIO business, which is widely, used 200+ dealers across India.
• Coordinated a team of 8 programmers and provided a technical and functional guideline during development process of DMS System.
• Responsible for Installation and configuration of IIS 5.0 Server.
• Responsible for development of application library-functions for DMS application.
• Responsible for functional testing and code review of DMS application.
• Role: Technical Coordinator, Oracle Assistant DBA.

Environment: Solaris, Oracle 9i, Windows 2000 Professional, ASP, and MS-Access 2000