Post Job Free

Resume

Sign in

Sql Server Data Architect

Location:
Buffalo Grove, IL
Posted:
January 21, 2024

Contact this candidate

Resume:

Eduard Eylin

*** ********* **. *, ******* Grove, IL 60089

Cell 847-***-****

E-Mail: ad2y56@r.postjobfree.com

Summary:

Data Architect / Senior Database Administrator with over 35 years of experience in data management solutions.

Infrastructure, implementation and management. Key assets include team leadership experience, excellent

analytical skills and creative problem-solving skills. Repeated success in full development cycle of SQL

Server and Oracle database solutions, Network Administration.

Technical skills:

Environment and Databases :

Clustered Enterprise Servers with Microsoft SQL Server 2000 - 2019 (with High Availability).

Amazon and AWS (Microsoft Azure) Cloud installations.

Virtual Environment (Hyper-V, VMWare )

System Administration and Security (Windows, Active Directory, DNS, Network).

Oracle 11G / 12C.

SAN/NAS Storage.

Data Domain Backups.

Operating systems:

Windows Administration 2000 – 2016 (Clustered environment Server builds and management).

Data Architecture / Development tools:

MS SQL Enterprise Manager Tools and Visual Studio, SharePoint setup and administration, TOAD, ER/Studio, ERWin, Visio, PowerShell scripting.

Monitoring and Backup:

Solar Winds - IGNITE, QUEST FogLight, SQLSentry, RedGate (SQL ToolBelt), IDERA, LiteSpeed, RMAN.

Experience:

MEDLINE, Mundelein 3/18 - Present

Data Architect / Senior Database Administrator

Designed and implemented multi-vendor database solutions on Local DC and AZURE Cloud.

Upgrade of existing servers to VM/Clustered environments on SQL Server 2016/2019 with High Availability.

Setup and managed Replication to secondary Data Center and Data Warehouse, Analytical Services and Data Integration.

Data upgrades and Migration to the new platforms and versions of the vendor’s product.

Data Recovery Solution – DR at remote data center on SQL Server 2019 with High Availability.

New servers builds: Order processing and shipping, Human Resources and Finance department, SharePoint, Corporate security, Backups solutions and monitoring, Antivirus and Phone System.

Logical and Physical design and implementation of the required hardware and software resources.

Integrated a Central Monitoring server, installed and configured SolarWinds for Database servers and Network monitoring.

Performed an internal/external security audit on multiple servers and installations to raise the level of security and accommodate HIPPA and corporate security AUDIT.

Automated database server setup and configuration based on multiple requirements and templates.

Performance tuning and code review with application development team. Provided feedback to code changes and documented standards to which the development must follow.

Ametek Rauland-Borg, Mount Prospect, IL 3/17 – 3/18

Consultant – Data Architect/Senior SQL Server DBA

Designed and implemented new environment builds, upgraded existing database server instances.

Proof of Concept for Datacenter build on AZURE cloud. Risk and performance Assessment.

Built and Migrated data to the new platforms and environments of the products with SQL Server 2016 with Replication and AlwaysOn High Availability.

Setup and configured network and database security with Windows Active Directory and MS SQL Server (Single Sing-On).

Audit security and permissions on all existing environments, review data processing and configuration standards according to SOX, SAS and HIPAA requirements.

Implemented data partitioning, in-memory tables, setup standard maintenance plans for recovery and for performance improvement.

Implemented Disaster Recovery proceedures with Replication and Log Shipping.

Setup and configured Replication for Reporting Services to separate from OLTP for performance.

Network and Database servers monitoring via NAGIOS and SolarWinds.

Implemented server health and database performance monitoring with reporting capabilities.

Compiled a library of standards and procedures for infrastructure design and configurations, development standards and implementation proceedures, documented all server licencing.

Risk assessment, development source code review and project prioritizatisation.

Teletrac NAVMAN, Glenview, IL 6/16 – 3/17

Consultant: Data Architect / Senior Systems Engineer

Designed, implemented and administered global Datacenters, Amazon and Microsoft Clouds.

Data Migration to the new platforms and versions of the products and existing environments.

Administered network security on Windows AD and MS SQL Server.

Performed (internal and external) environment security audits for government compliance requirements.

Built and managed Clustered SQL Server 2012/2014 environment for worldwide use with High Availability.

Upgraded existing server installations to Microsoft SQL Server 2012/2014 with High Availability.

Implemented data partitioning and sharding, setup required maintenance plans for recovery.

Implemented Disaster Recovery sites at the remote countries via Replication and Log Shipping to DC.

Setup and configured Reporting Services on all of the servers for audit and documentation.

SharePoint Setup and Administration.

Managed SharePoint installation and multi-farm administration.

Network and Database servers monitoring via NAGIOS and IGNITE.

Setup weekly reporting for system health, audit of users and user groups, network resources and database access.

Compiled library of standards and procedures for environment design, infrastructure, development and implementation procedures.

ALLSTATE Co., Northbrook, IL (MODIS Inc.) 4/13 - 6/16

Consultant: Data Architect / Senior SQL Server & Oracle DBA

Designed and implemented multi-vendor database solutions on Local DC and Microsoft Cloud.

Upgrade of existing server to VM/Clustered environments on SQL Server 2012/2014 with High Availability.

Data Migration to the new platforms and versions of the products and existing environments.

