Scott Leone work email
- Valid
- Valid
Scott Leone personal email
Experienced Senior Database Administrator Team Lead with a demonstrated history of working in the manufacturing industry. Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solution Development (MCSD). Skilled in Software Architecture, Database Architecture, SAP ERP, SAP Business Warehouse (SAP BW), SQL Server Databases, Enterprise Software, and Business Intelligence (BI). Strong information technology professional with a Bachelor of Science (BS) focused in Computer Science from Governors State University.
-
Senior Database AdministratorHorace Mann Jul 2020 - PresentSpringfield, Il, Us -
Database Team Lead / Architect / Data EngineerTate & Lyle May 2016 - Jul 2020London, England, Gb• Microsoft SQL Server DBA team lead for the SAP ERP, APO, CRM, and BW database system (18 TB of production data) using mirrored SQL Servers for high availability and log shipping for disaster recovery.• Manage DBA team.• Architected enterprise reporting and analytics data warehouse in Azure.• Created RPA UIPath architecture.• Microsoft SQL Server DBA for 120 SQL Servers and 2500 SQL databases.• Maintain backups of production, test, development, and training databases.• Create corporate SQL Server standards for database encryption, backup encryption, data masking, and security standards to meet GDPR security compliance.• Create corporate SQL Server installation standards which include server settings, SQL Server settings, storage layout, and common maintenance jobs. • Refresh test, development, and training databases with production data when needed.• Monitor and performance tune databases up to 7.5 TB in size.• Debug complex T-SQL stored procedures and triggers.• Work with application teams to create proper indexing and SQL code for optimal performance.• Manage SQL Server capacity requirements and planning.• Manage licenses for the SQL Server inventory.• Manage the testing of backups to ensure Service Level Agreements are met.• Upgraded SAP databases from SQL Server 2008 R2 Enterprise to SQL Server 2014 Enterprise.• Managed the migration of numerous databases from SQL Server 2000 to newer versions.• Work with SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005, and 2000 in a Mirrored, Log Shipped, SAN, VMware, and Azure environment.• Patch the SQL servers, web servers, and application servers on a monthly basis. Apply critical updates.• Manage incident and change requests using ServiceNow for the DBA team.• Work on large SAP upgrade projects performing the DBA lead role.• Perform quarterly audits of Critical SQL Servers.• Installed SQL Servers in Azure and configured log shipping to Azure.• ITIL Certified in 2017. -
Sr. Database Developer / DbaSourcelink Jan 2015 - Apr 2016Itasca, Il, Us• Microsoft SQL Server DBA and SQL Developer for the TSC marketing database system (3TB of data) using clustered SQL Server 2008 R2 servers.• Microsoft SQL Server DBA and SQL Developer for the Aarons marketing database system (1TB of data) using SQL Server 2014 servers.• Architect, design, and implement Business Intelligence cubes.• Perform complex address and name matching for marketing mailings with SSIS and SAP Business Objects.• Create numerous marketing campaigns based on complex requirements.• Create many SSRS (SQL Server Reporting Services) and Cognos reports.• Create many SSIS (SQL Server Integration Services) packages and SAP Business Objects jobs to import and export data between systems.• Maintain backups of production, test, development, and training databases.• Refresh test, development, and training databases with production data when needed.• Use SQL Server backup compression during database backups.• Monitor and performance tune databases.• Debug complex T-SQL stored procedures and triggers.• Quickly create T-SQL queries to provide data to end users.• Work with SQL Server 2014, 2008 R2 in a Clustered, SAN, and VMware environment.• Patch the SQL servers, web servers, and application servers on a monthly basis. Apply critical updates.• Manage security of Microsoft SQL Server logins and business application user accounts. -
Dba / Erp Programmer / System AdministratorSchool District U-46 Oct 2013 - Jan 2015Elgin, Il, Us• Microsoft SQL Server DBA for the WorkForce time and attendance system (120GB of data).• Microsoft SQL Server DBA for the Tyler Munis ERP system (100GB of data).• Microsoft SQL Server DBA for numerous business systems to support the school district.• Create many SSRS (SQL Server Reporting Services) reports.• Convert many Crystal 2008 Reports to SSRS reports.• Create SSIS (SQL Server Integration Services) packages to import and export data between systems.• Work with SQL Server 2012, 2008 R2, 2005, and 2000 in a SAN and VMware environment.• Maintain backups of production, test, development, and training databases.• Refresh test, development, and training databases with production data when needed.• Monitor and performance tune databases.• Patch the SQL servers, web servers, and application servers on a monthly basis. Apply critical updates.• Manage security of Microsoft SQL Server logins and business application user accounts. -
Senior Software Engineer / DbaBemis Company, Inc. Dec 1997 - Sep 2013Zurich, -, Ch• Developed enterprise system with latest C# .NET 2010 technology. WCF, WPF, Prism, Entity framework.• Architected, designed, and developed a multi-site Shop Floor Data Collection system in VB .NET.• Microsoft SQL Server DBA for the Shop Floor Data Collection system.• Microsoft SQL Server DBA for Oracle Hyperion Financial Management (HFM).• Architected, designed, and developed a data transfer program to synchronize data between SQL Servers and AS400s in VB.NET.• Hyperion Technical/Development specialist for Hyperion Financial Management (HFM). HFM application system administrator. Installed/configured HFM 4.02, Reports, and Hub.• SAP North American Project Team Leader on SAP BW (Business Warehouse) projects.• Trained over 200 users on how to use SAP BW query analyzer and create new BW queries.• Architected, designed, and developed a Sales Force Automation system in ASP .NET.• Architected, designed, and developed a FoxPro to MS SQL Server data transfer application using Visual FoxPro 6.0. Emails sent from the SQL Server based on business rules in triggers.• Managed 3rd party development for a Shop Floor Data Collection project.• Converted a multi-site database application to work in the year 2000.• Started an effort to use WebEx to reduce travel costs/provide remote user support -
Senior Software DeveloperGeneer 1992 - 1997Us• Worked on numerous projects for AT&T, Hewlett-Packard, First American Title and Escrow, Lawson Mardon Packaging, Clifton Gunderson, and others.• Developed commercial-grade software applications within a team-oriented environment using OOA, OOD, JAD, RAD/prototyping, use cases, data modeling, code reviews, and QA metrics.• Commended by supervisors for providing excellent customer satisfaction and the ability to consistently produce high quality software on time.• Assisted in architecture and design of a national, multi-site, distributed client/server database system for a large title insurance application using Delphi and SQL Server.• Architected a distributed client/server database system for a membership/fund tracking application using HTML, Visual FoxPro, and SQL Server.• System architect/technical lead for numerous enhancements to a large manufacturing application in FoxPro. The system modules include A/R, A/P, G/L, Purchasing, Order Entry, Shipping Receiving, Scheduling, MRP, Specifications, Budgeting, and Production Statistics.• Developed data driven SQL query and reporting engines for a major telecommunications billing package. Served as technical domain expert on numerous system upgrades.• Provided estimates for software sizing using Function Points and experience.
Scott Leone Skills
Scott Leone Education Details
-
Governors State UniversityComputer Science -
Kankakee Community CollegeBusiness Computer Programming
Frequently Asked Questions about Scott Leone
What company does Scott Leone work for?
Scott Leone works for Horace Mann
What is Scott Leone's role at the current company?
Scott Leone's current role is Senior Database Administrator at Horace Mann.
What is Scott Leone's email address?
Scott Leone's email address is sc****@****yle.com
What schools did Scott Leone attend?
Scott Leone attended Governors State University, Kankakee Community College.
What skills is Scott Leone known for?
Scott Leone has skills like Microsoft Sql Server, C#, Software Development, Vb.net, Sap, Database Administration, Business Intelligence, .net, Sql, Software Engineering, Asp.net, Databases.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial