We provide IT Staff Augmentation Services!

Senior Dba Consultant Resume

Denver, CO

SUMMARY

  • Having 14 years of experience in handling Oracle Databases on various platforms like Linus, UNIX and Windows platforms. Skills in Installation, Cloning, Patching, Upgrade, Data Guard, Real Application Clusters (RAC), OEM Grid control, Replication, Performance Tuning, OCI, Backup & Recovery through RMAN, Exadata and Golden Gate.
  • Proficient in installation and configuration of Oracle 19c,18c,12c,11g,10g & 9i on LINUX/Windows platforms.
  • Expertise in installing, configuring, and maintaining Oracle RAC (Real Applications Clusters).
  • Install, configure & manage GOLDENGATE environments.
  • Administration of Exadata Database Machines on X5, X6, X7 & X8.
  • Upgrade oracle databases.
  • Performed RMAN backups (Full, Incremental and Cumulative) and recovery.
  • Have implemented two types of standby databases supported by Data Guard - logical standby and physical standby databases.
  • Worked on large-scale databases with size around 60+ TB in large system environments.
  • Expert in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
  • Created development, test, stage and production ‘RAC and standby databases’ for OLTP and Data Warehousing environments.
  • Applied Patch Set Updates and One-Off patches when required.
  • Strong experience in database performance tuning using tools like TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables.
  • Provided 24x7 on-call production database support with timely resolution of tickets.
  • Performed RAT (Real Application testing), before any major change on Production databases to identify performance issues.
  • Configured Oracle Enterprise Manager for monitoring databases.
  • Setup and upgrade of Oracle Agents on the database servers.
  • Proficient in implementing Oracle Flashback technology for faster recovery of tables/database.
  • Management of Schemas, Objects & Partitioning the tables & indexes
  • Database replication using Materialized views and advanced Replication methods like GOLDENGATE.
  • Performed Switchover and Failover drills.
  • Good experience on Container and Pluggable databases.
  • Expertise in maintaining and reinforcing standards for change management, database security plan and auditing.
  • Excellent knowledge of Oracle Architecture, SGA, Listeners, TN names, SQLNET, V$ and DBA views.
  • Well experienced in working with various project, application, and infrastructure teams, in large enterprise projects.
  • Versatile team player with excellent analytical, communication and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEMS: IBM AIX, HP-UX, Sun Solaris, Red Hat Linux, and Windows

RDBMS: Oracle 19c/18c/12c/11gR2/10g/9i

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Oracle Data Guard, Real Application Clusters (RAC), ASM, TOAD, Data Pump (Expdbp, Impdp), SQL*Plus, SQL*Loader, SQL Developer, Golden Gate, EXADATA

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ASH and ADDM

PROFESSIONAL EXPERIENCE

Confidential, Denver CO

Senior DBA Consultant

Responsibilities:

  • To provide 24X7 database support for multiple Clients.
  • Gathering requirements and Designing database layout.
  • Installing/Configuring database environments.
  • Performing environment consolidations for better capacity usage.
  • Good experience in managing Exadata x5, x6, x7 and x8 database machines with different configurations like quarter/half/full racks.
  • Performed multiple database migrations to Exadata and Oracle Cloud (OCI).
  • Hands on experience in upgrading Oracle databases to latest versions like Oracle 19C.
  • As per the App team requirements, creation/cloning of Oracle databases.
  • Troubleshooting and fixing the performance issues.
  • Configure/Optimize backups using RMAN.
  • Experienced in installation, configuration and maintenance of table, schema and DB level replication using Oracle Golden Gate.
  • Troubleshooting and fixing Golden Gate sync and replication issues
  • Setup OEM13C and configure required databases in it.
  • Expertise on Exadata Storage server features like Smart Scan, Storage Indexes, Smart Flash Cache, HCC & IORM.
  • Create, Manage and Monitor databases in Oracle Cloud (OCI).
  • Converted Non-CDB databases to CDB/PDB.
  • Cloning Pluggable databases.
  • Documenting methodology to setup for any new technical implementation.
  • Report project progress to higher management and the respective stake holders.

Environment: Exadata Machines (X5, X6, X7, X8), OCI, RHEL, OEL, Oracle-12C,18C,19C, Oracle Enterprise Manager (OEM 13c), RMAN, Golden gate, Jira ticketing tool.

Confidential, Plano, TX

Oracle DBA Consultant

Responsibilities:

  • Support all the Oracle database environments.
  • Coordinating with various Toyota infrastructure teams.
  • Ensure an excellent quality of deliverables and efficiency in meeting deadlines for all assignments.
  • Planning and executing Data Center Migration (DCM) activities.
  • AS part of DCM activities, create and manage Cluster (RAC) databases.
  • Troubleshoot and fix slowness issues in Cluster (RAC) databases.
  • Upgraded Cluster (RAC) databases from 2.
  • Install and Configure Goldengate for the databases.
  • Troubleshoot issues related to Goldengate replication.
  • Configured standby cluster databases, troubleshoot, and fix for any synchronization issues.
  • Configure and Refresh Materialized views.
  • Setup, Monitor and fix the failed jobs in the database.
  • Tuning of SQL queries and database systems.
  • Performed Capacity Planning and Bench Marking.
  • Partitioned large tables for better performance and manageability.
  • Logical and Physical Database Design.
  • Upgrade and Patch databases of multiple versions.
  • Refreshing databases, schemas & tables as requested by users.
  • Extensive experience in Data guard configuration, implementing and maintaining standby databases.
  • Creating users and roles accordingly.
  • Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups, and Logical backups.