Data Recovery Solution - built at remote data center on SQL Server 2014 with High Availability.

New servers built for: SharePoint, Corporate security, Antivirus and Phone System and LYNC 2013.

Logical and Physical design and implementation of the required hardware and software resources.

Upgraded Central Monitoring server, installed and configured FogLight by QUEST for Network and Database servers monitoring.

Performed an internal/external security audit on multiple servers and installations to raise the level of security and accommodate AUDIT requirements.

Performance tuning and code review with application development team. Provided feedback to code changes and documented standards to which the development must follow.

SurePayroll a Paychex Company., Glenview, IL 03/11 – 4/13

Data Architect / Senior SQL Server & Oracle DBA

Data Architecture review, Project Management and coordinating resources within the team.

Proposed and built new and improved database structures and enforced standards.

Planning, building and implementing new SQL Server and Oracle Clustered environments.

Server builds and configuration of OS, SQL Server or Oracle software with required packages.

Data Migration to the new platforms and versions of the products and existing environments.

SharePoint Setup and Administration for the Enterprise.

Implementing user access security, setup monitoring software, maintenance procedures and backup schedules. Production support and performance Monitoring.

Built centralized monitoring server for Network/Database Servers monitoring (QUEST FogLight)

POC - Research, design and testing of new hardware and products for new environment.

Acted as a liaison for Development, Testing and QA of pre-production release.

WALGREENS Co., Lincolnshire, IL 01/10 – 3/11

Data Architect / Senior SQL Server - Team Lead

Planned and upgraded existing installations to SQL Server 2012 (Clustered Environment on VM).

Data Migration to the new platforms and versions of the products and existing environments.

Active Directory integration of domain groups and users on all databases servers for single sign-on.

User and group access audit to accommodate for Statement on Auditing Standards (SAS) No.70.

Logical and Physical design and implementation of the hardware and software on new server installs.

Data Recovery site implementation at the remote data center via Replication and automated process cycle for environment refreshes.

FogLight by QUEST setup for centralized monitoring (Network and Database servers).

Server performance monitoring uncovered issues that required changes to be made and were successfully implemented that resulted in performance increase by 30-40%.

Projects Completed: Walgreens Long Term Care, Disaster Recovery and TAX department and Human Resources databases on single multi-terabyte SAN storage, Data Warehouse.

SharePoint Setup and Administration.

ADP Automatic Data Processing, Inc., Deerfield, IL 03/04 – 12/09

Data Architect / Senior SQL Server / ORACLE DBA

Server Builds and Upgrades of existing installations of SQL Server and Oracle packages.

Database logical and physical design, implementation using Visio/ER Studio and server management.

Performance monitoring, tuning and database optimization providing technical support and guidance to developers and end users.

Setup and configured database maintenance procedures and data processing jobs on a schedule.

Automating Data exchange with the clients through secure FTP servers (loads/extracts), Replication and Log Shipping to DR data centers.

24x7 support of multiple multi-terabyte SQL Server installations at multiple locations in US.

Data warehouse project with logical and physical design and implementation.

ALLSTATE Co., Northbrook, IL (MODIS Inc.) 10/98 - 03/04

Consultant: Data Architect / Senior SQL Server & Oracle DBA

Designed and implemented multi-vendor database solutions.

Upgrade of existing servers to VM/Clustered environments.

Data Migration to the new platforms and versions of the products and existing environments.

Data Recovery Solution - built and maintained remote data center as a Disaster Recovery site.

Logical and Physical design and implementation of the required hardware and software resources.

Implemented database performance monitoring,

Internal and external security audit on multiple servers and installations to accommodate requirements.

Performance tuning and code review with application development team. Provided feedback to code changes and documented standards to which the development must follow.

Education:

2022 AZURE Cloud installation: AZURE SQL, COSMOS DB, Terraform (training by vendor).

2019 Learning Tree International: AWS Cloud and Automation (AWS)

2016 ALLSTATE - AWS (Microsoft Cloud) – Configure and build database servers on the cloud.

2014 Learning Tree International : MS SQL Server Advanced Administration and Configuration with High Availability)

2013 Learning Tree International : Oracle Database Installation, Configuration and Administration (Advanced Course).

2011 WALGREENS Inc. On-Site Training ( Microsoft and Oracle Corporation Instructors)

AWS (Microsoft Cloud) – Configure and build database servers on the cloud.

Advanced Cluster Installation, Configuration and Administration in Enterprise environment.

Microsoft SQL Server 2008 R2 and Oracle 11 C advanced administration and configuration.

2010 MCTP (Microsoft Certified Training Provider) (Harper College), Schaumburg

Completed MCITP, MCDBA and BI tracks.

Windows 2003 and 2008 Enterprise Server Administration.

SQL Server 2008 Advanced Implementation and Administration.

2001-2002 Microhard Inc., Oak Brook Microsoft Certified Technical Education Center

Completed A+, Network+, MCSE, MCSA NC and CCNA tracks.

1999-2001 Data Base Design Inc. Buffalo Grove, IL

Microsoft Certified Technical Education Center.

MS Windows 2000 Network and OS Essentials. Managing MS Windows 2000 Environment.

MS SQL Server 7.0/2000 Database Design, Implementation and Administration.

DIPLOMA

1985-1993Moscow Technical University, Moscow, Russia _

Mechanical & Electrical Engineering M.S.

Computer Science M.S.



Contact this candidate