Data Developer

Nelson

516-***-**** *******.*****.**@*****.***

Oracle Database Administrator

Highly skilled and experienced Proactive Oracle Database Administrator IT Professional with over 6 years + of hands-on experience, including complete life cycle knowledge. Skilled at analyzing AWR, ASH, and ADDM reports in order to troubleshoot performance issues and ensure that the system works at it optimal. Highly detailed oriented, with a drive to continually expand and obtain knowledge to better service Oracle Databases and assist in solving problems. Looking to apply skills learned through experience in assisting companies to archive their goals and objectives.

Areas of expertise include:

Project & Production Support

Oracle 12c, 11g, & 10g Versions

Installation & Configuration

Upgrades & Patches

Migration of Systems

EXADATA

Backup & Recovery

Performance Tuning

Data guard & Broker

Goldengate

RAC

Development

Testing

QAT

Creation of Conceptual, Logical, & Physical Data Models

RMAN

Recovery Catalog

Optimization of SQL & PL/SQL Scripts

Database Security

Creating & mg. User Profiles

AWR Report

ADDM Advisors

Windows OS-

Linux OS

Auditing

Flashback

SQL-Trace

TKPROF

SHELL Scripts

OEM Database & Grid Control

OCFS

POSTGRESQL (1 year)

SQL SERVER (2 years )

OLAP

Linux

Solaris

Unix

AIX

*AWS Migration

Tools:

SQLPLUS OEM WINSCP PUTTY

VNC TOAD SQL DEVELOPER

PROFESSIONAL EXPERIENCE

Break Parts Inc. McHenry, IL

Oracle Database Administrator February 2017 – PRESENT

Installed, configured, maintained, and supported Oracle 11gR1, 11gR2, physical and logical standby database for testing, developing, and production of various applications.

Experienced with migrating some databases from Oracle to Exadata

Upgraded Exadata machine from a half rack to a full rack

Worked closely with the network team to ensure Exadata machine runs effectively

Carry out both logical and physical database modeling using Microsoft Visco and Sql Developer

Experienced in physical database design by creating materialized views, indexes, partitions and clusters

Installation, upgradation, troubleshooting and configuring of Golden Gate 12c software

Configuring Golden Gate Downstream Mining and integrated components for active-passive and active-active replication

Administered seamless switchovers through skillful configuration of Data guard and Broker

Oversaw 24/7 on-call support for 12 databases using Oracle 12c Cloud Control for alert monitoring and notification.

Implemented logical database design to ensure data integrity and flexibility

Installed and configured Golden Gate to work with Agent on OEM Golden Gate plugin

Monitored and troubleshot Golden Gate replication issues

Upgraded databases from 10g to 12C

Configure RAC with its services like TAF for high availability and scalability

Upgraded GI and databases from 11g to 12c while keeping physical standby databases in place

Upgrade the ASM instance using rolling upgrade

Monitor and troubleshoot RAC databases to maintain availability of production databases

Migrated systems to Multitenant Architecture using CDB and PDB applications

Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues

During production hours, resolved lock and resource contention issues

Provided tuning recommendations to application teams through troubleshooting systems using SQL baselines, SQL profiles, and SQL Tuning Advisor

Identified root causes of SQL performance issues by analyzing EXPLAIN PLAN, SQL-TRACE, and TKPROF trace files

Aided troubleshooting of performance issues through analysis of AWR, ASH, and ADDM reports

Cloned and migrated small databases using import/export utilities, and used Data pump import/export for 11g/12c databases

Applied patches (including opatch), upgrades, and maintenance on all databases

Utilized production data to refresh development and test instances regularly

Assisted in management and database administration of Oracle database applications on Exadata platforms.

Provided technical assistance for installation and upgrading of existing Oracle databases.

Performed database management functions such as maintenance, access issues and security.

Experience installing, administering the Enterprise DB release of PostgreSQL

Extensively utilized Oracle 11gR2 features, including Real Application Testing, Enhanced RMAN, Oracle Data Pump, EM Grid Control, and various others daily, and enhanced features in 12c such as table and partition recovery

Implemented Oracle TDE to provide transparent encryption of stored data

Managed the monitoring and troubleshooting of database replication issues

Optimized results using EXPLAIN PLAN, SQL-TRACE, TKPROF, and STATSPACK to performance tune Oracle Database Objects

Collaborated with application development teams to support and resolve any issues encountered

Used Oracle Enterprise Manager to perform database monitoring, maintenance, replication processes, and performance tuning

Florida Blue Jacksonville, FL

Oracle Database Administrator December 2012 – January 2017

Experience with migrating from on premise to Exadata machine using Golden Gate

Converted non-RAC single instance to RAC database instances

Installation, upgradation, troubleshooting and configuring of Golden Gate 12c software

Configuring Golden Gate Downstream Mining and integrated components for active-passive and active-active replication

Implemented procedures for automation of database management through tables and indexes.

Executed processes for evaluation of system space, database allocation and storage metrics.

Maintained all existing databases and new installations at current and stable production levels

Installed 11gR2 RAC while performing disk group management in ASM

Monitored health checks of OCR and VOTING DISKS while troubleshooting issues in RAC environment

Ensured the secure and efficient operation of Oracle Database Systems

Performed daily tasks such as resolving tickets, development support, and collaboration with application tuning

Extensively monitored grid control database, error notification configuration, listener installation, and addition to grid control

Created and implemented recovery strategies, and successfully recovered databases using RMAN

Utilized RMAN utility to schedule and monitor physical backups in the CRON tab

Created users, groups, roles, profiles, and granted privileges according to job needs

Optimized and tuned SQL queries using SQL-TRACE, TKPROF, and EXPLAIN PLAN utilities

Used integrity constraints and database triggers to maintain data integrity and security

Applied security patches such as Patch set, Critical Patch Updates, and Patch Set Updates

Used Transportable Tablespace (TTS) to quickly move a user’s tablespace across Oracle databases

Implemented data refreshes using RMAN, Data pump, and conventional export/import for Oracle 11g and 10g

Installed and configured Oracle 11.2.0.1 database on AIX, SOLARIS, LINUX, and UNIX platform

Successfully migrated from Oracle 11g to 11gR2 RAC database and 12c non-CDB to pluggable databases

Upgraded databases from 11g to non-CDB 12c

Successfully used materialized views and Oracle Streams in Oracle 10gR2 to perform data replication

Implemented Tablespace level TDE security and created Oracle wallets

Constantly monitored the performance of databases through viewing alert log and trace files

Ran scripts to check status of databases, including free and used space, fragmentation, and other details

Managed space, capacity planning, disaster recovery, and overall maintained the databases

Utilized RMAN with zero downtime to create physical standby databases, and performed failover and switchover using Data guard broker as well as manually

EDUCATION & CERTIFICATION

Bachelor’s Degree in Computer Science (BSc)

Certificate in Computer Data Processing

Oracle 12c SQL Fundamentals

Oracle Certified Associate 12c Database Administrator (OCA)

Contact this candidate