John A. Sammerson
Raleigh
Summary
Having served in a Database Administrator and IT Systems Analyst capacity at SCHS, with proven leadership SDLC experience in enterprise business models that include health, financial, e-commerce, telecom and billing systems for Fortune 100 companies, federal and state governments, I would like to be considered for Business Systems and Intelligence (BSI) Branch Manager position.
Overview
19
19
years of professional experience
Work History
Database Administrator & Systems Analysis
NC CENTRAL CANCER REGISTRY
Raleigh
12.2006 - Current
- Managed database administration for all branches at NC State Center for Health Statistics and Vital Records, focusing on logical and physical structure, data security, optimization, and migration.
- Led strategic planning initiatives for CCR, maintaining Gold classification for 6 consecutive years. Developed an operations activity calendar, identifying bottlenecks and dependencies to alleviate staff anxiety and provide clarity on goals and deadlines for major data submissions. Documented system specifications and monitored software and hardware licensing deadlines across SCHS.
- Systems Oversight & Operations: Serve as liaison with ITD Security team to address numerous security matters such as Vulnerability scans, Certificate renewals, Disaster Recovery Plans, Vendor Readiness Assessments, Privacy Threshold Analysis, secured data transfer and at-rest practices. Tested and implemented several new CDC software releases and platform upgrades. Led several Go/No Go implementations. Provided real-time technical support for 200+ users at cancer facilities, hospitals and staff. All while maintaining 99% system availability and data reliability. Often times having to diagnose and fix system performance issues. Document and disburse new procedures while tracking valid users. Ensure database security, integrity and functionality and update certificates to enforce user identity management and system access controls. Led database re-architecture effort and migration effort using Rubrik Cloud Management. Versed in Waterfall and Agile operations.
- Directed cross-country database migration and rearchitected specifications for various platforms. Configured VPN Juniper and Cisco firewalls, upgraded database and software applications, and led user training efforts. Advocated for establishment of Test/Development and off-site Disaster Recovery environments to IT upper management. Collaborated with SCHS branches to document process flows and address operational pain points.
- Contributed to securing multiple CDC grants and achieving NAACCR Gold status through active participation in national Cancer Registry conferences. Specified server requirements for migration efforts and created data flow presentations. Engaged with SCHS branches to document operational data flows and established database and server specifications during re-architecture. Provided training for external users and staff on database and application changes.
IT Systems Analyst
Intersections Inc
Chantilly
Systems Analyst
US CENSUS BUREAU
Suitland
Snr. Staff Engineer
ERICSSON, INC
RTP
Snr. Software Engineer
NORTEL NETWORKS
RTP
Software Engineer and DBA
MCI COMMUNICATIONS
RTP
Software Engineer
IBM CORPORATION
RTP
Member of Scientific Staff
BELL-NORTHERN RESEARCH
RTP
Education
MS - Computer Engineering
North Carolina State University
Raleigh, NC01-1994
BS - Computer Science
City College of New York
New York, NY01-1987
Skills
- SQL Server and NET Framework
- Data analysis
- XML and web services
- HL7 integration
- IIS and Cisco networking
- Agile methodologies
- Microsoft 365 Copilot
- MS Project management
- Visio and SharePoint
- Ultimus workflow management
Professional Association
Tarheel Toastmasters Public Speaking Chapter, President, CC, 2013-2014
Relevant Technical Skills
- SQL Server
- Rubrik
- .NET Framework
- XML
- MS 365 CoPilot
- RedGate Packager
- MS Project
- Visio
- Sharepoint
- Ultimus Workflow Mgmt
- HL7
- IIS
- Web Services
- Cisco
- Agile
Previous Technical Positions
- Intersections Inc, Chantilly, VA, IT Systems Analyst
- US CENSUS BUREAU, Suitland, MD, Systems Analyst
- ERICSSON, INC, RTP, NC, Snr. Staff Engineer
- NORTEL NETWORKS, RTP, NC, Snr. Software Engineer
- MCI COMMUNICATIONS, RTP, NC, Software Engineer and DBA
- IBM CORPORATION, RTP, NC, Software Engineer
- BELL-NORTHERN RESEARCH, RTP, NC, Member of Scientific Staff
Timeline
Database Administrator & Systems Analysis
NC CENTRAL CANCER REGISTRY
12.2006 - Current
IT Systems Analyst
Intersections Inc
Systems Analyst
US CENSUS BUREAU
Snr. Staff Engineer
ERICSSON, INC
Snr. Software Engineer
NORTEL NETWORKS
Software Engineer and DBA
MCI COMMUNICATIONS
Software Engineer
IBM CORPORATION
Member of Scientific Staff
BELL-NORTHERN RESEARCH
MS - Computer Engineering
North Carolina State University
BS - Computer Science
City College of New York