SUMMARY

• Associate Vice President, Senior Database Architect with 39 years in IT, and having extensive management/hands - on experience in Amazon Web Services (AWS), Big Data Frameworks, Database Architecture and Design, Performance Tuning, Data Warehousing/Business Intelligence, High-Availability Disaster Recovery. Proven ability to achieve results, coordinate technical teams, develop and implement IT strategies to realize business objectives. Demonstrates exceptional organizational, technical and customer relationship skills.

TECHNICAL SKILLS

Cloud Technologies: Amazon Web Services (AWS) - EC2, ECS, S3, Glacier, CloudFront, RDS, DynamoDB, VPC, VPN, Route53, Direct Connect, Lambda, IAM, CloudWatch, CloudTrail, AWS CLI, SQS, ELB/ALB for Microservices.

Operating Systems: z/OS (Mainframe), AS/400 (Mid-Range), Linux, Unix and Windows OS.

Database Management Systems: DB2 for z/OS, ORACLE, MS SQL Server, PostgreSQL, DB2/LUW.

In-Memory Engines/Streaming: SparkSQL, Kafka, Storm, Kinesis, Presto, Redis, Memcached

Data Warehousing: Confidential, IBM DB2 Analytics Accelerater (IDAA), SnowflakeDB, RedShift.

Web Servers: WebSphere Application Server, Apache Tomcat.

Integration Tools: Informatica, MS-SSIS, AWS Data-Pipeline, AWS Glue.

Automation: Puppet, CloudFormation, Terraform, Opsworks.

Programming: SQL, PERL, COBOL, HTML, Unix Shell scripting, REST, XML

PROFESSIONAL EXPERIENCE

Confidential - Owings Mills, MD

Associate Vice President, Senior Database Architect

Responsibilities:

