We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Dearborn, MichigaN

PROFESSIONAL SUMMARY:

  • Highly accomplished in Implementing Maximum Availability Architecture with a successful 8+ years track record of success in administering Oracle 12c,11g and 10g databases and Repeatedly successful in navigating complex and technical environment.
  • Having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, RAC installation and maintenance, setting up and configuring, performing all kinds of backups and recoveries, cloning databases, database security, migration and documentation.
  • Implemented and configured Oracle GoldenGate on a 2 - node RAC cluster.
  • Troubleshooting and fixing GoldenGate errors in a 2 node RAC production environment.
  • Configured Automatic Storage Management (ASM) for 11g RAC databases.
  • Monitored and Administrated ORACLE RAC databases on ORACLE 11g Clusters
  • Expertise in Dataguard configuration, implementation and maintaining physical standby databases in 12c / 11g / 10g on Linux.
  • Expertise in configuring Active Dataguard, snapshot standby and troubleshooting issues and configuring service level agreements(SLA) for query’s accessing standby databases.
  • Troubleshooting Dataguard using views, troubleshooting missing archive log issues, patching Dataguard environment, applied logs with delay.
  • Configured Dataguard Broker and managed standby databases using Dataguard Broker.
  • Implemented and configured GoldenGate on standalone server and RAC infrastructure.
  • Expertise in installing and configuring transactional level DDL, DML, BI-DIRECTIONAL, UNI-DIRECTIONAL replication using GoldenGate v10, v11 and 12c.
  • GoldenGate utilities like GGSCI, Log dump, defgen for troubleshooting issues and performed data replication from SQL server database to Oracle database using GoldenGate 11g.
  • Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied patches to GoldenGate environment 12.1.0.2.
  • Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and Handy in upgrading GoldenGate from v11 to 12c.
  • Migrated Non ASM databases to ASM.
  • Added disks to disk groups using ASM system when the file system is full.
  • Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control(OEM).
  • Hands on experience in OEM 13c, involved in upgrading OEM from 11g to 12c
  • Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling RMAN jobs, SQL tuning advisor.
  • Successfully implemented the planned downtime by creating blackouts in OEM.
  • Involved in creating templates to monitor the databases based on requirements.
  • Configured Database Vault, Data Redaction, and Data Masking techniques in OEM.
  • Expertise in implementing database Backup and Recovery concepts using RMAN utility.
  • Implemented scheduling full, incremental, cumulative and hot, cold backups.
  • Performed Various Tasks on RMAN: configuring backup, Block recovery, data file recovery, registering databases in catalog, TSPTR (Tablespace point in time recovery).
  • Configured Catalog database for RMAN backups.
  • Experience in logical backups and Database migration tools with Data pump, Export/Import.
  • Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database.
  • Experienced in maintaining large Production, Testing and DEV environments and worked on database cloning with RMAN.
  • Valuable experience in applying Patches like PSU and CPU Patches Quarterly and Upgradation of databases from versions 10g,11g to 12c.
  • Experience in Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.
  • Resolved so many networking issues in environment and supported application users to connect to the databases and retrieve the data.
  • Had a pleasant experience in closely working with Engineering Team to implement databases as specified.
  • Enjoyable experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
  • Have a good knowledge on small flash cache and troubleshooted Exadata small scan off load issue.
  • Compressed data in distinct levels using Exadata.
  • Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies.
  • Worked on Exadata Database Machine X4-2 Half Rack, X3-2.
  • Implemented new Exadata Machine features like Exadata smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases.
  • Migrated databases into Exadata Machine with minimal downtime using Dataguard.
  • Worked on Instance Tuning, Memory Tuning and SQL Tuning.
  • Involved in Migrating SQL server .
  • Experienced in Performance Tuning by analyzing AWR, ASH and ADDM reports.
  • Good exposure to oracle technologies like AWR, ASM , Flashback and Data Pump Import/Export.
  • Created ASM Disk & Disk groups and Maintained Oracle ASM instance.
  • Installed and configured EBS 12.1.3 Validation environment with a 2 node 10g RAC (ASM)
  • Worked in environment Upgrading EBS 11.5.10 to EBS 12.2.4 and Oracle DB from 11g to 12c.
  • Installed and Configured Oracle Retail Merchandising System ( RMS ) 8.0.
  • Tested and Supported various Oracle RMS applications.
  • Upgraded current systems from Oracle Retail Merchandising System (RMS) 8.0 to latest version.
  • Hands on partitioning tables and creating Materialized views.
  • Replicated data based on column and row level sub setting using Materialized views.
  • Worked with Ticketing tools like BMC remedy, service now, Pack 200 etc.
  • Implemented downstream capture at the destination database using Oracle Streams.
  • Performed Schema and Table Level Replication using Oracle Streams.
  • Configured and Implemented Oracle Streams for high availability.
  • Have good knowledge in Mongo DB.
  • Worked with both VLTP and VLAP databases and have a pleasant experience using ETL tools in Data-ware house environments.
  • Hands-on experience with Configuration and maintenance of Oracle Database Appliance (ODA).
  • Using Oracle Database Appliance simplified deployment, maintenance, and support of database solutions for organizations of every size.
  • Provided 24x7 on-call support for production databases.

TECHNICAL SKILLS:

Operating System: Oracle Linux, Red Hat Enterprise Linux(RHEL), Sun Solaris, Windows 2008/2003

RDBMS: Oracle 12c/11g/10g

Languages: SQL, PL/SQL, UNIX shell scripting, XML, C, C++

Tools: & Utilities: TOAD, SQL Tools, ADDM, DBCA, Log miner, BMC Remedy, AWR, ASH, Putty, ETL tool, Log dump, defgen, Tuning advisors, ORACHECK, TFA.

Oracle Tools: RAC, RMAN, ASM, OEM (11g, 12c, 13c), SQL *Loader, exp/imp, GoldenGate, Dataguard

Oracle products: Real Application Cluster (RAC), GoldenGate, Dataguard, Import & Export, Data pumps, Oracle wallet management, Automatic Storage Management (ASM), Recovery Manager(RMAN).

Ticketing Tools: BMC remedy, Service now, Pack 2000

PROJECT EXPERIENCE:

Confidential, Dearborn, Michigan

Sr. Oracle DBA

Responsibilities:

  • Worked as a primary DBA for more than 150 databases and provided application support as required.
  • Installed and configured Oracle 12c,11g, 10g on Linux for Production, Development and Testing environments.
  • Worked closely with Engineering team in creating Databases.
  • Migrated data from one source to another source using ETL tool.
  • Installation of Oracle 12c Real Time Application Cluster(RAC) on ASM, Upgrading RAC cluster from 11.2.0.4 to 12.1.0.2 and upgrading databases, monitoring and managing databases on RAC
  • Used OCRCONFIG for OCR and OLR backups, Used CRSCTL, SRVCTL utilities to manage cluster ware and services in RAC environment
  • Worked on ASM in RAC and involved in creating DBFS in RAC, created ASM Volume, ACFS in RAC environment.
  • Involved in Installation and configuration of Oracle 11g and 12c RAC using Cluster ware and ASM.
  • Migrated databases using GG and RMAN for 2 node RAC.
  • Setup Automatic Storage Management to reduce I/O contention and support RAC databases.
  • Implemented and configured GoldenGate on a 2-node RAC cluster
  • Configured Automatic Storage Management (ASM) for 11g RAC databases.
  • ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL.
  • Involved in moving databases in Exadata on various versions on half node RAC environments.
  • Experienced in compressing data in various levels using Exadata.
  • Closely worked with Designing team in configuring Oracle 12c on Exadata boxes.
  • Experience in Oracle GoldenGate installation, configuration and troubleshooting GoldenGate issues.
  • Configured Down Stream Capture using GoldenGate.
  • Performed replication of data in distinct levels using GoldenGate and Dataguard techniques.
  • Configured active-active(Bi-directional), active-passive (Uni-directional) GoldenGate replications.
  • Involved in Classic and Integrated extract implementation and operations.
  • Hands on Cross platform migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with minimal downtime.
  • Involved in deploying new application and setting up replication between the databases using GoldenGate and troubleshooting issues.
  • Performed GoldenGate replication Monitoring, Performance Tuning, and Capacity Planning.
  • Worked with defgen and Log dump utilities in troubleshooting GoldenGate performance issues.
  • Enabled DML/DDL data replication, setup the heart-beat table to monitor GoldenGate replication lag and provided real-time lag report.
  • Replicated tables to different instances for load balancing and configured GoldenGate to support 24x7 environment.
  • Performed Backup, Restore and Recovery using RMAN and Flashback.
  • Used RMAN new feature of 11g and 12c.
  • Migrated Non ASM databases to ASM and Configured ASM disk groups to store Datafiles, redo log files, and control files.
  • Worked with developers in T- SQL programming in writing complex Queries , stored procedures, Triggers , Functions using T- SQL , MySQL database administration on a largescale MySQL installation.
  • Performed Performance Tuning by analyzing AWR, ASH, ADDM reports.
  • Prepared Documentation of Database performance with the help of ASH, AWR reports.
  • On daily basis activity monitored the databases using OEM, Worked with Data Masking Pack , Oracle Database Vault , Audit Vault, Data Redaction in OEM .
  • Mass deployment of agents on target servers and monitoring the servers using OEM.
  • Troubleshoot Database performance issues using Automated Workload Repository(AWR) and Automatic Database Diagnostics Monitor(ADDM). Tuned database for optimum performance.
  • Configured ODA and maintained ODA with minimum down time.
  • Created Oracle 12c databases for 2 large departments, from planning and testing through production.
  • Implemented Disaster Recovery for production database using Dataguard.
  • Upgraded databases from 11gR2 to 12c with Dataguard configuration.
  • Created standby databases and involved in converting Physical to Snapshot standby and Active Dataguard.
  • Configured Dataguard Broker and performed Switchover/Failover using Dataguard Broker.
  • Resolved blocking sessions on Oracle databases and monitored alert logs and applying shipped archive logs to standby databases using Media Recovery Process(MRP).
  • Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
  • Worked on refreshing Materialized views, creating reverse key indexes and hash partitioning tables
  • Upgraded Oracle databases from 11g to 12c and applied PSU patches when required.
  • Used Data pump operations to migrate the data in various levels.
  • Import/export/refresh data with Data Pump , load data for App teams.
  • Provided on-call 24x7 DBA support for Production databases and Test databases.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2) and 12c (12.1.0.4), Data pump, GoldenGate, Dataguard, RAC, Linux, Solaris, ASM, OEM, TOAD, SQL-T, Exadata, Green plum.

