James H. Randall

adbwnv@r.postjobfree.com

704-***-****

Summary:

Over (15) years of IT Technology experience with expertise as a Senior Oracle DBA/Project Manager/Team Lead/DBA Manager experience including design, documentation, testing, upgradation, implementation, maintenance, troubleshooting, migration, performance tuning, backup and recovery, user training and support using Oracle 8i/9i/10g/11g/12C, MS SQL Server 2000/5/8r2, SQL*Loader, Oracle Partitioning, Oracle Enterprise Manager 13C (OEM CLOUD GRID CONTROL, various management packs i.e., ZFS, EXADATA, and CLOUD MANAGEMENT), RMAN, JDBC and J2EE apps, ODBC, Oracle Diagnostics Pack, Oracle Stats Pack, AWR/ASH, PL/SQL, UNIX Shell Scripting, VERITAS/SYMANTEC NETBACKUP 7.5/Backup Exec and Windows NT/2000/2003/2008/2012, Citrix, Red Hat/SUSE LINUX, UNIX (HP, AIX, SUN) environment. Oracle 8i Master DBA, Oracle 8i Network and Distributed Master DBA, ORACLE SECURITY AND GUARDIUM SPECIALIST USING DISA STIGS COMPLIANCE FOR ORACLE, DB2, MSSQL SERVER, WINDOWS, Linux and UNIX ENVIRONMENTS.

Education:

Senior Non Commissioned Officer Leadership and Management Training

Situational Leadership Training I & II for Managers

Achieving Exceptional Customer Service for Managers

Windows Administration and Support Resource Manager

Implementing and Administering NT 4.0

Supporting Windows NT 4.0 Core Technologies

Supporting NT Server 4.0 Enterprise Technologies

Internetworking with TCP/IP on Window NT 4.0

Core Technologies of Microsoft Exchange Server 5.0

Windows NT Terminal Server

CITRIX Metaframe 1.8

Legato Networker 5.1

Introduction to Oracle: SQL and PL/SQL Using Procedure Builder

Develop Data Models and Design Databases (Using Case Model Method)

Oracle 8i Database Administrator

Oracle 8i Performance Tuning Workshop

Oracle 8i Backup and Recovery Course

Programming Oracle PL/SQL Units

Oracle Designer 2000

Oracle 8i Distributed Applications

Oracle 8i New Features for Administrators

Oracle8i Distributed Systems Part 2: Advanced Replication

Oracle 9I New Features for Administrators

Maintaining Microsoft SQL Server 2008 R2 Database

Technical Skills:

Language: PL/SQL, UNIX Shell Scripting

Database: Oracle 12C/ 11g/10g/9i/8i, MS SQL Server 2000/5 /8Other Tools/Skills: SQL*Loader, Oracle Partitioning, Oracle Enterprise Manager (OEM) Expert, RMAN, JDBC and J2EE apps, ODBC, OLEDB CONNECTIVITY, Oracle Diagnostics Pack, Oracle Stats Pack, Informatica Power Center 6/5.1, Omni Back, VERITAS 4.5/Backup Exec, SQL-BACKTRACK, PEOPLESOFT, Oracle Golden Gate Replication Software

Operating Systems: Windows NT/XP/2003/2010/2012, Vista, Citrix, Linux, Unix (HP, AIX, SUN) Networks/Protocols: TCP/IP, SPX/IPX, Microwave Wireless, Satellite, HF/UHF/SHF RF Transmission

Professional Experience:

Blue Cross Blue Sheild of Florida/Guidewell

Sept 2019 – December 2019

Senior Information Security Specialist(Guardium Admin)

Jacksonville, Florida

•Help to ensure the quality design, implementation, installation/configuration, and provide technical admin support for IBM Guardium solutions

•Provide day-to-day (24/7) infrastructure platform support/monitoring and oversight of Operational and Administrative activities related to Guardium

•Design HA (High Availability) and System Backup/Recovery Strategies

