Systems Administration Oracle Database

Daniel Williams

************@*****.***

Objective:

Database Administration position where I can apply my skills, background, and track record of successful design, implementation, and delivery of database systems to help bring your software product from concept to market.

Professional Profile:

Over 20 years of experience with Oracle database and system administration on multiple platforms. Experience in conducting requirements analysis, design and implementation of Oracle database systems as well as the configuration of Oracle on multiple operating systems, hardware platforms and virtual environments. Extensive knowledge of the UNIX operating system and utilities. Proficient in design and implementation of logical/physical database layout and backup/recovery systems.

Experience:

Oasis/Torch Technlogies: Dec. 2017 – present

Oracle 11.x-19c DBA/UNIX Systems Administration/Weblogic Administration:

Installation, configuration and administration of Oracle 11g – 19c database, Weblogic 12.x, OEM13c.

Database migration to AWS.

Database object creation (tables, indexes, triggers, etc.).

Dataguard installation and configuration.

Applied quarterly patches and maintained database STIG compliance.

Database upgrades, performance tuning, capacity planning, backup and recovery.

PL/Sql troubleshooting and programming.

UNIX systems administration and shell scripting for various tasks.

Template creation of server and database deployments on Vmware.

ICS: June 2015 – Nov. 2017

Oracle 11.x-12c DBA/UNIX Systems Administration/Sql Server 2012 DBA:

Installation, configuration and administration of OEM 12c and 13c on Linux for monitoring, backup configurations, corrective actions, etc. of Oracle, MySql and Sql Server databases.

Utilization of Emcli coupled with shell and sql scripts for migration of OEM 10g to 12c as well as automation of database monitoring tasks and notifications.

Created templates of server and database deployments on Vmware.

Created unix, Powershell scripts for automation of template creation and deployment on Vmware.

Installation, configuration and administration of Oracle 11g and 12c.

Installation and configuration of MySql on Linux.

Installation and configuration of Sql Server 2012 on Windows Server 2012.

Encrypted communications setup (PKI/SSL/TCPS).

General Dynamics: Feb. 2007 – May 2015:

Oracle 8.x-12c DBA/UNIX Systems Administration:

Installation and configuration of RAC 12c on Linux.

Installation and configuration of RAC 11gr2 on Linux and Solaris.

Installation and configuration of OEM 10g – 12c on Linux and HP-Itanium.

ASM/CRS/ACFS administration.

Node addition/deletion.

Rolling PSU application and upgrades from 11.2.0.1 to 11.2.0.3 cluster stack.

Installation and configuration of Oracle 9 – 12c on HP-Itanium, Linux and Solaris.

Upgrades from Oracle 9.x – 12c.

Migration of 10g databases from HP-UX to HP-Itanium.

TAF and Dataguard implementations.

Advanced Replication implementation.

TDE and auditing implementations.

Replication of databases using rman/expdp, impdp for refresh of development and Q/A environments.

Oracle Advanced Security (SSL) implementation.

Oracle Application Express (APEX) implementation.

Aflac: Nov. 2006 – Feb. 2007

Oracle 10g DBA/UNIX Systems Administration:

Installation and configuration of Oracle 10g on Solaris 10.

Setup of RMAN backups.

Configuration of dbconsole for monitoring/administration.

Install and configuration of software packages for Aflac.

Worked with UNIX SA’s to configure Solaris 10 for optimal performance.

Defined and implemented best practices for logical and physical database design.

Cloned databases for refresh of development and integration platforms.

Performed code reviews and implementation of sql code for creation of tables, indexes, synonyms, etc.

Configuration of Oracle flashback capabilities.

General Dynamics: Jun. 2005 – Oct. 2006

Oracle 9i/10g DBA/Developer

UNIX shell/PERL programming for enhancement of CMOS application.

Upgrade of Oracle database from 9i to 10g for CMOS application.

PL/SQL programming for running database tasks (recompilation of invalid objects, tablespace maintenance, cleanup of obsolete data, etc).

SQL programming for maintenance and creation of primary keys, indexes, foreign keys, tables, triggers, etc.

