SUMMARY:

• Over 20 years of experience in Information Technology. Areas of specialization include: Data Engineer, AWS Migration, Project Management, Confidential 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, Confidential Z/OS, OS/390

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

DATABASE: Confidential UDB DB2, MongoDB, Oracle, Sybase, SQL Server, CICS, and SQL/DS

PROFESSIONAL EXPERIENCE:

Confidential

DATA ENGINEER

Responsibilities:

• 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
• Data Engineered extract collection / extract, transform, load (ETL) and store data into big data and RDBMS structures for visualization used mongorestore tool to restore specific databases and collections, restore data from one collection and database to another, and to create a new MongoDB replicate node. used mongodump tool to take backups MongoDB databases and collection ised mongostats to monitor replication lag of nodes in a replica set monitored long running operations using db.currentOp( ) and killed long running operation using db.killOp( ) checked disk I/O usage using iostats and mongoperfand db.serverStatus to get an exhaustive list of metrics used mongoimport and mongoexport tools used mongotop to determine timespent reading and writing data
• Initially Contract to Hire
• The Confidential 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, import, alter, explains
• Tuned DBM CFG, DB CFG, and Registry Parameters
• SQL tuning, import & exporting, loads and data movement
• Production support 24/7 on call rotation
• Optim Performance Monitoring
• Oracle Goldengate 12c (converted tables to / from Oracle to / from DB2)
• AWS setup & configuration of databases on EC2 servers
• Configure and deploy application storage, database storage, data backup, data archiving, and disaster recovery solutions
• 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:

• Assigned to the one of Confidential ’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:

• Confidential UDB DB2 Database Administration
• Assigned to the Confidential 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

CONSULTANT - SAVTIRA Data Architect / DBA

Confidential

Responsibilities:

• Confidential UDB DB2 V9.5 to V9.7 Upgrade
• Confidential 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

Confidential

Data Architect / DBA

Responsibilities:

• Confidential 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

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
• Confidential InfoSphere modeling tool

Data Architect-DBA

Confidential

Responsibilities:

• 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

Data Architect - DBA

Confidential, Florida

Responsibilities:

• Supported & Design Confidential 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
• Confidential 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
• Confidential Performance Monitor / SQL tuning

Data Architect - DBA

Confidential

Responsibilities:

• 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
• Confidential 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 names technology (using the Z/OS DB2 Catalog Communications Database) to access UDB Linux V9.1
• Set-up HADR (high availability disaster recovery)

CONSULTANT

Confidential

Responsibilities:

• Hired as a consultant to migrate 80 databases from Sun 15K Solaris to Sun 6800 Solaris Confidential Replication Version 8
• Hired as a consultant to develop I2 Technologies DB2 UDB AIX / Linux databases in single & multi partition (EEE /DPF) environment
• Design and created database objects for Merchandise Planner, Demand Manager, Promotion Optimizer, Replenishment Planner and Profile Manager sub-modules.
• Design/Develop/Size Informatica Staging/DataWarehouse/Datamart repository database
• Installation of DB2 UDB Server and Client Version 8.1 / 8.2
• LDAP Database
• Created databases, bufferpools, tablespaces, tables, indexes,
• Executed UDB utilities, reorg, reorgck, runstat, load, export, import, alter, explains,
• Tuned DBM CFG, DB CFG, and Registry Parameters
• SQL tuning single partition and multi partition
• Design backup, restore strategy (Disaster Recovery Plan) Tivoli Storage Manager(TSM)

DB2 UDB DBA DBA / ARCHITECT

Confidential

Responsibilities:

• Position required security clearance.
• Created databases, bufferpools, tablespaces, tables, indexes,
• Design fail system using HACAMP / HADR.
• Executed Confidential 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:

• 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:

• 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 Confidential 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
• Confidential Replication Version 8

DB2 UDB DBA/ARCHITECT

Confidential

Responsibilities:

• 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, Confidential 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 Confidential 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

DB2 UDB DBA ARCHITECT

Confidential

Responsibilities:

• Performance and tuning, volume stress testing, and performed capacity planning, drafted test plan, and automated the increase the volume of data
• 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.
• Performed physical Management of DB2 UDB objects, data structure and physical makeup of tables and upgrades / installed DB2 add - on software package ( Confidential 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 Confidential 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