Sql Server Manager

Mark A. Phipps

**** ******** *** *** . ******, GA 30519 . 678-***-****

E-mail:********@*******.***

Summary

Successful results-oriented Senior Database Administrator / Database

Manager, with more than 15 years experience leading people and project

teams in designing and implementing systems with positive impact to the

company's budget and timeline. Knowledgeable in all areas of System

Development Life Cycle for mission critical systems, from project

requirements to post implementation.

Professional Skills

Database Version/Hardware

Oracle Database Servers: 9i, Sun Servers: E6800, E25K, X4600

10g, 11i (4+ yrs) (6+ yrs)

Informix Dynamic Servers: 7.x, HP Servers: rp7400, N-Class

9.x (8+ yrs) Servers (3+ yrs)

SQL Enterprise Servers: 2000, IBM Servers: 3090, RISC 6000

2005 (9+ yrs) (8+ yrs)

Storage: EMC, StorageTech, O/S: Solaris 2.x, HP-UX 11.x, AIX,

Hitachi (6+ yrs) NT 2000, 2003

Database/Technical Expertise

Oracle Enterprise Manager (OEM) Project Management

(6+ years) (4+ years )

SQL Server Data Data Warehouse Design &

Replication/Mirroring (2+ Implementation (8+ yrs)

years)

SQL Server Integration Services Performance Monitoring and Tuning

(SSIS) (2+ years) (8+ years)

RMAN Backup and Recovery Business and Technical

(4+ years) Reengineering (5+ years)

Applications

ER*Win 7.3 SAS 9.x

(8+ years) (2+ years)

BAAN IV Informatica 8.5

(2+ years) (4+ years)

PeopleSoft HRMS 8.x COGNOS, BrioQuery

(4+ years) (5+ years)

Apache, WebLogic 8.x Rational Suite-Clear Case, Clear

(5+ years) Quest (7+ years)

Development Experience

SQL*Plus, SQL*Loader, PL*SQL COBOL II, CICS, DB2

(5+ years) (10+ years)

HTML, XML, HL7 v2.5 Bourne, Korn, Bash Shells

(3+ years) (7+ years)

SQL Developer, TOAD, EXCEED PERL, AWK, SED

(5+ years) (7+ years)

Experience

Science Applications International Corporation - Atlanta, GA

(September, 2005 to October, 2010)

Senior Database Administrator / Development Manager

. Managed a team of 7 performing database administration, data

architecture, and SQL development in planning, designing, and

implementing a national BioSense data warehouse application as one of

CDC's top security awareness projects. Management responsibilities over

5 years include overseeing System Development Life Cycle (SDLC) efforts

from defining business requirements with data architects to physical

implementations with database administrators. Supported the J2EE and SAS

development teams.

. Interfaced directly with CDC's top management team to discuss software

evaluations, recommendations, and maintenance of the technical

infrastructure. Databases environment included SQL Server 2000/2005 and

Oracle 10g in Windows-clustered and UNIX-based environments

respectively.

. Coordinated all database requirements and designs with various

subcontractors to include Northrop Grumman, SAIC, Unisys, and CDC

representatives for quarterly releases and new projects. All stages of

the SDLC were documented within Microsoft Projects detailing resource

assignments.

. Met with CDC Data Analysis group in JAD session on a regular basis to

review Data Warehouse discrepancies and provided suggestions

to possible solutions.

. Provided assistance in building out a NHIN compatible interoperability

infrastructure for the Beacon Community of the Inland Northwest (BCIN).

Top five Health Information Exchange (HIE) vendors were thoroughly

researched and a weighted software evaluation matrix completed showing

their overall healthcare coordination and technical solutions.

. Planned and implemented a 10+ Terabyte database migration effort between

Windows SQL Server 2005 and UNIX Oracle 10g on a Sun Enterprise 25K

platform.

. Directed the data architect team members responsible for all logical and

physical designs utilizing ER*Win7.3 data modeler in creating star

schema data marts with drill-down capabilities.

. Created SQL Server Integration Services (SSIS) packages to benchmark

results against Informatica workflow processes. Wrote T-SQL stored

procedures and triggers in support of database maintenance.

. Assisted Unisys's Mid-Tier Data Center (MTDC) operational and system

administration staff in creating Staging and Integration environment

involving over 30+ development servers.

Emergint Technology - Atlanta, GA (August, 2003 to September 2005)

Database Manager

. Led database administrators and SQL developers over 2 years period in

support and maintenance of CDC critical applications to include

BioSense, BioWatch, and NHSN in partnership with Science Application

International Corporation (SAIC) in a SQL 2000/Windows-clustered

