Steve Hamer
About Steve Hamer
Steve Hamer is a Database Services Manager at Alight Solutions with extensive experience in database administration and performance tuning.
Current Role as Database Services Manager at Alight Solutions
Steve Hamer is currently employed as a Database Services Manager at Alight Solutions in Lincolnshire, IL. In this role, he oversees the database services operations, ensuring the effective management, tuning, and optimization of various database systems. He applies his extensive expertise in database management to maintain and improve the performance and reliability of database services.
Extensive Experience at Aon Hewitt
Steve Hamer has had a long and diverse career at Aon Hewitt, where he held various positions, including Senior Oracle DBA, Night Printer Operator, OS/390 DB2 Database Administrator, and Senior UNIX/Linux DB2UDB/Informix Database Administrator. His roles spanned from 1989 to 2017, showcasing his proficiency in database management and his ability to adapt to different database environments and technologies.
Specialized Knowledge in Database Systems and Tools
Steve Hamer has specialized expertise in a wide array of database tools and systems. His skills range from performance tuning across SQL, application, operating system, and network layers to managing hardware platforms including SUN, Fujitsu, Dell, and IBM Blade. He is proficient in using database tools such as backup, restore, reorg, runstats, load, export, import, db2look, db2move, db2pd, and reorgchk, as well as operating system tools like sar, iostat, prtdiag, and vmstat.
Achievements in Database Management
Throughout his career, Steve Hamer has led several critical database management projects. He designed and implemented three Oracle X5-2 Oracle Database Appliances (ODAs) and managed the migration of PeopleSoft HRMS from Informix to UDB. He also led the standardization of database servers, layouts, designs, scripts, and disk configurations, and was responsible for the IBM Smart Analytics System 5600. Additionally, he successfully managed the transition of DB2 environments from 32-bit to 64-bit for data warehouses.
Proficiency in Programming and Multiple RDBMS
Steve Hamer is skilled in various programming languages, including DB2 CLI, PL/SQL, Unix Shell scripting, perl, and JCL. He has experience with a multitude of RDBMS, such as DB2, SQL Server, Informix, and Oracle. His extensive knowledge in these areas allows him to efficiently manage and optimize database operations and applications across different systems.