Sql Server Data
Resume:
SERGEY KHARITONOV
Niles, IL 60714
acxehn@r.postjobfree.com
LinkedIn: https://www.linkedin.com/in/sergey-kharitonov-88963ab9
Summary
Over 20 years of extensive experience in database administration, data architecture, analysis, design, development and implementation for MS SQL Server 6.5 / 7.0 / 2000 / 2005 / 2008 / 2008 R2 / 2012 / 2014 / 2016.
A SQL Server DBA involved in installation, upgrade, configuration, monitoring, tuning, backup and recovery, security and troubleshooting of MS SQL Server 6.5 / 7.0 / 2000 / 2005 / 2008 / 2008 R2/ 2012 / 2014 / 2016.
Experience in evaluating the system and providing recommendations related to capacity planning, performance tuning, pro-active monitoring, and trend analysis.
Possess years of expertise in Replication/Log shipping/Database mirroring of multiple databases over a wide area network.
Strong knowledge of development tools, technologies, and Data Modeling/Analysis. Exceptional analytical and problem solving skills.
Professional Experience
2013 – Present HyperQuest Inc., Schaumburg, IL
Senior Database Administrator
As the DBA, responsible for design, coding, and implementation of backend for claims process automation, estimates auditing, alternative parts sourcing, and data handling. Participate in data modeling and analysis, database design and implementation. Develop and implement company standards, along with best practice and recommendations for Transact SQL programming.
Designed, developed and implemented a customized monitoring and maintenance system (SysMonitor), which provides historical data for analysis and optimization of SQL Server. This system includes:
database size and growth rate reports for accurate capacity planning;
blocks and locks reports (including historical data) for deep analysis and troubleshooting locking/blocking/deadlocking issues;
set of SQL Server Agents jobs to analyze and defragment indexes and maintain index statistics;
current and historical data of index usage (seek, scan, lookups) for deep performance tuning;
current and historical data for tables and indexes which are not used anymore (to keep databases clean and prevent over-indexing for “popular” tables);
list of most expensive queries (in terms of read I/O, write I/O, or CPU usage) on daily or weekly basis for future investigation of performance improvement.
Designed, developed and implemented data archival strategy for historical data on the main relational databases. Identify data that must remain online, as well as data that should be archived. Completed full analysis of corporate data retention and archiving requirements. Maintaining current, active data online and selecting the most appropriate storage for archived data ensures a cost-effective balance throughout the information lifecycle. This process also ensures that enterprise application databases are maintained at a manageable size to improve performance and availability of critical systems.
2001 – 2013 Wheels Inc., Des Plaines, IL
Senior Database Administrator
As a member of the DBA team was responsible for design, coding, and implementation of back end of automotive Vehicle and Fleet Management system, which provides corporations with solutions to their fleet leasing and management needs (fuel, maintenance, vehicle inventory, accident managements, vehicle acquisitions, fleet office support, etc.).
work on data modeling and analysis, as well as database design and implementation projects;
develop and implement company standards, along with best practice and recommendations for Transact SQL programming;
lead a team of developers to analyze and enhance the back end code for improving SQL Server performance;
set up and manage replication services between multiple databases;
as a member of the DBA group, was responsible for 24/7 database support.
2000 – 2001 eSkye Solutions, Inc., Lisle, IL
MS SQL Server DBA / Data Architect
Responsible for design, coding, and implementation of the back end of the Electronic Beverage Order Tracking System (eBOTS). eBOTS an online network for beverage retailers, restaurants, distributors, control states, and suppliers. eBOTS utilize multiple MS SQL Server 7.0 / 2000 and SQL Server CE databases on the back end.
design multiple Data Transformation packages;
build complex triggers and stored procedures enforcing business rules;
design and develop dynamic hierarchical data structures to support the ever-changing customer requirements;
participate in the creation and coding of multiple applications designed to support the main system;
involved in platform migration from MS SQL Server 7.0 on Windows NT to MS SQL Server 2000 on Windows 2000.
1996 – 2000 Askesis Development Group Inc., Chicago, IL
Development DBA
Contribute to design and development (back end code) for Behavioral Healthcare Management System (BHMS) for major clinics nationwide. BHMS included a number of interacting modules such as HR, accounts receivable/payable, clinicians, patients, and coverage modules, documents and diagnosis system.
Work as a member of the DBA team on the database analysis, data modeling, design and implementation.
Education
MS in Mathematics and Computer Science
1977 – 1983 University of Aviation, Kharkov, Ukraine
Certifications
First certification: Microsoft Certified Database Administrator (MSDBA), 2001
Latest: Exam 70-461(Querying Microsoft SQL Server 2012), 2015
Exam 70-462 (Administering Microsoft SQL Server 2012 Databases), 2016
References
Available upon request.
Contact this candidate