Joseph Sheppard

*** ****** **

Lincoln, Arkansas 72744

479-***-****

abhv6p@r.postjobfree.com

Objective

Seeking a database administration position that allows me

to focus on providing a stable database backend. I would

like to keep current of, and leverage, the new

functionality that is continually added to the latest

versions of RDMS management software. My seven years of

database programming and administration experience has been

focused on MS-SQL Server. I have also developed for and

administered mySql instances, and have developed for

Oracle. I have architected several solutions for my

employers that have stood the test of time. I enjoy

writing reports, and am very experienced in Crystal

Reports. My vision in architecture is toward scalability.

My greatest asset may be my adaptability: I am equally

comfortable writing web services, developing databases, or

scripting within the proprietary languages of our

third-party systems.

I am a great team player, and have a like-able, pleasant

personality. I am experienced in analyzing business needs,

designing a solution, and then implementing the finished

product. I have several high-availability, heavily-used

applications in production that have great track records of

low maintenance, which speaks of excellent scalability,

given our approximately 40% growth in new locations. I

have achieved both A+ and MCSE certification, with

electives in MS-SQL Server.

Work Experience

Database Administrator/Programmer-Analyst

May 2004 - Present: America's CAR-MART, Bentonville, AR

Description: Manage over 100 MS-SQL databases, and the

consolidated warehouse. Developing software solutions for

the Operations and Executive staff. This position answers

directly to the IT Director, and to the President of the

company.

Responsibilities:

Manage 93 remote MS-SQL databases, including monitoring and

maintaining hourly backups, merge replication on 15 minute

intervals, and a custom data warehouse

Implement database restores on remote servers

Implement and maintain backup jobs on five corporate

servers, including a mySql backend for our VOIP phone

system

Administrator of our Crystal Reports Server.

Administrator of our document imaging solution (scans from

remote locations into Ascent Capture server, ICR-ed using

Paradatec software, storage back-end by Fortis on MS-SQL).

Develop VB.Net backend web services to support the data

needs of our front-end solutions

Manage coordination with third party developers on custom

solutions, including scope, milestones, and final

deliverables

Troubleshooting reported problems with most of the

Company's systems

Maintain SOX compliance via Software Development Lifecycle

documentation, Change Requests, and user audits.

Crystal Reports report design.

Manage application rollouts, including scripting demands

Manage our help desk technician

Accomplishments:

Implemented replication between a central server and our

remote servers across nine states. This allowed for

centralized backups, eliminating the nightly task from the

field offices. Developed packages to support this

infrastructure, including hourly differential backups, and

scripting support to distribute schema upgrades

Developed our custom data Warehouse via a combination of

procedures and DTS packages to populate the data nightly,

to allow for reporting and data availability to secondary

applications.

Design and implementation of our Crystal Reports server.

"Ported" dozens of HTML reports into Crystal. Developed

Crystal Reports User-Defined Functions to support functions

on the reports. Developed a system of time frame

parameters and procedures to allow end users to schedule

recurring reports with the default Crystal Reports Server

front end, eliminating the need for a custom front end

Developed a remote printing solution that consists of a

Windows service and a client application, which allows our

AP clerks to print directly to MICR printers at our

locations in the field.

Eliminated hundreds of daily email-based check requests

with a three-tier web application that records requests,

displays them for the AP personnel, allows an approve or

deny code with textual communication back to the field

office, and includes a daily export/import for our

accounting software. This immediately freed up two full

time AP positions, and helped with the goal of adding new

locations without adding more AP clerks. This system also

records deposits, and has a full-featured checkbook

interface which has eliminated the need to install thick

client accounting software at the remote locations.

Wrote the financial Payment Scheduling class of our

proprietary underwriting software, which accepts Weekly,

Bi-Weekly, Semi-Monthly, and Monthly payment terms,

calculates interest, and produces complete payment

schedules. This class is used by three or four other

applications outside of the thick client application to

ensure that scheduling and payment collection is consistent

throughout the organization.

Programmer

August 2002 - May 2004: Arkansas.Net, Fayetteville, AR

Description: Continued development and maintenance of

companies' custom Account Management System. Responsible

for writing any back-end database support for the web

department.

Accomplishments:

Personally developed the connectivity software we send to

all of our customers, saving the company the per-unit

licensing of third-party software. Monitors the connection

time for a given username, and alters this username

slightly to take advantage of the lowest possible rate from

our wholesale port providers. This package works across

five Windows platforms, from Win95 to XP, including ME and

NT4.0. It remained viable and in production for five

years.

To allow hosting services to the many real estate offices

in Northwest Arkansas, I implemented an SQL backend which

utilized the MLS (Multi-Listing Service) provided by a

company in Boston. This system used SOAP to provide

searching methods for our various websites. This system

synchronized four times daily, from a MS-SQL database, to a

mySQL database.

To enable our "No Spam" guarantee, I wrote the high speed C

program that parsed all email to search for headers which

identified the email as spam by our third part application,

and added a few other custom headers to allow our email

delivery system to determine its destination. To ensure

that no email from our 25,000 customers would cause a

malfunction of this command line tool, I had to decipher

and implement RFC 2822, which defines the syntax for valid

email messages.

Field Technician

Jan 2001 - Aug 2002 Arkansas.Net, Fayetteville, AR

Primary responsibility is to troubleshoot and maintain our

30 nodes in Arkansas, remotely if possible. Initiate

repairs with SWB, ASI, or local telcos. Equipment includes

Cisco routers and Ascend/Lucent MAXes. Install and

troubleshoot DSL customer's issues. Responsible for

maintaining Customer Service department's network.

Implemented a Windows NT domain with roaming profiles for

the CSRs. Responsible for establishing a fault-tolerant

backup system for our Accounting server.

Education

University of Arkansas, Fayetteville, AR

Some College Coursework Completed

Majored in Computer Systems Engineering. Completed about

60 hours toward this degree.

2002 Staffmark, Fayetteville, AR

Certification

Microsoft Certified Network Engineer (Electives: SQL

Administration (96% grade); SQL Design and Implementation

(87% grade))

2000 Staffmark, Fayetteville, AR

Certification

Comp/TIA A+ Certification

Skills

MS-SQL 2008R2: Transactional Replication; Merge Replication

with Manual Identity Range Management (Even/Odd

Identities); Log Shipping; SSIS

MS-SQL 2000: DTS design; Stored Procedures; Debugging;

Merge Replication; Differential Backup strategies;

mySql: Stored Procedures; Backups; Restores

Crystal Reports Server

Visual Basic.Net (Moderate Experience; Brainbench test:

3.59 "Master")

C (Moderate)

Perforce CVS

Visual Basic 6 (Advanced)

Qualified Fortis Administrator (Document Management

solution)

Perl - Object Oriented (Moderate)

Javascript (Moderate)

Crystal Reports (Advanced Experience; Brainbench: 3.54

"Master")

MS-SQL Server (Moderate)

mySQL (Moderate)

Java (Light)

Contact this candidate