Oracle DBA

Michael J. Stephens

**** ******* ****

Austin, TX. 78745

512-***-**** (c)

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

Objective

Oracle Database Administrator.

Skill Profile

Maintained Oracle 10g and 11g in SUSE z/Linux, Red Hat Linux VM, and Solaris environments.

Worked with a large, 32+ TB, database with Oracle 10g RAC

Install Oracle 11g in Linux and Solaris systems, including the use of silent install methods.

Setup RMAN backups for newly installed instances ad maintain RMAN backups for existing systems including shell scripting and cloning.

Cloned databases using RMAN backups and Active Database.

Provide advanced support for the resolution and prevention of outages, customer support requirements, and service level issues.

Analyze the performance of and optimize SQL statements using OEM 11g and 12c, SQL Developer, and Toad

Create and test Oracle Real Application Testing environments

Create and test Oracle Transparent Database Encryption environments to apply Tablespace Encryption, including planning for the production system conversion

Use Oracle Data Pump to export and import databases, tablespaces, schemas, and tables across multiple databases, often to apply character set conversion and tablespace encryption

Create and apply table, key, index, trigger, and other DDL maintenance to multiple test and production environments.

Use Oracle Enterprise Manager, SQL*Plus, SQL Developer, OEM, and Grid Control to interrogate, monitor, and maintain the Oracle instances, schemas, tablespaces, triggers and other Database objects.

Create multiple Oracle statistics optimization jobs and the scripts to execute them weekly and monthly.

Develop ksh and bash on zLinux, Linux, and Solaris, and SQL*Plus scripts to monitor, report, and maintain the Solaris and Linux environments, including using cron, ftp, ssh, and smbclient.

Design and write triggers to capture fine grained auditing data on selected tables as well as the COBOL sub-programs needed for z/OS reporting of the audit data from the Oracle instances.

Create SQL*Plus infrastructure in batch z/OS, Windows, and Linux environments to maintain client Oracle databases.

Help with the setup and testing of Oracle GoldenGate products to replicate client databases.

Monitor and troubleshoot GoldenGate processes

Monitor extract and load operations to move client data from z/OS Datacom databases to z/Linux Oracle instances.

Set up an Oracle Wallet and OpenSSH in zLinux and Solaris environments to secure SQL*Plus maintenance and reporting across the production and development instances.

Manage software development projects as Project Leader and Senior Systems Analyst.

Work with end users and management during all phases of project development.

Analyze system, program, job, and data requirements.

Design databases, programs, work flow, and jobs and write specifications for programmers and analysts on the projects.

Create and maintain documentation for developers and users of applications.

Create and maintain the project documentation using MS Project and other project management products.

Manage programmer and analyst resources available to accomplish the project tasks.

Design and run program and system testing to validate project results.

Design and run production implementation of the resulting systems.

Extensive experience with IBM mainframe systems, as well as several mid-range systems using UNIX and VMS, and CDC mainframes.

Mainframe Systems Programmer; installed and maintained numerous third-party systems-level software products.

Database Administrator for CA-Datacom. Installed, maintained, tuned, and supported CA-Datacom, Data Query, Ideal, ODBC/JDBC Server and related products.

Design and write COBOL programs that interface with Oracle instances and with CA-Datacom databases using SQL, native calls, VSAM Transparency, and MetaCOBOL.

Design and write CA-Ideal programs for both online and batch environments.

Expert in batch COBOL including IBM’s VS, MVS, and Enterprise COBOL.

Design and write JCL and scripts to transfer data to and from the mainframe using FTP.

Well versed in the use of DFSORT, SyncSort, IDCAMS, and other utilities.

Work with ADABASE and Natural in VMS and MVS systems.

Non-mainframe experience includes:

MS-Access, Word, and Excel

ColdFusion and Dreamweaver application programming with MS Access and SQL Server databases.

X/HTML and CSS.

Micro Focus Net Express COBOL, Enterprise Server, and Mainframe Express.

