Oracle Guard

240-***-****

admhur@r.postjobfree.com

Professional Summary

Experienced Oracle DBA with 5+ years of experience in Oracle Database Administration and PostgreSQL in large-scale production environments across multiple platforms.

Expert in implementing High Availability solutions with Oracle 12c RAC, Oracle Data Guard and replication using Streams.

High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)

Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.

Performance Tuning of the database (Memory Tuning, I/O Tuning)

Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.

Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 12cR2 on two node RAC

Worked on large-scale databases with size around 10TB in large system environments.

I managed Oracle and PostgreSQL databases supporting many different applications. Great knowledge in PostgreSQL database architecture, experience assuring the availability, performance, integrity, and security of Oracle and PostgreSQL databases for both

OLTP and OLAP environments.

Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.

Built a new two-node Oracle 18c RAC Cluster Production database with Physical Standby.

Providing the performance tuning of slow running queries in Production Murex application.

Installed a new Oracle 13c Enterprise Manager Cloud Control for database monitoring.

Implemented OEM 13c Alert Email System. It monitors databases, cluster, hosts, etc

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Created indexes to facilitate easy user interface implementation and tuning.

Involved in construction of DR sites for all the Production and IST environments.

Performed Database Refresh from Production to IST, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Upgrade/Migration of oracle databases from 11g to 12c and 11gRAC to 12cRAC.

Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.

Cloned Database from Production to Test and Development.

Exporting and Importing of dumps using expdp and impdp.

Experience in Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 19c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc

Expert in RMAN backups including full, incremental and cumulative.

Excellent knowledge in FlashbackRecovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

Extensively worked on Import/Export and DataPump Import/Export tools.

Knowledge in configuring ASM (Automatic Storage Management)

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing.

Professional Experience

FREIGHTCAR AMERICA - Cherokee, AL

July 2017 – Present

Oracle PostgreSQL Database Administrator

Experience with large databases (1.5 Tb) for OLTP and OLAP applications.

Performed installation, configuration and maintenance of oracle 12c/19c, 12c RAC databases.

Experience in configuring oracle 11g, 12c Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management(ASM).

Performed migration of oracle 11g/12c non RAC single instance to RAC database instances.

Experience with 12c cluster maintenance using CRSCTL command.

Experience in using SRVCTL command for Oracle 12c RAC database.

Implemented Disaster Recovery database 11g/12cData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

Installed and configured Oracle 12c database on a test server using Oracle standard procedures and OFA, for performance testing and future 11g production implementation.

Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption

Extensively worked with ASMCMD for managing ASM environment.

Used Oracle 12c/19c AWR & ADDM to monitor database activities and performance tuning.

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Implemented oracle 19c active standby database for test database environment.

Implemented oracle 19c flexi asm for pre-prod environment.

Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.

Installed, Configured Oracle 19cGoldengate on Oracle 19c Database.

Implemented OEM 19c Repository database, OEM 19c Agent and golden gate plugin Installations.

Extensive Experience with Change Board Meetings and Change Control Management for all database changes.

Providing database administrative support and 24x7 on call support for production, development oracle 19c/12c databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.

Resolved data integration issues.

Performed version upgrades and patch installs.

Solid discipline in providing end-users timely updates on their problems. Installing server software.

ASM implementation & maintenance. Migrating and upgrading the Oracle 10g database to Oracle 11g and incorporating the changes in the database design.

Proactive performance monitoring, and capacity planning for future database and server growth using OEM.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

PAYCHEX INC - Rochester, NY

March 2014 – July 2017

Oracle Database Administrator

Hands on experience in cloning the non-multitenant container database to pluggable database in 19c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Loading data from flat files to database using SQL*Loader, External Tables.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Performed Database upgrade from Oracle 12c to Oracle 19c RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Involved in the installation, configuration and extended support to Oracle 12c, 19c two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 12c, 19c RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggersand Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 12c to 19c.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implementing Datapump utility of Oracle 12c, 19c for re-organizing Databases/Schemas/Tables to improve the performance.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Databases migrated to RAC for improved resiliency and performance.

Security User Management, Privileges, Role, Auditing, Profiling, Authentication. Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.

Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.

Provided valuable inputs for various performance tuning issues.

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. Refreshed/cloned databases using RMAN utility.

Involved in fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.

Experience working on POC of 19c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc

Made optimal use of Oracle Support with Service Requests.

Provided 24 X 7 production support.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes

Contact this candidate