RICK JACQUES
14512 E. 36th Street S.   Independence, MO. 64055
Work:  [Send email to request phone number] 16.1684 	Cell:  [Send email to request phone number] 16.1684

WORK EXPERIENCE
	ScriptPro Mission, Kansas
Application Systems Analyst	10/08 – Present
	SQL Server 7.0, 2000 and 2005 Administration
	Database performance
	Database Backups and Restores
	Utility development for Database Maintenance
	Hardware and Software support for ScriptPro Application

	Mediware Information SystemsLenexa, Kansas
Senior Database Engineer	02/08 – 07/08
	Manage Informix databases on AIX, HP, SUN and WINNT platforms
	Responsible for space allocation, backup strategies, table maintenance
	Physical Database Design
	Database Security
	Maintained scripts for monitoring the database thresholds and backup
success
	Responsible for replication strategies and implementation using
Informix Enterprise Replication
	Responsible for space allocation, backup strategies, table maintenance
	Physical Database Design
	Database Security
	Create jobs for backup, reorg and maintenance items etc…
	Evaluate SQL store procedures (UDRs), views, statements etc..
	Program scripts for database tools in Perl for Informix on WINNT
	Convert scripts from korn shell to Perl for Windows

	Embarq Data ManagementOverland Park, Kansas
Senior Database Engineer	03/05 – 02/08
	Manage SQLSERVER2000/2005 databases
	Responsible SQLSERVER for space allocation, backup strategies, table
maintenance 
	SQLSERVER Physical Database Design
	SQLSERVER Database Security
	Create jobs for backup, reorg and maintenance items through SQLSERVER
maintenance plans
	Implement SQLSERVER log shipping strategies 
	Implement and maintain SQLSERVER replication databases
	Data manipulation using SQLSERVER DTS,SSIS 
	Manage Informix databases on AIX, HP, SUN and WINNT platforms
	Responsible for space allocation, backup strategies, table maintenance
	Database Design
	Data Modeling using Erwin
	Data Fragmentation Strategies
	Data Normalization and De-Normalization
	Database Security
	Maintained scripts for monitoring the database thresholds and backup
success
	Responsible for replication strategies and implementation using
Informix Enterprise Replication
	24 X 7 on call production support







Sprint/IBM Data ManagementOverland Park, Kansas
Senior Database Administrator	07/98 – 03/05
	Manage Informix databases on AIX, HP, SUN and WINNT platforms
	Responsible for space allocation, backup strategies, table maintenance
	Maintained scripts for monitoring the database thresholds and backup
success
	Responsible for replication strategies and implementation using
Informix Enterprise Replication
	24 X 7 on call production support
	Managed DB2/UDB databases on AIX and WINNT platforms
	Created and maintained partitioned databases
	Data Modeling using Erwin
	Data Fragmentation Strategies
	Data Normalization and De-Normalization
	Responsible for space allocation, backup strategies, table maintenance
	Maintained scripts for monitoring the database thresholds and backup
success
	24 X 7 on call support
	Created and maintained a data management web site for DBA funtions
Developer	07/95 – 07/98
	Web / Java software development
	Developed/Converted software systems from smalltalk to web based Java
applications
	Designed back-end storage and database needs for the applications
	Development of telephone switch software on a Unix platform
	Development with C, Java, HTML, Perl, Korn Shell, SQL

Self Employed
PC Harware/Software	02/90 – 06/95
	Design and build PCs according to client needs
	Diagnose PC problems with hardware/software and repair
	Setup network card. Modems and other peripherals
	ODBC and client database connections
	Windows OS install and setup
EDUCATION

DeVry Institute of Technology  Kansas City, MO.
B.S., Computer Information Systems

Additional Training/Courses
Managing Projects; George Washington University
IBM Certified Database Associate; IBM/DB2 UDB V8.1
Microsoft SQL Server 2005 Administration; Hand On Technology
Informix Dynamic Server Enterprise Replication;; Informix
Informix Dynamic Server 7.3 New Features; Informix
Managing & Optimizing Informix Databases; Informix
Relation Database Design; Informix
Shell Programming For System Administrators; Unix Systems Administrators
Structured Query Language; Informix
Informix-ESQL/C; Informix
Software Testing Methodology; Sprint
SUMMARY
I have thirteen years experience as a Database Administrator. During the
thirteen years I’ve had training using SQLSERVER 2000/2005, Informix (Windows and
Unix) and DB2 UDB on Windows platform.  My experience is in Database Engine
administration with emphasis on high availability, disaster control,
backup/restore and performance tuning. I’ve implemented data replication using
SQLSERVER and Informix technologies.  I’m also experienced in SQLSERVER log
shipping implementations. I’m experienced in core database design using disk
layout and fragment strategies for performance. Experienced writing stored
procedures and utilities using Perl on Windows and Korn Shell on Unix platforms.