Resume

Sign in

Manager Oracle

Location:
Minneapolis, MN
Posted:
January 11, 2020

Contact this candidate

Resume:

Lincoln A.W. Bryant

**** ********* ** *

MINNEAPOLIS, MN 55444

Mobile: 763-***-**** Email: ada9xl@r.postjobfree.com

https://www.linkedin.com/in/lincoln-bryant -14298b79

EXPERIENCE SUMMARY

An accomplished and seasoned Oracle Database Administrator (DBA) with over 7 years of experience and extensive knowledge in Oracle database administration. Expertise in supporting Oracle Databases 10g, 11g, 12c and 18c platforms with expertise in Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring, Data Guard, Grid Control and Oracle Streams. An Oracle Certified Associate (OCA) in Oracle 12c and SQL Fundamentals with vast experience working with various tools such as; SQL, RMAN, PL/SQL, Oracle Enterprise Manager (OEM) and SQL *Loader; worked on operating system like UNIX, LINUX, Windows and AIX.

SKILLS AND COMPETENCIES

Installation, configuration, upgrade and Patching of Oracle 10g, 11g, 12c, and 18c using OUI, DBCA, DBUA

Database migration using Exp/Imp/Data pump, and SQL Loader

Backup & Recovery using RMAN

Tools/Utilities: RMAN, OEM Oracle Management Server, SQL*Plus, Export/Import, Data Pump, RMAN, AWS, ADDM.

Monitoring and performance tuning using AWR, ADDM, OEM console, Grid Control, SQL Developer, Explain Plan, Optimizer Statistics

Database Security and Migration

Patching, troubleshooting, maintaining ERP application and Oracle Database

Oracle DBA skills, Oracle ERP skills, shell scripting

RDBMS: Oracle 10g, 11g, 12c, and 18c.

Languages: HTML, JavaScript, PL/SQL, SQL, UNIX Shell Scripting, MySQL.

Oracle Data Guard configuration and Administration (using Broker)

Worked with various operating systems like MS Windows Servers (2003, 2008), Unix and LINUX (Red Hat)

User Management, creation, monitoring and management of database users. Altering passwords and granting/revoking access to system/object privileges, roles and auditing user actions.

In-depth understanding of security and backup procedures to ensure database integrity.

PROFESSIONAL WORK EXPERIENCE

FedEx

Oracle Database Administrator September 2019 – November 2019

Maintained the integrity and performance of company databases and guarantee that data is stored securely and optimally; carry out daily incremental backup and weekly full backup of databases using RMAN. Database upgrade using DBUA, shell database creation using DBCA, and applying quarterly patches for security using Opatch Utility.

Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance

Lead database upgrade and quarterly patching projects, and mentor junior Oracle Database Administrators. Work and coordinate with a team of oversea partners.

Monitoring and reporting daily backup with RMAN, configuring and managing backups (full and incremental)

Migrate Databases to Exadata using datapump and RMAN duplication process.

Analyze and determine the feasibility to leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.

Extensive skills to configure and build one-way, tow-way, active-to-active Oracle Goldengate Extract/Replicat for multiple databases.

Experience with Goldengate deployment topologies, which include Unidirectional Replication, Bidirectional Replication, Broadcasting, and Integration of data.

Managed database Security by creating, assigning appropriate roles and privileges to users depending on the use activity; auditing and performing other security related tasks including Transparent Data Encryption.

Applied Oracle quarterly patches to non-RAC and RAC configured databases.

Performed day to day database administration tasks like database creation as well as working on projects such as upgrades (from 10g, 11g to 12c) and patching

Performed Point-in-time recovery as well as cancel based recovery

Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS_STATS, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

Championed database migration from 10g to 11g and database upgrade from 11g, 12c to 18c using the Oracle Datapump and DBUA respectively.

Table space monitoring, Performance monitoring and tuning for performance improvement

Cloned, patched and implemented upgrades and migrations,

Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I also used block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.

TARGET

Oracle Database Administrator April 2019 – August 2019

Full knowledge and expertise in database administration, performance tuning, database backup & recovery using RMAN, database security, database optimization, and data migration using datapump; database upgrade using DBUA, shell database creation using DBCA, and applying quarterly patches for security using Opatch Utility.

Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.

Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution

Monitoring and reporting daily backup with RMAN, configuring and managing backups (full and incremental)

Lead database upgrade and quarterly patching projects, and mentor junior Oracle Database Administrator. Work and coordinate with a team of oversea partners.

