SUMMARY

• Oracle Certified Professional DBA with 12+ years of experience as a Senior/Lead Oracle 10g/11g/12c DBA in 24x7 Production high availability, Test, and Development Instance environment.
• 10+ years on - site Experience in the USA with various Domain (Health-Care, Financial Services, Insurance, Manufacturing, Energy Provider / Utility, Food & Beverage).
• Hands on experience in RAC (Real Application Clusters), Data Guard/Standby, ASM, GoldenGate, Data Guard Broker and Grid Control on various Platforms including Red Hat Linux, AIX, HP-UXi, Solaris, and Windows Servers.
• Hands on Experience in Administration of RAC services for workloads management, and applications high availability.
• Experience in Developing Backup and recovery strategy for RAC and non-RAC databases for large Databases.
• Experience Setup Linux Servers for ASM (Asm-libs) and Clusterware installation.
• Configure and monitor Oracle Clusterware resources.
• Experience managing Oracle HA services for RAC Databases.
• Experience in applying Patches both on Application and Database.
• Strong implementation experience in Oracle GoldenGate 11/12g for unidirectional/bidirectional replication.
• Experience working on Exadata X2/X3/X5/X6 series servers.
• Experience working on OracleEngineered Systems, Oracle'sZero Data Loss Recovery Appliance (ZDLRA).
• Experience working on OracleEngineered Systems, Oracle’sZFSStorage Appliance (ZFS).
• Experience Upgrading Databases from 8i/9i/10g to 11g and from Oracle 10g/11g to Oracle 12c.
• System administration experience with Oracle E-business Suite (Oracle 11i/12i). Experience in installation, configuration, and maintenance of Oracle Applications 11.5.X, single node and in multi-node RAC environments.
• Experience Managing Oracle Argus pharmacovigilance systems for comprehensive drug safety.
• Experience working with Attunity replicat product for replicating Data across different DBs.
• Conversant with the technical aspects of DBA such as Installation (RAC /Non-RAC), Data Guard (DGMGRL), Upgradation, applying patches, Data-Pump, Import/Export, RMAN, SQL *Loader, Fine Grained Auditing (FGA), Database Auditing.
• Experience on Migration of major databases to Oracle from MS SQL and Sybase and MY-SQL.
• Experience in Database Conversions from Various platforms.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Performance Tuning of SQL statements and Database Tuning using tools like SQL Performance Analyzer, explain plan, TKPROF, ADDM, AWR reports, etc.
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases.
• Implemented OracleAdvanced SecurityTransparent Data Encryption(TDE).
• Experience working in Large Data Centers for Infrastructure setup.
• Administered databases of various sizes from 1+GB to 300+TB.
• Experience in Oracle Enterprise Manager (OEM)/Grid Control 11g/12c & Oracle Management Server (OMS).
• Experience in,Software as a Service(SaaS),Platform as a Service(PaaS), andInfrastructure as a Service(IaaS).
• Experience in Big Data / Hadoop technologies i.e. ApacheCassandra and MongoDB administration.
• Experience working in Attunity Replicate for replicating Data.
• Experience working with Amazon Web Services Architect.
• Cloud Migration to Oracle cloud.
• Implemented AWS Lambda, S3, EC2, VPC, Redshift, DynamoDb, Glacier, Cloudwatch.
• Served as a Database Administrator/Lead DBA managing other DBA's and worked with the offshore team while leading them and worked as a part of a team in a 24x7 production environment and provided on-call and day-to-day support.

PROFESSIONAL EXPERIENCE

Sr. Oracle/Cloud DBA consultant

Confidential, Los Angeles Area, CA

Responsibilities:

• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU). Performance Checks, GoldenGate replication checks, OS checks.
• Creating/Managing CDB / PDB and have done migrations from 11g to 12c.
• Logical and Physical Design (Data Modeling) of the databases 11g/12c.
• Installed, configured and supporting Oracle GoldenGate 11.2/12.1 for Oracle to Oracle data replication.
• Implemented Oracle GoldenGate 12x Bi-Directional (active-active) replication for Oracle databases.
• Implemented GoldenGate extracts/ replicats / Oracle initial load / transformation/mapping.
• Data Refresh using Data Pump Utility, SQL Loader from Prod to UAT, SIT, and DEV
• Implemented change data Capture for newly designed migration system.
• Perform RMAN Online backup (Full/ Incremental) of Oracle RAC Databases, setting up and monitor standby database.
• Working as an Amazon Web Services Architect.
• Migrated Oracle Database to the cloud.
• Working on AWS Lambda, S3, EC2, VPC, Redshift, DynamoDb, Glacier, Cloudwatch.
• Attunity replicat support for the Oracle to SQL Server replication.
• Oracle Enterprise Manager (OEM 13c) Installation and day to day maintenance.
• Provide Production DBA support, as needed, on a 24/7 basis.

Sr. Oracle DBA consultant

Confidential, Pleasanton, CA

Responsibilities:

• Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.2, ASM and Oracle Cluster ware.
• Managing Exadata X-5 and X-6 servers.
• Supported Oracle'sZero Data Loss Recovery Appliance (ZDLRA) and ZFS Engineered Systems.
• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU). Performance Checks, GoldenGate replication checks, OS checks.
• Creating/Managing CDB / PDB and have done migrations from 11g to 12c.
• Database backup and recovery using the data domain.
• On-boarding pharmacy stores from multiple source servers into Production system using Oracle GoldenGate on Exadata X3 servers.
• Using shell enable the GoldenGate monitoring.
• Support Development team for Big Data Cassandra development and integration.
• Installed, configured and supporting Oracle GoldenGate 11.2/12.1 for Oracle to Oracle data replication.
• Implemented Oracle GoldenGate 11.1/11.2/12.1 Bi-Directional (active-active) replication for Oracle databases.
• Implemented GoldenGate extracts/ replicats / Oracle initial load / transformation/mapping.
• Data Refresh using Data Pump Utility, SQL Loader from Prod to UAT, SIT, and DEV
• Implemented change data Capture for newly designed migration system.
• Perform RMAN Online backup (Full/ Incremental) of Oracle RAC Databases, setting up and monitor standby database.
• Installation and managing and Development Oracle text for large Databases.
• Administrate, monitor, secure, backup and optimize/troubleshoot the Cassandra cluster environments in production and non-production environments.
• Preparing and Configuring the Initial Capture on the source system in GoldenGate.
• Assisting Application Development Project lifecycle through migration to Production, including SQL optimization and post-implementation support.
• Provide Production DBA support, as needed, on a 24/7 basis.

Database Administrator

Confidential, Winona, MN

Responsibilities:

• Installed, configured and supporting Oracle GoldenGate 11.1 and 11.2 for Oracle to Oracle data replication.
• Implemented Oracle GoldenGate replication using downstream mining database.
• Implemented Oracle GoldenGate 11.1 Bi-Directional (active-active) replication for Oracle databases.
• Implemented Oracle GG 11.2 Bi-Directional replication for Oracle Databases.
• Implemented GoldenGate extracts/ replicats / Oracle initial load / transformation/mapping.
• Configure integrated extracts for compress tables.
• Upgrade Oracle GoldenGate 11.1 to 11.2.
• Upgrade Oracle database from 11.1 to 11.2 on Exadata.
• Migrated database from Exadata V2 to Exadata X2 series.
• Implement Oracle transparent data encryption (TDE) on Exadata.
• Installation configuration Oracle 12c.
• Documenting standard operating procedures.

Oracle DBA Production Support consultant

Confidential, Raleigh, NC

Responsibilities:

• Day to day Level 1st Production Support DBA with more than 1000+ databases.
• Performed database administration duties including software installation, patching, backup and recovery, performance tuning, monitoring.
• Configuration of RAC
• Query Tuning using ADDM, AWR Reports.
• Managed/Monitored around 200+ DB’s across various Data Centers of UK, Switzerland, US, Singapore, from different sizes from 1TB up to 40TB.
• RMAN Backup and Recovery, DB Performance Tuning instance level.
• Data migration to another database as per requirement for new systems.
• Change management to all environments.
• Performing flashback database operations to recover from human errors.
• Performance tuning of the databases using Stats pack/AWR and ADDM.

