Jo
hawkman2k@gmail.com
973-362-8385
Succasunna, NJ 07876
DBA and System Support Specialist
26 years experience W2
0
Recommendations
Average rating
177
Profile views
Summary

  • For the last 3 years, I have been the DBA/Application Admin for Axways Secure Transport for Benjamin Moore.
  • When I took over Secure Transport had a reputation as a “problem” application. There were literally thousands of failures and or retries every month. Within 6 months after quantifying the issues, tuning Secure Transport and having both internal and External partner tune their destination servers for the volume, Secure Transport became one of the most stable applications in our Enterprise.
  • Being a DBA, I also took the time to learn the data model and created scripts to get summarized metrics down to hourly granularity by account, subscription, and file type. I also monitored and tuned the queries and the MySQL database itself so as not to interfere with transfer processing.
  • I led the 5.2.1 Secure transport migration to a new Data Center last year and upgrade to 5.4 this year. After studying MySQL database internals, I tuned the MySQL database after experiencing 1 hr delay in processing 5 concurrent transfers of 8,000 files each.
  • Performance tuning is part of any DBA’s DNA, so that attribute will be helpful in the Performance Test Engineer position. I recently developed a database restore in a Disaster Recovery scenario (fresh database). I also developed a suite of Linux utilities that would monitor and send emails to the proper partners for missing transfers as well as successful ones. An enhanced version also attached the transferred file to our Partners.
  • I have experience with all phases of software development. It also has required that I interface with all groups within the enterprise. These groups include end-users, business analysts, data modelers, system administrators and architects, vendors, ETL development groups, web groups and reporting groups.
  • I have been involved in developing standards and strategies in areas such as data conventions, data and database standards. I also have been involved in managing change control and developing Software Development Lifecycle standards.

Disciplines & Technical Skills

  • Databases: Oracle 10&11g, 9i 8i & 7 w/parallel server experience, MySQL, SQL-Server, Teradata, Sybase
  • Operating Systems: UNIX, RedHat 6.5, MVS
  • Languages: Unix shell, C(some), PL1, COBOL, JCL, SQL, PL*SQL,
  • DB Tools: Oracle Enterprise Manager, Toad, Spotlight on Oracle, Desktop SQL-Server Management Studio, MY-SQL Workbench
  • Modeling Tools: Erwin/Model Mart
  • Front End: SAP, Business Objects, Micro Strategy, Crystal Reports, Holos, Cognos Powerplay and Impromptu
  • ETL Tools: Informatica Environment
  • Office Tools MS Office, MSProject, MS Access, PowerPoint, Visio

Experience
Education
Attended in Programming
Chubb Institute
Certifications
Certificate of Programming
Skills
DBA
2020
21
Oracle
2020
21
Data Warehousing
2020
18
SAP
2020
17
UNIX
2020
17
Axway
2020
14
Data Center
2020
14
Database Backups
2020
14
Metadata
2020
14
MySQL
2020
14
PL/SQL
2020
14
SQL
2020
14
SQL Server
2020
14
Volume Testing
2020
14
Informatica
2006
7
ETL
2005
6
Warehouse
2006
5
OPTIM
2005
4
Star Schema
2006
4
Erwin Data Modler
2005
3
MicroStrategy
2005
3
Production Support
2005
3
Solaris
2006
3
Data Analysis
2001
2
ERP
2001
2
Oracle Financials
2001
2
Applications Architecture
0
1
Business Analysis
0
1
Business Objects
0
1
C
0
1
Capacity Planning
0
1
Cobol
0
1
Cognos
2006
1
Crystal Reports
0
1
Data Analytics
0
1
Data Modeling
0
1
Database Maintenance
2006
1
Disaster Recovery
0
1
Email Campaign
0
1
GSAP
0
1
HP
0
1
Impromptu
0
1
JCL
0
1
jQuery
0
1
LAN
2020
1
Linux
0
1
Microsoft Office
0
1
Microsoft PowerPoint
0
1
MS Access
0
1
MS Project
0
1
MS Visio
0
1
Oracle J Developer
0
1
ORMS
0
1
PC Software
0
1
Performance Testing
0
1
Performance Tuning
0
1
PL/1
0
1
PowerPlay
0
1
RedHat
0
1
REST
2006
1
SDLC
0
1
Shell Scripts
0
1
Sybase
0
1
Teradata
0
1
TOAD
0
1
Workbench
0
1
Awards
AT&T Ace Division Team Award - DBA, 2020
Pharmacia Bravo: Eplerenone CFM Mart, 0
Pharmacia Bravo Plus: Insight Project Genesis, 0
Benjamin Moore: Group Applause awards for Tomax Axway, 0
Individual for Customer Centricity and Technical Acumen, 0