Confidential, WA

GoldenGate consultant

Responsibilities:

  • Supported and monitored more than 100 production and development databases using OEM
  • Provided day to day and on-call Oracle DBA technical support for clients by monitoring database servers, reacting to alerts, providing maintenance reports and other support requirements.
  • Handled Change Requests of users by troubleshooting Level1 and Level2 tasks as per SLA defined.
  • Configured GoldenGate components for unidirectional and bidirectional replications and maintained data synchronization.
  • Monitored and performed Performance Tuning of GoldenGate at database level and GGSCI level, investigated replication failures using Log dump utility.
  • Planned and implemented cross platform upgrades from 11g to 12c using GoldenGate.
  • Installed and maintained Oracle 12c on new Red Hat Linux environments.
  • Extensively used GoldenGate during Migration and Troubleshooting issues.
  • Worked with defgen and Log dump utilities in-order to resolve the issues in GoldenGate.
  • Have a pleasant experience in working as a Golden Gate SME.
  • As a Golden Gate SME interacted with multiple teams to gather data and configured the Golden Gate as per the requirement.
  • Implemented security access controls to data: Set up users , assign roles and security profiles , grant permissions, and manage resources , etc.
  • Proactively identified and mitigated project risks by analyzing gathered statistics.
  • Planned and Implemented Disaster Recovery (DR) and High Availability using RAC and Dataguard.
  • Performed installations of Oracle databases. Configured Listeners, create/migrate databases as per client requests. Oracle 11g installations on Linux servers, configuring Listeners and backup Listeners.
  • Cloned Databases using RMAN and Cold Cloning .
  • Used Oracle Datapump to export and import database table information.
  • Extensive experience in RMAN recovery in RAC and standalone database environments.
  • Worked with Oracle grid control. Oracle databases were under Linux and Unix operating systems.
  • Used to take the backup of databases using RMAN catalog . The restore capability included the restoring via stored RMAN tapes and using the RMAN database and tablespace restore and / or recover capability of RMAN.
  • Created Duplicate Database Using RMAN, Strong in Oracle Backup and Recovery.
  • Successfully implemented Backup & amp; Recovery using RMAN, Hot and Cold backups.
  • Experience doing Oracle RAC security patches , upgrades and installs.
  • Applied patches to resolve the Bug issues.
  • Installed and configured EBS 12.1.3 Validation environment with a 2 node 10g RAC (ASM)
  • Upgraded EBS 11.5.10 to EBS 12.2.4 and Oracle DB from 10g to 11.2.0.4.
  • Performed health checks of RAC cluster-ware components OCR, voting files and backups using OCR config and Troubleshooting Issues using Cluster-ware logs in 12C and 11g RACDAT
  • Experience in shell scripting and a good understanding of the Cron Jobs.
  • Installed and configured MySQL on Linux and Windows environments.
  • Effectively configured MySQL Replication as part of HA solution.
  • Installed, security, and maintenance of Linux based systems including MySQL 5.0.22 configuration.
  • Hands on upgrading databases from 10g to 11g and from 11g to 12c.
  • With the help of Data Pump operations performed the backup operations of database in different levels.
  • Copied data from one server to other using SCP and Data Pump.
  • Created SQL Tuning Sets and loading the plans into SQL Plan Management (SPM).
  • Enhanced performance of databases using various components like ACCESS TUNING ADVISOR, SEGMENT ADVISOR, UNDO ADVISOR and Automatic Shared Memory Management.
  • Involved in installation , configuration and maintenance of Oracle 11g/12C databases on Exadata boxes .
  • Migrated databases to Exadata x4-2 by configuring physical standby and switchover.
  • Worked on EXADATA X4-2 and x3-2 machines and migrated application databases using Expdp, GoldenGate and Dataguard.
  • Provided on-call 24x7 DBA support for production databases.

