Scott Leone

Scott Leone Email and Phone Number

Senior Database Administrator at Horace Mann @ Horace Mann
Scott Leone's Location
Bartlett, Illinois, United States, United States
Scott Leone's Contact Details

Scott Leone personal email

n/a
About Scott Leone

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.

Scott Leone's Current Company Details
Horace Mann

Horace Mann

View
Senior Database Administrator at Horace Mann
Scott Leone Work Experience Details
  • Horace Mann
    Senior Database Administrator
    Horace Mann Jul 2020 - Present
    Springfield, Il, Us
  • Tate & Lyle
    Database Team Lead / Architect / Data Engineer
    Tate & Lyle May 2016 - Jul 2020
    London, 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.
  • Sourcelink
    Sr. Database Developer / Dba
    Sourcelink Jan 2015 - Apr 2016
    Itasca, 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.
  • School District U-46
    Dba / Erp Programmer / System Administrator
    School District U-46 Oct 2013 - Jan 2015
    Elgin, 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.
  • Bemis Company, Inc.
    Senior Software Engineer / Dba
    Bemis Company, Inc. Dec 1997 - Sep 2013
    Zurich, -, 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
  • Geneer
    Senior Software Developer
    Geneer 1992 - 1997
    Us
    • 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

Microsoft Sql Server C# Software Development Vb.net Sap Database Administration Business Intelligence .net Sql Software Engineering Asp.net Databases Enterprise Software Erp Process Improvement Wcf Database Design Sap Bw Cross Functional Team Leadership Oracle Sap Products Visual Basic .net Software Architectural Design Hyperion Hfm Mcsd Mcad Mcdba Foxpro Data Analysis Big Data Analytics Solution Architecture

Scott Leone Education Details

  • Governors State University
    Governors State University
    Computer Science
  • Kankakee Community College
    Kankakee Community College
    Business 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

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

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.