SUMMARY

• 6 years of IT experience as Oracle Database Administrator on a variety of UNIX (Solaris, HP - UX, AIX), Windows with Oracle ( 8i, 9i, 10g, 11g,12c), RAC, Streams, Data Guard, Advanced replication, Installation, Configuration, Migration, Sizing and Space management, Backup and Recovery, Performance tuning and troubleshooting.
• Expertise in database administration, installation, configuration, upgrades, migration, performance tuning, backup and recovery, cloning, space management, patching, and security, auditing and designing databases.
• Expertise in Monitoring of Oracle OEM 12c (12.1), Administration, configuration, OEM 11g/12c Installation, 11g OEM to 12c OEM Upgrades.
• Worked on upgrading of oracle databases from 11g to 12c.
• Expertise in using 12c, 11g features Active data guard/snapshot standby, and 10g Features DATA Pump, Flash back recovery, AWR, ADDM, while building database.
• Experience with complex database recovery scenarios, Export/Import Datapump.
• Upgraded existing, high available production Oracle databases by DBUA and manual upgrade method to PSU patch set updates.
• Capable of tuning SQL using EXPLAIN PLAN, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and tracing at user level and TKPROF.
• Experience with Oracle Application Architecture and Oracle Application\Database support.
• Experience in all aspects of the software development lifecycle including: requirements gathering, design, coding, testing and production support .
• Experience in installing, configuring and maintenance of Oracle Golden Gate and DataGuard.
• Having experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS NetBackup.
• Experience in developing new and enhancing existing standards, processes and procedures, and guidelines for database environments using industry experiences, best practices research, and business needs.
• Worked on Standby site setups for both applications and databases .
• Interact with Network/OS teams on network setups and load balancer setups.
• Experience in automating backup strategy using the UNIX shell script CRON UTILITY.
• Experience in Data Architecture which supports development, test and production databases.
• Extensively worked on large-scale databases with size of more than 2TB in large system environments
• Possesses the ability and knowledge to grant access privileges to database users by creating, configuring and maintaining user profiles and roles for database access, Included login and password
• Can create development, test and production databases using database configuration assistant- DBCA, manual scripts and SQL Plus using Automatic storage management- ASM.
• Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Participated in appropriate consulting, interfacing, and for users and delivered associated documentation for user interaction with the database environment.
• Strong presentation, troubleshooting, analysis, design, code, unit test, system test, implementation with excellent interpersonal and communication skills.

TECHNICAL SKILLS

• OPERATING SYSTEMS: Sun Solaris 8,9,10 IBM AIX 5.x, 6.x, Red Hat, Linux 4 .x,5.x, 6.x, and Windows.
• RDBMS: Oracle 9i, 10gRAC, 11gR2RAC, 12c, SQL Server 2005 and 2008.
• LANGUAGES:SQL, PL/SQL, Java, C, XML, Pearl, Shell Scripting.
• UTILITIES: RMAN,Oracle Enterprise Manager/Grid Control, Data, Guard, OLAP, SQL*Loader, EXP, IMP, Data pump,SQL developer, Veritas Net Backup and Golden Gate,RAC.
• TOOLS: TKPROF, TOAD, EXPLAIN PLAN, AWR, STATSPACK, ADDM, Putty and AUTO Trace, Winscp3, ERWIN.

PROFESSIONAL EXPERIENCE

Confidential, Woodland Hills, CA,

Responsibilities:

• Administer Oracle 11g/10g production, test, and development environment on Windows Server 2003, IBM-AIX, Sun Solaris and RHEL Linux.
• Configured and Migrated the Oracle enterprise manager 11g to 12c.
• Maintained and Support Data Warehouse Vantage products Databases i.e. each over 30 TB in size.
• Responsible for supporting Global Databases and Data Warehouse production and non-production environments.
• Worked in 24x7 production environment and provided on-call and day-to-day support.
• We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database. We achieved this using Data Guard.
• Migrated cross platform oracle databases using Data pump procedure within the downtime.
• Maintained and Implemented end to end replication between MS SQL Server 2008 and Oracle database using materialized view and SSIS packages.
• Worked on Disaster recovery or Business continuity program to step up all Exadata servers in remote location using RMAN techniques.
• Experienced and troubleshooting the cell nodes in Exadata servers.
• Using Exacheck version 224, applied the patch for bug to both 11.2.0.3 and 11.2.0.2 oracle database home during the Exadata Cell server upgrade to 11.2.3.3.0.
• Create and maintain Job instruction information as per the autosys servers for oracle replication.
• Created and managed multiple data types and objects for standard and live reorgs, including individual partitions, domain indexes, user-defined data types, and tables with both LOB data types and LONG columns.
• Installed BMC capacity optimization tool, configured reports & maintained their databases.

Environment: Oracle 12c/11g/10g RAC, Red Hat Linux (RHEL 5.9), AIX, Exadata, Data Guard, TOAD 11.6.1.6, Cron, Rman, Oracle Grid Control, CA Erwin.

Confidential, Minneapolis, MN,

Responsibilities:

