Post Job Free

Resume

Sign in

Oracle Support

Location:
San Antonio, TX
Posted:
June 28, 2020

Contact this candidate

Resume:

Tony Taplin

Email: add6ag@r.postjobfree.com

PHONE: 210-***-****

Sr. Oracle DBA/Golden GATE/PEOPLESOFT

LOCATION: TEXAS ONLY

Over 10 years Oracle Database administrator (DBA)/Peoplesoft Adminstrator supporting, designing, installing, upgrading, migrating, monitory, and tuning, production, test, development database and application administration. Highlights include the following:

Sr. Oracle Database Administration 11g, 12c, Database Configuration Assistant (DBCA)

Performance Tuning & Capacity Monitoring

Backup & Recovery: RMAN, DATA PUMP

ACTIVE DATA GUARD, FLASH BACK

OEM 12c, 13c

ASH, AWR, Execution Plan, PGA, SGA

Oracle RAC & ASM Administration/Installation

Exadata, UNIX/Linux (SCP, Bash,Korn,SSH) Windows, AWS, CLOUD

PeopleSoft Admin, PS TOOLS, APP Designer, Data Mover

Shell scripting, Oracle SQL Tuning, SQL Plus, PL/SQL

Database Encryption

SQL Server 2012, 2016, 2017, 2019

SQL Always ON/Clustering, Failover

SQL High Availability

SQL DDBOOST Backup Appliance

EXPERIENCE

Clear Channel Outdoor

Database Engineer

06/2019 to Present

Provide SQL Database Engineering clustering support for All United States Clear Channel Outdoor production, test, and development database Environments.

Duties include:

Installing and configuring SQL Server instances, 2012, 2016, 2017.

Installing and supporting Always ON SQL Server database cluster environments

Perform production database migrations

Perform database capacity planning.

Monitored production, test, and development database performance

Review backup logs

Review database logs

Review server logs

Install and configure SQL Server SSIS, SSAS, SSRS

Worked under production SLA’s

Carlson Wagonlit 11/2018 to 02/2019

Sr. Oracle Database Administrator, contract

Provide Oracle Database Administrator support for All USA Oracle Database Environments.

Duties include:

Worked on 45 TB Exadata Oracle Databases, 11g, 12c, and 13c.

Monitored database space.

Provided database support for helpdesk tickets.

Reviewed database storage capacity.

Monitored production, test, and development database performance

Familiar with Grid Control, Golden Gate, ASM, RAC.

Experienced creating Data Guard.

Created User accounts, assign roles, Schemas, etc.

Worked with developers in performance tuning and change control in production

Reviewed database backups.

Worked under production SLA’s

Exposed to Golden Gate and familiar with trouble shooting commands (ggsci; ggserr.log; info; info manager; stats; status; lag: view reports; run-time stats; discard file; and more)

GDT/San Antonio Water System (SAWS), San Antonio, Texas

Sr. Oracle DBA/SQL Server DBA, contract

09/2018 to 09/2018

Provided Database Administrator support.

Duties include:

Performed database admin tasks for Oracle 11g, RAC clustering, Data Guard, OEM, ASM, Oracle and MSSQL Server databases 2008 and 2017.

Provided database support for helpdesk tickets.

Reviewed database storage capacity.

Worked with team on all other database tasks as assigned.

Monitored all database performance.

Examined Data Guard performance.

Created User accounts, assign roles, etc.

Reviewed database backups.

USAA, San Antonio, Texas

Sr. IMPERVA Systems Engineer Admin (Cyber Security), contract

06/2018 to 08/2018

Provided System administration potentially 200 IMPERVA Management and SOM servers.

Duties include:

IMPERVA application administrator, configured IMPERVA Management servers (MX).

Administered IMPERVA SOM servers.

Installed/Updated IMPERVA MX and SOM performing patches administration

Maintained all Linux MX server environments for development, test, and production IMPERVA environments

Performed some Linux scripting

Created User accounts, assign roles, etc.

Administered all IMPERVA GUI environments.

AFS/US STATE DEPARTMENT, San Antonio, Texas

Sr. Oracle DBA/PeopleSoft DBA, contract

01/2018 to 05/2018

Provided database production/stage/test/development Oracle database support.

Duties included:

Created DEMO/SYS PeopleSoft Oracle databases in AMAZON WEB SERVICES (AWS) CLOUD. EXADATA.

Created Oracle 11g, 12c, Oracle databases on EXADATA Linux Red Hat, Windows 2008 and 2012 database servers.

Performed quarterly Oracle Critical Security Database Patching, supported Oracle databases on EXADATA.

Provided DBA support for Oracle RAC, Data Guard, and ASM

Created Oracle schemas, granted, roles, select, insert, update, and delete to user

Performed database tuning; utilized TOAD, PHIRE, Service NOW

Created Oracle Database Links.

Setup OEM 12c and 13c.

Participated in SLA, Change Control

DSA Inc., San Antonio, Texas

Sr. Oracle Database DBA

09/2014 to 01/2018

Worked in Fast paced database environments.

Duties included:

Created Oracle 11g and 12c databases on Linux

Implemented Oracle Transparent Data Encryption (TDE) for production Oracle database for a world-wide database system

Performed database migrations.

Performed Oracle database Upgrades, Patching, performance Tuning

Used RMAN database backup and recovery,

Worked with development teams on application upgrades and testing

Performed database monitoring and SQL tuning

Performed optimization, fine-tuning, scaling for mission-critical production systems

