We provide IT Staff Augmentation Services!

Sr. Oracle Dba/ System Engineer Resume

0/5 (Submit Your Rating)

Chicago, IllinoiS

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.

We'd love your feedback!