SUMMARY

• Seeking a position in a rapidly growing Company, which would best utilize my strong experience as an Oracle Database Administrator.
• 8 years of experience as a Oracle DBA in the latest Oracle 19c, 12c R2, 12c R1 and 11g R2 versions with Oracle RAC, Oracle ASM and Oracle Data Guard configurations on Linux servers.
• Rich presentation and documentation skills using MS VISIO and the cloud based Gliffy software. Always ready to represent DBA projects and database architectures using diagrams for better communication to senior IT leaders in the organization.
• Extensive knowledge and experience as an Oracle DBA (19c, 12c R2, 12c R1 and 11g R2).
• Well experienced as an Oracle DBA using Oracle RAC, Oracle Data Guard and Oracle ASM.
• Strong experience in upgrading Oracle databases from 12c R1, 12c R2 to the latest Oracle 19c version using DBUA utility.
• Rich experience in installing Oracle 12c R1, 12c R2, 19c and migrating traditional databases (non - CDB) into a Oracle 12c multi-tenant container database (CDB).
• Well experienced using Oracle Data Guard Broker (DGMGRL).
• Installed and configured Oracle Enterprise Manager Cloud Control 13c on Linux x86-64 bit servers to manage, monitor and administer various Oracle databases in the enterprise
• Monitored /managed 4 node RAC environments databases, using OEM grid control, and RMAN database backup and recovery.
• Gained good experience in Oracle database performance tuning both at the macro level including using parallelism in Oracle database operations as required as well as the minor level troubleshooting database developer performance tuning issues. Used Diagnosis tools such as TKPROF and can review and act on Oracle AWR reports.
• Very strong in Oracle database backup and recovery using both RMAN and user-managed methods (hot backup and cold backup).
• Very hands on in cloning databases in Oracle using both user-managed method (Cancel based Recovery, Time based recovery) and RMAN backup-based duplication.
• Strong in using Oracle DataPump utilities for unloading (expdp utility) and loading data (impdp utility). Well-versed with taking object level backups, schema level backups as well as the full database backups using expdp.
• Good interpersonal skills and a good team player with activities and timelines.
• Can work with Oracle support to search knowledge base and create service requests in https://support.oracle.com

TECHNICAL SKILLS

Database Systems: Oracle Database Enterprise Edition 19c, 12c R2, 12c R1 and 11g R2.

Oracle Advanced Features: Oracle ASM, Oracle RAC and Oracle Data Guard

Database Monitoring and Management: Oracle Enterprise Manager Grid Control 13c (OEM)

Languages: Oracle PL/SQL, Linux Shell Scripting

Operating Systems: Oracle Enterprise Linux (OEL), Red Hat Enterprise Linux (RHEL)

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• 24 x 7 Oracle DBA support and maintenance using Oracle ASM, Oracle RAC and Data Guard.
• Involved in both daily database administration support and maintenance as well as new implementations and projects such as Oracle 12c R1 to Oracle 19c upgrades.
• Setup and Configured Oracle Automatic Storage Management 19c (ASM) Grid Infrastructure on Oracle Enterprise Linux platform using Oracle Universal Installer program.
• Experience in configuring and managing OracleReal Application Cluster(RAC) with ASM,Data Guardfor Oracle High Availability.
• Configuration and Management of OracleData Guard using Data Guard Broker.
• Providing DBAsupport to multiple Cluster, Non Clusterand ASM Databases in production, development and Testing Server in Linux Environments.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Installation, Configuration ofASM,RACdatabases, Adding Services and maintainingGRIDcontrol.
• Installation, configuration and maintenance ofPhysical StandbyusingOracle Data Guardfor Disaster recovery process onOracle 11g, 12c, 19c.
• Setup physical standby’s (DATAGUARD) for several Databases running 12c and 19c as well (CDB and Non-CDB)
• Configured Data guard broker between theprimaryandstandbydatabases, perform Switchover/Failover and monitor the data guard status via command line.
• PerformOracle RDBMS 12c/19c patching on RAC and Data Guard environments.
• Install/support/upgrade/maintain/backup Oracle RAC DB in PROD environments.
• Applying Oracle interim patches using the Oracle OPatch utility as well as applying Oracle 19c RUs (Release Updates) and RURs (Release Update Revisions).
• Primary responsibility for creating Oracle test and development databases by using RMAN backup-based duplication from production database. Prepared DBA documentation work for standard backup and recovery procedures using detailed screenshots and architecture diagrams in Atlassian WIKI (Confluence).
• Worked with Oracle Support https://support.oracle.com to create service requests and research known issue articles for various Oracle database issues. Pro-actively followed up with Oracle Support for a timely resolution of these service requests.
• Worked with IT auditors in performing database audits for tasks such as annual password resets, Oracle object and system privilege audit, Oracle database roles’ audit and annual database DR tests.
• Provided on-CALL DBA support using PagerDuty tool.
• Created programs using Linux shell scripting to automate database administration tasks such as Oracle RMAN backups, disk space monitoring, identifying blocking sessions, Oracle Data Guard archive log apply lag and database availability etc.
• Involved in User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking System/object privileges, roles, auditing user actions in the database.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Provide 24 x 7 database administrative activities for the organization’s Oracle databases.
• Involved in both daily database administration support and maintenance as well as new implementations and projects.
• Performed Oracle 12c R1 Grid Infrastructure setup and configuration for implementing Oracle ASM.
• Upgraded Oracle databases from Oracle 11g R1 to Oracle 11g R2 using Oracle Database Upgrade Assistant (DBUA).
• Performed Oracle database cloning using RMAN duplication and manual method.
• Tune Oracle databases using performance metrics in AWR reports (Automated Workload Repository) as well as work with Oracle application developers such as Oracle Java developers and PL/SQL developers in fixing their database performance issues SQL Trace, Oracle execution plan analysis, right sizing TEMP and UNDO table spaces etc. along with troubleshooting database locking issues and resolving them in a timely fashion.
• Involved in strengthing Oracle databases security by setting up database profiles with resource limits, review and revokation of sensitive system privileges.
• Extensively worked in Oracle SQL, PL/SQL, Query performance tuning and reviewed application developer produced DDL scripts using best practices such as object naming, normalization and index design.
• Applied Oracle quarterly security patch bundles ( CPU patches ) and patches for known one-off issues using Opatch utility.
• Worked with System Administrators in helping migrate Oracle database datafiles from existing disks to new high speed SAS disks.
• Worked with Oracle Support https://support.oracle.com to create service requests and research known issue articles for various Oracle database issues.
• Worked with ORACLE RDBMS utilities such as DBCA for creating databases, DBUA for upgrading databases as well as NETCA for Oracle*Net configuration.