Environment: IBM-AIX, HP-UX, RHEL, Oracle 12C, 11gR2, 11gR1, 10g, 9i, Oracle RAC (12.1.0.2, 11.2.0.4), Oracle Enterprise Manager (OEM), RMAN, Expdbp/Impdp, ASM, AWR, SQL*Plus, PL/SQL, ServiceNow ticketing tool.

Confidential, Cincinnati OH

Oracle DBA Consultant

Responsibilities:

  • Installation and Maintenance of Oracle 10g, 11gR2 and 12C standalone and RAC databases
  • Upgraded oracle databases from 9i to 10g, 10g to 11g and 11g to 12c.
  • Performed RAT (Real Application testing), before any major changes on production databases to identify performance issues.
  • Configured Physical standby databases for production databases and responsible for synchronization between primary and standby databases.
  • Upgraded RAC databases from 11.2.0.2 to 11.2.0.4 and 11.2.0.4 to 12.1.0.2, including standby database.
  • Apply patches and PSUs for multiple databases.
  • Configured Oracle ACTIVE DATAGUARD for Database Disaster Recovery by using DATA GUARD broker (DGMGRL).
  • Performed oracle database refreshes using Expdbp/Impdp from production to test database.
  • Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
  • Involved in monitoring the database related activities using Oracle Enterpriser Manager 11g Grid Control and OEM 12C.
  • 24x7 remote support and on call support for Production databases.
  • Perform cloning of database using RMAN tool.
  • Setup and upgrade Oracle Agents on the database servers.
  • Analyse SQL statements, reorganize database objects and design indexes to improve response of queries.
  • Performance tuning of database by using the reports AWR, ADDM, ASH, TKPROF, SQL TRACE, and EXPLAIN PLAN.
  • Automating the daily routine activities and Schedule maintenance jobs by creating/developing UNIX shell scripts and Oracle scheduler jobs.
  • Planning the backups using RMAN, logical (import/export, Impdp/Expdbp), hot and cold backup.
  • Oracle Database capacity planning, Creating & Managing Database Structures, space management and storage allocation.
  • Familiar with the third-party tool Delphix, which is used for provisioning a database and refreshing databases very quickly for application teams and testing teams.

Environment: IBM-AIX 6.1 &7.1, RHEL 2.6, Oracle 12C, 11gR2, 11gR1, 10g, Oracle RAC (12.1.0.2, 11.2.0.4), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, TOAD, Unix Scripting, SQL*Plus, PL/SQL, INFRA ticketing tool.

Confidential, Seattle, WA

Senior Oracle DBA

Responsibilities:

  • Database monitoring and maintenance of 60 production databases and around 200 test and development databases.
  • Professionally solving day-to-day problems.
  • Supported Oracle 10g RAC databases on Sun Solaris servers.
  • Troubleshooting failed batch jobs and failed user jobs in the database.
  • Finding database fragmentation like table & index fragmentations & reorg those objects.
  • Performing Table level and schema level refresh using Data pump Export (Expdbp) and Import (Impdp).
  • Experience with loading data from flat files into tables using SQL* loader.
  • Supporting streams configured databases environment.
  • Creating Users and managing users by assigning roles, privileges and profile to users.
  • Create and troubleshoot DB Link’s issues in Oracle for communicating with external databases.
  • Troubleshooting long running jobs and performance issues in the database.
  • Experience with backup and recovery methods HOT/COLD, EXPORT/IMPORT and DATAPUMP.
  • Experience with database backup tool RECOVERY MANAGER (RMAN) on ORACLE 10G and ORACLE 11G.Experience at Cloning of database using RMAN.
  • Worked on performance issues of database using Automated Workload Repository (AWR), Automated Database Diagnostic Monitor (ADDM) and Active Session History (ASH).
  • REFRESH/CLONING of Database for development, testing purposes.
  • Configured and supported Automatic Storage Management (ASM) databases.
  • Analysing Alert Log and User Trace Files and diagnosing the problem.
  • Worked with Oracle support to resolve various database issues through SR (Service Request).

Environment: Sun Solaris, Oracle 10g/11g Oracle Enterprise Manager (OEM), RMAN, Import/Export, Data Guard, ASM, AWR, TOAD, SQL Developer, Unix Scripting, SQL*Plus, Service Request Ticketing tool.

Confidential

Oracle DBA

Responsibilities:

  • Responsible for administration and supporting Oracle 9i databases in DEV, QA, UAT and Prod environments
  • Scheduling and maintaining RMAN (Recovery Manager) backups.
  • Refreshing dev/test databases from Production databases.
  • Applied PSU patches to Oracle Databases.
  • Database monitoring and performance tuning using OEM (Oracle Enterprise Manager), AWR and ADDM
  • Worked on Automatic Storage Management (ASM) for managing data in SAN
  • Monitoring and resolving tickets in different environments
  • Export and import of database objects from one database to another database.
  • Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
  • Created Users, Roles, Profiles and granted privileges to users as required.
  • Created UNIX shell scripts to automate batch jobs through Cron.
  • Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyse jobs, database backup logs etc.

Environment: HP-Unix, Oracle 10g, Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, SQL*Plus, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

  • Installation and creation of Oracle 9i databases.
  • Maintaining Production, Development and Test Databases.
  • Creation of users, profiles, and roles accordingly.
  • Creation of Tablespaces, data files, tables, and indexes.
  • Perform user managed Backups.
  • Doing Export and Import at Database, Schema, and table level.
  • Resizing of Tablespaces based on alerts
  • Upgraded the database from 9.2.0.4 to 9.2.0.7
  • Configured Recovery Manager (RMAN)
  • Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
  • Accepting and solving User raised Tickets in ticketing tools like Remedy, Manage now.
  • Created Technical Notes and Documentation

Environment: IBM AIX, Windows 2000/2003, Oracle 9i, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, SQL*Loader, Remedy and Manage now ticketing tool.

Hire Now