• Installed Oracle 10g/11g and 12c RAC (4-node) systems, 11g, 12c OEM in HA environment on different OS platforms (IBM AIX, Linux, Solaris 10.0, RHEL and VMware).
• Responsible for providing 24X7 production support for critical Payments, Financial, and connectivity applications’ Oracle 10g/11g/12c databases on Solaris and RHEL.
• Worked on upgrading RAC database from 11.2.0.4 to 12.1.0.2
• Good working experience with Container databases or Pluggable Databases (PDBs).
• Worked on upgrading RAC database from 11.2.0.3 to 11.2.0.4.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Experience with Change Management for all the database changes.
• Migrated oracle databases from oracle streams to oracle golden gate 11x Active-Active Bi-directional replication.
• Installed Oracle Golden Gate 11.2 version on Linux and Solaris Boxes and configured High availability VIPs / XAG for the same.
• Successfully configured DDL and DML replication as part of Golden Gate replication.
• Assisted in designing and analysis of Oracle Exadata server for infrastructure and in other similar projects.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.
• Configured the Database level Heart beat tables for Golden Gate monitoring and deployed DBMS schedulers to check the latency over the sites.
• Improved performance of REPLICAT process using Range functions in Golden Gate and used some Macros and Tokens in Golden Gate.
• As part of GOLDEN GATE resolved Replicate/extract/pump issues and upgraded classic EXTRACT to Integrated capture to overcome the compression table’s issue.

Environment: Solaris 10, RHEL, Oracle Database Version 10g/11g/12c, RMAN, DATA PUMP, Data guard, RAC, Streams, Golden Gate, ASM, ACFS, Oracle Enterprise Manager Grid Control 12c, Shell script.

Confidential, Milwaukee, WI,

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0. Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on IBM-AIX nodes.
• Worked on upgrading RAC database from 11.2.0.3 to 11.2.0.4.
• Daily database administration tasks including backup and recovery through RMAN, Import/Export Performed data transfer using Export/Import using command line as well as in interactive mode and through DATA PUMP.
• We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Involved in Installation and configuration of Oracle 10g &11gRAC using Cluster ware and ASM.
• Experienced in implementing Oracle Database advanced security practices.
• Implemented Streams replication between RAC and non RAC database environments.
• Successfully configured and installed Oracle Golden Gate for replication.
• Successfully implemented DDL and DML replication in Oracle Golden Gate.
• As part of GOLDEN GATE resolved Replicate/extract/pump issues and upgraded classic EXTRACT to Integrated capture to overcome the compression table’s issue.
• Helped in developing applications based on Oracle Exadata platforms.

Environment: Red Hat Linux 5.0, Oracle 10g, 11g and 12c, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, DATA PUMP, RAC, Data Guard, Golden Gate, ASM,, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader, Shell script.

Confidential, Jackson, MS,

Responsibilities:

• 24*7 on call rotation supporting over 200+ production database.
• Installation, configuration and administration of Oracle12c, 11gand 10g databases on RHEL.
• Involved in Design and implementation of oracle 10g Data Guard both physical/logical standby databases for high availability and disaster recovery Monitoring several databases of Terabyte sizes using Oracle Enterprise Manager (OEM).
• Involved in installation and support for RAC 11g in Linux for more than 20 production using 2-node real application clusters (RAC).
• Analyze and determine the feasibility of leveraging the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Involved in installing SQL Server 2012 R2 in Test and Production environment.
• Involved in development of inbound interface custom package to validate and import Order details data into Oracle Applications OM Order interface tables from external system.
• Involved in database patching by applying PSU and one of patches as required.
• Performed upgrade of database from 10g to 11g with Oracle Database Upgrade Assistant (DBUA) in development, testing and production.
• Expertise in Oracle Golden gate installation, configuration, and troubleshooting Golden gate issues.
• Implemented Data Guard, creating both logical and physical standby databases in 10g, 11g and 12c RAC environment for production database.
• Implemented Oracle streams for replication and configured table spaces for streams administration at database and table level.
• Upgrade Golden gate 11.1 to 11.2 with patch-set provided by oracle.
• Performed HOT backup and COLD backup.
• Installed and controlled Grid Control to monitor RAC and Non RAC instances patched and upgraded the grid control Participated in analysis and designing of Oracle Exa data Server for infrastructure and related projects.
• Performed RMAN backup and also developed backup strategies using Incremental and Cumulative backup methods.

Environment: Oracle 12c/11g/10g, SQL, PL/SQL, ASM, Oracle Enterprise Manager Grid Control, Real Application Cluster Loader, Oracle Enterprise Manager (OEM),SQL Developer, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Columbus, OH,

Responsibilities:

• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Installation, upgrade, maintenance and patching of RAC/NON-RAC 11g/10g RDBMS.
• Evaluated and implemented new technologies. Deployed and maintained 50+ servers that include VMware, Microsoft and Unix platforms Refreshed/instantiated Physical standby database using advanced 11g features like Active Database Duplication (ADD) from stand-alone to 2-node.
• Used extensively Flashback’s feature of Guaranteed Restore point on standby-database to perform large sized data-exports to not disturb the Primary database and placed the database back to Standby mode.
• Responsible in performing Data guard Switch-over and Switch-back exercises during the maintenance window.
• Wrote shell scripts to automate the process of monitor file-system usage, switching Archive log destination, database monitoring etc
• Performed logical backup using export and import utilities.
• Creating table spaces, tables, views, scripts for automatic operations of the database activities.
• Performing the daily tasks of a DBA including alert logs, backups, space management and health check of the databases.
• Designing Tables, Constraints, Views, and Indexes etc in coordination with the application development team.

Environment: RAC 11g, Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, SQL Developer, Red Hat Enterprise Linux, RMAN, Data pumps, Exports/Imports.