Alan Fisher
125 Fairford Drive
Holly Springs, North Carolina 27540 
[Send email using form at bottom] 
  [Send email to request phone number] 01-9265 
  
  
Objective: I wish to obtain a position in database administration and analysis
that would allow the application of my knowledge to support interesting and
challenging projects. 

Experience 

Ateb, Inc/DISYS, Inc, Raleigh, NC
December 2008- present
Database Analyst

Contract Position
Troubleshooting PostgreSQL database issues related to performance, connectivity
and content
Providing advice to System Administration team for optimal storage of company
data and PostgreSQL administration and configuration.
Assisting Statistical and Clinical programmers with analysis of requested data
Writing SQL queries to retrieve requested data from IVR, OutBound Calling and
reports databases.
Writing R code to query databases, retrieve and package data for statistical
analysis
Troubleshooting SPSS, R, and SQL queries 
Authoring iReports for internal business customers, and submitting to web
administration application for scheduling
Troubleshooting iReports for functionality
Reverse Engineering of existing database structures.
Establishing offline databases for reporting purposes.

DBA Tools: PGExplorer, phpmyadmin, PGAdmin III, Squirrel, Toad for PostgreSQL,
ModelRight
Reporting Tools: iReports, JasperReports, JasperServer
Statistical Software: R, SPSS

LimeLeap Solutions, Washington, DC
April, 2008 – present
Database Administration Consultant

Database Administrator: SQL Server 2000/2005
System Administrator: Windows 2000/2003

Remote Position
Instance Installation and Configuration for Accepting Corporate Data
Database Engine, Instance, Database and Table Creation, Upgrading and
Maintenance 
Database Backup, Restore, Disaster Recovery and Testing 
System and Performance Monitoring 
Database Parameter Tuning 
SQL Query Tuning 
Preparing Reports on OS, Hardware, Database, Table for Submission to Upper
Management 
DTS Package Troubleshooting
Hardware and Software Evaluation and Recommendations to Development Director
Root Cause Analysis for Interruptions in Productions Environment
Database Server and File Auditing


DBA Tools: Enterprise Manager,  Veritas NetBackup and Agents, SQL Server
Management Console, Surface Area Configuration, SQL Spy, SQL Server Integration
Services, SQL Server Profiler, Microsoft Office 2003/2007 Office Professional
Suites, Query Analyzer,  osql


Peopleclick, Inc, Raleigh, NC
August 2007-September 2008
Senior Database Administrator

Database Administrator: MySQL 4.1.x - 5.0.x, SQL Server 2000/2005, Oracle 11g
System Administrator: Red Hat Linux, Windows 2000/XP/2003,Vista, Apache  2.x,
php 5 , Nagios

Duties 
Instance Installation and Configuration for Accepting Corporate Data
Database Engine, Instance, Database and Table Creation, Upgrading and
Maintenance 
Database Backup, Restore, Disaster Recovery and Testing 
System and Performance Monitoring 
Database Parameter Tuning 
SQL Query Tuning 
Database Replication, Mirroring and Log Shipping 
Preparing Reports on OS, Hardware, Database, Table for Submission to Upper
Management 
Lead DBA Support for Data Warehousing  Operations
OLAP Cube Troubleshooting, Construction and Configuration
Participating in on-call rotation in 24x7 Network Operations Data Center 
Root Cause Analysis for Interruptions in Productions Environment
Hardware configuration Consultant
Windows Cluster Administration
Database Scripting
ETL Development and Deployment
Database Server and File Auditing
Web Server Administration
DTS Package Troubleshoting

  
DBA Tools: Toad, MySQL Administrator, Query Builder, Enterprise Monitor, Nagios,
, Spotlight for SQL Server,  and MySQL,  Enterprise Manager,  Veritas NetBackup
and Agents, mysqldump, SQL Server Management Console, Surface Area Configuration,
SQL Spy, SQL Server Integration Services, SQL Server Profiler, Microsoft Office
2003/2007 Office Professional Suites, Query Analyzer, HADR/HACMP, Oracle RAC,
osql, Zenoss, Apache


