Snr. Oracle Database administrator available

Snr. Oracle Database administrator

available
Profileimage by Anonymous profile, Snr. Oracle Database administrator
  • 30092 norcross Freelancer in
  • Graduation: Bsc in Computer Science.
  • Hourly-/Daily rates:
  • Languages: English (Native or Bilingual)
  • Last update: 25.11.2020
KEYWORDS
SKILLS
Technical Skills
  • 18+ years of experience in Oracle DBA and have been involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
  • Expertise in Oracle 11g, ASM, RAC, OEM, Data Guard, RMAN and Shell Script
  • Configured and maintained replication using Oracle Golden Gate.
  • Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
  • Having good knowledge on EXADATA and Involved in moving databases in EXADATA to  RAC environment.
  • Experience in Data Migration using Data pump utility, Non RAC to RAC and Non ASM to ASM.
  • Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
  • Implemented Oracle Audit Vault
  • Managed Oracle security (using virtual private databases and role-based security).
  • Implemented virtual private database/application context code.
  • Database Refresh from Production to Development and from Development to Test environments.
  • Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.
  • Experience in Space Management by Monitoring and Managing Tablespaces.
  • Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
  • Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer. 
  • Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden Gate (OGG) in Oracle to Oracle homogeneous environments.
  • Monitoring Alert log for any errors and issues.
  • Resolved Replication related errors Such as ORA -1403, 0001, and several other errors regarding golden gate replication during and after code deployment activity.
  • Good understanding of no-SQL database, Cassandra and Hadoop.
  • Communicated and interfaced with Oracle support via Metal-link to troubleshoot day-to-day database issues. 
  • Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.
  • Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup, adding a node to existing cluster database for High Availability and Recovery. 
  • Hands on experience working on High Availability Environments.
  • 24 X 7 Production Database on Call Support.
  • Experience working with data warehousing (OLAP) applications, transactional database (OLTP) development, installing, configuring, administering, managing oracle databases, implementing solutions like High Availability (HA), Disaster & Recovery, Cloning, and Database Security. 
  • Mentored other DBA in various Oracle and non-Oracle related tasks.
PROJECT HISTORY
WORK HISTORY
General Motors                                                                                                       Atlanta, GA                                                                                                                                              Feb.2017– Present
Lead - Oracle Database architect.
Environment: Oracle 9i/10g/11g/12C, TOAD, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Guard, Grid Control, Golden Gate, EMC, HP-3Par, Linux Advanced Server, RHEL, Windows, ASM.
 
Responsibilities:
  • Mentoring Team members and Junior Data Database Administrators in all aspects of the Software Development Life Circles.
  • Installation, Configuration and Migrated multi- Terabyte Database from existing to a new Data Center.
  • Installation, upgradation, configuration and troubleshooting Oracle Goldengate 11G/12C software.
  • Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
  • Managed Oracle security (using virtual private databases and role-based security).
  • Implemented virtual private database/application context code.
  • Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility. 
  • Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard/Rman Duplicate.
  • Installed configuring Real Application Clusters (RAC) on Oracle11g /12c Automatic Storage Management (ASM).
  • Setup and maintenance of DATA GUARD on 11g,12C for Disaster Recovery and reporting purpose with various modes.
  • Performed Data Center Migration involving multi-Terabytes Oracle databases.
KFORCE,  Atlanta, GA                                                                                                                   Sep.2015– Jan 2017
Lead -    Oracle  DBA (The Home Depot)
Environment: Oracle 11g/12C, TOAD, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Guard, Grid Control, Golden Gate, EMC, HP-3Par, Oracle Linux, Windows, ASM.
 
Responsibilities:
  • Installation, Configuration and Migrated multi- Terabyte Database from existing to a new Data Center.
  • Installation, upgradation, configuration and troubleshooting Oracle Goldengate 11G/12C software.
  • Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
  • Managed Oracle security (using virtual private databases and role-based security).
  • Implemented virtual private database/application context code.
  • Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using, report files and LogDump utility. 
  • Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle Golden Gate and Dataguard/Rman Duplicate.
  • Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle11g Automatic Storage Management (ASM).
  • Setup and maintenance of DATA GUARD on 11g,12C for Disaster Recovery and reporting purpose with various modes.
  • Database Cloning for Logical and Physical Standby server.
  • Maintained and monitored RMAN backup, restore, and recover as needed.
  • Created database links to retrieve data from multiple Databases source to ODS.  
  • Monitored Schema level performance issues and performed the tasks like analyzing tables, rebuilding indexes and gathering Stats on a timely basis.
  • Performed Data refreshes using export/import as well as data pump jobs for monthly partition maintenance like truncating partitions and adding new partitions.
  • Successful in providing 24/7 support for production, development, and test database.
  • Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
  • Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose's.
  • 24X7 production support and on call rotation