Environment: Oracle 10g/11g/12c, Data Guard, ASM, Oracle Enterprise Manager Grid Control 10g, 11g/12c GoldenGate, RMAN, Exadata, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris, Core: Banner 8, AppNav and Ellucian Solution Manager, Oracle database.

Confidential, St. Louis, Missouri

Sr. Oracle DBA

Responsibilities:

  • Extensive knowledge on database administration for Oracle 11g/10g with experience in very large scale database environments and mission critical systems.
  • Experience in Installation, Configuration and Monitoring of Oracle Server on Linux.
  • Provided 24x7 support and on call support on rotational basis.
  • Daily health check of the database using AWR, ADDM reports.
  • Experience in Oracle GoldenGate installation, configuration and troubleshooting GoldenGate issues.
  • Used defgen and Log dump utilities to solve the issues in GoldenGate configuration.
  • Migrated databases from one server to other using GoldenGate configuration.
  • Configured GoldenGate for Uni-directional replication.
  • Configured wallet in GoldenGate for security and confidentiality purposes.
  • Implemented Data guard with maximum availability, protection and performance configurations and worked with Switchover case and have knowledge in Failover process.
  • Configured Oracle Dataguard for Disaster Recovery(DR) on standalone databases in 11g.
  • Configured Snapshot standby database for Real time testing environment.
  • Involved in the conversion of Physical to Logical standby database to apply SQL generated statements to Standby database in Dataguard configuration.
  • Configured and Managed Dataguard to implement Physical standby database for DR solutions.
  • Configured Dataguard Broker and performed Switchover processes.
  • Configured multiple standby databases for a primary database.
  • Management of Objects, Schemas, Partitioning the tables and Indexes and administration of RAC and Dataguard databases in Oracle 11g.
  • Involved in Upgrading OEM from 10g to 11g and 11g to 12c.
  • Deployed and configured 12c agents in OEM.
  • Expertise in monitoring, troubleshooting OEM 12C.
  • Assisted developers in tuning SQL statements in the applications.
  • Experienced in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate and Dataguard with minimal downtime.
  • Upgraded databases from 10g to 11g.
  • Migrated databases from one server to another server using RMAN, Data Pump etc.
  • Proficient in setting up and troubleshooting network connections (i.e. setting up Listener and TCP/IP Connections).
  • Administrated and Monitored databases of various sizes from 500GB to 15TB.
  • Applied recommended Patches to the Production and Test environments.
  • Migrated the data from one server to other server using Data Pump operations.
  • Experienced in performing Performance tuning using AWR and ASH reports.
  • Created stored procedures, Functions, Triggers , Cursors and SQL scripts Using SQL Server Management Service( SSMS).
  • Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing Materialized views, created Partition tables and maintaining index’s.
  • Installed and Configured Oracle Retail Merchandising System ( RMS ) 8.0.
  • Tested and Supported various Oracle RMS applications.
  • Upgraded current systems from Oracle Retail Merchandising System (RMS) 8.0 to latest version.
  • Applied PSU Patches in the test environment whenever required.