GPI/CarQuest Inc., Raleigh, North Carolina 
January 2005-August, 2007
Database System Administrator 
Database Administrator: MySQL 4.1.x - 5.0.x, SQL Server 2000/2005 , DB2 UDB
v8.x, PostreSQL 7.x , Oracle 9i, 10g
System Administrator: Red Hat Linux, AIX, Sun Solaris 9/10, Windows
2000/XP/2003, Apache 1.x, 2.x 
  
Duties 
Instance Installation and Configuration for Accepting Corporate Data
Database Engine, Instance, Database and Table Creation, Upgrading and
Maintenance 
Database Backup, Restore, Disaster Recovery and Testing 
System and Performance Monitoring 
Database Parameter Tuning 
SQL Query Tuning 
Network, User, and Server Security 
Database Replication, Mirroring and Log Shipping 
Preparing Reports on OS, Hardware, Database, Table for Submission to Upper
Management 
Participating in on-call rotation in 24x7 Network Operations Data Center 
Replication setup, monitoring and administration
Root Cause Analysis for Interruptions in Productions Environment
Windows, Solaris, and AIX Cluster Administration
Database Server and File Auditing
BASH, Perl, and PHP Scripting
Web Server Administration
  
Tools 
DBA: Toad, MySQL Administrator, Query Builder, Enterprise Monitor, Nagios,
Snort, SnortIDS, Ethereal, Splunk, Spotlight for SQL Server,  and MySQL, 
Enterprise Manager, DB2 Control Center, InnoDB Hot Backup, Veritas NetBackup and
Agents, mysqldump, SQL Server Management Console, Surface Area Configuration, SQL
Spy, SQL Server Integration Services, SQL Server Profiler, Microsoft Office
2003/2007 Office Professional Suites , DB2 DAS, DBDBCC, osql, Zenoss, Apache
  
  
Becton Dickinson Technologies, Research Triangle Park, NC 
October, 2003 - January, 2005   
System Analyst 
Database Administrator: MySQL 4.1.x - 5.0.x, PostreSQL 7.x, Sybase 
System Administrator: Mac OS X, Mac OS X Server, Mac SAN, Windows 2000, 2003,
Apache 2 
Duties 
Database Engine, Instance, Database and Table Creation, Upgrading and
Maintenance Database Backup, Restore, Disaster Recovery and Testing 
System and Performance Monitoring 
Creating php Interfaces to Access Antibody and Instrument Generated Data 
Analyzing Present and Future Needs and Preparing Reports and Presentations for
Capitol Purchases 
Network, User, and Server Security 
Interfacing with Scientific Investigators to Determine Hardware and Software
Needs 
Scientific Data Archiving and Storage 
Consulted with Bio-informatics Department on Software Development Projects 
Root Cause Analysis for Interruptions in Productions Environment
Database and Table Development 
Data Normalization and Modeling
ETL Development and Deployment
Perl,  BASH, and PHP Scripting


Tools 
MySQL Administrator, phppgadmin, phpmyadmin, Query Builder, Enterprise Monitor,
Nagios, Snort, SnortIDS, Splunk, mysqldump,  R/S Plus, php4/5, Retrospect, MS
Office 2003, CellQuest 
  
  
StemCo Biomedical, Inc. Durham, NC 
October 2000 - October 2003 
Database System Administrator 
Database Administrator: SQL Server SBS 2000, Access 
System Administrator: Mac OS 9/X, Windows 2000/XP/2003 
Network Administrator: Mixed Windows, Mac environment
Duties 
Consulted with External Vendors on Software Development Projects
Configured routers to allow FTP, VPN, and RADIUS access to servers
Access DBA for patient and sample data.
Authored and implemented security policy for Network, UNIX, Mac, and Windows
Servers and Desktops
Responsible for Backup of Scientific and business data using VERITAS and
Retrospect Suites
Participated in planning, development, design and testing of bio-informatics
software.
Planned, designed Ethernet network and handled contracting for implementation.
Prepared and presented business analysis studies for purchasing major equipment
upgrades.
Primary IT support for Windows 2000, XP, Mac OS 9, and UNIX
  