Migrate Databases to Exadata using datapump and RMAN duplication process.

Analyze and determine the feasibility to leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.

Extensive skills to configure and build one-way, tow-way, active-to-active Oracle Goldengate Extract/Replicat for multiple databases.

Experience with Goldengate deployment topologies, which include Unidirectional Replication, Bidirectional Replication, Broadcasting, and Integration of data.

Comprehensive experience as Oracle DBA, especially in Exadata and Oracle Goldengate proficient in Oracle 10g/11g/12c software installations, migrations, database capacity planning, automated backup implementation, performance tuning on Linux/Unix and Window platform.

Monitors and resolves Data guard problems, maintains flashback capability, troubleshoots database problems including performance issues and resolves them with the AWR, Performance views and SQL Tuning advisor.

Table space monitoring, Performance monitoring and tuning for performance improvement.

Implement database security using Oracle's Transparent Data Encryption (TDE) to protect the organization's critical information and exceeding the industry standard.

Monitoring the database for growth and added space to the table spaces as per demand.

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

Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012

BEST BUY

Oracle Database Administrator July 2016 – March 2019

Maintained the integrity and performance of company databases and guarantee that data is stored securely and optimally; carry out daily incremental backup and weekly full backup of databases using RMAN.

Responsible for the successful running of all applications and services running on the database.

Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance

Monitoring and reporting daily backup with RMAN, configuring and managing backups (full and incremental)

Migrate Databases to Exadata using datapump and RMAN duplication process.

Analyze and determine the feasibility to leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.

Extensive skills to configure and build one-way, tow-way, active-to-active Oracle Goldengate Extract/Replicat for multiple databases.

Configure error handling for Oracle Goldengate restart, logging, production support and status reporting.

Comprehensive experience as Oracle DBA, especially in Exadata and Oracle Goldengate proficient in Oracle 10g/11g/12c software installations, migrations, database capacity planning, automated backup implementation, performance tuning on Linux/Unix and Window platform.

Monitors and resolves Data guard problems, maintains flashback capability, troubleshoots database problems including performance issues and resolves them with the AWR, Performance views and SQL Tuning advisor.

Implement database security using Oracle's Transparent Data Encryption (TDE) to protect the organization's critical information and exceeding the industry standard.

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

Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012

Championed database migration from 10g to 11g and database upgrade from 11g to 12c using the Oracle Datapump and DBUA respectively.

Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I also used block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.

ST. JUDE MEDICAL

Oracle Database Administrator January 2012 – June 2016

Full knowledge and expertise in database administration, performance tuning, database backup, database recovery, database security, database optimization, and data migration of Oracle instances.

Performed SQL Tuning and provided consultation such as creating Materialized views, table partitions, adding indexes, dropping unnecessary indexes

Managed database security by creating and assigning privileges to users depending on the user’s activity, auditing and performing other security related tasks including Transparent Data Encryption and acknowledged HIPPAA laws.

Used RMAN for database refresh with hot backups, incremental backups and validated to ensure the backups were secured and usable for recovery.

Experience in database cloning from hot backups, RMAN, schema-based refreshes from production to lower environments. Experience in duplicating database from RMAN active database feature, and from RMAN backup set

Create users assigning the necessary roles and privileges

Monitor alert logs for any errors or tuning issues

Migrated data between different database and oracle versions, schemas using Oracle data pump.

Restored and recover of database from offline and online and RMAN backup.

Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size with the use of AMM and ASMM.

Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.

Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution

Managed Automatic Storage Management (ASM) and Non-ASM database file systems

Using Oracle Enterprise Manager (OEM) for database monitoring and performance tuning

Performed Dataguard switchover as required for maintenance.

EDUCATION/ CERTIFICATION:

Bachelor’s in Economics

University of Liberia – Dec. 2009

Oracle Database 12c Administrator Certified Associate (OCA)

Oracle University- March 2019

Certificate in Computer Science

IICS Liberia – June 2004

Work Authorization Status: GREEN CARD HOLDER {

REFERENCES:

1.Azoh Harry, Supervisor

Preston IT Consulting, LLC

Email: ada9xl@r.postjobfree.com

Phone: 443-***-****

2.Norbert Neba, IT Consultant

Preston IT Consulting, LLC

Email: ada9xl@r.postjobfree.com

Phone: 240-***-****

3.Jude Ntam, Database Administrator

Email: ada9xl@r.postjobfree.com

Mobile: 612-***-****



Contact this candidate