Database Administrator Sql
Resume:
Samuel H. Roseman
Pflugerville, Texas
https://www.linkedin.com/in/samuelroseman
********@****.***
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 ********@****.*** 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