SUMMARY:

• Over 20 years of experience in Information Technology. Areas of specialization include Data Engineer, AWS Migration, Project Management, IBM DB2 LUW Database Administration, MongoDB Database Administration, AWS Architect, and Hyperledger Fabric Composer, Data Architect, Database Design & Modeling, Data Warehouse
• Design, Data Modeling, Data Normalization, Database Conversion, System Installation, Planning, Implementation, and Migration.
• I have solid experience programming in Korn Shell / Bash scripting and writing SQL code to include SQL tuning, restructuring, and optimizing SQL, tuning SQL applications.
• I have superior communication skills, both written and oral.

TECHNICAL SKILLS:

Hardware: P/690 / AIX, RS 6000 / AIX, IBM Z/OS, OS/390

Software: COBOL, VSAM, C++, SQL, REXX, QMF, OS/JCL, CICS, Java, JSP, WebSphere, Python, TSO, SPUFI

DATABASE: IBM DB2, IBM IMS, MongoDB, Redshift (Redshift Spectrum), Oracle, Sybase, SQL Server, MySQL, SQL Server,CICS, and SQL/DS

PROFESSIONAL EXPERIENCE:

Confidential

AWS Lead Architect

Responsibilities:

• This project is a migration effort to migrate all AWS EDW objects from Sierra Nevada Corporation to a newly formed Subsidiary Sierra Space to host in AWS Govcloud
• Designed, implemented, and maintained the pipelines that enabled the ingestion of raw data into Redshift Data Warehouse
• Transform data to be optimized for analytics
• Made the data available for various data consumers using their tool of choice
• 100% Serverless environment using Lambda Serverless Environment
• Jenkins and Terraform used to manage all Infrastructure as Code (IaC)
• Databases include SQL Server, Postgres, Aurora DB
• Postgres DB Aurora.
• Lambda
• Step functions
• Glue Crawlers
• Glue ETL
• Quick Insight
• Glue Catalog to Data Catalog Schema
• Redshift and Redshift Spectrum
• DBT
• Fargate
• Snowflake / Redshift data warehouse database used primary as the data consumption layer; source of BI and other consumers
• Terraform used to manage all Infrastructure as Code (IaC)
• Kafka used to publish - subscribe/pub-sub/message broker for event based streaming
• RStudio using R for a quick simple scripting and quick and dirty data manipulation
• The Intelli J IDE uses JAVA for all development and data work done with this IDE
• This project is a data engineering effort to setup, architect, and configure AWS Glue to build, import, export to/from data lakes of AWS S3 data pipeline to develop data catalog with crawlers to create database and tables. The data originates from the State Florida Z/OS and the data is migrated to RDS ((MySQL) and Redshift Spectrum using DMS and SCT. All executing on various EC2 Linux servers. Also used Anthem to query S3 files using SQL.
• Experience with migration of modern (e.g., cloud, AWS Redshift, AWS glue, SQL, noSQL) databases and data processing services, data architecture, and data storage
• Experience developing BI reports, dashboards, and/or predictive analytics using BI tools AWS Quicksight
• Experience with service oriented environment and AWS best development practices.
• Superior knowledge of the fundamentals of iterative developments and applications of Agile concepts and principles.
• Using AWS Elastic Load Balancer (Application)
• Using Simple Storage Service (S3)
• Using Route 53
• Using IAM
• Using AWS Relational Database Service (RDS) for MySQL
• Using Elastic File System (EFS)
• Using Security Groups
• Using AWS CloudFormation
• Using Lambda
• Using Micro Focus COBOL
• This is a jack-of-all- skills position of DBA, scripting data ingestion from / to flat files into databases, ETL, ingestion processing using automation of Bash Scripting, Python, and problem resolution.
• Day-to-Day Ingestion processing.
• Wrote, executed, modified, documents the daily X12N provider, Rx, dental, institutions, and professional claim files from health insurance companies to extract, transform, and load data intoboth MongoDB and Oracle database using various ingestion data quality techniques andstrategies.
• The systems are used by DevOps, big data analytic and Analysis, business intelligence, artificial intelligence, data scientist teams.
• Conversion from MongoDB back to Oracle for better DSS type query processing.

Confidential

MongoDB DBA and Application Developer

Responsibilities:

• Created, Install, Upgrades
• OPS Manager
• MMS
• Query Tuning
• Collection and Document Design
• Change Stream
• Aggregation, CRUD, mongoexport, mongoImport mongostat, mongotop
• Created and Optimize Indexes
• Debug and Diagnose Database Performance
• Atlas
• Robo3T
• Compass
• Explain (Execution Stats)
• Python Scripting
• Create User ID from the Mongo Shell and in OPS Manager
• Performed backup and restores from the Mongo Shell and in OPS Manager and mongodump and mongorestore utility
• Setup replica-sets from the Mongo Shell and in OPS Manager
• Check Replication Lag of Nodes
• Check Disk I/O usage
• Setup and Configure SSL
• Setup custom Roles
• Python Scripting
• Monitor and Kill Long Running Operations
• Collect Mongo Metrics
• Initially Contract to Hire
• The Anthem Database Infrastructure contains 77,000 Database Servers
• Significant Linux Korn Shell Scripting, Bash Scripting expertise to monitor performance, email alerts, automation of tasks and processes of
• Logical and Physical design, Architect of Data Warehouse Data Warehouse, Data Modeling, Database Infrastructure setup, Planning, Implementation, Management, Administration, and Design
• DB2 Installation, upgrades, Instance, and database backup and restores
• Virtual Database Servers
• HADR (High Availability Disaster Recovery) and HACMP
• Virtualization Servers Environment
• Daily use of JIRA story during daily standup meetings
• DB2 Utilities: reorg, reorgck, runstats, load, export,
• Install and setupDB2instances for Application teams.
• Assist with plans for database upgrades by maintaining, evaluating, and creating a processing model
• Assesses database performance by developing a protocol for measurement of results and identification of problem areas.
• Help customers by providing support for database performance by monitoring database performance; evaluating and resolving processing and programming problems; designing database management tools; answering user questions.

CONSULTANT

Confidential

Responsibilities:

• IBM UDB DB2 Database Administrator assigned to the American Express account
• Assigned to the one of IBM’s customer as staff augmentation to facilitate server migration from one data center to another data center.
• Lift & Ship / Reinstall
• Virtualization Servers
• Migration testing and Validation
• DB2 Server Build
• Failover testing and validation
• DB2 Health Check
• DB2 Diag.log analyzer db2mtrk - Memory tracker command

SENIOR MANAGER

Confidential

Responsibilities:

• IBM UDB DB2 Database Administration
• Assigned to the MetLife account / TriCare Medical application for DOD
• Active DOD Interim Security Clearance
• AIX Platform
• Unix Shell Scripts /Perl Scripting
• Wrote scripted import, exporting, import, load, backup, runstats, reorg, rebind

Confidential

Data Architect / DBA

Responsibilities:

• IBM UDB DB2 V9.5 to V9.7 Upgrade
• IBM DB2 table partitioning, database administration, Database performance tuning through database physical design, configurations, reorg, runstats, event monitor, snapshots and implementations of data aggregations, MQTs, MDCs, Tables Partitioning, and indexing.
• Installation, configuration and migration
• Platform is LUNIX
• Performed redirected restore to move data
• Setup HADR
• Wrote scripted import, exporting, import, load, backup, runstats, reorg, rebind

CONSULTANT

Confidential

Responsibilities:

• IBM UDB DB2 V9.5 to V9.7 Upgrade
• Installation, configuration and migration
• SQL Server 2008
• Informatica Upgrade to 9.0
• Platform is Unix AIX 5.3
• Performed redirected restore to move data
• Data Modeling 3NF
• PeopleSoft HR Support
• Wrote Unix Shell Scripts to monitor HADR
• Wrote scripted import, exporting, import, load, backup, runstats, reorg, rebind

CONSULTANT - Data Architect - Project Manager

Confidential

Responsibilities:

• Data Modeling 3NF
• Requirements Gathering / Data Mapping
• Using Ralph Kimball’s Dimensional Design Architecture (Star Schema)
• Design Fact Tables ( measurements )
• Design Dimensions Tables ( context
• Design Surrogate Key / Design Natural Keys
• Type 2 Slowing Changing Dimensions Methodology
• Design ETL Processing
• IBM InfoSphere modeling tool
• IBM UDB DB2 V9.1
• Healthcare - ER Data Model - Data Warehouse Architect
• Logical Data Modeling and Physical Data Modeling (STAR Schema)
• Supported Blue Cross Shield Medical Records Databases
• Strong knowledge in DB2 UDB DPF / BCU environment Unix, and enterprise warehousing.
• DBA for a large BCU DB2 UDB DPF/ EEE environments - 13TB 57 partitions
• Across 7 servers.
• Experience in DB2 with table partitioning, database administration, Strong Knowledge on Database performance tuning through database physical design, configurations, reorg, runstats, event monitor, snapshots and implementations of data aggregations, MQTs, MDCs, Tables Partitioning, and indexing.
• Performed query performance optimization, tuning implementations,
• SQL tuning, import & exporting, cursor loads and data movement
• Production support 24/7 on call rotation
• Provided support for backup & disaster recovery processes and procedures.
• Outstanding verbal and written communication skills.
• Strong AIX/Unix scripting, TSM, Netbackup, BMC Patrol, DB2 governor, Query Patrol

CONSULTANT - Data Architect - DBA

Confidential

Responsibilities:

• Supported & Design Blue Cross Blue Shield Florida Medical Records Databases
• Healthcare - Data Architect
• Logical Data Modeling and Physical Data Modeling
• Database Infrastructure, Planning Implementation, Design, Management, Administration
• Hire to design logical and physical design of a multi-terabyte Partitioned Datawarehouse for Medical Claims Analysis application using UDB V9.5 64 bit & UDB V9.1 32 bit
• DPF / BCU environment single partition and multi partition
• Design AB Initio ETL tables
• Created databases, bufferpools, tablespaces, tables, indexes, views
• IBM UDB V9 utilities, reorg, reorgck, runstat, load, export, import, alter, Explains,
• Tuned DBM CFG, DB CFG, and Registry Parameters
• Design and implemented Database Backup and Recovery Plan
• DPF, HADR, Replication and other high availability strategies
• 3rd party tools Todd, DBArtisian, Quest Central, Toad
• IBM Performance Monitor / SQL tuning
• Hire to migrate DB2 databases from Z/OS series machine to P series machine
• Migrate DB2 databases from UDB AIX V8.2 32 bit to UDB Linux UDB V9.5 64 bit
• Replication Version 8
• Re-design database objects for Student Registration Database
• Tuned DBM CFG, DB CFG, and Registry Parameters
• IBM DB2 UDB utilities, reorg, reorgck, runstat, load, export, import, alter, Explains,
• Programs will remain executing on the the Z machine and re deployed using alias
• Hired as a consultant by IBM to work on the TSA (No Fly Database) account as Lead DBA at the Colorado location. Position required security clearance.
• Created databases, bufferpools, tablespaces, tables, indexes,
• Design fail system using HACAMP / HADR.
• Executed IBM DB2 UDB utilities, reorg, reorgck, runstat, load, export, import, alter, explains and SQL tuning
• Tuned DBM CFG, DB CFG, and Registry Parameters
• Design backup and restore strategy

DB2 UDB DBA DBA / ARCHITECT

Confidential

Responsibilities:

• Hired as a consultant by Confidential to write Disaster Recovery Plans and implement the DR plans during a mock recovery drill using IBM’s Recall facility
• Wrote migration plans to migrate from DB2UDB version7.2 to UDB DB2 version 8.
• Upgraded DB2 UDB fix pack 9 to DB2 UDB fix pack 11
• Oracle Database Administration
• Performed WebSphere Deployments of java, JSP, HTML, and JavaBeans code
• Executed, interpret and recommended coding changes based upon Explain outputs.
• Perform day-to-day DB2 UDB utilities, reorg, runstat, load, export, alter, etc.
• Wrote a series of Korn Shell scripts to monitored the system and
• Executed event monitor to examine the deadlock, connections, SQL statements, transactions, deadlocks, bufferpools events, table space events, and tablescreate event monitor evmonal for statement and deadlocks. Monitored and tuned buffer pools, dbm cfg parameters, db cfg parameters, registry parameters, lock escalation, etc.
• Executed Text extender
• Support the WorkBrain HR and time accounting application.
• Executed Redirected Restore to build test databases using the production backups.

DB2 UDB DBA DBA / ARCHITECT

Confidential

Responsibilities:

• Hired as a consultant by Confidential to perform DBA functions in an AIX 5.2.1, UDB DB2 7.2, EEE (DPF), EE environment
• Performed ER Data Modeling and Data Normalization using Erwin
• Created tablespaces, tables, bufferpools, indexes etc.
• Wrote a series of Korn Shell scripts to monitored the system and executed IBM DB2 UDB utilities, reorg, runstat, load, export, alter,etc.
• Wrote Korn Shell scripts create DDL’s, load data index creation, backup, FTP, etc., loading tables and backup and recovery of table spaces perform migration using DB2 UDB data movement utilities and data replication utilities
• Wrote a serries of K shell scripts to perform Backup and restore Executed snapshot monitor to examine databases, table spaces, tables, locks, bufferpools, unit of work, and dynamic SQL performance issues
• Executed event monitor to examine the deadlock, connections, SQL statements, transactions, deadlocks, bufferpools and created. event monitor evmonal for statement and deadlocks
• Monitored and tuned buffer pools, dbm cfg parameters, db cfg parameters, registry parameters, lock escalation, etc.
• Executed Text extender Utilities

DB2 UDB DBA DBA / ARCHITECT

Confidential

Responsibilities:

• Performed Data Base Administration on a Data Warehouse banking application for second largest thrift bank in USA
• Performed production system monitoring, system and application performance for a in a multi - instance, multi-system environment, and multi-database environment in an AIX 5.2.1, UDB DB2 7.2, EE environment
• Programmed Korn Shell scripts to automate calling SQL Stored Procedures
• Activities include table space, table design, executing load utilities, import and export, db2look, rebinds, reorgs, reorgcheck, index advisor, runstats, various snapshots, and performance monitor and tuning
• Enhanced the Instance and data base parameters and variables, monitored table space growth, and performed SQL tuning
• Set-up procedures to backup and recover databases, wrote run books and documentation and trained users
• I worked with various DB2 third party tools.

DB2 UDB DBA / ARCHITECT

Confidential

Responsibilities:

• Converted system, application, and conversion from Oracle to DB2 UDB, converted system, application, data conversion from DB2 UDB Z/OS to DB2 UDB, and converted system, application, data conversion from DB2 Z/OS to DB2 UDB.
• Wrote scripts create DDL s, load data index creation, backup, FTP, etc., loading tables and backup and recovery of table spaces perform migration using DB2 UDB data movement utilities and data replication utilities
• Developed a process to migrated BLOB data from Z/OS to DB2 UDB and wrote program in REXX to call stored procedures
• Developed a process to migrated Oracle to DB2 UDB AIX
• IBM Replication Version 8
• Performed DB2 UDB RS/6000 and OS/390 DB2 performance and tuning of the on - line truck order application. Performed SQL program tuning by writing the SQL code, re-structuring, and optimizing SQL
• Created and optimized indexes, optimized buffer pool hit ratio, CASHE SQL statements, proper sizing of the MAXKEEPD, VPSEQT, and other ZPARM parameter to alleviate CPU Deadlocks, concurrency, I/O concerns, and etc.
• Wrote static COBOL Stored Procedures (SP). I utilized various DB2 performance and monitoring tools: CA Detector, IBM testing using INTERTEST Software and Stored Procedure Builder. Some data existed on SQL-SERVER 2000 databases.
• Executed EXPLAINs to determine access path, tuned SQL, joins, utilization of indexes.

DB2 UDB DBA / ARCHITECT

Confidential

Responsibilities:

• Hired to do DB2 UDB performance and tuning at the instance, database, and application level for a AIX, UNIX, WebSphere, NT system
• Used the IBM UDB DB2 data movement utilities and data replication utilities.
• Tuned, reviewed, update various database manager configuration file (instance) and database configuration parameters for optimal performance
• Executed snapshot monitor to examine databases, table spaces, tables, locks, bufferpools, unit of work, and dynamic SQL performance issues
• Executed event monitor to examine the deadlock, connections, SQL statements, transactions, deadlocks, bufferpools events, table space events, and tables. I executed predefined monitors of Visual Performance Monitor to observe monitor capacity, sort, locking, cache, deadlocks, prefetchers, disk performance, application global memory, and long running queries
• Tuned application SQL using various tools including explain, visual explain, index advisor, db2diag.log, and db2alert.log and executed reorgck, runstats, reorg, backup and restore, index estimate size
• Tuned DB2 applications and DB2 sub - system by executing Explains and DB2PM Performance Monitor and reported on finding of the DB2PM Performance Monitor Accounting Traces/Statistical reports
• Recommended optimal buffer pool utilization, monitored DB2 subsystem for performance, access paths, and trade-off various access paths by reviewing DB2 internal as they relate to table space and index mechanics
• Implemented, developed and choose the optimal DLL to implement efficient DB2 objects
• Migrate DB2 objects from one sub-system to another, created the following: DATBASES, TABLES, INDEX, TABLESPACE, STOGROUP, SYNONYM, VIEWS, ALIAS
• Loading tables and backup and recovery of table spaces, migrated DB2 UDB data movement utilities and data replication utilities.

DB2 UDB DBA/Systems Programmer

Confidential

Responsibilities:

• Performed physical Management of DB2 UDB objects, data structure and physical makeup of tables and upgrades / installed DB2 add - on software package (IBM s QMF & DB2 PM) and OEM (CA S FileAid, Information Builders s EDA) and others software products and tools.
• Monitored DB2 subsystem for performance, access paths, and trade-off various access paths
• Monitored DB2 internal as they relate to table space and index mechanics and implemented and choose from the various SQL/DLL options to implement efficient DB2
• Migrated DB2 objects from one sub-system to another utilized DSNCOPY and used DB2 UDB data movement utilities and data replication utilities
• Migrated DB2 V3.1 to DB2 V4.1, and DB2 V4.1 to DB2 V5.1 using the install Clist, and various utilities to verify the integrity of the installation IVP
• Performed IMAGE COPY, QUIESCE, RECOVERY, REORG, REPORT, MODIFY, BIND, CHECK, LOAD
• Performed backup and recovery of table spaces, catalog, and directory and recovery of application Tablespaces and Index, package and plan administration, capacity planning, performance and tuning
• Performed alter of DB2 objects, reorganizing, monitor DB2 Databases (DB2 PM) created databases, tables, index, table space, stogroup, synonym, views, alias, stored procedures, triggers
• Utilized SMP/E, DB2 CONNECT, and IBM LinkVICE PRESIDENT APLICATION Development / Web Architect, careerengine.com
• Oversaw new application software development as well as technology advancement for the company's category-specific online sites and Implement design methodology and system procedures
• Managed the daily activities of developers and DBA s for requirements gathering, systems analysis and design, data base design and administration, programming, testing, implementation, trouble shooting
• Utilized Active Server Pages (ASP), Java, Java Server Pages (JSP), Servlets, WebSphere, DB2 UDB EE/EEE, SQL-Server 7, JDBC, Sybase, Javabeans, XML, HTML, Javascript, and Homesite on NT Server and AIX RS/6000

DB2 UDB DBA /ARCHITEC

Confidential

Responsibilities:

• Convert AXA Equitable Insurance Company s application systems from VM to MVS
• Wrote conversion plans from a DBA point of view. Performed analysis and programming need to get migrated application working in MVS
• Designed and developed a methodology to migrate and convert DB2 tables, COBOL II, FORTRAN, EZTRIEVE, QUICKJOB, ASSEMBLER, FOCUS, FOCEXECS, DB2, IMS, and SQL/DS
• Migrated DB2 objects sub - system to subsystem, create databases, tablespace, views, synonyms, table spaces, indexes, etc.
• Wrote utilities to count datasets (application programs, DB2, and applications.
• Wrote utilities to move and convert datasets from VM to MVS, PC s, UNIX (Solaris), and IBM DB2 UDB (AIX) RS 6000. (Utilities written in Rexx, Java, COBOL DB2 UDB, DSN1COPY, Unix Shell scripting)
• Wrote test plans, implementation plans and documentation capabilities
• Hired to replace the original five developers in a Prudential down sizing and out source effort and assigned to the system to replace original developers
• Performed the design and the programming to enhance the CRMS (Client Request Management System) a system used tracking calls used by Customer Service Specialist (CSS) and to log customer calls into a DB2
• Wrote detail specifications and assisted in the DB2 design of a 12 table database and performed system analysis, developed user requirements, programming of adhoc reports and queries, and production support using CICS, DB2, COBOL II, VSAM REVOLVE and QMF

DB2 DBA / ARCHITECT

Confidential

Responsibilities:

• Performed application DBA functions at Confidential on the record management for 40K accounts system using Sunguard s 401K record management software provides 24 hour support
• Performed analysis and programmed the ST file compaction system in an effort to allow for more diversity across all sub - systems and companies using various DB2 utilities and CICS, COBOL II and VSAM
• Convert the 12 Federal District Software Systems into one system to execute at the New York District computer systems included: fedwires, funds transfer, government securities, remote logging, recreate site, startup systems, and audit log
• Performed application DBA functions DBD gens and PSB gens
• Used IMS (DB/DC) Fath Path DEDB and MSDB, DB2 GSAM databases and Cobol and performed systems analysis, wrote programs to generate various banking reports.

Independent Consultant

Confidential

Responsibilities:

• Rehired to perform tax reporting enhancements for The Corporate Trust Securities, developed an Online securities processing, and to clone parts of an existing system for an IVR (Interactive Voice Response) system for securities processing using CICS, IMS (DB/DC) and VSAM
• Rehired to standardize