Created and utilize OEM, used TOAD, performed Unix Shell scripting

Assisted in the Administration support of Service Now applications

TESORO ENERGY/ENDEAVOR, San Antonio, Texas

Lead Oracle Database DBA SAP/SQL Server DBA

02/2012 to 09/2014

Maintained, upgraded, migrated, and worked with the SAP Basis Team provide IT support for a Large Oil Company.

Duties included:

Created Oracle 10g and 11g database for SAP

Provided SAP CRM/ERP Support as an Oracle DBA

Used SAP Brtool. Performed Oracle 10 to 11g upgrades

Worked with Grid Control, installed Oracle agents on database servers

Performed Oracle Patching using OPatch

Utilized RMAN for database backup and recovery

Used AWR and ADDM reports to perform analysis

Performed Oracle database performance Tuning

Created MSSQL 2008R2 database on Windows Servers

Worked for an International Leading Oil and trading Company

HEB Grocery

Sr. Oracle DBA/SQL/MySQL DBA/Peoplesoft Admin

02/2008 to 02/2012

• Provided PeopleSoft ERP DBA support

Performed Oracle DBA production support in Oracle 10g, 11, Oracle Cluster Ware, ASM, RAC

Configured/Installed Oracle Data Guard

Performed database Migrations

Applied Security Patches using Opatch

Performed Daily Oracle RMAN database backups and recoveries

Worked with Oracle RAC, OEM and Grid Control, performed statistics. Rebuilt indexes

Installed Oracle databases on Linux Operating Systems

Perform Oracle database upgrades, used OPatch, runInstaller, and more

Utilized performance tuning techniques

Created Oracle Schemas and managed tablespaces

Ran AWR and ADDM reports, familiar with performance tuning

Used data pump, and performed database, schema, table export/imports

Wrote SQL code, Linux/Unix scripts. Use AWK, SED, and more

Installed, monitored, configure SQL SERVER DBA 2005/2008 databases

Used activity monitor. Looked for deadlocks. Worked on improving database performance

Familiar with SSIS, SSRS. VMWARE

Performed SQL Database restores. Created maintenance plans. Used DBCC and more

Performed other SQL DBA duties. Check alert logs. Used clustering

Administered application Security

KCI 04/2005 TO 02/2008

Sr. Oracle PeopleSoft ERP and Oracle Financials Database Administrator

Configured PeopleSoft installs, upgrades, fixes, patches, and maintain PeopleSoft Application server, Process Scheduler, and Web servers

Performed PeopleSoft Tools upgrade

Provided PeopleSoft ERP database support

Monitored daily Oracle 9i, 10g databases for performance to provide support to our users

Performed database 9i, 10g, 11i, upgrades, apply patches and fixes

Installed and setup Oracle Applications. Applied frequent patches

Installed and used OEM/Grid Control

Provided support for Apache and Oracle Web support

Configured Oracle workers. Installed Oracle Financials suite

Worked with Oracle Concurrent manager

Searched Metalink to resolve Oracle database issues

Performed database backups using RMAN and DATA PUMP

Wrote Unix scripts in K shell and borne shell

Administered application security

Worked with IT management on Oracle database performance issues

Wrote documents to establish guidelines and procedures for application use

Programmed using linux scripting. Analyzed and used performance tuning techniques

Utilized database and application security

Swift Foods, Greeley, CO.

Sr. PeopleSoft ERP Financials and HR Administrator

02/2004 to 04/2005

Installed PeopleSoft and configured and worked with People Tools, Weblogic, Process Scheduler, Data Mover, Application Designer, tuxedo, WSL, Application Server, PIA)

Worked with Corporate production Oracle database administrators to install/upgrade/Patch PeopleSoft Application

Wrote and prepared documents for training and established procedures

Performed PeopleSoft Tools upgrade

Heavily involved and responsibility of Corporate PeopleSoft Disaster Recovery Plan.

Implemented Quarterly tax updates for HRMS application

Performed database updates

Provided IT management with timely and accurate information regarding PeopleSoft

Harcourt, San Antonio, TX

PeopleSoft ERP Admin/Oracle DBA/SQL Server DBA

04/2000 to 02/2004

Upgraded all applications

Configured and set PeopleSoft Internet Architecture (PIA)

Performed PeopleSoft ERP admin and database support and Oracle DBA support

Applied PeopleSoft/Oracle patches, updates, and application fixes

Understood PeopleSoft Security Administration including row-level security

Provided IT management with timely and accurate information regarding PeopleSoft

Created PeopleSoft Oracle instances and People Tools environments

Configured PeopleSoft Install, upgrade, fixes, patches, and maintain PeopleSoft Application server

Worked with the development group and on a daily basis to support PeopleSoft

Created Processed Scheduler and Web Server for production and test/development environments.

Created Oracle 8i/9i and SQL server databases

Managed, created, and tuned Oracle tablespaces, indexes, views, procedures, and SQL scripts

Tuned databases, SQL statements, worked with developers to identify bottlenecks.

Performed daily database backups using RMAN

Performed database disaster recovery

Provided application support

Installed, configured, monitored, and patched SQL SERVER DBA 2005/2008

Used Activity monitor to discover database query deadlocks

Performed SQL Database restores. Used DBCC and more to improve database performance

EDUCATION & TRAINING

M.B.A., Information Systems, Webster University, St., Louis, MO

M.A., Information Systems, Webster University, St., Louis, MO

B.S., Computer Studies, University of Maryland UC, College Park, MD

PeopleSoft Administration Training-certificate



Contact this candidate