Resume

Sign in

Manager Oracle

Location:
Cary, North Carolina, United States
Posted:
April 23, 2019

Contact this candidate

Resume:

Resume of Ewerton Ciuffo

Oracle Database administrator

US citizen / ADP II clearance Current Residence: NC, 27513

Contact: ac86t1@r.postjobfree.com Phone 949-***-****

Certification: Oracle Certified Professional Database Administrator (OCP DBA 11G)

Oracle Certified Professional Database Administrator (OCP DBA 9i)

Oracle Certified Professional Database Administrator (OCP DBA 7.3)

Oracle Database Administrator – over 18 years(US), OCP DBA certified since 1999

Performed Oracle management activities like Install, upgrade, configure, backup, restore, performance tune, apply patches (CPU, PSU), monitor, troubleshoot, refresh and duplicate database instances. Used RMAN, recovery advisor.

Installed and managed RAC clusters, Grid Infrastructure (ASM, Oracle clusters). Install and maintain Data Guard / Standby databases. Activities included DR testing, maintain Data Guard/Standby infrastructure, resolve Standby gaps.

Performed Performance tuning in Oracle databases/Queries with Tuning Advisor, ADDM, AWR, ASH, TKPROF, OEM, App Dynamics. Responded to SLA breaches.

Experienced in Oracle databases Enterprise Edition 12c(12.1.0.2), 11G (up to 11.2.0.4), 10G (up to 10.2.0.5), 9i (up to 9.2.0.4), 8i, 7.34

Work with storage team for storage level replication (IBM global mirroring and BCV).

Perform capacity planning, request and add resources to database.

Platforms: AIX (5.3, 6.0, 6.1, 7.1), HP ux, Solaris, Linux (RHEL).

Work with best ITIL practices, Service Now, Remedy.

PeopleSoft Oracle application DBA – over 9 years

Install Peoplesoft, Peopletools, tuxedo, apply patches, configure application server, process scheduler.

Apply major upgrades using Change Assistant.

Apply tax updates and patches, troubleshoot, act as Liaison to Oracle Support.

Implement updates and fixes. Co-ordinate Peoplesoft / Oracle DB/ OS patches. Use of application tools, migration tools, data mover. App Designer. Configuration Manager. Perform Peoplesoft DDLAUDIT, SYSAUDIT.

Run and analyze compare reports. Work with change control (STAT). Performance tuning at application and database level. Perform database refreshes, monitor Processes and trace SQL, Peoplecode, Cobol, SQR. Monitor and trouble shoot report repository.

Interact with functional team, developers. Tune Peoplesoft temporary tables. Participate in Peoplesoft Upgrade process (PT 8.49 to 8.512 and PS FIN/HR 8.9 to 9.1)

Taken classes on Peoplesoft Update Manager (PUM)/DPK for PT 8.53 and above.

Experienced in Peoplesoft Financials SCM 8.8 up to 9.1

Experienced with Peoplesoft Human Capital Management 8.8 up to 9.0

Experienced with Peopletools 8.49 up to 8.51

Proficient in Peoplesoft Update Manager (PUM) (attended classes)

Work history

Metlife/Capgemini – 7/2015 to 4/2019 – Cary, NC

Oracle Database Administrator

Sourced by Capgemini, support Metlife Oracle Database Operations for a team with oversight over 100+ Oracle database instances, including VLDBs(Multi Terabyte) and multiple Peoplesoft, homegrown and third party applications. Work with offshore teams. Engaged with Situation Management team on high stake incidents, provided root cause analysis. Worked on DoD secured Tricare Databases (Clearance ADP II required).

Performed RMAN backups and eventual recovery, operated standby/Dataguard with Real time and snapshot standby, performed DR tests with restore points and flashback, applied patches, performed Query and database tuning. Used following tools on daily production support: Enterprise Manager-OEM Grid Control, Perceiver, Patrol, Maestro, App Dynamics. Performed Security Compliance audits. Worked with Identity Management team on access management. Performed maintenance on shell scripts.

Worked with IBM team on migration of Oracle databases from AIX to Red Hat Enterprise Linux(RHEL). Worked in Oracle 11G/12C databases. Engaged on rotating On Call schedule. Trouble shooted major incidents and interfaced with Oracle support. Provided support for AD and PM teams.

Riverside County 4/2006 – 4/2015 – Riverside, CA

Database Administrator III (Senior level)

Duties:

