Oracle Manager

Obj***

Robert Warnock

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

Ranchos de Taos, New Mexico 87557

Phone: 575-***-****

Email: *********@*******.***

SUMMARY

Mr. Warnock brings over 25 years of experience in Information Technology. His previous

experience includes assignments as an Oracle Database Administrator for the New Mexico State

Police and as a contractor for the U.S. Department of the Interior Bureau of Indian Affairs. Most

recently as a contractor for U.S. Department of Agriculture Forest Service supporting Oracle

Content DB conversion. He has also assisted with a major conversion project from a legacy

database system to a UNIX based oracle database system. Additionally, he has taught college

coursework which include subjects such as an Introduction to Computing, SQL *using oracle*, and

an Introduction to Oracle 9i certification. His skills include SQL queries, database administration,

database ETL, technical support and maintenance.

EDUCATION AND TRAINING

BS, The University of Texas at Dallas, Texas, Computer Science, 1992

CompTIA A+ Certification (A+)

Microsoft Certified Professional (MCP)

Linux Certified Professional (LCP)

Oracle Certified Professional (OCP)

Currently training for CompTIA Security+ Certification

SECURITY CLEARANCE: Currently holds a Public Trust security clearance - HSPD12

EXPERIENCE

Glacier Technologies, 04/10 – Present, Content DB End User Support

• Contracted to the United States Department of Agriculture; Forest Service requiring a

Federal OPM Public Trust security clearance as conversion support for content DB.

• Work Tier II conversion support for Oracle content db conversion.

• Assist as elevated support for local site change requests.

• Monitor 2003 Windows servers as needed.

Chenega Federal Systems, 02/09 – 04/10, Oracle Database Administrator IV

• Contracted to the United States Department of the Interior; Bureau of Indian Affairs

requiring a Federal OPM Public Trust security clearance as an Oracle DBA.

1

Obj100

• Shared responsibility of FMIS/ITIMS production, education, and development databases

on disparate networks.

• Apply patch sets to binaries/databases.

• Clone/Create/Delete/Replication of db’s as needed.

• Support helpdesk and assist with troubleshooting issues.

• Monitor trace/alert logs/disk space/process memory.

State of New Mexico, Dept. of Public Safety State Police, 01/07 – 02/09, Oracle DBA

• Maintain Oracle binaries and several mission critical databases for production,

development, and test environments.

• Upgrade 9i databases -> 10gR2.

• Apply patch sets to binaries/databases.

• Oracle Export/Import, netcfg, dbca, OEM, Grid Manager, Metalink.

• Create/Delete db’s as needed.

• Monitor trace/alert logs/disk space/process memory.

• Manage Backup/Recovery of databases.

• Work with Primary/Secondary database configuration in order to apply high availability

(Data Guard)

• Support Application Team for testing/production testing and implementation.

• Responsible for 24x7x365 databases; NMLETS (Messaging), CJIS (Criminal

Information), PUBINFO (Missing persons & Sex offender), CCW (Conceal & Carry),

DPS (Accidents/Activity), FA (Fleet Maintenance), RESP (Responses), REPOS

(Developer Repository -ERDs).

• Responsible for corresponding development and test databases.

• Install, configure and maintain Oracle Grid Control Manager and Agents using Secure

Communication.

• Work with Oracle sales and support for license questions and resolve issues.

• Assist with Application Server issues.

ACT, 07/06 – 11/06, Lead IT

• Maintain IT requirements for call center. Computer servers (Windows 2000/2003) and

client (agent) computers (Windows 2000). Reconfigure project floor as needed.

• Insure computer and telephone systems are operational and available 24x7x365. Clients

include Bank of America, MBNA, and others.

University of New Mexico –Taos, 06/06 – 12/06, College Instructor

• Teach coursework; CT102 Introduction to Microcomputers, Summer/Fall semesters.

Northern New Mexico College, 08/03 – 05/06, College Instructor

• Teach coursework; CS102 Computer Literacy, CS105 Introduction to Databases (using

Access), CS210 Database Design and Programming (using Oracle), and ECET230

2

Obj100

Microelectronics II with lab (A+ software/networking topics). A topics series of 1 CR

courses include Oracle SQL Intro, Intermediate, and Advanced.

• Set up Linux / Oracle 9i database server for new courses to be offered beginning

December ‘03. DBA topics using Oracle.

Northern New Mexico College, 03/04 – 07/06, Oracle DBA

• Work with new HP9000 UNIX Server, 3 application web servers and user support for

SCT/Banner implementation.

• Clone the pre-production database to create the production database; configure the

INB/SSB servers to function with the new production database.

• Install, configure, and prepare Windows 2000 Server Operating systems for the

application servers, Internet Native Banner INB and Self Service Banner SSB, supporting

the 3 Tier SCT Oracle Banner project. Install and configure the Brio reporting server for

the SCT Oracle Banner project. Coordinate efforts with SCT to install the Oracle

Application server (web-server) software; Oracle patches and software for remote access

– Terminal Services and VNC.

• Convert Legacy data to the SCT Banner the Finance module; Load the Chart of Accounts

and related Oracle database tables. Support the Finance area with issues regarding

Purchasing, Accounts Payables, and core Finance areas. Conversion of Student related

tables; person data and currently working with Academic History conversion.

• Work with key staff members for the successful cutover of Banner Finance, Financial

Aid, Registrar, and Payroll.

• Assist technical staff/end users with the SCT Banner product; security, roles, processes,

backups, and processes.

3

Contact this candidate