environment. Supported Oracle 9i/10g on Sun E6800 platform.

. Coordinated the retrieval and processing of high-security sensitive data

from the Department of Defense (DOD), Veteran Administration (VA), and

LabCorp in various delivery formats to include HL7 and XML.

. Oversaw the installation and configuration of multiple servers in a

Windows-clustered environment to support staging, hot sites, and

production environment.

. Supervised Unisys's system administration group in administering system

upgrades, security patches, and software to achieve optimal system

performance.

. Worked with MTDC operational staff to maximize WebLogic and SAS server

uptime with that of the database servers.

. Assessed current hardware and software needs, making recommendations to

high-level management according to project requirements.

. Performed database capacity planning by identifying potential data

volume growths and following best practice archival procedures.

. Assisted with the conceptual and logical models utilizing ER*Win 7.2 and

responsible for the database physical implementation onto EMC SAN

drives.

. Created stored procedures, triggers, and views in order to provide

support for quarterly release requirements.

National Service Industries (NSI) - Atlanta, GA (September, 2001 to

July, 2003)

Database Administrator

. Performed database administration tasks for Microsoft SQL Server 2000

Enterprise Edition on Windows 2000 Server platform for subsidiary

company Atlantic Envelope.

. Installed and maintained multiple instances of Microsoft SQL Server 2000

on Dell PowerEdge Tower Servers for the EQ-Commerce OLTP system.

. Migrated UNIX-based PeopleSoft HRMS 8.17 Informix database server to

Microsoft SQL Server 2000 environment utilizing Data Transformation

Services (DTS).

. Implemented SQL Server transactional data replication between IT

department and the company's Atlanta plant for fail-over purposes.

. Scheduled batch and backup jobs while providing for system

and application notification alerts.

. Maintained Informix database servers for both PeopleSoft HRMS

8.x and BAAN IV applications.

John H. Harland Company - Decatur, GA (April, 1990 to February, 2001)

Senior Database Administrator - (July, 1996 to February, 2001)

. Administered database role and responsibilities for Microsoft SQL Server

7.0 on Windows NT 4.0 Enterprise Edition.

. Installed, upgraded, and tuned SQL Server database for the

Internet Check Order (ICO) OLTP system.

. Maintained database environment through Enterprise Manager Server

Management components to include SQL Server Agents, Database Maintenance

Plan, and Backup procedures.

. Implemented database designs incorporating data integrity,

security, and indexing strategies.

. Imported and exported SQL Servers database contents utilizing Bulk Copy

Program (BCP) to interface with legacy Mainframe-based applications and

Data Warehouse environment.

. Assisted developers and clients in defining standards and guidelines for

dynamic SQL access.

Data Warehouse Manager - (July, 1993 to July, 1996)

. Managed a team of analysts and developers to provide business and

technical requirements for an Executive Information System (EIS) in

sales and finance departments.

. Designed star schema models for subject areas related to

revenue and profitability analysis.

. Created an operational data store to stage, transform, and

validate legacy system information.

. Developed aggregation strategies for data marts to accelerate

end-users query performance.

. Built complex queries with client/server application tool BrioQuery

for OLAP and EIS reporting.

System Analyst - (April, 1990 to June, 1993)

. Performed business and technical requirements for IBM

mainframe-based application projects.

. Participated in the logical and physical database design of SuperLink

utilizing CASE technology.

. Designed and programmed DB2/CICS system for the standardization of

Harland catalog codes.

. Coordinated the migration effort of all financial system from DOS/VSE to

MVS environment.

. Tuned SQL for relational database (DB2) system to improve batch

processing.

Metropolitan Atlanta Rapid Transit Authority - Atlanta, GA (March,

1988 to April, 1990)

Senior Programmer/Analyst

. Implemented and administered Dunn and Bradstreet System (DBS)

Payroll/ Personnel package.

. Provided end-users with customized online screen capabilities

to interface with DBS payroll system.

. Acted as a liaison between end-users and development staff

providing detail program specifications.

. Played a lead role in the design and development of the Run-

Assignment Transportation System.

. Performed all system development utilizing structured

programming methodology COBOL/CICS.

Education

FLORIDA INTERNATIONAL UNIVERSITY Miami, FL

B.B.A., Management Information System (Major), Computer Science (Minor),

1985

STRAYER UNIVERSITY Atlanta, GA

Master of Science, Management Information System (Expected 2011)

Certification: Informix Certified System Administrator version 9.x

Informix Certified Database Specialist version 9.x

Training: Oracle 10g Administration Workshop Release I

Oracle 10g Administration Workshop Release II

Contact this candidate