Oracle Database Administrator and Hadoop Administrator Resume Pittsburgh PA - Hire IT People

SUMMARY

Certified Oracle Database Administrator with over six years of experience supporting Oracle 11g/12c/19c databases, including installation, configuration administrations, and upgrades. Three years of SQL Server and Hadoop Administration.
Proficient experience in Performance tuning, Monitoring, and Oracle Enterprise Manager (OEM)
Extensive experience in performing backups and testing crash recoveries using hot/cold backups and utilizing Recovery Manager (RMAN
Proficient in Real Application Cluster (RAC) Installation, Configuration, and administration with Automatic Storage Management (ASM) on Oracle11g&12c RAC Grid infrastructure and standalone.
Proficient in configuring and troubleshooting Oracle Data Guard for high availability and disaster recovery purposes.
Administered over 600 databases across Development, QA, UAT, and PROD environments via command line and Oracle tools - Oracle Enterprise Manager Cloud 12c and 13c.

TECHNICAL SKILLS

Operating Systems: Redhat Linux, Oracle Linux, AIX 5.3, 6.1 RHEL 5.x., Linux Enterprise Server 9, 10., Windows 2012

RDBMS: Oracle 10g, 11g, 12c, 19c, SQL Server

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python, Java

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

Oracle Database Administrator and Hadoop Administrator

Responsibilities:

Successfully upgraded oracle databases from 11g to 12 and 12c to 19c on DEV, TEST, and PROD
Provided Database Administration support for Oracle, Hadoop, and MS SQL Server
Successfully migrated tables from Oracle to SQL Server
Cloning/duplicating the database with RMAN and user-managed (hot/cold) backups.
Planned and implement backup and recovery strategy and wrote shell scripts to do nightly RMAN backup.
Installed, patched, and managed Oracle Database versions 11g and 12c on Red Hat Linux and Windows Operating Systems.
Implemented two types of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 and 12c.
Led disaster recovery testing or emergency recoveries and ensured recoverability of Databases was possible.
Conducted meetings with the Application team to tune their Application performance
Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters) with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
Documentation of Standard Operating Procedures

Confidential, Pittsburgh PA

Oracle Database Administrator

Responsibilities:

Performed Installation and configuration of Oracle 12c database on Unix, Linux, and Windows platforms.
Installed Oracle enterprise manager 12c, oracle management repository, deployed agents and created incident rules.
Performed SQL and PL/SQL tuning 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 in writing code for Packages, Triggers on tables.
Installed Oracle 10g and 11gR1,11gR2, 12c databases on Redhat Linux 6,
Applied Bug fixes patches and Quarterly Security Patches for the stand-alone and 2-node RAC databases within the maintenance window.
Performed schema management, database sizing, and maintaining privileges of users and user profiles.
Worked on Database Wallet and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption.
Set up physical Standby/Data Guard for high availability and disaster recovery.