• Working with the Architecture and Window Infrastructure Services groups, developed the AWS EC2 instance process to extract log files from RDS databases to Amazon S3 for ingestion into SPLUNK, for enhanced RDS instance monitoring.
• Assists Microsoft Azure DBA’s in understanding and using AWS services.
• Working in AWS regions (Dev, SIT, Stage and Prod) through approved channels (i.e, Vagrant Desktop, GitHub Repos, Jenkins CI:CD and Terraform scripts to standardize RDS database creation and maintenance.
• Researched and developed strategy to move DB2 z/OS mainframe data to AWS cloud-based persistent storage, or “Data Lake”, Recommended POC for Attunity Cloudbeam and Replicate products keeping on-premise mainframe DB2 Warehouse data in sync with Amazon Redshift warehouse.
• Created proposal for TRP acquisition of the CENTRIFY Direct Control for DB2 software for strategic alignment with Microsoft’s Active Directory enabling centralized identity management. The product was procured in Jan. 2017, and I am currently leading teams across 3 technical domains for enterprise-wide deployment using Puppet.
• Provides hands-on support for IBM Sterling File Gateway for TRP managed file transfers, and working with MTS staff resolved major issues with SFG database purge process failures, correcting out-of-space conditions, and improving file transfer performance throughout the SFG environments.
• Created new ODBC-JDBC driver technology using XML that enables clients (Adobe Campaign MMO, Prospectus E2E, Retail Metrics and Discount Brokerage applications) to leverage the IBM DB2 Analytics Accelerator appliance. I deployed the new driver technology across 30+ TRP servers that include: Business Objects, MicroStrategy, QlikSense, and Alteryx.
• Guided the construction and deployment of the new Enterprise Content Management environments at TRP, coordinated teams across technical domains (WebSphere, DB2, AIX) and business verticals, with vendor interaction as required. Led TRP staff and IBM consultants in resolution of the Content Management Integration Services (CMIS) performance issues for proposed integration with Alfresco.
• Provides hands-on support for LDAP on Linux servers that include troubleshooting, performance tuning, migrations and upgrades.
• Provides subject matter expertise and guided the MTS deployment of DB2 Connect servers across new Informatica Linux machines accessing DB2 z/OS production data. Troubleshoots Informatica processing failures and performance issues impacting delta uploads to Salesforce, WebSphere processes, and ad-hoc users.
• SQL tuning, database optimization and object creation as required.
• Working with teams across business verticals on server decommissioning efforts.
• QUEST FOGLIGHT V5 installation, configuration and administration in AWS on EC2 instances (POC).

Environment: DB2/UDB (z/OS and LUW), SQL Server, Linux, z/OS 1.9, AIX, IBM DB2 Analytics Accelerator

Confidential - McLean, VA

Lead Information Systems Engineer

Responsibilities:

• Confidential PoC and Evaluation of 8150Z Series performance and throughput of multi-terabyte data warehouse applications. DBMS, System and Storage Array support and Internals.
• Classified: TOP SECRET Evaluation and assessment of the Internal Revenue Service’s ORACLE 10g and EMC Symmetrix DMX Systems Architecture and Database Design for the Electronic Fraud Detection System (EFDS) supported by the Computer Services Corporation ( Confidential ).
• Performed the Confidential Security Audit on the Centers for Medicare and Medicaid Services DB2/UDB environment resulting in discovery of 2 security holes requiring correction.
• Evaluation of the TM1 real-time OLAP tool from the Confidential Corp.
• Apache Tomcat, Java Servlet and JavaServer Page (JSP) development.
• Coordination and implementation of OLAP reporting tools under evaluation by the CEM Business Operations and CEM IT Services team. Performs Data Modeling for OLTP and OLAP processes.
• ORACLE and MS SQL Server Data mart/Warehouse Development and Support
• Provides expertise on CEM Business Intelligence (BI) and Business Performance Management (BPM) initiatives

Environment: DB2/UDB ESE and DPF, ORACLE 10g, SQL Server 2005, UNIX

Confidential - Chevy Chase, MD

Lead DB2 DBA (Consultant)

Responsibilities:

• Migration of Confidential Legacy Data Warehouse from INFORMIX to DB2/UDB v8.2
• DB2 Data Partition Facility (DPF) 10 Node administration
• SAS Script Conversions from INFX to DB2
• Mainframe to UNIX Data Transfers
• DDL Conversions using the IBM Migration Toolkit (MTK) for INFX
• Conversion of SQL SERVER DTS Packages from INFX to DB2
• Korn Shell and PERL Scripting
• Oversees and provides guidance to junior DBA’s
• Leading DB2 Federation Proof-of-Concept at Confidential

Environment: DB2/UDB ESE v8.2, Informix, ORACLE 9i, SQL Server 2000

Confidential - New York, NY

Data Warehousing Specialist (Consultant)

Responsibilities:

• Migration of Confidential Data Warehouse from ORACLE 9i to DB2/UDB v8.1.
• ORACLE PL/SQL/DB2 SQL Conversions, SQL Performance Tuning
• IBM Migration Toolkit (MTK) utilization.
• Sybase to DB2 UDB data/application migration and conversion.
• Support for 10-node Data Warehouse on UDB EEE v7.2 system.
• DB2 UDB system upgrades from v7.2 to v8.1.
• Support for PeopleSoft HRMS and Financial systems on DB2 UDB/Oracle.
• Oracle system upgrades from v8.0 to v9.2.
• DB2 UDB and Oracle Capacity Planning.

Environment: Windows 2000, Solaris, AIX, DB2 UDB 7.2, DB2, ORACLE 9i, SYBASE

Confidential - Mechanicsburg, PA

Senior Database Administrator

Responsibilities:

• Data Modeling/ERD, Reverse Engineering and STAR Schema Development.
• DTS Package Creation and ETL Process Development.
• Cube Architecture, OLAP Analysis and WEB Tool Design.
• Apache Tomcat, Java Servlet and JavaServer Page (JSP) development.
• Security, monitoring, support and maintenance of corporate DBMS platforms.
• Development of Backup/Recovery Procedures, Performance Tuning and High Availability
• Integration of SQL Server 2000/Windows 2000 and EMC Symmetrix Storage Area Network (SAN).

Environment: EMC Symmetrix ICDA 8730, OS/400, HP-UX, Windows 2000, SQL Server 2000, ORACLE 8i, DB2 7.2

Confidential - San Francisco, CA

VP, Manager of Database Engineering/Systems

Responsibilities:

• Managed DBA resources (FTE or Contractual) for E-Commerce brokerage applications.
• Evaluation SProCT, DB2 UDB EE/EEE, Spotlight/Navigator for corporate business purposes.
• Implementation of HA capability for DB2 UDB (VERITAS Cluster/SUN Cluster 2).
• Led migration from SYBASE to DB2 UDB EE as Corporate DBMS platform for new systems.

Environment: Windows NT 4.0, SOLARIS 2.6, S/390, SYBASE, DB2/UDB

Confidential - Landover, MD

Senior Database Administrator

Responsibilities:

• Managed IDMS/DB2 environments and data for COMDISCO Disaster Recovery strategy.
• Maintenance of DB2 Data Sharing Groups for MVS/ESA Parallel SYSPLEX operation.
• Developed/maintained Economics Data Warehouse using SYBASE ADAPTIVE SERVER IQ.
• Implemented and managed the Confidential Database Middleware Architecture.
• Developed PowerBuilder and Microsoft Access apps to test DBMS Middleware capability.
• Managed DARS software for conversion of IDMS network records to DB2 table structures.
• Implementation and administration of the TACT ADSO/DB2 INTERFACE (VEGA 90’s).

Environment: MVS/ESA, Windows NT 4.0, Windows 95, IDMS 12.0, DB2 v 6, MS SQL Server 6.5, SYBASE ASE 11.9.2