Duke University Medical Center Durham, NC
IT LAN Administrator/Access Consultant, 8/1999 - 10/2000
• Windows 98, NT, 2000, Mac OS 9 system administrator.
• Responsible for storage and backup of clinical research data on networked
computers.
• Designed and implemented Access 2000 database for clinical trials patient
data.
• Operated image facility using Spot and Adobe Photoshop for acquisition and
analysis of fluorescent image data.
• Acquired, analyzed and warehoused flow cytometry data using CellQuest and
VERITAS DVD systems.
• Administrated data backup for scientific and clinical data.
• Group IT support for Windows 2000, 2003, Office, UNIX and Mac OS 9.


University of North Carolina Chapel Hill,NC
LAN Administrator/MS SQL Server DBA, 12/1997 - 8/1999
• DBA for the Liver Stem Cell Biology group.
• Purchasing, installing, upgrading troubleshooting and configuring PC and
Macintosh machines.
• LAN administrator on Windows NT and Mac OS 9 network.
• Acquired, warehoused, and statistically analyzed flow cytometry data using
Summit, Cyclops CellQuest front-end software with Sybase and MS SQL 7 back-end
database servers.
• Acquired, warehoused and analyzed image data using Leica TCS and Adobe
Photoshop software.

Astra Arcus AB Sodertalje,Sweden
IT Administrator, 1/1997 - 12/1997
• Manager of the flow cytometry facility for Astra Arcus AB.
• Involved in purchasing, configuration and installation of PC and Macintosh
machines on corporate network and instructing others on usage.
• Information Systems/Information Technology Administrator and member of the
corporate IS/IT committee.
• Webmaster for the Neuroimmunology section.
• Main contact for editing internal and external reports for English grammar and
content.

Duke University Medical Center Durham, NC
Network Engineer II, 12/1992 - 1/1997
• Responsible for maintaining, acquisition, storage and archiving of flow
cytometry data generated by facility instruments.
• Network Administrator for a mixed PC, Mac, and UNIX network environment.
• Responsible for computer installation, configuration, troubleshooting and
repair.
• Evaluated new technologies for use in facility operations.
• NAS storage administration for UNIX based system.
• Developed billing and maintenance tracking system using Excel

Air Quality Research Triangle Park, NC
Product Manager, 8/1991 - 12/1992
• Director of marketing and sales for formaldehyde and toluene passive
dosimeters.
• General Manager of all operational functions, which included production,
sample analysis, quality control, customer relations and technical support.
  
  
  
Education

NORTH CAROLINA CENTRAL UNIVERSITY, Durham, N.C. B.Sc. in Mathematics (Magna Cum
Laude) with a minor in German and a concentration in Computer Science. Member of
Alpha Kappa Mu academic honor society.
  
Additional Training 
Jaspersoft BI Suite, Jaspersoft , San Francisco, CA
Microsoft Cluster Training, Peopleclick, Raleigh, NC
Oracle DBA I and II, Wake Tech, Cary, NC
Orale PL/SQL, Wake Tech, Cary, NC
DB2 Administration for Experts, Jack Morton, Durham, NC
Writing Queries Using TSQL, New Horizons, Morrisville, NC
Maintaining A SQL Server 2005 Database, New Horizons, Morrisville, NC
DB2 Administration for UNIX, Jack Morton, Durham, NC
SQL Server 2000 Administration, Global Knowledge, Cary, N.C.
MySQL Database Performance and Tuning, MySQL AB, Raleigh, NC 
CISSP Prep Course, New Horizons, Morrisville, N.C.
Perl Level I&II, North Carolina State University
Network Security II, Global Knowledge, Cary, N.C.
Network Security I, Global Knowledge, Cary, N.C.
XML Level1, North Carolina State University
PHP/MySQL, North Carolina State University
R/S Plus, BD Technologies, RTP, N.C.
CLARA Robotics Management Software Training, Caliper, Braintree, MA
MS SQL 2000 Administration, DBBasics, Raleigh, N.C.
MS Project, Productivity Point, Morrisville, N.C.
Access 2000 / Beginning, Intermediate, Advanced, New Horizons, Durham, N.C.
Oracle SQL*Plus and PL/SQL, North Carolina State University, Raleigh, N.C..

Society Memberships
InfraGard