Administrator Data
Resume:
PROFESSIONAL EXPERIENCE
Senior/Professional Database Administrator
IBM/COMPUTER SCIENCES CORPORATION
. LEAD DBA FOR CHRYSLER AND TOYOTA ACCOUNTS
. DATABASE SUPPORT FOR TOYOTA MOTORS IN TORRENCE, CA AND CHRYSLER MOTORS
IN TENNESSEE
. PLATFORMS ADMINISTRATED INCLUDE SQL SERVER 2000/2003/2005/2008 R2 AND
2012, MYSQL 5.X, NDB_CLUSTER,
. MAIN DUTIES INCLUDE INSTANCE CREATION DATABASE SECURITY, PERFORMANCE
TUNING, DISASTER RECOVERY SCHEMAS, QUALITY CHECKS OF EXISTING DATABASE
INSTALLATIONS, PUSHING CODE AND DATA BETWEEN ENVIRONMENTS.
. SUPPORTS APPLICATION AND OPERATIONAL TEAMS ON DATABASE DESIGN AND
HARDWARE CONFIGURATION.
. DEVELOPS AND SOLVES SPECIALIZED SOLUTION TO DATA MIGRATION, SYSTEM
CONFIGURATION, DATABASE AND OS CONFIGURATION
. AUTHORS DOCUMENTS ON NEW PROCEDURES AND POLICIES
. PRIMARY SUPPORT FOR DB2/ORACLE/SQL SERVER BASED TICKETING, BACKUP
REPORTS AND DATA MIGRATION.
. MENTORS NEW STAFF ON DATABASE AND APPLICATION TEAMS ON PROCEDURES AND
POLICIES AND HOW TO BEST IMPLEMENT SOLUTIONS
. PRIMARY INTERFACE WITH APPLICATION, MANAGEMENT AND QUALITY TEAMS
THROUGHOUT BOTH ORGANIZATIONS.
Revenue Solutions Inc. November 2012-March 2013
Alexandria, VA
Conversion Consultant
Responsible for determining data to be transferred from legacy to new
Oracle based Data Warehouse environment for NCDOR.
. Used Oracle 11i w/ SQL Loader and SQL*Plus for code development.
. ETL Process Coordinator
. Data Quality Auditor
. PL/SQL debugger and coder for stored procedures, triggers and
functions.
. Developed new processes for ETL from legacy to new systems
. Mentored new hires on process and coding.
DBA / Developer July 2012 - September 2012
Listingbook - Greensboro, NC
. SQL Server 2008 R2 DBA/ Developer
. Managed data sharing between different environments
. Managed software lifecycle for new deployments of MLS areas
. Writes queries in T-SQL to support the adding of new MLS listings.
. Uses GIS to install new search areas for upcoming MLS areas
. Responsible for promoting new MLS area data from Development to QA to
Production Environments.
. Troubleshooting stored procedures, triggers, and functions in real
estate listing databases
. Member of conversion team implementing new MLS's
. Systems Administrator for to MS Server 2008 R2 SSMS, SSRS and SSIS
Database Administrator March 2011 - June 2012
RGI Informatics - Cornwallville, NY
. Sr. MySQL DBA
. Configures MySQL databases for use by training, QA, and end-users.
. Installs configures and connects MySQL databases onto Mac, CentOS
and Windows environments.
. Performs Performance Tuning of SQL Queries and Severson MySQL 5.1.x
Advanced Server
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company
standards.
. Architected new database model implementations and built
applications according to client requirements
. Establishes Policies and Documentation for Surround SCM Software
Repository Mac OS X servers including RAID configuration and disk
swap-outs.
. Supported new feature implementations according to SLDC company
guidelines
. Supported QA, Development and Implementation Departments with
database analysis, modelling and building as well as administration
and security.
. Installs and Configures Mac OS X Server versions 10.6 and 10.7 on
pre-approved hardware
. Configures MacBookPro and Windows 7 and Vista laptops for VPN
connectivity.
. Configuration and Troubleshooting of Apache Server Installations
. Installation of Software critical to VA effort to electronically
store medically relevant data, including STATA, and various Darwin
dependancies and applications to allow connectivity to a variety of
databases, including SQL Server and Oracle.
. Configures virtualization for DR purposes using VirtualBox, VMWare
and Parallels.
. Holds Public Trust Clearance with Veterans Administration.
Database Administrator August 2010 - March 2011
Research Triangle Institute - Raleigh, NC
. Responsible for continual operation of all SQL Server 2000/2005/2008
R2, MySQL 5.x and Oracle 10g instances and databases in many
environments, including DoD/DHS security compliant data.
. Supported QA, Development and Implementation Departments with database
analysis, modelling and building as well as administration and security.
. System Administrator for Windows Server 2003 and SQL Server
200/2005/2008 R2
. Managed data sharing between different environments and coordinated
new database schema and specialized database platform services
. Leader of team to automate database creation for customers.
. Leader of evaluation team for various monitoring software and
schemas, such as Quest and Zenoss.
. Performance tuning of databases.
. Troubleshooting of SSIS and DTS legacy packages.
. Performing Ad-Hoc SQL queries for customers.
. Various database related application configuration and tuning.
Chief Technology Consultant July 2010 - January 2014
Pb2Au - New York, NY
. Main technology advisor for startup Intellectual IP consulting firm
. Responsible for all aspects of technology consultation for novel and
patentable hardware and software inventions.
. Chief Data Architect for CRM and web based applications
. Supported database and IT technological development projects company-
wide
. Designed, implemented and maintained back-end database instances
needed for novel and open-source application packages
. MySQL database design based on PHP form data collection.
. Web design and modification using CSS, Dreamweaver, Flash and PHP.
. PostgreSQL database design and implementation for project related to
onset of age related disease diagnosis.
. CentOS, Apache, MySQL 5.2 installation and administration for
corporate web presence.
Systems Administrator January 2010 - June 2010
College Foundation, Inc. - Raleigh, NC
. Primarily Responsibility for SQL Server 2000, 2005 and 2008 R2
instances in Production, QA, Testing and Staging Environments.
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company standards.
. Architected new database model implementations and built applications
according to client requirements
. Primary support for QA and contract programmers in a .NET based
environment.
. Performing Ad-Hoc SQL queries for customers.
. Database Instance Creation in all environments
. Database Security for users, groups and objects on SQL 200/2005/2008
R2
. Database Backup using IBM Tivoli Storage Manager command line
inputs.
. Database Tuning using Microsoft tools to optimize both database
engine and query performance.
. IIS Administration of external and internal websites, including
building, deployment of new code, troubleshooting and maintenance.
. Database Architecture duties, including diagramming in Visio,
Reverse Engineering, comparisons, using RedGate software tools,
between various environments and normalizing data.
. Importing large batches of data to various environments from text,
Excel and Access and other database sources.
IT Support Analyst August 2009 -January, 2012
Bowlin Enterprises
. Hardware Troubleshooting and upgrading
. Application Troubleshooting and configuration
. Web page design and troubleshooting.
. Staff support and training.
. Remote support of all IT related issues.
. Advisement of hardware and software purchasing and configuration.
. Network Administration and Troubleshooting
. Report template generation.
. Database retrieval using SQL queries
Database Analyst December 2008 - May 2009
Ateb, Inc / DISYS, Inc - Raleigh, NC
. 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.
. Experience developing strategic solutions to complex business
problems involving translation and mining of data from production
to statistics departments.
. Design of database tables, file structure, DDL and DML packages.
. Architecting of newly deployed database and data warehouse components
for statistical analysis.
. Assisting Statistical and Clinical programmers with analysis of
requested data.
. Writing Ad-Hoc 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.
Oracle DBA September 2008 - December 2008
Autonomic Resources - Cary, NC
. Oracle 9i and 10g DBA responsible for account creation, security,
tuning, database cloning, and environment refreshes.
. Led business analysis and business development inititibes
. Administrator of Jasper Server and iReports generation.
. Participated on on-call rotation.
. Database Monitoring of all Oracle instances.
. Oracle Application set-up Oracle Applications Administrator on Solaris
9, 10 and AIX.
. System Administrator on Solaris 9, 10 and AIX.
. Optimized database implementation on SAN using various RAID schema
Database Administrator April 2008 - June 2009
LimeLeap Solutions - Washington, DC
. Database Administrator: SQL Server 2000/2005
. System Administrator: Windows 2000/2003
. Remote Position
. System, Database and application architect for hosted company OLTP and
reporting instances.
. Instance Installation and Configuration for Accepting Corporate Data.
. Database Engine, Instance, Database and Table Creation
. Designing of database tables, indexes, stored procedures and triggers.
. Database Backup, Restore, Disaster Recovery and Testing System and
Performance Monitoring
. Database and Windows Server 2000 and 2003 Parameter Tuning
. SQL Query Tuning
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company standards.
. DTS Package Troubleshooting
. Hardware and Software Evaluation and Recommendations to Development
Director
. Root Cause Analysis for Interruptions in Production Environment
. Database Server and File Auditing
. Security Auditing, Recommendation and implementation
. System planning for optimization of performance
Senior Database Administrator August 2007 - September 2008
Peopleclick Inc - Raleigh, NC
. 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.
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company standards.
. Database architect, implementer and policy establishment and
documentation for new software inititatives
. Performance tuning for SQL Server and MySQL instances and databases
. Database Replication, Mirroring and Log Shipping.
. Designing customized table structure in MySQL for Sugar CRM deployment
and then porting structures and data to SQL Server 2005 instances and
databases
. 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 Production Environments.
. Hardware configuration Consultant. Windows Cluster Administration.
Database Scripting.
. ETL Development and Deployment.
. DTS and SSIS Package Troubleshooting
. Security Auditing, Recommendation and implementation
. Optimized database implementation on SAN using various RAID schema
Database Systems Administrator January 2005 - August 2007
CarQuest Inc. - Raleigh, NC
. 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
. Instance Installation and Configuration of Database Engine
. Database and Table Creation, Upgrading and Maintenance
. Database Backup, Restore administrator
. Database platform performance tuning.
. Network, User, and Server Security Administrator
. Database Replication, Mirroring and Log Shipping
. Participating in on-call rotation in 24x7 Network Operations Data
Center
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company standards
. Replication setup, monitoring and administration
. Database architect, implementer and policy establishment and
documentation for new software initiatives
. Root Cause Analysis for Interruptions in Production Environments
. Windows, Solaris, and AIX OS Cluster Administration
. Database Server and File Auditing
. Custom database and instance design of MySQL and DB2
. BASH, Perl, and PHP Scripting Web Server Administration
. Optimized database implementation on SAN using various RAID schema
Systems Analyst October 2003 - January 2005
Becton Dickinson Technologies
. 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
. Network Administrator: Mixed Windows, Mac environment
. Duties
. Database Engine, Instance, Database and Table, DML and DDL custom
Creation from collected design criterion Database Backup, Restore,
Disaster Recovery and Testing.
. System and Performance Monitoring.
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company standards
. Replication setup, monitoring and administration
. Database architect, implementer and policy establishment and
documentation for new software initiatives
. Supported new feature implementations according to SLDC company
guidelines
. Supported QA, Development and Implementation Departments with database
analysis, modelling and building as well as administration and security.
. 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
Database Systems Administrator October 2000 - October 2003
StemCo Biomedical, Inc. - Durham, NC
. 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
. Business analysts for specialized software initiatives
. Managed data sharing between different environments
. Established hardware, software and database modelling, sharing and
handling and documented all procedures according to company standards
. Replication setup, monitoring and administration
. Database architect, implementer and policy establishment and
documentation for new software initiatives
. Supported new feature implementations according to SLDC company
guidelines
. Supported QA, Development and Implementation Departments with database
analysis, modelling and building as well as administration and security.
. Participated in planning, development, and 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
IT LAN Administrator / Access August 1999 - October 2000
Duke University Medical Center - Durham, NC
. 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, including table structure field optimization and design
from criterion,
. 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.
MySQL DBA December 1997 - August 1999
University of North Carolina Chapel Hill
. 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.
. Designed table, index, stored procedure and trigger structures for
customized data storage.
IT Administrator January 1997 - December 1997
Astra Arcus AB - Sodertalje, Sweden
. 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.
Network Engineer December 1992 - January 1997
Duke University Medical Center - Durham, NC
. 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
EDUCATION
NORTH CAROLINA CENTRAL UNIVERSITY, Durham, N.C.
B.Sc. in Mathematics (Magna Cum Laude)
Concentration in Computer Science.
TRAINING
. Data Analysis using Programming Statistical (R statistical software),
online, Coursea.org
. MATHEMATICAL METHODS FOR DATA ANALYSIS (MATLAB SOFTWARE), ONLINE
COURSEA.ORG
FOR SQL SERVER 2012, ONLINE COURSE THROUGH CSC
. JASPERSOFT BI SUITE, JASPERSOFT, SAN FRANCISCO, CA
. MICROSOFT CLUSTER TRAINING, PEOPLECLICK, RALEIGH, NC
. ORACLE DA I AND II, WAKE TECH, CARY, NC
. ORACLE 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.
Current Webmaster for the following sites:
PB2AU.COM
SERENITYEXPRESSIONS.COM
COMFORTPARADIGM.COM
GEORGEPOWELL.NET
DANNY.MYSTITECH.COM
MEMBER OF THE BOARD OF DIRECTORS OF THE NETWORK OF TRIANGLE ASTROLOGERS
Contact this candidate