Environment: Oracle 11g, 10g, Linux, Solaris, ASM, Data Guard, GoldenGate, RMAN, OEM, TOAD, SQL, RAC.

Confidential

Oracle DBA/ Developer

Responsibilities:

  • Valuable experience in Data Migration using traditional export/import and Datapump.
  • Provided 24x7 on call support on rotational basis.
  • Proficient in space management, capacity planning, monitoring and management.
  • Experienced in database migration by designing and implementing database logical and physical storage structures.
  • Experienced in taking Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. Performed full, incremental and cumulative backups using RMAN.
  • Extensive knowledge of Oracle Architecture, SGA, PGA, Static and Dynamic views.
  • Experience in user management which includes creating users, assigning roles and privileges.
  • Closely worked with Engineering team while Installing GoldenGate on source and target servers for Replication and implementing load balancing topology.
  • Configured GoldenGate Parameter files for Extract, Pump and Replicat process for replication.
  • Monitored and supported more than 50 database instances using scripts and daily health check like alert logs, invalid objects, table spaces usage, long running queries, backups, listener up and running, etc.
  • Configured and administered ASM instances and worked on troubleshooting ASM related issues.
  • Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
  • Involved in the process of upgrading databases from 10g to 11g.
  • Involved in building backup and recovery plans for critical databases from failures with minimum downtime.
  • Involved in creating templates and developing notification methods in OEM to support monitoring functionality for oracle databases and database/application servers.
  • Involved in troubleshooting of database using AWR, ASH and ADDM reports for better performances.
  • Worked on Table partitioning to increase performance.
  • Responsible for Network configuration and involved in a Client -Server environment using TNS Names, LISTNER, Net Configuration Assistant and other configuration files.
  • Performed Cross Migration and Migration of data using traditional export/import and Data Pump.

Environment: ORACLE 9i/10g/11g, Oracle 10g RAC, ASM, Windows 2003, RHEL 4.x, OLTP, Data Warehouse, RMAN, TOAD, SQL*Loader, Data Pump, SQL, PL/SQL, Data guard, OEM, Shell Scripting, GoldenGate, Dataguard, OEM Grid Control.

Confidential

Jr. Database Administrator

Responsibilities:

  • Provided 16x7 supports for Oracle 9i/10g production databases in UNIX environments.
  • Granting and monitoring user access rights and privileges through Roles.
  • Monitoring the table space growth periodically.
  • Regular monitoring of alert and trace files, database disk usage on the server.
  • Moving database to archive log mode and no archive log mode.
  • Altering of system parameters (p-file and sp-file).
  • Used EXPORT/IMPORT/DATAPUMP to do table/schema level and full database refresh.
  • Configured Recovery Manager (RMAN) to perform backup, restore, and recovery operations.
  • Implemented Hot, Cold and Logical backup plans.
  • Performed Schema and Table level replication using Oracle Streams.
  • Monitored data transfer between the Database servers using Oracle Streams.
  • Successfully performed data replication using Materialized views and Oracle streams in 10gR2.
  • Terminating user locks and user account locks and jobs as per user request.
  • Migrated the data from one server to the other using traditional export/import.
  • Creating users, giving privileges to them on particular tables etc. And maintaining tablespace sizes.
  • Altering the databases from archive log mode to no archive log mode and vice versa depending on requirement.
  • Applied interim Patches every quarterly in the test environments.

Environment: Oracle 9i/10g, Sun Solaris, windows NT/2000/2003, RMAN, DBCA, Dataguard, Oracle Enterprise.

Hire Now