Uploaded File
Jo
hawkman2k@gmail.com
973-362-8385
Succasunna, NJ 07876
DBA and System Support Specialist
21 years experience W2
0
Recommendations
Average rating
28
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
DBA and System Support Specialist
Consumer Goods
Jan 2006 - Apr 2020

Application Admin/DBA: Axway Secure Transport, Tomax, Accpac, Vertex, Amber Road
ETL Tools: Tomax Utilities, Unix Shell, SQL, PL/SQL, Axway Secure Transport(Tumbleweed)
Sources: Tomax, Oracle Financials, Accpac, SAP, Data warehouse

Contributions:

  • Axway Secure transport:
    • Took over support when the system had 1000s of failures or retries a month and tuned to become a dependable Application. Zero failures and a handful of retries
    • Developed a monitor that would alert support if an expected file transfer DID NOT occur
      • Enhanced to include User emails transfer results positive or negative
      • Attached files to email and send to the user community
    • Created MY-SQL scripts for transfer metrics over time, down to the hour granularity
    • Led efforts to migrate Axway to new Data Center
    • Led efforts to upgrade to latest release and new Architecture
      • Studied MYSQL internals to resolve
        • Volume testing issues
        • Developed and tested Database back up strategy(including DR) without hot backups as BMC did not want to purchase license for the tool
  • Vertex
    • Loaded Monthly files
    • Led Upgrade from Vertex 6 to 8
    • Found Hosting groups SQL-Server Backups where taking 6 full backups and only 1 log backup a day. Reverse of what was intended.
  • Amber Road
    • Backup and DBA duties
    • Found Oracle Database Corruption upon move to a new center that could have otherwise allowed a corrupt database to become the Production instance
    • Found That Oracle Redo logs created by application install were not Multiplexed
  • Streamlined and Scaled Tomax Retail system and Accpac Ledger Conversion
    • Automated Site Setup
    • Created Metadata Repository
    • Automated Tomax ledger jobs
    • Developed SQL-SERVER scripts to Clone Accpac Companies and site
Axway Database Backups DBA MySQL Oracle SQL SQL Server UNIX Data Center Volume Testing Metadata Data Warehousing SAP
Remove Skill
Data Warehouse DBA
Telecommunications
Jun 2005 - Jan 2006

Environment: HP, Solaris, Informatica, Cognos, Oracle

Contributions:

  • Hired to as an Oracle Developer to create reports for Avaya’s Maintenance Contracts Star Schema warehouse.
  • The reporting database went through the current inventory star and to various SAP tables to follow documents through the supply chain. This project turned out to have over 80 tables and corresponding Unix jobs to load them
    • Designed Reporting friendly database.
    • Created the first Unix shell-based subsystem to create inventory/supply chain reports
    • Provided templates for Kshell jobs for rest of team
Cognos Data Warehousing DBA Informatica Oracle UNIX SAP REST Database Maintenance Solaris Star Schema
Remove Skill
Senior Oracle DBA (USMC Data Warehousing Team)
Chemicals/Pharmaceuticals
Aug 2001 - Apr 2005

Environment: HP-Unix, Oracle, Informatica, Microstrategy, Business Objects

Performed all end-to-end activities that are common in a highly complex IT environment (150+ databases, 40+ applications). Received a Bravo and Bravo Plus Awards.

  • As a Senior DBA, led the data team in completely porting and migrating all database applications from 7.3.4 to 8i Oracle environment. This included setting up true development, test, and production environments. Earned the Bravo Plus award for this achievement.
  • As Senior DBA, led ETL and reporting teams during Full SDLC for the Eplerenone data warehouse. This resulted in a successful roll-out of this new environment. Earned the Bravo award for this achievement.
  • Enabled star joins and Materialized views which allowed the Oracle optimizer to actually query a summarized view even if a query was originally directed to 100 million row transaction table.
  • Managed multiple projects that involve modeling, developing, and implementing enterprise-class applications for a zero-defect tolerance environment.
  • Designed, developed, and implemented optimal and scalable processes that support day-to-day operations of a rapidly growing enterprise database environment (150+databases,
    4 DBAs and 2 Architects).
  • Responsible for the Erwin Model Mart based Entity Relationship physical model for multiple projects. Used Erwin to monitor certify test database mirrored production.
  • Did logical and physical design to create star schema based on doctors' responses to questionnaires.
  • Responsible for infrastructure initiatives that assist database administrators group in refining database security, support, and monitoring procedures and improve the overall productivity of the team. This included the development of home-grown DB monitoring utilities to pro-actively monitor all database availability, responsiveness, and disc space available.
  • Simultaneously provided uninterrupted production support services on several databases; migrated/upgraded databases; developed and tested back up and recovery strategies on a regular basis.
  • Provided 24x7 on-call support to various kinds of critical Sales and Marketing production applications that serve several customers and corporate and external users.
Data Warehousing DBA Erwin Data Modler ETL Informatica MicroStrategy Oracle Production Support Star Schema
Remove Skill
Application DBA
Chemicals/Pharmaceuticals
Jul 1998 - May 2001

Environment: Sun Solaris, Oracle 9i-11g, Tomax, Oracle ERP, Accpac
Front End Tools: Tomax
ETL Tools: Tomax Utilities, Unix Shell
Sources: Tomax, Oracle Financials, Accpac

  • I was hired as an Application DBA to Re-Engineer the processes to load the warehouse to accommodate the new SAP sources. ETL, data analysis. Conversion to Oracle/Unix re-engineering to SAP sourced data. Took Informatica class to better support the ETL team. Worked with Finance and Sales and Marketing Dept.
  • Based on users' requests, instituted a Virtual Book Close subsystem in our warehouse to allow users to balance sales results vs Ledger line items, that before was not included in the data model.
  • After a Warner Lambert team took several months trying to resolve minor inbalances between the Ledger and the warehouse and after a 15 million dollar out of balance situation arose, I asked the warehouse Director if I could take charge of the matter and should be able to find the issue in under a week. As promised, I found the issue in under 5 days. After meeting with Finance dept, SAP team and Staging group I identified the bug. I then also wrote the PL*SQL fix for the staging team and the ZAP to fix the warehouse data.
DBA Oracle UNIX Solaris SAP Oracle Financials Informatica ETL ERP Data Analysis
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Attended in Programming
Chubb Institute
Record has not been verified.
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
SQL
2020
14
SQL Server
2020
14
Volume Testing
2020
14
Informatica
2006
7
ETL
2005
6
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