•Perform appliance, agent installations, patch testing, product upgrades, and data backup/purge operations

•Work with vendor on problem resolution

•Create policies and audit reports to meet the business requirements

•Provide system information to clients and auditors

•Participate in Disaster Recovery Planning, Design and Tests

•Perform security audits, scan and monitor servers.

•Investigate and report on security alerts and perform security incident reporting.

•Setup and review security audit logs.

•Perform Daily Guardium Health Checks like Aggregation/Archive Errors,

•Scheduled Jobs Exceptions, Detailed Enterprise S-TAP View, Daily Data Export/Import, Archive Checks, etc., and work on issues or any failed processes.

•Perform Alerts Checks & Action on Appliance URL (Splunk/SCOM) Alerts, Inactive STAP alerts, Var Disk space alerts, Sniffer, CPU Utilization, My SQL Disk space and Storage alerts. Perform Daily Audit Process Results check and work on issues or any failure processes.

•Install, configure, and upgrade Guardium appliances and agents (GIM & STAP, etc.).f. Perform and support Guardium Data management activities like Archive, Backup, Purge, etc.g.

•Perform Guardium appliance patching, upgrades and ensure availability of the Guardium infrastructure

US Postal Service/Northrup Grumman/ARCO LLC

April 2018 - Dec 2018

Senior Oracle DBA

Raleigh, NC

●Database Backup and Recovery

●Database Patching and upgrades

●Install and Build database structures

●Develop and maintain shell scripts

●Query and performance tuning

●Develop and maintain documentation

●Program in PL/SQL

●Performance tuning of databases

●Reviews database design and make recommendations regarding enhancements and/or improvements

●Maintains security and integrity controls.

●Develop stored procedures and or triggers

Wells Fargo/Matrix Inc.

March 2017 - Sept 2017

Senior Database System Architect

Charlotte, NC

• Supported technology architecture activities (design, strategy, research, governance to design, etc.) with a specific focus on the area of database technology.

• Worked with partner architects, program managers, and leaders to deliver a strategic project of key significance to the corporation.

• Developed and maintained business system and corporate architectures.

• Responsible for working on medium to high architectural impact projects, recommending exceptions to the Enterprise Architecture for low to medium impact projects, reviewing and approving low architectural impact designs and directing implementation of the architecture for multiple applications or a component family.

• Conducted complex technology and system assessments for component architecture.

• Led in component architecture and participated in enterprise architecture activity.

• Provided in-depth technical and systems consultation to internal clients and technical management to ensure alignment with the Enterprise Architecture.

years of design and planning experience in systems, applications or IT Architecture.

• Technology architecture, as defined by TOGAF, i.e. design, architecture governance

• Expert experience with the Oracle database

• Experienced with security products, not necessarily specific to Oracle

Ford Motor Company

Dearborn, Michigan

Sept 2016 - Feb 2017

Database Security Engineer

●Expert knowledge of Windows operating systems internals ranging from W2K3 to W2K12, including related Windows administration skills and security features.

●Managed Oracle Dataguard Databases using OEM 12C GRID CONTROL and Dataguard Broker

●Clone database systems using RMAN and OEM12C GRID CONTROL

●Expert knowledge of UNIX operating systems internals ranging from SUSE 9, 10, 11, and 12, AIX 6.x, 7.x, and Solaris 10, including related server administration skills on these operating systems and security features.

●High level knowledge and understanding of database technologies like SQL Server, and DB2 LUW

and DB2 mainframe database migration to Oracle.

●Expert knowledge and understanding of Oracle database technologies.

●Guardium Security Appliance product specialist

●Strong inter-personnel skills with the ability to work across organization boundaries as required

●Implemented Dataguard (Physical Standby) for RAC databases.

Department of Energy Savannah River National Nuclear Laboratory _

Aiken, S.C.

April 2016- July 2016

Senior Oracle DBA Consultant

•Oracle Performance OBIEE Database/Application Consultant.

•Configured Oracle Memory Modules for better performance

•Marinated Oracle Dataguard Databases using OEM 12C GRID CONTROL and Dataguard Broker

•Reconfigured Oracle's Parallel Query and Degree of Parallelism for better use of CPU and USER I/O.

•Identified and Optimized poor running SQL QUERIES.

•Reduced reports from 4 hours to 1.5 hours reporting

•Brought ETL loads from 5 hours to 1.47 hours.

Public Works Commission, City of Fayetteville, N.C _

April 2015 - Feb 2016

Senior Oracle DBA

●Oracle Utilities Work And Asset Management Application DBA

●Oracle Utilities Customer Care and Billing Applications DBA

●Oracle Utilities Meter Data Management DBA

●Oracle Utilities Mobile Workforce Management DBA

●Oracle Fusion Middleware System Integrator

●Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning

●Design, implement and support databases using Oracle RDBMS

●Develops programs using PL/SQL

●Leads and conducts complex backup, recovery and query tuning using Data Domain, Legato, Tivoli TSM

Serves as interface between users and information systems/processing specialists

●Builds compliant databases, writing scripts in SQL, UNIX commands, and shell scripts

●Created functional and technical specification documents

●Coordinate testing procedures with Q/A group

●Troubleshoot and support production systems

●Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)

●Red Hat Linux 5 System Administrator Oracle Linux 5

●Thorough understanding of Oracle internal structure and processing such as detailed knowledge of memory structures

●Created backup and restore scripts and designed backup strategies

●Provided monitoring and performance tuning of very large databases required

●Clone database systems using RMAN and OEM12C GRID CONTROL

●Usage of AIA FP for integration with Oracle EBS R12

●Implemented Dataguard (Physical Standby) for RAC databases.

Select Group/FCB Raleigh, NC

January 2015 – March 2015

Senior Oracle DBA

●Monitor and resolve HP Services Manager Tickets

●Review DB Status and IBM DB2 Databases

●Perform project task assignments

●Review Oracle/DB2 SOX Reports

●Review Oracle Grid Control data

●Monitor Oracle/DB2 backups using CommVault

●Patch Oracle/DB2 systems

●Oracle Database Consultant

●Errors including backup history and resolving backup errors

●Monitor and take action emails in UNIXDBA mailbox

●Serve as daytime on call support for the Data Management Team

●Maintained Oracle

•Managed Oracle Dataguard Databases using OEM 12C GRID CONTROL and Dataguard Broker

Insight Global/Walgreens

Greater Chicago Area

December 2013 – October 2014

Senior Oracle DBA

•Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning

•Design, implement and support databases using Oracle RDBMS

•Develops programs using PL/SQL

•Leads and conducts complex backup, recovery and query tuning using Data Domain, Legato, Tivoli TSM

•Serves as interface between users and information systems/processing specialists

•Builds compliant databases, writing scripts in SQL, UNIX commands, and shell scripts

•Create functional and technical specification documents

•Coordinate testing procedures with Q/A group

•Troubleshoot and support production systems

•Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)

•Experienced using modeling tools such as ERWIN

•Extensive experience using SQL and PL/SQL

•Ability to write complex UNIX scripts and has an understanding of the UNIX architecture

•Understands Oracle and OS architecture and interactions between database and applications

•Thorough understanding of Oracle internal structure and processing such as detailed knowledge of memory structures

•Created backup and restore scripts and designed backup strategies

•Provided monitoring and performance tuning of very large databases required

•Maintained Oracle Golden Gate 11gR2 on Unix and Windows Platform.

•Marinated Oracle Dataguard Databases using OEM 12C GRID CONTROL and Dataguard Broker

National Energy Technology Laboratory

Pittsburgh, PA

March 2013 – November 2013

Senior Oracle DBA Team Leader

•Generate performance report of server and Oracle database using Statspack, AWR, ADDM and TOAD

