Sinkevich, A. Email & Phone Number

Chicago, Illinois, United States

Schaumburg, Il

Supported a SQL environment with over 80,000 databases across 300 instances, including Payroll, Core HR and Talent modules.• Successfully deployed, monitor, and maintain of AlwaysOn availability groups including in house scripts to maintain jobs, logins etc.• Perform version upgrades (SQL 2014 to SQL 2016) as well as apply Service Packs and Hot fixes when vulnerability is identified.• Created, deployed, and supported report projects using SSRS for several home-grown applications.• Developed and implemented SQL Server security standard for the entire company. Created PowerShell scripts to help managesecurity more efficiently.• Participated in SAS70 audit activities. Performed SQL Server audit.• Researched and implemented Resource Governor solution to limit the resource utilization and downtime due to outages.• Provided comprehensive ongoing support and administration for multi lifecycle environments.• Tune SQL Server by examining current workloads and hardware, making improvements, and measuring results.• Provided database expertise to consult application teams.• Write ad-hoc queries, stored procedures, jobs, and functions to support the SQL servers.• Configured Transparent Database Encryption (TDE) to protect data at rest using SQL Serve built-in feature.• Resolve data issues and facilitate data analysis.• Created scripts to automate various manual processes.• Created and maintain database and process documentation.• Worked with development teams to design required database and schema objects.• Responsible for a change control process to limit the number of production outages.• Created a process to collect database backup information to identify and report recovery gaps.• Identified the gap with capacity planning and created a process to collect resource utilization along with several SSRS based reports toassist with capacity planning activities.

Lincolnshire, Il

Primary Responsibilities•Operate SQL databases ensuring that systems are running optimally ensuring availability, efficiency, and recoverability.•Designing, planning, and implementation of new SQL Server estate.•Consolidation/expansion of existing services.•Design and implement monitoring solutions for SQL databases.•Develop and maintain automation scripts for daily operations.•Establish alliances with other teams through recognition of dependencies.•Ensure security and privacy policy follows best practices.•Acts as an expert technical resource to client and development staff in all phases of the development and implementation process.•Expert knowledge of SQL Server licensing.• Managing over 1500+ SQL Servers from 2005, 2008, 2012, 2014 and 2016• Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.• Performance Tuning, Query Optimization, using SQL Server monitoring utilities such as Idera SQLdm, BMC Patrol, NewRelic, Spotlight, SQLSentry, Spotlight, and Performance Dashboard• Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention• Manage Report backups, restores, recovery models, database shrink operations, DBCC commands, Clustering• Install/Configure and troubleshoot AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies• SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system stored procedures)• Service Management expertise using SNow.• Working knowledge of Business Intelligence (BI) platforms including SSIS, SSAS and SSRS• Experience with Cloud database hosting providers AWS EC2, Azure VM and Azure SQL Database• Expertise in SQL technologies by understanding new current/forthcoming versions (e.g. SQL 2016, etc.)

Chicago, Illinois, United States

• Provided day-to-day support and administration of production, test and development databases, which included execution of change, incident, availability, and capacity management processes. Worked closely with software development team to modify existing schema to improve performance and functionality of the developed applications.• Reviewed and analyzed statistical data for performance tuning opportunities.• Recognized and implemented automation opportunities reduced the amount of hands-on support.• Monitored over fifty database servers with Idera Diagnostic Manager to eliminate outages or service variations.• Applied vendor-provided software upgrades and patches to the database management systems and applications software, wheredatabase-specific expertise was required.

• During the three months contract at Midas was responsible for 24 x 7 DBA activities encompassing an integrated system of over twenty Microsoft SQL Servers, heavily reliant on SQL Server replication technology.• Was responsible for daily support, troubleshooting, monitoring, optimization and tuning of SQL Server environment across entire system.• Developed automated daily, weekly, and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.• Administered SQL Server security.• Supported system wide replication tasks including monitoring and alerting. Provided problem resolution.

Greater Chicago Area

Following tasks performed at these clients: Wheels, Inc., Des Plaines, IL; Sprint, Overland Park, KS; Arthur Andersen, Chicago, IL; Informational Resources Inc, Chicago, IL; Catalyst International, Milwaukee, WI; Howard Schultz and Associates, Arlington Heights, IL• Administered database server, including backups, restore and space capacity planning.• Tuned SQL Server for performance.• Performed SQL code migration from development to test and production environments.• Administered SQL Server security.• Created VBA functions to enforce business logic on the client side.• Presented Vantive Out-of-the-Box, gathered requirements, and performed GAP Analysis of Support Application.• Performed conversion of database objects from SQL Server 6.5 to 7.0.• Reverse engineered and performed data conversion of client financial data files into Microsoft SQL Server and xBase formats to beused in an auditing environment.• Created custom conversion programs using FoxPro and Visual Basic.

Bs, Finance

Ms, Computer Science