Reitzel, Morris H.

Database Engineer

*** ********** **

Odenton, MD 21113

615-***-****

adylgl@r.postjobfree.com

Summary:

* ***** ** ********** **** Big Data / Hadoop and Hive

** **** *** **** scripting

4 years Pig Scripting

5 Spark Scala in MAPR data cluster from Oracle, SQL Server

3 years Python Experience

7 years Github Experience

1.5 years Confluent Kafka Experience

15 years of experience with SQL Server 2000, 2005, 2008, 2012 in Healthcare Industry

7 years of experience with Oracle in Healthcare and Defense Contracting Environment

8 years of experience with Sybase in Dept. of Defense Sector

Experience with SQL 2005, 2008 & 2012 SSIS

Experience with SQL Server 2000 Enterprise Manager, DTS and Query Analyzer

Experience with SQL Server 2005, 2008, 2012 SQL Server Management Studio

Performance and Application Troubleshooting with SQL Server Profiler

SQL Server T-SQL Scripting and Procedure Development, Maintenance and Testing

Experience with C, C++, Ada, Java

Experience in .NET routines inside of SSIS packages

Experience with Talend ETL tool.

DBA experience with SQL Server, Oracle and Sybase

Experience with Data Modeling with Computer Associates Erwin 4.0 and Embarcadero E/R Studio

Experience with HBase and MAPR NoSQL database

Oracle PL/SQL Scripts, Procedures and Packages Development, Maintenance and Testing

Oracle Forms Development, Maintenance and Testing

Oracle Administration through Enterprise Manager

Sybase Ada Workbench and PowerBuilder Development, Testing and Deployment

Windows and Unix Batch Scripts for Database Administration

IBM JCL on an IBM Mainframe Operating for Batch Jobs involving the M204 system.

M204 Database Management Administration, M204 Application Program Modifications and Testing

Online Azure and AWS Cloud Training

Supported Tableau Reporting Team and Tableau Online Training

Operating Systems:

Microsoft Windows, Unix, IBM mainframe operating system

United Healthcare Services Data Engineer (Dec 2012 to January 2023):

Location: Baltimore, MD / remote

Duties/ Responsibilities:

8 years of experience creating and deploying Unix Data Ingestion processes from Tetra Data, Oracle, SQL Server and Flat File Data Sources in a MAPR Big Data / Hadoop Cluster based on Business Requirements.

6 Spark Scala with Java for data imports and transfer Mapr Cluster

3 years Python Experience

1.5 years Confluent Kafka Experience

7 years working with Github as the Configuration Control tool for Big Data / Unix

Process Documents creation for operations group reference.

Big Data Tools include Sqoop, Complex Pig Routines and Hive database

Intellij with Maven to create Scala Projects / Java that is compiled into deployment Jars

Talend Job created for the use with Big Data Ingestion Projects.

Java Subroutines created that were called from inside of Pig and Talend.

Bash and Korn Shell Script creation as the driver to Sqoop, Hive, and Pig calls.

4 yrs experience with SVN Configuration Management used for Big Data Projects.

3 years of experience creating and deploying SSIS 2008 and 2012 file ingestions into 2 SQL Server Data Marts with SourceSafe Configuration Control tool.

3 years Develop and Support of .Net applications which interacted with SSIS

SSMS 2008 and 2012 were used for table and index maintenance.

SQL Server database team tasks were requested for Disk and Database creation tasks.

Created ODBC connection into Oracle to import into Excel Documents.

Oracle SQL Developer was used for database exploration during ingestion projects.

Supported Tableau Reporting Team and Tableau Online Training

GHX Inc. DBA And Database Engineer (April 2001 to August 2012):

Location: Brentwood, TN

Duties/Responsibilities:

DTS and SSIS data extraction into delimited flat files

DTS imports automated importation from multiple Excel and Flat Files with a common format.

SSIS imports automated importation from multiple Excel and Flat Files with a common format.

DTS and SSIS data extracts from transactional databases into Data Warehouse Database

2008 Import and Export Data Tool and T-SQL Script for the mass setup of user data

T-SQL Scripting to correct database data issues that created application errors

Troubleshooting complex SQL Queries between 150 and 250 formatted lines to determine the causes of data retrieval failures from a parts catalog

Stored Procedures, and Functions Creation, Testing, Maintenance, and Tuning

Database Data and Inbound Data Integrity Analysis and Troubleshooting

SQL Server Database Administration backups, database creation restores from database template, and deployments for new customers

SQL Scripts for production data correction after version upgrades

SQL Job for SSIS, DTS, T-SQL and Window Batch Scripts

Performance and Application Troubleshooting with SQL Server Profiler

SSRS administration and deployment of reporting to new Customers

Oracle PL/SQL Development, Maintenance and Testing

Basic Oracle Administration for Application Maintenance

Data imports and exports from Access to Oracle through an ODBC interface

Windows Batch Scripts for SQL Server Database Administration

Patuxent Technology Partners, Data Engineer (June 1999 to March 2001):

Location: Columbia, MD

Duties/Responsibilities:

Oracle Forms Development, Maintenance and Testing

PL/SQL Scripts, Procedures, Packages and Triggers Development, Maintenance and Testing

Java Programming with JDBC and SQLJ