•Migrated 17 applications/databases from Oracle 10g Windows 2003R2 to Oracle 11gR2 Windows 2008 R2

•Migrated 17 Applications/databases from Oracle 11g Windows 2008 R2 to EXADATA.

•Provide Database Administration for Windows SQL Server 2000, 2005, 2008 R2

•Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning

•Design, implement and support databases using Oracle RDBMS

•Write functional and technical specification documents

•Coordinate testing procedures with Q/A group

•Troubleshoot and support production systems

•Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)

•Installed, Configured, and Implemented Oracle 12C Grid Cloud Control and Plugins for Exadata and SQL SERVER and Oracle Service Oriented Architecture for various Fusion Middleware applications.

•Deployed Agents for Windows 32/64 bit Operating Systems

•Provide maintenance on all EXADATA environments.

•RedHat Linux 5 System Administrator of the Exadata Machine

•Marinated Oracle Dataguard Databases using OEM 12C GRID CONTROL and Dataguard Broker

U. S. DEPARTMENT OF LABOR/OSHA

February 2013 – March 2014

SENIOR ORACLE FUSION MIDDLEWARE CONSULTANT

•Install and Configure WebLogic 10.3.6

•Install and Configure Oracle SOA 11.1.1.7 Infrastructure

•Install and Configure Oracle Identify Management and Oracle Access Manager 11.1.1.7

•Install and Configure Oracle Forms and Reports

•Installed Repository for OID and Oracle Forms/Reports

•Migrated Oracle 10.2.0.4 to Oracle 11.2.0.3 on WINDOWS 2008/R2

Management Science Associates/A.C. COY, INC.

Pittsburgh, PA

November 2012- March 2013

Senior Oracle DBA

•Designs, installs, and maintains complex functions of major database systems including access, allocations, validity checks, security, documentation and tuning

•Design, implement and support databases using Oracle RDBMS

•Develops programs using PL/SQL

•Leads and conducts complex backup, recovery and query tuning

•Serves as interface between users and information systems/processing specialists

•Builds compliant databases, writing scripts in SQL, UNIX commands, and shell scripts

•Write functional and technical specification documents

•Coordinate testing procedures with Q/A group

•Troubleshoot and support production systems

•Perform complex DBA tasks (e.g.: create databases using complex structures; ensure data security and integrity; perform complex database migrations)

•Experienced using modeling tools such as ERWIN

•Extensive experience using SQL and PL/SQL

•Ability to write complex UNIX scripts and has an understanding of the UNIX architecture

•Understands Oracle and OS architecture and interactions between database and applications

•Thorough understanding of Oracle internal structure and processing such as detailed knowledge of memory structures

•Created backup and restore scripts and designed backup strategies

•Provided monitoring and performance tuning of very large databases required

•Significant experience in data warehousing database architectures

•Provide database tuning for .asp pages that were taking 3-5mins/ down to under 5secs.

•Re-indexing of fragmented objects

•Generate performance report of server and Oracle database using Statspack, AWR, ADDM and TOAD

•Allocate storage and configure ASM

•Extensive use of performance tools like AWR, ADDM, TKPROF and Explain plan for performance monitoring and troubleshooting with shell scripting.

•Provided a level of senior expertise to define a comprehensive set of procedures through which the integrity, security, operating performance

•Database I/O tuning by reorganization of database and tablespace and re-indexing

•Work with Oracle or other vendors to solve database problems when they occur

•Assist ETL, Report developers with performance tuning ETL jobs & report execution

•Enforce all security policies and perform security audits

•Create, Define & Implement Backup using RMAN.

•Created planned maintenance for rebuilding indexes and gathering statistics to decrease db file sequential reads

•Tuned the SGA using Oracle Best Practices for RAC ASM Systems

AT&T/EXTERNETWORKS INC Columbus, OH

March 2012 – August 2012

SENIOR ORACLE DBA CONSULTANT

•Provide Maintenance and Support of People Soft Databases on ATT Hosted Systems in 2 data centers

•Provide Maintenance and Support for Oracle OEM Grid Control Version 11gR2

•Provided SQL Tuning for PeopleSoft Database Migration

•Assisted in the Data Transformation of Sql Database to Oracle Database for PeopleSoft CRM PORTAL FINANCE

•Production Support DBA for over 50 PeopleSoft Databases

•Provided Database Tuning of PEOPLESOFT environments

•Created RMAN duplicate/clone procedure for refreshing of large PEOPLESOFT Databases using RMAN production backups

•Provide Maintenance and Monitoring for Oracle Dataguard Databases

Duke Power/ALLTECH Solutions

Charlotte, N.C

September 2011 – February 2012

Senior Oracle DBA Consultant

•Provide Database Support for All Active Databases on IBM AIX Systems

•Oracle Utilities Work And Asset Management Application DBA

•Oracle Utilities Customer Care and Billing Applications DBA

•Oracle Utilities Meter Data Management DBA

•Oracle Utilities Mobile Workforce Management DBA

•Oracle Fusion Middleware DBA

•Provide 24/7 Database Support

•Provide Maintenance and Support Oracle RMAN Environments

•Provide Maintenance and Support Oracle Golden Gate Production Environments

•Provide Maintenance and Support of People Soft Databases

•Provide Maintenance and Support for Oracle RAC ONE NODE

•Provide Maintenance and Support for Oracle OEM Grid Control Version 11gR2

•Implemented and Maintained AVAMAR backups

•Implemented EMC Domain Backups Using OEM Grid and RMAN

•Created Data Guard Databases for Failover

•Provide Maintenance and Support for Oracle Streams

•Oracle Migration from 9/10 to Oracle 11GR2

•Provided Patch Management and Installation

•Install, configure and apply patches to Oracle database software and related software components on Oracle 11g r2 Grid RAC and 10g RAC on IBM, Sun Solaris and Linux Operating System.

•Upgrade version from 9i to 10G R2, 10.2.0.1 to 10.2.0.3 and 11g r2 Grid

•Allocate, design, installation and Administration Oracle ASM in Oracle 10g & 11g r2

•Monitor database performance and resource utilization

•Patching and bug fixing of Oracle Database 10g and Oracle 11g

•Configure Database Flashback for oracle 10g and oracle11g

•Set Monitoring System OEM for Database and PeopleSoft application and Email notification upon up/down

•Re-indexing of fragmented object

•Generate performance report of server and Oracle database using Statspack, AWR, ADDM and TOAD

•Allocate storage and configure ASM

•Extensive use of performance tools like AWR, ADDM, TKPROF and Explain plan for performance monitoring and troubleshooting with shell scripting.

•To provide a level of senior expertise to define a comprehensive set of procedures through which the integrity, security, operating performance

•Database I/O tuning by reorganization of database and tablespace and re-indexing

•Work with Oracle or other vendors to solve database problems when they occur

•Assist ETL, Report developers with performance tuning ETL jobs & report execution

•Enforce all security policies and perform security audits

•Create, Define & Implement Backup using AVAMAR BACKUP Manager

University of Richmond, Richmond, VA

March 2011-September 2011

Senior Oracle DBA Consultant

•Performed Oracle Upgrades from Oracle 10.2 to 11gr2

•Maintained Banner/SunGard Database Systems on IBM AIX Systems

•Provided Production Database Support for Teradata Studio Abroad Application

•Implemented Oracle BI for Department of Computer Science School

•Implemented Oracle OEM Grid Control and Intelligent Agent Installations

•Provided Oracle RMAN integration with Symantec NetBackup Version 7.1

•Provided Oracle Production support for various Oracle Dataguard Databases.

•Provided Database Support for MSSQL Sever 2005 and 2008r2

•Documented Resource and Control Environment for Server/Database Management

•Mentored and trained junior DBA’S on Oracle Best Practices and Techniques