Use of explain plan, TKProf and dbms_stats to decrease development time by improving development

database performance.

Installation and configuration of Oracle 9i and 10g on HP-UX and Windows servers.

HP UNIX/Linux Systems Administration:

Installation and configuration of HP 11.0/11i.

Installation and configuration of Oracle 10g on Red Hat Linux.

Migration of development database from Oracle 8i on HP-UX to Oracle 10g on Linux.

Computer Sciences Corporation: Dec. 2004 – May 2005

Oracle 10g DBA/Linux/UNIX Systems Administration:

Installation and configuration of Oracle 10g databases on Linux.

Installation and configuration of Linux.

Installation and configuration of Solaris.

Network Telephone: Feb. 2000 – Dec. 2004

Oracle 8.X/9.X DBA:

Installation and administration of Oracle databases on UNIX O/S (Sun and HP-UX) as well as Windows NT.

Created and cloned databases for reporting, Q/A testing, development and user acceptance testing.

Wrote UNIX shell scripts and SQL queries for various monitoring tasks, exports, hot backup of databases, archiving of data, rebuilding of indexes and maintenance of tablespaces.

Created and maintained partitioned tables and indexes.

Utilized transportable tablespaces for data warehousing.

Creation and automatic refresh of materialized views for quick turnaround of reports.

Worked with application developers to build databases for various projects.

Competent with creation and modification of Oracle objects such as tables, indexes, views, synonyms, tablespaces and procedures.

Physical and logical database design, I/O subsystems and RAID systems experience.

Thorough understanding of concepts such as parallel query, partitioned tables and indexes, cost-based and rule based optimizers, explain plan and TKProf, hot and cold backups and storage management.

Highly skilled in disaster recovery, routine maintenance, patch application, upgrades and performance tuning for Oracle databases.

Migrated billing system database (Express ADC) from HP-UX to Sun server.

Upgrade of TBS (MetaSolv) applications (CLEC and Telecom applications).

Discoverer 4/5 implementations. Implementation of Oracle Application Server 9i.

Sql Server 2000 DBA:

Installation and administration of SQL Server databases.

Established and implemented best practices for database creation, security, maintenance and backups of enterprise level data warehouse.

Implementation, administration and troubleshooting of replication, jobs and DTS packages.

UNIX systems administration:

Broad understanding of troubleshooting the UNIX operating system.

Installation of Sun O/S version 9, SSH, TOP, Apache and various other software packages.

Setup of RC scripts for automatic startup of applications/databases at boot time.

Knowledgeable in use of operating system utilities such as netstat, iostat, vmstat, tar, gzip, compress, cpio, awk, sed, mailx, etc.

Worked with UNIX admins with setting up kernel parameters for optimal performance of Oracle databases.

PL/SQL:

Wrote procedures, functions and triggers used in various Oracle forms.

Wrote code for replication and maintenance functions.

Crystal Reports:

Developed various revenue and equipment reports for Provisioning and Billing systems.

Administered Crystal Enterprise application for automation of nightly batch reports.

XML/HTML:

Performed maintenance on web pages that interfaced with Crystal Enterprise web server and Oracle Database.

Unix shell scripting:

●Incorporated SQL scripts into shell scripts for automation of monitoring tasks, backups, etc.

Other skills:

Applications Development

●Object-Oriented Analysis and Design, Systems Analysis and Design, Testing and Quality Assurance.

Utilities

●RMAN, Logminer, Transact-SQL, Vmware, T.O.A.D., Oracle Virtualbox, vCloud Director, Emcli, GIT, AWS, JIRA, Bitbucket, CI/CD.

Prior work history:

Electrician 1994 – ‘99

●Worked for various commercial electrical companies in Alabama and Texas as team leader.

U.S. Army Unit Supply Specialist 1991-'94

●Specialized in computer based communications network used to control inventory and

movement of equipment and men into conflict theatres.

Education:

CompTIA

Security + Certified, Jan 2015

Oracle University, Atlanta, GA

Oracle Database Administration, PL/SQL - Nov 2000

Coleman College, San Diego, CA

Computer Information Science, Oct 1999

Contact this candidate