Clinton Graca

Los Angeles, CA

ad0tfu@r.postjobfree.com

PH: 310-***-****

Authorized to work in the US for any employer

Work Experience

Senior Oracle Cloud DBA Consultant

ATOS/ Syntel, INC - Los Angeles, CA

Feb 2020 -Present

• Migrate MySQL database to AWS Amazon Aurora, EC2 and S3 bucket, using MYSQLDUMP and

Pacrona tools.

OCI Cloud Management ( Exadata/oracle, People Soft Refresh, maintenance of OCI downtime include patching).

• Zero Downtime Upgrade Oracle database from 12c to 19c using Goldengate.

• Upgrade Oracle database from 12 C to 19C using Rman duplicate and DBU Methods.

• Database Performance tuning, Installing SQLT and configuration on all prod databases.

• Backup restore/ Refresh Oracle database using different RMAN methods.

• IBM Neteza configuration,

• Implementation, Upgrade Oracle enterprise Manager server 12C to 13.4, OEM Agent upgrade.

• OEM, Implementation agent patches on all the production servers.

Senior Oracle DBA

TD Ameritrade Bank - Los Angeles, CA

February 2018 –Feb 2020

Responsibilities:

• Setting up, implement and Manage Oracle Golden-Gate deployments, configuring Oracle Golden

Gate in RAC high available environment.

• Implement variety of Performance tools, database Optimization and Performance Tuning

Recommendations (Red Hat Linux environment)

• Upgrade OEM 12 C to OEM 13C, including agent installation and Configuration

• Upgrade oracle 12 C to oracle 18C. AWS Environment.

Senior Oracle DBA Consultant

Saxon Global - Los Angeles, CA

January 2017 to February 2018

Responsibilities:

• Performance tuning, Optimization and recommendations (Red Hat Enterprise Linux and Sun Solaris

Environment)

• Troubleshooting performance issues with database Migration.

• Backup and Recovery, 11g and 12C version, Rman database backup

• Implementing OEM Grid Control 12 C, Db Console and automated reports.

• Oracle Golden Gate 12C installation and Configuration..

• AWS Cloud architecture and Configuration

Senior Oracle Database Administration

GLOBAL CLOUD, INC - Los Angeles, CA

July 2014 to January 2017

Responsibilities:

• Implemented and monitored over a hundred databases in a Unix and Red Hat Enterprise Linux

Environment

• DataGuard Implementation /Replication.

• Real RAC implementation and Golden Gate.

• Designed, configured and implemented the latest software. Oracle Diagnostics and Tuning Pack 11g

to OLTP and large scale Data-warehouse databases for optimal performance, availability and reliability

• Upgraded, installed and configured EM Grid control on 12C to administer and manage hundreds of

databases on many different environments, including Unix and Linux.

• Applied patches to all OMS consoles to set the system and database environments.

• Automated QA/DEV core and DW Refresh and Sanitization using different DBMS packages and

automated shell scripts.

• Set up Multi-master replication between real application cluster databases.

• Monitored the performance of production databases Made tuning recommendations and changes to

ensure optimal performance.

• Upgraded Enterprise Grid Control from 11g to Enterprise cloud 12C. Applied all console patches to all

OMS and set all system environments.

• Set up Oracle replication and advanced queries and partitioning.

• Participated in system capacity planning and forecasting as well as physical and logical modeling and

security.

• Oracle Cloud testing.

• Developed and implemented a strategy for validation of hot /cold backups.

• Implemented /automated Oracle Script to analyze and find Logical and Physical corruption.

• Implemented a strategy to detect and notify of any delays between primary and standby databases.

Oracle Database Consultant

IBM Corporation - Phoenix, AZ

May 2013 to July 2014

Responsibilities:

• Performance tuning, Optimization and recommendations (Red Hat Enterprise Linux and Sun Solaris

Environment).

• Monitoring Hundreds of databases. AIX and Linux environment.

• Working with Remedy software, troubleshooting performance issues with database Migration.

• Backup and Recovery, 10 and 11G2 version, Rman database backup.

• HACMP, CVS and RAC Cluster failover troubleshooting.

Oracle Database Administration Consultant

Envy Resources - Los Angeles, CA

May 2012 to May 2013

Responsibilities:

• Database Performance tuning, Optimization and recommendations (Red Hat Enterprise Linux and

Sun Solaris Environment.)

• Implementing OEM Grid Control, Db Console and automated reports

• Backup and Recovery, 10 and 11G version, Rman migration Recovery.