•Performed normal Daily Production DBA routines of monitoring and proactive maintenance.

•Installed, Configured, and Implemented Oracle Enterprise Manager.

•Configured OEM Alerts, Monitoring, and Notification via SMTP

IBM/ARTECH/QWEST

Fargo, ND, and Richmond, VA

September 2009- June 2011

Senior Oracle DBA

•Provide Production Database Support to various Qwest accounts on IBM AIX Systems

•Performed Oracle Database Tuning on Excessive Waits

•Performed Network Metrics for Baseline Analysis

•Provide Backup and Recovery configuration using RMAN and SQL-BACKTRACK

•Install Oracle Binaries and create new databases via DBCA and scripts

•Provide Manual upgrades from Oracle version 9i to 11g.

•Perform daily ticket troubleshooting using Remedy and automated ticket dispatch

•Increased employee production by creating load balancing by implementing 2 listeners

•Upgraded database from 9.2.0.8. to Oracle Version 10.2.0.4

•Provide 24/7 response to all production environments

•Database Cloning and Refreshing using Transportable Tablespaces.

•Install Quarterly Critical Patch Updates

•Provide AWR snapshots to client.

•Provide Database Admin for PeopleSoft and Siebel.

•Provide Database Support for Dataguard Database Configurations on IBM AIX Systems

Eagle Creek Software Services, Valley City, ND

December 2009- October 2010

Senior Oracle DBA

•Provide Production Database Support to various client accounts including RAC on windows

•Created and Implemented Oracle RMAN backups

•Performed Network Metrics for Baseline Analysis

•Created Backup and Recovery Manager documentation for New Database

•Documented Oracle Database Environment

•Created Oracle DBA Manual for company to manage the databases in their environment.

Blue Cross Blue Shield of ND/UPP Business Systems, Fargo, ND

July 2007- October 2009

Senior Oracle DBA

•Created and Implemented Patch Management for Database and AIX System

•Created and Implemented Oracle Dataguard and Oracle Standby Database on versions 8-10g

•Performed Oracle Database Tuning on Redo Logs

•Performed Oracle Database Tuning on Excessive Waits

•Performed Network Metrics for Baseline Analysis

•Troubleshot I/O bottlenecks on EMC_DMX3/AIX 5.3 LPAR Systems

•Repaired/Patch Oracle 9.2.0.8 Listener

•Increased OLTP from 30 thousand claims a week to over 30 thousand a day

•Increased employee production by creating load balancing by implementing 2 listeners

•Upgraded database from 9.2.0.8. to Oracle Version 10.2.0.4

•Upgraded database from 9.2.0.8 to Oracle Version 11g

•Developed and Implemented Oracle Advanced Replication for fail over using TAF

•Documented Oracle Environments for ease of management

•Created database objects such as indexes, tables, partitions, materialized views.

•Trained Personnel on Oracle Versions 9, 10, and 11g.

•Created and Implemented Proactive Maintenance

•Increased scalability and processing throughput allowing for new business opportunities

•Project Manager for Application/Database Upgrade and Migration

•Configured Oracle Enterprise Manager Grid Control

•Maintained Oracle Versions 9.2.0.8 – 11.1.0.6

•Maintained Databases in accordance with STIGS V7r2 and V8r1

•Successfully completed 3 major CMS/MEDICARE projects increasing revenue and ROI

•Implemented Oracle Enterprise Grid Control

•Designed, Implemented, and documented Disaster Recovery for several db applications

•Maintain PeopleSoft, Siebel, Remedy, Guardium implemented database systems

•Maintain M2 EDI Translator Software Application

•Implemented RMAN backups vice THRID PARTY software saving over 1 million dollars a year in expenses

Perot/Dell Systems/Catholic West Healthcare, Phoenix, AZ

August 2006 – June 2007

Database Management Team Manager Senior Oracle DBA

•Involved in patch management, system upgrades and system documentation.