Snr. Database Architect                                                   
Teksystems – Onstar Project (General Motors) ,   Detroit, MI               03/13- 09/15  
Environment: Oracle 9i/10g, TOAD, SQL Plus, Oracle Enterprise Manager (OEM), RMAN, Oracle and Linux.
Responsibilities:
  • Creating and maintaining databases, creating table spaces, tables, indexes, data files etc.
  • Installed configured Oracle Enterprise Manager (OEM) / Grid Control for monitoring and administrative tasks purposes.
  • Installed, Setup and configure Goldengate Bi-directional, Broadcast, and Unidirectional replication.
  • Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
  • Managed Oracle security (using virtual private databases and role-based security).
  • Implemented virtual private database/application context code.
  • Created and implemented replication between 2 databases running on Unix RAC for multiple schemas and validated replication for insert, updates functionality between both source and destination databases.
  • Handled several Onstar Global and minor releases from 4.3 – 6.2 Database and Goldengate replication design changes  from ODS and application perspective.
  • Installed, configured, loaded and implemented of Oracle Spatial Database changes using various ESRI files from different vendors (i.e. NavTeq,TomTom,Nokia, etc).
  • Installation and configuration of Oracle 10g / 11gR2/12c  Real Application Clusters (RAC)
  • Great Understanding of how the complex Banner environment works together.
  • Backup plan designing and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.
  • Perform capacity planning required to create and maintain database environments.
  • Helping the development team and data warehousing team.
  • Monitored table space size, resizing table space, relocating data files for better disk I/O.
  • Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Monitoring table space size, resizing table space, relocating data files for better disk I/O.
  • Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.
  • Performed large data loads through SQL*Loader  
  • Managing archive logs, DB-links, partitions.
  • Create Indexes by analyzing and rebuilding of Indexes for better performance.
  • Managed database users and security for the SQL Server database.
  • Fine-tuned and maintained large production SQL Server databases, as well as monitored overall database activities using Profiler
  • Monitoring of SQL Server databases, working to maximize availability and tune data performance as needed.
  • Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
  • Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer. 
  • Provided hands-on support and implementation of Installation / Configuration / Performance Tuning / Trouble shooting Oracle Golden Gate (OGG) in Oracle to Oracle homogeneous environments.
  • Monitoring Alert log for any errors and issues.
  • Resolved Replication related errors Such as ORA -1403, 0001, and several other errors regarding golden gate replication during and after code deployment activity.
  • Worked with various application teams in developing, testing and deploying codes across all life cycles of the application phase.
Lead  Oracle  DBA                                                                           
Accenture (Ally Financial, State of Vermont, Canada FRO),  Atlanta, GA                                        11/12 – 01/13
Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, Veritas NetBackup, RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL,
 
Responsibilities:
  • Managed and led DBA team in the complete SDLC, Database design, System analysis, design and development to production phase.
  • Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
  • Setup and configure RMAN Backup using Varitas – NetBackup for all  Backups.
  • Provided daily database administration support such as monitoring space utilization, backup, and export /import of schema objects.
  • Installed, configured and implemented Oracle Enterprise manager Grid Control.
  • Engaged in database and Disaster Recovery capacity planning and implemented Disaster recovery exercise.
  • Supported, maintained and troubleshooting Oracle Goldengate for data replication and high availability databases.
  • Debugging Goldengate replication issues such as abend of replicat,extract, and pump processes.
  • Implemented Oracle Transparent Data Encryption to encrypt tables and tablespaces that contains PII,PCI and SOX data.
  • Managed Oracle security (using virtual private databases and role-based security).
  • Implemented virtual private database/application context code.
  • Performed performance tuning using SQLT tool to migrate SQL profile between databases to impact and reduce query runtime.
  • Installed and configured Multiple Oracle 11g databases.
  • Responsibilities included applying CPU/PSU patches, maintaining and troubleshooting database issues.
  • Installed and configured Oracle Audit Vault server / database for a two (2) node RAC with a standalone audit vault server.
  • Installed and configured Audit Vault Agent on a two (2) node RAC.
  • Configured and integrated DB and OS collectors with the Audit Vault server/database
  • Performed Trouble shooting of ora errors and performance tunning of oracle instances and databases.
Snr. Oracle  DBA                                                                             
IBM (Pfizer, Virgin USA, Hertz, SOM, Budget ),  Dubuque, IA                                             10/09 – 12/11
Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, SQL BACKTRACK, Veritas NetBackup RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL,
 
Responsibilities:
  • Involved in the complete SDLC, Database design, System analysis, design and development.
  • Cloned databases using RMAN and manual copy.
  • Performed disaster recovery using Oracle Recovery Manager.
  • Setup and configure RMAN Backup using Varitas – NetBackup for all  Backups.
  • Supported, maintained and troubleshooting Oracle Golden Gate for data replication and high availability databases.
  • Performed backup and recovery using BMC SQL BACKTRACK.
  • Engaged in database capacity planning for a new application deployment.
  • Installation and configuration of Oracle 9i/10g/11g Real Application Clusters (RAC).
  • Performed backups and tested crash recoveries using conventional cold, hot and RMAN backups.
  • Experience in Supporting Bi-directional Goldengate replication between databases.
  • Setup and configure goldengate Manager Processes, Extract Processes, and Replicat Processes for a Unidirectional replication.
  • Responsibilities included installing, upgrading, migrating and applying patches to Oracle databases.
  • Managed 4 node Oracle 10g Real Application Clusters (RAC) databases with ASM Storage.
  • Responsible for creating standard database creation scripts, installation, upgrades, patches, contacting Oracle collaborative support for critical issues.
  • Performed numerous Oracle database  migration from RDBMS 10g through 11g using various Oracle migration methods such as EXPDP/IMPDP, Transportable Tablespace .
  • Performed cross-Platform Migration of oracle databases.
  • Supported Quest SharePlex for data replication and for high availability stand-by databases.
  • Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
  • Proactive monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM, and 10g OEM Grid Monitoring.
  • Performed daily service management activities related to change, incident and problem management, as well as coordinate and/or participate in team and customer meetings.
  • Analyzed and tuned Oracle database / instances using EXPLAIN PLAN, AWR Reports, Advanced Database Diagnostic Monitor (ADDM), StatsPak, SQL*TRACE and TKPROF.
GET IN TOUCH

Message:

Sender: