Database Administrator (Oracle, SQL Server

BRAD SHEARER

*** *.*. **** ***. McMinnville, OR *7128

cell 503-***-****

e-mail ********@*****.***

PROFESSIONAL SUMMARY

Experienced database professional: DBA, database programmer.

Primary experience in Oracle, most recent experience in SQL Server with some limited experience in

Informix and Sybase.

Windows 2008/2005/2000 and UNIX platforms; experience utilizing a wide variety of software tools,

languages and protocols.

Some experience in data warehouse maintenance, web-based application databases, reporting.

Industry experience: Health care systems/insurance, education, manufacturing, government/military, and

telecom.

HARDWARE/SOFTWARE

Programming languages/databases/tools:

Oracle Enterprise Databases 11G (11.2), 10G (10.2), 9i (9.2.3), 8i, SQL Server 2008 and 2005, TOAD for

Oeacle Xpert 10.6.1, PureSafety Occupational Health Management System (v.9), SQL Programmer,

Crystal Reports 9.0 / 8.5, Computer Associates BrightStor ArcServe v. 9/v. 11, Informix Dynamic Server

7.2, PL/SQL 2.1-2.3, ERWin, Power Designor, Visio, ORACLE E-Business Suite 11.1, Unix Shell

Scripting (Korn, SCCS), HTML, CA Brightstor 11.1, Track-IT Service Ticketing app

Hardware and operating systems:

Windows Server 2000/2005/2008 Server/Windows 7, Exadata X2 for Linux, Solaris 10, Linux 5, PTX

UNIX in Sequent X-16 environment; Sequent S200, Dynix/ptx/v4.1.3 (UNIX) environment. Sun Solaris

2.0, IBM Netinfinity 1000, AIX

EXPERIENCE

Database Administrator

Integra, Portland, OR

July 2012 - April 2014 SQL Server administration:

Monitor and maintain 277 production and 835 non-production databases utilizing SQL versions

o

on a team of primarily 2 and temporarily 3 SQL DBA's.

Create and configure new databases with respect to growth projections as communicated by

o

primary stakeholders.

Maintain and control access to and viability of existing Integra production and non-production

o

databases in alignment with security policies.

Coordinate with Change Management/Production Control Team to ensure that proper

o

procedures are followed in any changes to production databases(i.e. stored procedures, SSIS

packages, creation of new subscribers to Replication processes), pre-empting any potential

issues that may cause deploy times to impact other critical scheduled production processes.

Conduct required quarterly database audits against requirement checklist to ensure adherence

o

to guidelines and requirements agreed upon with Price Waterhouse Cooper. Utilize Tripwire

auditing tool to flag changes to production and identify and link said changes with approval

documentation.

Monitor and mitigate space requirement needs in conjunction with SAN administrator as they

o

arise.

Diagnose and resolve production database job failures reported through email and phone alerts

o

in a timely basis.

Maintain cross-platform database access to Oracle and DB2 through utilization of Linked Servers

o

by assuring proper configuration of connectivity through configuration files, e.g. tnsnames.ora.

Provide ad-hoc and scheduled database data refreshes for application development teams.

o

Correspond with vendors to maintain currency of latest software versions.

o

Monitor and mitigate database performance issues as they arise by SSMS performance monitor

o

and Quest Spotlight.

Perform managed failovers and failbacks on the server clusters as necessary in order to perform

o

scheduled maintenance.

Maintain regularly scheduled backups with Redgate SQL Backup, troubleshooting failures when

o

they occur, performing database restores/recoveries when necessary.

Perform on-call overnight rotation for production support.

o

March 2010 - July 2012, Oracle database administration

Maintain and monitor 30 production and 48 non-production databases on Oracle versions 8i, 9i,

o

10G, and 11G and monitor database performance through Sqlplus and Oracle Enterprise

Manager version 11, through customized alerts.

Migrate Oracle Financials database to new Solaris container, performing data overlays to non-

o

production environments and reconfiguring the Oracle EBS app.

Conduct Oracle Financials and Revchain billing (BillPlex) data overlays with schedules avoid

o

nightly nightly and weekly billing job schedules.

Update database statistics within restricted billing process windows when performance

o

degradation would occur.

Maintain login and user accounts, roles, and permissions as required.

o

Maintain and monitor Oracle Exadata X2. Perform data overlays to non-production environments

o

as requested for testing of Carrier Access Billing Software upgrades.

Worked in tandem with Oracle Support to resolve periodic outage issue for Oracle Financials

o

database caused by multi-threading configuration issue.

Perform on-call overnight rotation for production support.

o

Database Administrator / Data Analyst

Cascade Steel Rolling Mill, McMinnville, OR

January 2000 – November 2009

Develop, create, and maintain, development and production databases for rolling mills and melt shop.

Ensure capability of backup and restoration practices of said databases utilizing tape archival, on-line and

off-line backup strategies utilizing Computer Associates Brightstor 11.1.

Upgrade databases to accommodate new and current Oracle Enterprise Edition software.

Design, develop and implement back-end business rules validation system for Level 2 production

system using triggers, stored procedures and dynamically generated PLSQL.

Maintain Oracle 10G, 9i and 8i databases for PureSafety OHM employee health and safety software

application.

Act as liaison between the Cascade Steel Health and Safety Department and the Schnitzer Steel

corporate office to resolve issues with new feature upgrades to OHM Health and Safety Application.

Evaluate and make recommendations involving third-party software purchases and test integration with

Oracle databases.

Design and implement backup and recovery strategy.

Evaluate and implement any and all proposed data objects and their accompanying access strategies.

Design and write appropriate process scripts in Windows NT Command Script and Perl.

Design and implement RAID, physical and logical database requirements in implementation of any new

servers required.

Utilize hardware diagnostic utilities for database corruption troubleshooting and design and follow

procedures for database rebuilds for critical hardware or software failures.

Develop, maintain, and test Backup and Recovery procedures. Follow established performance tuning

evaluation testing and procedures.

Ad-hoc reporting as needed with SQLPlus and Crystal Reports.

Sr. Programmer Analyst III

Siltronic (formerly Wacker Siltronics), Portland, OR

March 99 – December 99

Maintain production support of Wacker's Certificate of Compliance System which utilizes data recorded

on silicon wafer measurement systems to report and verify customer specification requirements.

System works in tandem with Shipping and Invoicing to determine proper time to record sample

measurement data and tie to appropriate lots.

Tasks involve diagnosis of production problems due to breaks in data flow or timing issues.

Analyze data model to make modifications to database views to accommodate process changes.

Install and configure new versions of system to accommodate Y2K issues.

Diagnose source code in Centura Team Developer 1.5 to determine any newly discovered defects in code

in order to resolve unexpected behavior of system .

Sr. Technical Consultant I

Covansys (formerly CBSI, Inc.), Hillsboro, OR/on-site for Benova Health Systems

September 98 - February 99

Worked on-site at Benova Health Systems (Portland, OR), building, modifying, and automating data

loading interfaces along with accompanying server-side business rule packages in Oracle 7.3.4, for

member enrollment and disenrollment for Floridian state health insurance system. Pl/SQL 2.3 and korn-

shell scripting were utilized.

Vacation coverage, 3 weeks onsite as Oracle DBA for government client in Sacramento, CA.

Oracle Database Administrator

LGS, Inc./on-site at ADS, Vancouver, BC

Contract, 4/98 – 9/98

Install and upgrade the ORACLE 7.3.4 Server software and application tools running on IBM NetInfinity

1000 servers running WindowsNT 4.0.

Allocate system storage and planning future storage requirements for the 6 databases (Development, QA

and Integrated System Testing).

Create primary database storage structures (tablespaces); create primary database objects (tables,

views, indexes).

Maintain the production database creation script for the OLTP and BATCH Processing database.

Review and maintain indexing strategies, primary key and unique key constraints as well as any database

check constraints or triggers.

Modify the database structure as necessary.

Maintain the production database schema and packages ensuring version control and version

consistency across all servers.

Enroll users and maintain system security.

Ensure compliance with Oracle License agreements.

Control and monitor user access to the database.

Monitor and optimize performance of the database.

Maintain archived data on appropriate storage devices. Contact Oracle Corporation for technical support.

Database Administrator/Software Development Engineer

Activant Solutions (formerly CCI/Triad), Livermore, CA

1997-98

Monitor, program and maintain Informix database supporting automotive aftermarket decision-support

service (DSS) for inventory forecasting per geographic area.

Write programs to tune and modify Informix database engine and accompanying Informix 4GL and

ESQL/C programs to optimize overall production environment performance.

Develop and modify application programs that support, load and scrub data for the DSS.

Train production staff on process/interface modifications.

Assist in star/snowflake logical modeling for first phase of CCI/Triad Oracle 8 Data Warehouse for Sales

Activity.

Evaluate and make recommendations for implementation of OLAP, ROLAP or MOLAP front-end tools.

Assess requirements and optimal techniques necessary for conducting regular loads of data warehouse

in Sequent S200, Informix Dynamic Server 7.2, Dynix/ptx/v4.1.3 (UNIX) client-server environment, using

Windows NT.

Computer Programmer-Analyst (Applications)

University of California Office of the President, Oakland, CA

1996-97

Develop software interface between UC databases and Internet/World Wide Web for UC's financial aid

office.

Use structured software life-cycle development and project management processes to develop programs

and scripts.

Program World Wide Web site links between web page and university databases.

Research other web sites for use with or links to UC home pages.

Program financial aid application calculators for web site.

Other projects as assigned (business/systems analysis, etc.). Use Perl/CGI, HTML, SYBASE on an AIX

UNIX platform.

Programmer-Analyst

Pinole Point Steel, Richmond, CA

1995-96

ORACLE Apps (Manufacturing), PL/SQL interface script for Oracle Manufacturing Inventory System

Tables to Paradox database along with over 20 reports in Reports 2.5. Contract.

Computer Programmer-Analyst (Applications)

Lifemark Corporation (formerly Managed Care Solutions, Inc.), Phoenix, AZ

1994-95

Develop and test client-server database applications, reporting, accounting and customer tracking

programs for health insurance companies. Interact with customers to define program and report

requirements involving assignment and maintenance of ICD-9 codes, train customer-users on programs.

Analyze requirements for extracting data. Development environment: DOS/Windows 3.X, Novell NetWare

Workstation SHELL, ORACLE 7 Server, PL/SQL 2.1, ORACLE Applications (ORACLE Reports 2.0 and

2.5, ORACLE Developer 2000, ORACLE Forms 4), CDE2, and DBMS v7.

Computer Programmer-Analyst (Applications)

University of Phoenix and Apollo Group, Inc., Phoenix, AZ

1990-92

University of Phoenix, University Services Systems. Develop, program, test and performance-tune ad hoc

and standardized reports in SQL*Plus and Pro*C in client-server environment. Confer with users within

multi-faceted university environment to define reporting program requirements. Analyze entity

relationships and data integrity within ORACLE database to determine programming approach for most

accurate and expedient means of extracting data. Prioritize user request load to most efficiently utilize

processing resources while assessing which requests are most urgent and crucial to business operations.

1992-1994.

Apollo Group, Inc. (parent company of UOP), Information Systems Department. Write programs in

Business BASIC on Data General to meet user requests to modify and enhance program code for student

tracking system for University of Phoenix's 8 campuses; notify divisions of data problems, continue

transfer process when failures occur during daily data transfers between campuses.

Computer Programmer

AmSEC LLC, Crystal City, VA

1989-90

Consulted with customer to develop programs, maintain, modify and update PC database systems using

DBASE III+ and Clipper with accompanying reports and detailed forms for Navy manpower and training;

Determined customer requirements for the Equipment Facilities Requirements database transition from

WANG 2200 to Data General MV/7800 XP in ORACLE; conducted database transference;

Designed/coded newly requested reports. Wrote user manuals, installed software and trained customers

on use of systems developed. Assigned duties and supervised work of new programmer. Maintained daily

operations on WANG 2200. Trained new employees on use of WANG and Absolute Development System

(ADS). Programmed menus and data entry screens for development of PPROMIS system funding module

using AOS COBOL. Developed, programmed in-house software tracking module for Catalog System.

Hired as Junior Programmer, promoted within 6 months.

EDUCATION

B.S., History and Political Science, 1996, Excelsior (Regent's) College, U. of the State of NY.

A.S., Liberal Studies, business minor, 1990, Excelsior (Regent's) College, University of the State of NY.

Certificate, Computer Programming, 1988, Yorketown Business Institute, College Park, MD, Honor

Graduate.

Training: Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Release 2 - 3/2011,

ORACLE Education coursework: Introduction to ORACLE; Develop Applications with SQL*Forms I and II

(V.3), 1994. Informix coursework: Monitoring & Tuning Informix Engine, 1997. Crystal Reports Level II,

2001. Oracle DBA Certification “Boot Camp” 2002.

Contact this candidate