Sr. Oracle DBA Consultant / Oracle Apps DBA

Confidential, Reston, Virginia

Responsibilities:

• Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.1, ASM and Oracle Cluster ware.
• Performed day to day activities: Such as daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Performance Tuning and Support for DEV, UAT, and SIT, Production RAC Environment using ADDM, AWR Reports.
• Maintenance and performance support after the Oracle R12 upgrade.
• Perform RMAN Online backup (Full/ Incremental) of Oracle RAC Databases, setting up and monitor standby database.
• Installing and Configuring and Managing GoldenGate.
• Preparing and Configuring the Initial Capture on the source system in GoldenGate.
• Provide Production DBA support, as needed, on a 24/7 basis.

Lead Oracle DBA consultant

Confidential, Chicago, Illinois

Responsibilities:

• Managed and provided production support to more than 300+ Database instances.
• Managing HA RAC services.
• Adding Deleting RAC instances on clusters
• Administration of RAC clusters and ASM Disk Groups.
• Have done Creation and deletion of RAC Database up to 4 node RAC Databases.
• Experience in applying quarterly CPU patch published by Oracle for every quarter for RAC and non-RAC Databases.
• Installing and upgrading OCFS Cluster, RAC Clusterware, ASM software and Oracle binaries for RAC environment
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• Managed ASM for RAC Databases.
• Configured Oracle 10g/11g Oracle database for GRID performance monitoring and availability
• Experience in 10g Grid Control for managing the high availability databases.
• Cloning/ Data Refresh from production to set up test and development environments.

Sr. Oracle DBA/ System Engineer

Confidential, Chicago, Illinois

Responsibilities:

• Managed and provided production support to more than 1000+ Database instances.
• Involved with installation and maintenance of ORACLE 10g/11g RAC, ASM Database for high availability.
• 10g RAC Design/Installation/Configuration/Support: Design/Install 4 nodes RAC for Maximum High Availability/Business Continuity architecture.
• Configure physical standby database for RAC database from 3 nodes RAC to 2 nodes RAC.
• Set flashback database for a point in time recovery in case of disaster.
• Managing HA RAC services.
• Experience in multiple Supply Chain Management modules preferred such as Planning, Warehouse Management & Transportation for Oracle E-Business Suite.
• Applying patches for enhancement and fixing bugs using Adpatch, Opatch.
• Administration and upgrade experience of Oracle EBS 11i.
• Adding Deleting RAC instances on clusters.

Lead Oracle DBA/ Application DBA consultant

Confidential, Long Island City, New York

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Tablespace and Storage Management.
• 10g RAC Design/Installation/Configuration/Support.
• Disaster recovery using Standby Database and Database cloning.
• Monitored database health by scheduling shell scripts through cron jobs.
• Database, Tablespaces, and Schemas Design.
• Oracle replication solution from Shareplex and Replicate critical data and applications for high availability.
• Logical and Physical Databases Designing.

Oracle DBA Consultant

Confidential, Charlotte, NC

Responsibilities:

• Install Configure and upgrade of Oracle Databases.
• Design and implementation of backup and recovery strategy using RMAN.
• Tablespace and Storage Management.
• Disaster recovery using Standby Database and Database cloning.
• Monitored database health by scheduling shell scripts through cron jobs.
• Database, Tablespaces, and Schemas Design and implementation.
• Managed data security and user access.
• SData Modeling Layout of the databases.
• Database conversions from Sun Solaris/Windows to different platforms.

Oracle DBA / Apps DBA

Confidential

Responsibilities:

• Oracle Server software installation and configuration
• Creating and maintaining the data model and physical integrity of the databases.
• Planning, testing and setting up backup and recovery strategies.
• Disaster recovery using Standby Database and Database cloning.
• Writing migration scripts for migrating data from Oracle 11i Apps to Oracle 9.2.0.4
• Monitoring database health by scheduling shell scripts thru cron jobs.
• The database, Tablespaces, and Schemas Design and implementation.
• Managed data security and user access.
• Lead SRs and Production Support.