Excellent written and verbal communication skills.

Managed or participated in all phases of a major application software acquisition including evaluation, contract negotiations, installation, data conversion, testing, training, documentation, and maintenance.

Manage up to four programmers and analysts in both development and maintenance environments.

Well versed in the use of spreadsheet, word processing, project management, and flow charting tools.

Professional Experience

Beacon Hill, contracted with Haas Group International September 11, 2014 – April, 2015

Oracle Database Administrator (as Contractor from Beacon Hill)

Install, monitor, patch and maintain Oracle 11g databases in multiple Linux and Solaris servers up to about 900 GB

Analyzed performance issues and provide solutions.

Worked with:

oOEM 12c, SQL*Plus, SQL Developer, Toad, RMAN, TDE, RAT, APEX

Kforce Government Solutions, contracted with the VA May 15, 2012 – June 3, 2014

Oracle Database Administrator

Install, monitor, patch and maintain Oracle 10g and 11g databases in multiple Linux and Solaris servers from about 500 GB to 32+ TB

Installed OEM 12c OMR and OMS to support Data Masking and Redaction

Analyzed performance issues and helped Program Development team implement application changes in the Production environments.

Worked with:

oOEM 11g and 12c, SQL*Plus, SQL Developer, Toad, RMAN, and Grid Control

oLarge, 32+ TB, database with Oracle 10g RAC

Education Service Center, Region 20 November, 2008 – April 29, 2012

Database Administrator I

Monitor and maintain Oracle 10g instances in multiple z/Linux and Windows Server environments using:

oOEM, SQL*Plus, SQL Developer, and Grid Control

Create and use infrastructure to monitor and maintain Oracle 10g databases using SQL*Plus in z/OS, Windows, and zLinux.

Helped with evaluation of Oracle Streams and GoldenGate products to support replication of client data to local sites.

Manage and maintain GoldenGate replication instances.

Maintain z/OS Datacom client databases during transition to Oracle 10 in z/Linux.

Other tasks of a DBA.

Maintained computer usage billing reports, including re-writing the reports in COBOL.

Maintained job submission system using CICS COBOL.

Learning Sybase SQL Anywhere in order to support the new TxEIS system.

Learning COGNOS to support customers that use it.

Williams-Stephens Consulting August, 2005 – November, 2008

Consultant

Redesign client database.

Modify existing ColdFusion application to fix errors, add functionality, and utilize CSS.

Tiburon Technologies

Senior Consultant August, 2006 – May, 2007, March – May, 2008

Mentor client in the use of Micro Focus products.

Work with clients to convert legacy databases and programming to current system architectures.

Maintain CA-Datacom databases and Data Dictionary definitions to facilitate client data conversions. Load and extract client data.

Maintain CA-Datacom Server to facilitate data conversion.

Converted SQL COBOL code to use CA-MetaCOBOL+. Debug and tested resulting client programs.

DBA February – May, 2005

Contract DBA for a project to replicate a client’s VSE CA-Datacom databases in Tiburon’s z/OS system.

oInstalled CA-Datacom 10.0, CA-DataQuery, and CA-Server 5.0 and helped install the other supporting CA-Common Services products (CA-90’s).

oReplicated the Data Dictionary definitions for the client’s databases and loaded their data extracts.

oExtract client data to MS-SQL Server database using CA-Server, CA-DataQuery and other methods.

Temple-Inland, Inc.

DBA/Systems Programmer September, 2001 – November, 2004

Guarantee Financial Services (TICS), Systems Development & Support – Shared Services

Installed, maintained, and monitored the CA-Datacom database management system and its related products for all lines of business; TIFPC, TIFS, and Inland.

Provided technical support for the SSA Masterpiece suite of applications to the Shared Services group for technical and user documentation, definition of standards and procedures, planning and coordination of application data conversion and implementation.