Supported multiple database instances for a Peoplesoft Financials (FSCM) and HR(HCM) deployment. Supported Oracle RAC databases and corresponding Web Logic/Tuxedo Application/WEB Servers, including production, test, development, staging and demo. Work with storage team to perform flashes for refreshing databases. Partitioned tables and indexes. Support for Oracle RAC clusterware, Grid Infrastructure (11.2) . Worked on virtualized AIX LPARS. Applied Oracle DB patches, CPU, PSU. Migration from HP UX to IBM AIX. Shell script coding for database maintenance automation. Provide On-call support 24/7. Oracle advanced security (OAS). Created shell scripts for DB maintenance and alerts.

Coded shell scripts for automation of backups, Capacity management alerts and DB refreshes. Scripts sent emails to DBA team with status on daily routines and alerted for Oracle errors in alert log.

Support multiple Peoplesoft application servers, process schedulers and corresponding infrastructure. Apply patches to the Peoplesoft stack as well as the Peopletools software. Trouble shoot and performance tuning. Apply major upgrades with Change Assistant. Applied PeopleSoft HCM patch updates.

Worked the following tools: SRVCTL, CRSCTL, RMAN, ASM, ASMCMD, OUI, Data Pump, export/import, OEM (Grid Control, DB Console), Support Workbench, Data Masking, Advanced compression Option (ACO), Toad, Shell scripts, Oracle Tuning Package, Oracle Diagnostic packages, Advanced Diagnostic repository (ADRCI),SQLT, ADDM, AWR, CLUVFY, OPATCH, ORADEBUG, SQL Developer 3, DBMS_STATS, SHAREPLEX, Oracle Streams, Maestro, scheduling. Worked with Oracle 10G, 11G. Participate in Peoplesoft upgrade process (Fin/HR 8.9 to 9.1), Peoplesoft App Designer, Data Mover, psadmin, Change Assistant (CA), Configuration Manager, REN Server, Process scheduler, report repository, Tuxedo 10G.

Environment was AIX and Red Hat Linux (RHEL).

Robert Half technology – worked as consultant for clients listed below 3/2004 – 08/2005

ISTA Pharmaceutical 7/2005 – 08/2005 Consulting for Robert Half - Irvine

Consultant Database Administrator

Support Oracle Databases on LINUX RHEL 3.

Suburban Water Systems 5/2005 – 06/2005 and 12/05-01/06 Consulting for Robert Half

West Covina, CA

Install Oracle 9i, migrate database from 7.3.4 to 9i, create backup routine.

Create new user interface for the Order Management System.

First American 9/2004 - 3/2005 Consulting for Robert Half – Poway, CA

Consultant Database Administrator

Maintain Oracle Instances for Build Engineering team.

Install, configure and tune database, application.

Deploy applications, clone databases, and create staging instances.

Work with team of Architects to tune Weblogic/Java Application.

Work with QA teams and integration with off shore development teams.

Implemented backup strategy with RMAN and OEM. Installed and configured OMS.

Environment: Oracle 9i (up to 9.2.0.5), Solaris 9, Weblogic 8.

San Diego DPC (San Diego County) 3/2004 - 7/2004 Consulting for Robert Half

Consultant Database Administrator

Support Oracle database instances running on Solaris and AIX.

Interface Oracle Databases with Weblogic Application.

Mocked, cloned, migrated and upgraded databases.

Environment: Oracle 8i, 9i. Solaris 8 and 9. AIX 5L. Weblogic 8.

IPNet / Inovis 2/2003 - 1/2004 – Newport, CA

Consultant Oracle Database Administrator

Support Oracle databases and Unix Administration.

Install, upgrade and troubleshoot Oracle Databases in HP, Sun, AIX, Windows.

Work with Architects to fine tune Tomcat Application running on Oracle database.

Installed and managed Tomcat app server.

Supported development team in Java.

Attended UC Irvine 2002 – Extension Java Enterprise (J2EE)

Coteligent 4/1999 - 11/2001 Santa Ana, CA

Outsourced to Caloptima ( Orange County)

Oracle DBA

Responsible for the Healthy Families Oracle database for Orange County (CALOPTIMA)

Administer Oracle production database server. UNIX Administration on TRU64.

Install/Configure OEM / Intelligent agent and Data Gatherer

Database Design using Embarcadero ER.

PL/SQL programming. Shell scripts coding.

Education:

BS in Electrical Engineering – Universidade Veiga de Almeida, Rio de Janeiro, Brazil 1980

Post Graduate in Economy and Industrial Administration –UFRJ–Universidade Federal do Rio de Janeiro -1981

Java Enterprise edition certificate (J2EE) – UC Irvine 2004



Contact this candidate