Samuel H. Roseman

Pflugerville, Texas

https://www.linkedin.com/in/samuelroseman

acvey5@r.postjobfree.com

512-***-****

hp nonstop / Tandem professional with oracle

Expertise in designing and administering large-scale databases for such leading global corporate organizations as Sabre (the world’s leading travel technology company), General Motors, MCI/WorldCom, and Kmart.

Experience spans the Tandem Nonstop SQL platform as well as multiple Oracle versions including 9i, 10g, 11g, and 12c.

Reputation for delivering superior client service and innovation in designing databases and support systems that improve operational efficiency and accuracy.

Record of superior performance reviews throughout career with consistent success as team or project lead on complex migrations and upgrades.

Very strong analytical, problem solving, interpersonal communication, and presentation skills.

Technical Skills

Hardware: HP Integrity NS14200 (Itanium), HP S78000, PC, Tandem K20000

Operating Systems: Guardian B40-H06, Red Hat Linux, Oracle Enterprise Linux, Windows Server

Languages: Tandem C (TNS/R, TNS/E), Perl, GNU C, TAL, pTAL, Pro*C, Dynamic SQL

Applications: DSM/SCF, Goldengate, RDF, SQL/MX, DSM/TC, SQL/MP, Oracle (9i – 12c), Pathway, ODBC/MX, Measure

Professional Experience

HP Enterprise Services / EDS, Austin Texas 1998-2016

Oracle Database Administrator, Sabre Account, 2012–2016

Served as a member of a team of 24 administrators in the US and India and administered approximately 900 Oracle databases on behalf of the world’s largest travel technology company, which operates under the platforms Travel Network, Airline and Hospitality Solutions, and Travelocity.

Served on SaaS database administration team who supporting over 900 Linux based Oracle databases providing rotational on-call support, problem analysis and resolution, while also completing an average of 7 Production database change requests per day during established maintenance windows.

Encouraged team to write detailed implementation plans containing specific commands required to satisfy requested change. This allowed for effective pre-implementation peer review and a more streamlined implementation resulting in over 60% reduction in failed database changes.

Received superior annual performance reviews that exceeded established quality goals consistently maintaining database change success rate over 99%.

Nonstop SQL Database Administrator, Sabre Account, 2004–2011

Managed multiple Nonstop SQL RDF (remote data facility)-replicated databases of more than 9 terabytes and 9100 partitions for Sabre’s Certification and Production system. Analyzed Measure Performance data to review and monitor I/O activity and maintain historical database size information to enable growth analysis at the disk, table/index, and partition levels.

Selected as Lead Database Administrator (DBA) on migrations and upgrades based on of Tandem expertise and served as the subject-matter expert (SME) for Tandem applications.

Migrated 4 Production databases to 6 HP Integrity NS 14200 Itanium-based servers implementing a physical design strategy that reduced average fragmentation from 1776 per disk to an average of 1.38 per disk. Created robust Goldengate configuration to keep source and target databases in sync during the migration.

Develop numerous C programs containing embedded SQL in both the Guardian and OSS environment to automate database management tasks.

Samuel H. Roseman acvey5@r.postjobfree.com Page 2

HP/EDS (continued)

Nonstop SQL Database Administrator, Texas Healthcare, 1998–2004

Administered the CMS, Medically Needy, and V21 databases and the 1.1 Terabyte C21 Claims Engine database that supported state-funded and administered healthcare services offered through the Texas Department of Healthcare Services. Designed SQL tables and code to capture detailed weekly database performance statistics, summarized historical performance statistics, and developed a database security strategy. Configured and maintained the ODBC server configuration and assisted users with local ODBC client configurations. Managed DDL change control.

Created the initial physical design, charted database growth, analyzed performance statistics, and performed regular table and index maintenance.

Wrote many C programs to facilitate and automate database maintenance and partitioning efforts and to capture growth, capacity and performance statistics.

Additional Experience

MCI/Worldcom, Tulsa Oklahoma

Database Administrator

Administered a Nonstop SQL database, revising the physical database design, including the partitioning scheme for the ODS database that resulted in 1296 file partitions being optimally distributed across three Tandem K20000 servers.

At MCI, improved efficiency and accuracy of database changes and became the sole Tandem Database administrator within 5 months.

GM/EDS, Auburn Hills Michigan

Tandem System Administrator

Managed 8 Tandem servers, installing and configuring software and hardware for such customers as General Motors, GMAC, and the states of Texas, Alabama, and Arkansas.

Performed the first successful disaster recovery of one of the Tandem systems at a remote center.

Wrote C programs to automate system shutdown, startup and even upgrade tasks eliminating errors and reducing implementation times by 50%. Wrote numerous other C utilities interfacing with provided Guardian APIs / Procedure Call Library.

Storage / Database Administrator

Created and implemented the physical design for Nonstop SQL for multiple GM applications such as those that served Chevrolet and Oldsmobile dealerships and the GM Satellite system.

Wrote a TACL scripts to automate maintenance task increasing productivity four fold while also eliminating recurring errors.

Computer Operations

Began career with GM/EDS as a computer operator managing IBM mainframe systems earning elite exemption from EDS’ Operation Development Program due to prior superior performance.

Education

Bachelor of science (mathematics & computer science), Cum Laude,

LAWRENCE TECHLOGICAL UNIVERSITY

Continuing Education

NS-Series Servers Differences; Goldengate 9; Quality Management – ISO9001; Nonstop Kernel Architecture; Nonstop SQL Physical DB Design; Tandem System Management; Oracle 11g RAC; Introduction to Java Programming

Certifications

Oracle 11g Certified Professional (2011); Oracle 10g Certified Professional; Oracle 9i Certified Professional; EDS System Engineer, Tandem

Contact this candidate