Unix Scripts for Oracle Database Administration

Oracle DDL and table creation, table constraints, indexes, synonyms, comments, views and data migration

Computer Sciences Corporation, Computer Scientist (July 1997 to June 1999):

Location: Hanover, MD

Duties/Responsibilities:

Oracle Developer 2000 4.5, Oracle Reports 2.5, PL/SQL development, QA and maintenance

C programs and Unix scripts to implement modifications of a new Oracle Application.

Oracle Designer 2000 to reversed-engineer and maintain an ER diagrams of the Oracle Application.

Served as the backup Oracle for System restarts, data locks, deadlocks and security

Oracle Import and Export utilities were used to restore backup data and move data between the production and development Pipeline instances.

Keane Federal Systems, Senior Programmer Analyst (January 1995 to July 1997):

Location: Columbia, MD

Duties/Responsibilities:

Sybase Database Administration duties included installing and upgrading copies of Sybase and Database Interface Software, maintaining database backup procedures, establishing database security, providing Transact SQL expertise.

Training two other Sybase database administrators and performing system administration related to Sybase on Sun Solaris 2.4 and OS/2 platforms.

Bourne and C shell Unix scripts to perform to perform DBA functions.

Powerbuilder Application development, Testing and Maintenance.

Sybase Replication System at the Client Site.

Dept. of Defense, Ft. Meade, MD Computer Scientist (October 1990 to December 1994):

Duties/Responsibilities:

ADA Workbench programming, schema design, integration and testing to produce an interactive Resource Management Application on Sun Unix.

Sybase Database Administration duties included installing and upgrading copies of Sybase and Database Interface Software, maintaining database backup procedures, establishing database security, providing Transact SQL expertise.

Bourne shells and C shell scripts to perform to perform DBA Functions.

Data flow management interface development between two heterogeneous systems using the C Language. He performed systems evaluations of each system, followed by design, coding, test data preparation and test procedures preparation for unit and integration testing.

Database Subsystem Systems Requirements Specification and Preliminary Design for an Ada project that would performed data archival, signal processing, and result forwarding on an IBM RS6000 Fileserver under AIX.

Dept. of Defense, Ft. Meade, MD, Computer Analyst (April 1989 to October 1990):

Duties/Responsibilities:

Evaluation of two commercial off-the-shelf DBMS systems, Interbase and Sybase

Developed and tested C and Sybase open client library functions under a Sun4.1.3 OS.

Trained two new DBA’s to perform Sybase Administration.

Dept. of Defense, Ft. Meade, MD, Computer Analyst (November 1984 to April 1989):

Duties/Responsibilities:

File Manager/Database Administration for a MODEL 204 Data Flow Management system.

Performed backup and recovery functions, and analyzed audit trails, file statistics, and operational reports to ensure data integrity and operational efficiency.

Maintenance M204 and PL/1 programming and testing.

Provided for the training of another M204 File Manager/Database Administrator.

Served as the lead a team of other programmers in a PL/1 to M204 software conversion effort.

IBM JCL on an IBM Mainframe Operating for Batch Jobs involving the M204 system.

EDUCATION:

M.S., Computer Science (1989) GPA 3.5 out of 4.0

John Hopkins Unversity, Baltimore, MD 410-***-****

B.A., Computer Science (1984) GPA 3.84 out of 4.0

Oswego State College, Oswego, NY 315-***-****

A.A.S Data Processing (1982) GPA 3.84 out of 4.0

Genesee Community College, Batavia, NY 716-***-****

Technical Training & Certifications:

Designing an Analysis Solution Architecture Using MS SQL Server 2005 Analysis Services

Brain Bench 8.0 Oracle DBA Certification

Brain Bench PL/SQL Oracle Programming

Brain Bench RDBMS Concepts

Java Programming Language at Sun Microsystems

Database Management using Oracle 8.0 @ Capital College, Laurel MD

Programming in Java (1998), University of Maryland, Baltimore Campus,

Baltimore, MD 410-***-****

Oracle Procedure Programming 1998 from Oracle Corp.

Data Structures in C++ (1997), Anne Arundel Community College,

Arnold, MD 410-***-****

C Language Programming at the National Cryptologic School, Ft. Meade

Programming in X Windows at the National Cryptologic School, Ft. Meade

PL/SQL Database Programming, Oracle Corporation, Bethesda, MD 301-***-****

Sybase Database training courses and Sybase User Group Conferences.

Online Azure and AWS Cloud Training

OTHER ACHIEVEMENTS:

Letter of appreciation from the supervising Contractor while with for PTP.

Two letters of appreciation from the Customer while working for CSC.

Letter of appreciation from the customer while working on the special support project with Keane Federal Systems.

Two Cash Awards while working as a Computer Analyst with the Department of Defense.

REFERENCES:

Meskerem Amenu Data Engineer 614-***-**** adylgl@r.postjobfree.com

Dereck Krause Application Developer 301-***-**** adylgl@r.postjobfree.com

Hong Lee Sr Data Engineer 301-***-**** adylgl@r.postjobfree.com

Wubishet Nurga Sr System Mgmt Analyst 301-***-**** adylgl@r.postjobfree.com

Navin Chandar Rajaram BI Developer 443-***-**** adylgl@r.postjobfree.com

Contact this candidate