Alan Fisher
Holly Springs, North Carolina 27540
*******@*****.***
Objective: I wish to obtain a position in database administration that would allow the application of my knowledge to support interesting and challenging projects.
Experience
Peopleclick, Inc, Raleigh, NC
August 2007-present
Senior Database Administrator
Database Administrator: MySQL 4.1.x - 5.0.x, SQL Server 2000/2005
System Administrator: Red Hat Linux, Windows 2000/XP/2003, Apache 2.x, php 5
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
Participating in on-call rotation in 24x7 Network Operations Data Center
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
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
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
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
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
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
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