JOHN DAVID ADAMSKI
Lamoni, IA
641-784-6712
jda1@grm.net
https://www.linkedin.com/in/john-david-adamski
Relevant Experience
Over thirty years of IT experience ranging from programming to administrating datacenters. Extensive experience with databases design and management. Manage servers, storage, fiber switches and other devices in data center. Have worked on a large international system as Analyst, Project Lead and DBA in the Auto industry. Main person responsible for virtualizing majority of current employer's infrastructure and prepping for migration to DCaaS. Also implemented phase 1 of VDI at current employer. Budget restraints have postponed the remaining phases of VDI.
Experience Highlights
• Data Center and System Administrator ▪ Graceland University ▪ Lamoni, IA May 2001 – Present
Hardware: HP BL & DL series OS: Windows Server, SUSE/Opensuse, HPUX
Database: Informix, MS SQL Server Software: VMWare vSphere & Horizon View, Jenzabar CX & JICS
Backup/Recover: Unitrends, Data Protector, Veeam
Systems Management of Jenzabar CX systems by installing SMOs (System Modification Order) or PAs (Product Alerts) and then reviewing the changes with the area specialist and make any localization's that are needed.
VMWare Administrator of the VMWare VSphere and Horizon View software and hosts. Troubleshoot problems that arise, add/delete VMs as needed and monitor health of infrastructure.
Database Administrator of the Informix database and all SQL Server databases, do table maintenance and monitor performance.
DataCenter Manager, Manage, maintain and troubleshooting anything involved in the data center from changing lights to installing new equipment. This also includes managing the fiber network and backup systems.
• Business Process Engineer ▪ Volt Integration Solution Group ▪ Colorado Springs, CO December 1999 – January 2001
Document current processes. Talk with individuals involved in a process and develop a flowchart describing the process.
Document new processes. Work with individuals or groups involved in the process and develop a flowchart describing the improved process.
Enhance and facilitate the reduction of bottlenecks in processes. Guide individuals or groups in identifying bottlenecks or other obstructions for a smooth flowing process.
Meeting and problem resolution facilitator, help the groups of teams have productive meetings and meet their goals.
• Systems Analyst/DBA ▪ Ford Motor Company ▪ Dearborn, MI 1996 – 1998
Hardware: HP3000 Database: TurboImage Software: TRANSACT/3000, Adager, Librarian.
Researched and created resource allocation proposal for Year 2000 project. Reviewed all information gathered on the changes needed to the Hourly Personnel System, all literature on ways to resolve the Year 2000 issues and what was required to be Year 2000 compliant. Then identified six options to resolve the Hourly Personnel Systems year 2000 issues. Wrote proposal for resources with a primary and secondary option identified and all six options explained for management review and for management approval of option recommended.
Identified all data elements needed and source of data. Researched all data elements in the Hourly Personnel Systems for date fields not Y2K compliant, then identify the source of the data (i.e. another task, screen input, outside data feed, etc.), then identify all programs that use these data elements and whether there is data input, logic or database changes required for each of the 1250 programs. Then develop resource allocation proposal as described above.
Review and evaluate HP Operating System upgrades and HP's Y2K patches. Review operating system upgrades then report impact to the project members with work around and other solutions. Develop a migration plan from MPE classic to MPE Native mode.
Analyzed project problems and developed options for resolution.
Assist when needed with day-to-day maintenance program changes and correcting program bugs.
• Lead System Administrator and Conversion Specialist ▪ Ford Motor Company, Dearborn, MI 1992 – 1998
Hardware: HP3000 Database: TurboImage Software: TRANSACT/3000, Adager, Data General.
Database Administrator Defined, designed and supported database for the Component Divisions Purchasing System, which consisted of 8 IMAGE databases that needed periodical maintenance and changes to meet new requirements. These new requirements could have been governmental, corporate and / or business derived.
Converted Material Supply System from legacy system to new database. Ford enhanced one of their Purchasing Systems to be the Global Purchasing System; I defined, and designed the programs to extract data from my system to be loaded to this global system. Also, assisted in the definition of changes needed in the Global Purchasing System to accommodate the uniqueness of the Component Divisions. After the data was extracted, loaded and the users where using the global system, was responsible to archiving the data and programs of the old purchasing system.
Liaison between systems department and worldwide end-users. Help in prioritizing all needed enhancements and coordinate the conversion from the local system to the global purchasing system.
• Project Leader/Sr. Systems Analyst ▪ MIS International contract to Ford Motor Company ▪ Dearborn, MI 1985 – 1992
Hardware: HP3000 Database: IMAGE & TurboImage Software: TRANSACT/3000
Wrote, maintained and upgraded 480+ programs. The Purchasing System 5 billion dollars' worth of purchase orders for Ford's Component Divisions. As Project Leader I managed the team of programmers and analyst who maintained, enhanced and changed to meet customer requirements, automation initiatives and governmental and/or corporate regulations.
Design, maintained and upgraded 8 IMAGE databases holding Purchasing's data. Completely designed four of the databases and made major design enhancements to the other four. All eight databases had numerous enhancements to accommodate changes in the business practices. There were a few changes needed due to operating system or database upgrades.
Designed and implemented bridges to corporate IBM systems. Design and wrote programs to extract data from the IMAGE databases and electronically transfer them to a flat file on one of the corporate IBM mainframes for processing by a corporate system (i.e. accounting payable system).
Converted two Ford's Automotive Component Divisions to newer database with a system that tracked $5 billion. Design, wrote and tested programs on the HP to load extracted data from old Honeywell systems to the Purchasing's IMAGE databases.
Education
Graceland College Bachelor of Science Computer Engineering and Computer Science Lamoni, IA
Objective
Being hired in a full time or long-term contact position as a team leader or supervisor. Open to overseas positions.
Skills
Databases: Informix, SQL Server
Operating Systems: Windows Server, VMWare vSphere & Horizon View, SUSE/Opensuse
Back Up: Unitrends, Data Protector, Veeam
Storage: 3PAR, Buffalo NAS
ERP: Jenzabar CX, JICS