SUMMARY

• I have 15+ years of experience in Information Technology as a Database Architect/Admin and worked as a Senior Oracle DBA/Architect, GoldenGate Administrator, AWS Architect.
• Senior Oracle Cloud DBA/Architect, Oracle GoldenGate Administrator, Exadata Administration, Cassandra Admin/Mongo DB.
• AWS Cloud Architect with services like Lambda, S3, EC2, VPC, Redshift, IAM, EBS, CloudFront, Snowball, Cloudwatch, DynamoDb, Glacier, SES, SNS.
• Hadoop Administration (HDFS, MapReduce), maintain large and complex Hadoop Clusters by Planning, Installation, Configuration, Backup & recovery, Monitoring & Tuning.
• Oracle Certified Professional DBA with 15+ years of experience as a Senior/Lead Oracle 10g/11g/12c DBA in 24x7 Production high availability, Test, and Development Instance environment.
• Advanced understanding and development experience with NoSQL Cassandra/Datastax DB.
• Hands - on experience in setting up a Cassandra Database in an enterprise, Design and Support data migration on a worldwide multi-datacenter cluster.
• Experience with backup & recovery, security, monitoring, performance tuning and managing Cassandra cluster
• 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 with Oracle Engineered Systems, Oracle's Zero Data Loss Recovery Appliance (ZDLRA).
• Experience working with Oracle Engineered Systems, Oracle’s ZFS Storage 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.
• Strong implementation experience in 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.
• Administration, design, implementation and support highly available and scalable distributed Cassandra (DataStax) database solutions
• Monitor key performance metrics, measuring the utilization, performance and overall health of the Cassandra environment.
• Performance Tuning of SQL statements and Database Tuning using tools like SQL Performance Analyzer, explain plan, TKPROF, ADDM, AWR reports.
• Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of the databases.
• Implemented Oracle Advanced Security Transparent 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 i n, Software as a Service (SaaS), Platform as a Service (PaaS), and Infrastructure as a Service(IaaS).
• Experience in Big Data / Hadoop technologies i.e. Apache Cassandra and MongoDB administration, Ansible.
• Experience working in Attunity Replicate for replicating Data.
• Experience working with Amazon Web Services Architect.
• Experience working with cloud Migration.
• Implemented AWS Lambda, S3, EC2, VPC, Redshift, DynamoDb, Glacier, Cloudwatch.
• Migrating from RDBMS into HDFS.
• 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 DBA

Confidential, Irving, Texas

Environment: Oracle11g/12c, OEM 12c, Oracle Golden Gate 12c, Oracle RAC, ASM, AIX, Linux, Cassandra 3x, Mongo DB RMAN, Toad, OEM, ASM, AWR, ADDM, Shell scripting, Exadata, GoldenGate, ORaaS, AWS.

Responsibilities:

• Working as a Senior Application, DBA/Specialist Architect straddle the fence between the DBMS/RDBMS/No-SQL applications, and responsible for ensuring that the critical business application optimization for the database.
• Responsible for Database performance tuning for Business-Critical Applications.
• Administration, design, implementation and support highly available and scalable distributed Cassandra (DataStax) database solutions.
• Experience with backup & recovery, security, monitoring, performance tuning and managing Cassandra cluster.
• Monitor key performance metrics, measuring the utilization, performance and overall health of the Cassandra environment.
• Provide Level 3 on-call support for the 24/7 Cassandra database environment
• End to end performance diagnostics and tuning for OLTP/OLAP large-scale production Databases.
• Design, create Cassandra Database and support day to day activities.
• Creating/Managing CDB / PDB and have done ORaaS (Oracle as a service) migrations from 11g to 12c.
• 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.
• Logical and Physical Design (Data Modeling) of the Oracle Databases 11g/12c as an Architect.
• Installed, configured, and supporting Oracle GoldenGate 12 for Oracle to Oracle Data replication.
• Implemented Oracle GoldenGate 12x Bi-Directional (active-active) replication for Oracle databases.
• Design and configuration of the 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.
• Performed to fix the Oracle index/Object fragmentation for the highly used objects and schedule daily update stats on the critical objects as part of maintenance.
• Made performance improvements to the database by building Partitioned tables and indexes and converted non-partitioned tables to partitioned tables using online table redefinition.
• Tune database Design and plan for load balancing based on the utilization.
• Indexes and query optimization for bad queries based on the database analyzer and query plan.
• Performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration, and synchronization.
• Supporting AWS, ORaaS (Oracle as a service) and migrated Oracle Database to the cloud.
• Working on Software as a Service (SaaS), Platform as a Service (PaaS), and Infrastructure as a Service(IaaS).
• Designed, implemented, and documented setup and maintenance of Oracle 11g Data guard both physical/logical standby databases in high availability mode.
• Provide Production DBA support, as needed, on a 24/7 basis.

Sr. Oracle DBA consultant

Confidential, Las Angeles, CA

Major technologies: NoSQL/SQL Databases, MongoDB 2.4/3x, Memcached, Oracle 11g/12c on Linux/Exadata, GoldenGate.

Responsibilities:

• Support Oracle Databases on 4-Node RAC Cluster with Oracle 12, 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). Performance Checks, GoldenGate replication checks, OS checks.
• On-boarding on-air channels from multiple source servers into Production system using Oracle GoldenGate on MongoDB Databases.
• Have Supported the 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.
• Have 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
• Have completed the Installation and managing and Development MongoDB for large Databases.
• Have done Assisting Application Development Project lifecycle through migration to Production, optimization and post-implementation support.
• Provide Production DBA support, as needed, on a 24/7 basis.

Sr. Oracle DBA consultant

Confidential, Pleasanton, CA

Major technologies: Oracle 11g/12c on Linux/Exadata X3/X5/X6, GoldenGate, MongoDB,Redis.

Responsibilities:

• Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.2, ASM and Oracle Cluster ware and Managed Exadata X-5 and X-6 servers.
• 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.
• Performed 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
• Install,configure,support MongoDB on Linux.
• Supported the 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.
• 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.

Database Administrator

Confidential, Winona, MN

Major technologies: MongoDB 2.4, Oracle 10g/11g /12c on Sun Solaris/Linux, GoldenGate, Exadata X2.

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.
• Support experience of supply chain management system via Oracle Demantra management system.
• 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

Major technologies: Oracle 10g/11g on Sun Solaris/HP-UXi/Linux.

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

Major technologies: Oracle 10g/11g on Sun Solaris/HP-UXi/Linux.

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.) and 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

Major technologies: Oracle 9i/10g/11g on Sun Solaris/HP-UXi/Linux/AIX

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 Application Clusters (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

Major technologies: Oracle 9i/10G/11g on AIX/Sun Solaris/ Windows/HP-UX/Linux

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 the 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

Major technologies: Oracle 9i/10G/11g/11i on AIX/Sun Solaris/Linux/Windows

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

Major technologies: Oracle 9i/10G on AIX/Sun Solaris

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.