• Implementing and configuring logical and Physical Dataguard.

Lead Oracle Database Administration

My Life, Inc - Los Angeles, CA

May 2007 to May 2012

Responsibilities:

• Installing, implementing and upgrading all Oracle database Servers to the latest Oracle Version 10G

and 11G.

• Implementation of the OEM grid control, DB console and Automated reports

• Implementing Patches & other Oracle software's related

• Implementing and configuring Physical and Logical Dataguard

Testing implementing RAC in Solaris Environment

• Monitoring the Production database server's health and Performance tuning Optimization and

Recommendation

• Backing up and recovering data

• Performing data transfer more than 500 GIG database size, including migration data from and to

Different Platforms "from Solaris to Linux"

• Developed and implemented a strategy for hot & cold backups, using Rman/Shell scripting.

Implemented and managed multiple instances

• Business Intelligence application implementation, administration and optimization.

Oracle Database Administration Consultant

IBM Corporation - Kansas City, MO

February 2007 to May 2007

Responsibilities:

• New implementation/Cloning Development database version 10g to Production in Linux environment

• Database Optimization/ Performance tuning and making Recommendations.

Oracle Database Administration Consultant

Price Waterhouse Cooper - San Jose, CA

Oracle database

September 2006 to February 2007

Responsibilities:

• Performance Tuning of Oracle database 10g version, including SGA tuning and storage Tuning

• SQl tuning Using SQL Tuning Advisor, SQL Access Advisor, Analyzing AWR, ADDM

Reports and recommending changes required improving performance using DBMS

Packages Analysis and Materialized Views

Communications Techno System, UCLA - Los Angeles, CA

Oracle Database

July 2001 to September 2006

Support in a production databases, Sun Solaris and Windows NT/Windows 2000 Environment

• Oracle performance tuning, generating statspack and SQL net tracing reports

• Upgraded Oracle database 8i release to Oracle 9i

• Oracle database implementation, Management, Migration and Configuration of Oracle 9i/RAC on Sun/

Solaris

• Training Oracle Database/system Administrators and customers to resolve technical, and business

process issues

• Data Modeling and design

• Developed and implemented a strategy for hot & cold backups, using Rman/Shell scripting,

Implemented disaster strategy recovery, and ensuring data integrity

• Implemented and managed multiple instances

• Performed capacity planning database and host data collection, trending, and extrapolation

HP, Desktalk System - Los Angeles, CA

September 1999 to July 2001

Oracle Database Administration

Responsibilities:

Analyzed hydrocarbon reservoirs using geostatistical computer programs in UNIX environment

• Computer simulation and seismic modeling of dynamic hydrocarbon reservoir characteristics

• Backup and restore projects using tape devices in UNIX environment

Education

M.S. in Engineering

Colorado School of Mines - Golden, CO

1996

B.S. in Computer Science Engineering

University of Engineering

1993

Skills

• Database administration

• Database

• Sql server

• Oracle

• Oracle 8

• Pl/sql

• Replication

• Sql

• Sybase

• Aix

• Linux

• Red hat

• Solaris

• Sun

• Unix

• Ux

• Hp-ux

• Optimization

• Netbackup

• Rman

Additional Information

COMPUTER SKILLS

• Systems/Production Database Administration (UNIX, Linux & Oracle)

• Oracle Cloud 12 C

• SaaS, PaaS, IaaS

• AWS Cloud architecture

• Oracle 8/8i and 9i, 10g, 11g, 12 c Implementation & Configuration

• Discovery 9AIS, Materialized views

• Backup and Recovery planning using Veritas Netbackup

• Performance Tuning

• RAC (Real Application Cluster) 11g, Oracle Enterprise Manager, and Quest Software

(Toad, I/watch Sherplex and Spotlight on Oracle)

• Report Server, SQL*PLUS, SQL*LOADER, SQL*NET, PL/SQL

• Database Link/Replication, Management and Optimization

• Enterprise Data Warehouses, My Sql, Sybase and SQL server

• HP-UX, Solaris & AIX

• People Soft

• Websphere MQ Solution software implementation and Configuration

• Business Intelligence reporting optimization.

• Dataguard implementation, Rman backup and disaster Recovery

• Golden Gate 12C Admin

• Migration from Unix to Linux Environment

• OEM Grid control Implementation

• Operating systems: Red Hat Enterprise Linux (RHEL), Unix, Sun Solaris and Windows.

Languages: English/French

Citizenship: US citizen

Contact this candidate