•Involved for Oracle maintenance, material and management of all infrastructure systems for 42 hospitals.

•Maintained over 300 databases, 800 applications on various platforms.

•Maintained all SERVICE LEVEL AGREEMENT when Perot downsized my CORE DBA group from 14 to 3.

•Provided 24/7 database monitoring and maintenance.

•Implemented Standard Operating Procedures for daily, weekly, monthly and quarterly preventive maintenance.

•Implemented proper Disk, CPU, I/O and database monitoring and provided database troubleshooting guide for all applications using a 6 step

troubleshooting standard.

•Submitted 2 employees for Associate of Month and they were chosen. No one in the 5-year history for the DBA group has ever been selected.

•Provided architectural solutions to various application changes.

•Used REMEDY to provide change management tracking, incident reporting and incident tracking.

•Put several operation changes in the way the backup and recovery was performed.

•Performed performance-tuning baselines on all critical systems.

•Provided specific customer relations to enhance relationship with external and internal customers.

•Corrected 4 years of Audit hits from SOX and maintained MS Clusters.

•Maintained PeopleSoft Database backend

•Used RMAN on several databases and maintained Oracle versions 7.3.3 to 10gR2, SQL Server 2000/2005.

•Maintained Oracle Databases in a Veritas Clustering/RAC configuration

•Installed, Configured and Implemented Oracle Enterprise Manager

DSM Pharmaceutical/MODIS Inc., Greenville, NC

December 2005 – July 2006

Senior Oracle DBA\ Windows System Administrator

•Provided 24/7 Database Administration for Oracle Database Instances versions 7.3.4/8i/9i.

•Provided backup and recovery for 5-minute point in time recovery, all online backups using RMAN API.

•Created scripts to perform archive log cleanups.

•Performed Oracle Performance Tuning and Windows Operating Tuning Sessions for better database and system performance.

•Trained personnel how to use Oracle Enterprise Manager and manage various database applications.

•Provided Disaster Recovery Tools and FACTS for company implementation.

•Documented all Oracle Database environments and trained staff personnel in Oracle troubleshooting techniques and restoration.

•Provided database tuning and performance optimization.

•Provided database support for MS SQL Server 2000.

•Performed daily database maintenance routines and set up Oracle Enterprise Manager to manage database status, corruption, I/O contention, CPU contention, disk space parameters, archival process, page swapping, application performance and index fragmentation.

•Maintained ADP HRMS Database systems and created scripts to maintain crosschecks of RMAN backups.

•Configured and maintained Oracle 8i standby databases.

Ruan Transportation, Des Moines, IA

August 2005 – December 2005

Senior Oracle DBA/AIX System Administrator/Windows System Administrator

•Provided Oracle Support for Oracle Versions 7.3.4/8.1.7.3/9.2.0.4 on Windows 2000/2003 and IBM AIX version 4.3 and 5.3.

•Provided backup and Recovery using Oracle Recovery Manager API to tape and disk.

•Provided instance creation for various UNIX and Windows based Application.

•Provided Security Administration and provided AIX administration.

•Created volume groups, allocate disk space; provide monitoring of the AIX systems via crons and Tivoli Maestro Scheduler and Monitoring Suite.

•Developed scripts to automate administrative functions (Korn Shell etc.) Develop and Document Standard Operating Procedures.

•Facilitated and take direct responsibility for planning, installation, configuration and deployment of AIX based server(s).

•Provided project support for configuring, installing and developing new UNIX based software solutions.

•Provided guidance and training for junior staff to develop them as full system administrators.

•Provided support for development groups on Ruan Transportation UNIX servers.

•Performed Oracle backup and recovery using Tivoli Storage Manager ADSM, BMC SQL Backtrack, and VERITAS NetBackup.

•Performed Oracle Performance Tuning and performed oracle migration in test environment from 8i/9i to 10gR1.

•Provided database administration to PeopleSoft Database environment

Contact this candidate