Provided consultation with users, management, and business system analysts on the design and use of CA-Datacom components, database tables, and backup, restore and disaster recovery procedures.

Monitored and managed the usage of disk resources for Masterpiece and Datacom.

Systems Programmer/DBA July, 1999 – September, 2001

Austin Data Center, Technical Services

Advised and consulted with users and management on best usage of database systems.

Provided primary installation, maintenance, and user support for CA-Datacom products.

Installed and maintained CA-Jobtrac.

Installed and maintained CIMS.

SMP/E software installation of several other vendor products.

Provided rotating on-call support for all systems software.

Continued to provide support for the TIFPC Internal Audit data analysis functions with FOCUS and FOCAUDIT systems of Information Builders, Inc.

DBA/Systems Programmer; Programmer June, 1994 – July, 1999

Temple-Inland Forest Products Corporation, Corporate I/S

Primary DBA for CA-Datacom products during the Masterpiece financial systems project.

Began training as Oracle DBA.

Designed and wrote a Visual Basic program for the Benefits department to format and transfer data to the mainframe.

Supported the Masterpiece GL and CA-Datacom database systems prior to the start of the company-wide Masterpiece project.

Supported IRS and internal audit requests against both the Masterpiece and legacy systems.

Supported TIFPC Internal Audit data analysis functions with FOCUS and FOCAUDIT systems of Information Builders, Inc.

Self Employed September, 1993 – June, 1994

Provided programming, systems integration, and consulting services on a contract basis with various clients in the Nacogdoches and Lufkin area, including the installation of a 10BaseT LAN using LANtastic.

Stephen F. Austin State University June – August, 1993

Programmer Analyst

Part of team to install, test, and document IA's Financial Reporting System, FRS, on a VAX 7000 with SAG ADABAS and Natural.

Southern Methodist University September, 1980 – June, 1993

Senior Systems Analyst

Computer and Information Services

Project Manager and team leader with up to four programmers and analysts responsible for Library Automation, Financial Accounting, Accounts Payable, Alumni Development, and Project Leader for numerous smaller projects.

Member of campus-wide Data and Telephone Communications Infrastructure Project.

oMember of the team that wrote a grant proposal to the Department of Education. That proposal generated the largest to-date grant for a data communications project on a single campus. The network was used in support of the SMU library automation project and became the beginnings of a campus-wide, fiber-based, digital PBX and WAN system.

Data Center Project Leader of the Library Automation Project.

oProvided technical evaluation support and member of contract negotiation team.

oInstalled and maintained the NOTIS library automation system.

oHeavily involved with all phases of the Library Automation Project in addition to Data Center responsibilities.

oHeavily involved with international user group community, giving presentations, and serving a stint as the chairman of the MVS Special Interest Group.

oResearched and evaluated business and library document imaging systems.

Other Data Center responsibilities included:

oProject planning and scheduling support to data center management.

oInterviewed, evaluated, and advised on the hiring of new employees.

oPerformed personnel evaluations.

oProvided technical training for analysts, programmers, and users.

oProject Leader for the conversion of the Financial Accounting and Accounts Payable systems for the migration from Control Data to IBM mainframe systems.

oDesigned, developed, and managed the programmer team to create an on-line inquiry subsystem for the batch based GL and AP systems using CA-Datacom and CA-Ideal.

oDesigned, developed, and managed the programmer team to create an IRS 1099 system for the AP system using CA-Datacom and CA-Ideal.

oDesigned and implemented a fraternity and sorority rush system that was used for almost 10 years at the university.

Adjunct Professor September, 1987 – May, 1988

SMU Cox School of Business

Taught Beginning and Intermediate COBOL.

Education

Master of Business Administration

Southern Methodist University (1987)

Dallas, Texas

Bachelor of Business Administration

Systems Analysis

University of Texas at Arlington (1980)

Arlington, Texas

Bachelor of Science

Psychology

University of Tulsa (1974)

Tulsa, Oklahoma

Contact this candidate