Steve Sandonato Email & Phone Number

Hines, Il

Process change order requests from developers nationwide with the goal of increasing user functionality and data accuracy in an 11 TB corporate database.

Aurora Il

• Installed/upgraded ERP application server software on Windows Server 2008. • Applied patches to ERP application server software and database objects.• Worked with development team and business users to test upgrade.• Supported development team during CRP testing.• Developed and implemented a database backup strategy using Oracle RMAN.• Rebuilt the Oracle 12c database/instance during the ERP upgrade process. • Reviewed Oracle initialization parameters and implemented changes that dramatically improved database/application performance.

Norhtbrook, Il

Allstate Insurance – Consultant Senior Programmer Analyst• Design, develop, and implement application back end changes for financial and billing applications.• Provide business partners with ad-hoc reports per request.• Work with team members and business partners to resolve production issues in a timely manner.

Oak Brook Illinois

Senior Programmer Analyst • Application technical lead for Oracle 10g upgrade project. Designed, coded, and implemented major enhancements that allowed the application to take advantage of various new features in Oracle 10g.• Developed and implemented data interface processes from legacy Oracle databases to a new Oracle application suite. The client area used the legacy data to make informed and timely decisions on restaurant development projects.• Modified mainframe menu item data file interface from a manual/FTP process to a messaging based solution. This eliminated the need for the business area to enter this data manually.• Provided 24 hour application production support for mainframe and PL/SQL applications.• Served as liaison between application teams and infrastructure outsourcing company to ensure software and hardware upgrades did not adversely impact the business applications.Database Administrator • Installed and upgraded Oracle database management system software.• Monitored and maintained in-house data movement application.• Tuned Oracle and mainframe DB2 applications to ensure optimum performance.• Provided 24-hour production support for Oracle and DB2 databases and applications.• Automated several manual DBA tasks which allowed DBA team members to focus on mission critical projects and tasks.• Provided development DBA support. Created and implemented objects on Oracle and DB2.

Bs, Computer Science

Education record

Education record