Sql Server

SLAVA VDAVICHENKA

PAGE *

SLAVA VDAVICHENKA

TECHNICAL

SUMMARY:

Production SQL Database Lead/Administrator with over seventeen years of IT experience including

•

Database Design, Administration, and ETL implementations

Proficient in SQL Server, SAP Data Integrator, and Java

•

Participated in projects at all stages of SDLC including planning, requirement analysis, design,

•

development, integration, testing, deployment and operational support

Worked in teams as development DBA with a single company product as well as a production DBA

•

supporting SQL Server farms leading a support team of 7 people

Successfully delivered to SQL 2008 and SQL 2012 upgrades, real-time ERP-to-ERP replication,

•

data duplication and cleanup projects leveraging offshore teams and SCRUM methodology

Self-starter, have strong troubleshooting and analytical skills, paying attention to details, can work

•

without supervision and clearly defined directions to meet important deadlines

An active participant and a speaker at local SQL user group

•

TECHNICAL

SKILLS:

Databases: SQL Server 2014-2000 (SSIS, SSAS, SSRS), MySQL, Oracle, MongoDB

•

Modelling: Erwin, Visio, Rational Rose, Enterprise Architect, Hibernate Tools

•

Integration: SAP Data Integrator, Integration Services, Pentaho

•

Tools: Red Gate, SCOM, Redmine, Jenkins (CI), Subversion, Git

•

Programming: Eclipse, Tomcat, Jetty, J2EE, JMS, JDBC, Freemarker, Ant, Maven

•

Languages: T-SQL, Java, Groovy, Visual Basic, XML, HTML, JavaScript

•

Operating Systems: Windows Server, Linux

•

EXPERIENCE:

4/14 – 12/14 Weiss Residential Research, Natick, MA

SQL DBA Architect

Weiss Residential Research develops a proprietary technology that optimizes housing market decisions.

Weiss’ technology calculates property specific price indexes for over 45 million homes. WRR analytics

improves investment decisions, portfolio management and modeling engines. The analytics are

produced through the use of Big Data techniques, novel algorithms and by harnessing massively parallel

computing power.

Migrate database from MySQL to SQL Server 2014.

•

Re-design schema for scalable parallel processing.

•

Installation of SQL Server 2014, Setup backup and disaster recovery (via log shipping), alerts.

•

Optimization of existing processes (queries and SSIS packages).

•

Environment: SQL Server 2014, Azure

10/13 – 4/14 Liaison International, Watertown, MA

Lead SQL DBA

Liaison provides admissions management solutions to higher education. It powers the most admired

admissions offices with its centralized application service, provided to universities through professional

associations, and its unicas product, provided directly to universities.

Lead a DBA team (remote members in India and Canada).

•

Make sure all administration tasks are implemented on time (backups, optimization).

•

Troubleshoot application and data transfer (SSIS) issues.

•

Implement tools for process automation and self-service (using Red Gate and DBMaster tools).

•

Work with management, infrastructure, support, and development teams.

•

Troubleshooting and implementation of sql server transactional replication (SQL 2005) and

•

clustering (2012).

Planning and implementation of upgrade to SQL 2012.

•

SLAVA VDAVICHENKA

PAGE 2

Optimization of view, stored procedures, and ORM queries.

•

Monitor of the database systems using Red Gate monitor.

•

Participate in business projects to deliver new application solutions.

•

Implement change management and best practice monitoring.

•

Environment: SQL Server 2005 & 2012, Red Gate, DBMaster, SSIS

SLAVA VDAVICHENKA

PAGE 3

11/10 – 10/13 Movado Group, Paramus, NJ

Team Leader, SQL DBA

Movado SFA (sales force automation) allows users to download data from SAP about customers

(contacts, credits, order and billing history), company products, pricing and availability. Once data

downloaded Sales Representatives can use the application offline and without VPN connection to take

an inventory, calculate sell-thru, generate and print orders. SFA application will use EDI to automatically

submit orders to ERP.

Responsible for analysis of original application written in Visual Basic (algorithms and data model).

•

Owned data model, worked with development, business analysis teams on the application data

•

model.

Installed and managed SQL server.

•

Optimized database using multiple data files, server settings, indexes as well as changing SQL

•

queries.

Extracted historical and incremental master and transactional data including customers, materials,

•

pricing, sales, and billing from SAP ECC and BW into Microsoft SQL database utilizing BODI XI and

SQL server stored procedures.

Wrote project-related documentation.

•

Environment: SQL Server 2005 & 2008, SAP Data Services, Java, Hibernate, VBA

2/10 – 10/10 PerformCare, Trenton, NJ

Production SQL DBA

PerformCare is a complete behavioral health care and human services company that supports over 4

million members in the public and private sectors. PerformCare specializes in providing superior,

innovative solutions to support behavioral health, human services, and integrated health programs that

are outcomes-focused and customized for: Medicaid and Medicare Plans, Commercial Health Plans,

Wellness, Employee Assistance, and Specialty Products

Reviewed existing SQL server landscape.

•

Proposed multiple options to implement disaster recovery and fixed SQL server replication in

•

production.

Reviewed and fixed multiple issues in security (replaced authentication to integrated).

•

Implemented HA and DR using mirroring and log shipment (cheaper option than cluster).

•

Setup monitoring jobs and alters (drive space, mirroring and log shipment issues, jobs failures).

•

Worked with development team in identifying and fixing queries, stored procedures using SQL

•

Profiler.

Helped in creating the missing indexes and statistics in various tables as part of the performance

•

tuning, optimizing .net application to make mirroring and log shipment more efficient.

Created test and development environment culture, assisted in change management setup.

•

Helped to go through SQL server audit (data had personal health information).

•

Fixed SSIS packages to use configuration parameters instead of hardcoded server names.

•

Provided 24/7 on-call support for production support.

•

Environment: SQL Server, SSIS, SSRS

10/08 – 6/09 Intercontinental Hotel Group (IHG), Atlanta, GA

Database Modeler/Integration Consultant

Priority Club Rewards is IHG's worldwide loyalty program. With 60 million global members, Priority Club

is the largest loyalty program in the hotel industry.

Owned data model, worked with development, ETL, business analysis teams on model.

•

Implemented integration with database encryption tool for PCI compliance.

•

Worked with technical advisors on conceptual model and integration with 3rd party applications.

•

Worked with architects to make web services compliant with Enterprise SOA Standards.

•

Managed integration with Data Cleansing Software (customer deduplication, addresses).

•

Managed an offshore development team (8 developers) using 2-week agile iteration.

•

Designed integration with MapQuest for hotel radius search.

•

Contributed into continuous integration setup and build automation.

•

Participated in demo preparation for every iteration.

•

Environment: Oracle, ERWIN, Excel, Enterprise Architect, Eclipse, Hibernate Tools, Git, SVN, Maven,

Hudson, Google sites, Mingle, Map Quest API, Web services, SOA, Hibernate, Spring, CXF, Checkstyle,

PMD, Сoberture, MQ Series

SLAVA VDAVICHENKA

PAGE 4

8/07 – 9/08 Movado Group, Paramus, NJ

Production DBA Team Lead

Supported retail and business intelligence applications including OLAP cubes, worked on migration of

multiple legacy applications to SAP platform leveraging an offshore team.

Supported production and pre-production databases. Environment included 21 servers in 3 time

•

zones (EST, Switzerland, and Hong Kong), 459 database instances in compatibility modes from 6.5

to 2005. 33 applications used 226 unique databases with total size more than 1Tb. Most production

servers were hosted by Windows Server 2003 64 bits with RAID5/10 over SAN, and test/dev.

servers were based on enterprise VMWare products.

Coordinated major upgrades and troubleshooted operational issues with application owners and

•

software vendors.

Worked with IT team on hardware issues, communication channels problems, and hardware

•

requirements.

Supported retails cubes critical to the business.

•

Monitored daily synchronization with company boutiques and cube updates.

•

Troubleshooted OLAP design & performance issues.

•

Developed software/hardware inventory application based on MS Analysis Services and SQL

•

Server, Excel, Java technologies to collect statistics that allowed analyzing the company’s software

and hardware environment in real time. The application reduced time required to support requests

by 15%, helped to work in unknown environment to figure out relationships between applications,

databases, and people.

Tuned SQL server performance, troubleshooting and real-time monitoring of internal processes

•

(SQL server jobs, windows tasks, real-time replication, custom downloads, SSIS packages) basing

on Microsoft Operational Manager 2005 notifications.

Completed migration from SQL 2000 to SQL 2005.

•

Implemented of data replication from SAP R/3 into legacy database schema in order to support

•

legacy applications (10) during transition period (2-3 years).

Tool evaluation (open source and commercial).

•

Research targeting possible replication architectures (real-time replication versus scheduled

•

downloads).

Made proof of a concept for several most important master and transactional tables, took online

•

classes, and spent a week with a consultant provided by Business Objects.

Developed project plan development, coordination with application owners and offshore team,

•

troubleshoot implementation issues.

Created a tool to generate mappings basing on metadata files which speed up implementation for

•

one table by 70%.

Environment: MS SQL 2005 including (DTS, SSIS, SSAS, SSRS), Orion Integrator, Microsoft Remote

Desktop, Microsoft Operations Manager, Excel, SAP R/3, Business Objects Data Integrator, Microsoft

Project, Sybase, DB2/AS400

2/07 – 7/07 SAP of America, Phoenix, AZ

Development DBA

PML – Promotion Merchandising Layout, SAP PML for Retail provides retailers with an effective

advertising, marketing, and promotions tool that streamlines the process of selecting and presenting

products and promotions within printed and electronic promotional collateral. Electronic merchandising

layout and merchant-centric asset management functionality enable the merchandising organization to

create more targeted and timely promotions while improving productivity and efficiency. SAP PML

enables the merchant or merchandising assistant to create and maintain a database of offers and easily

plug them into an electronic merchandising layout that is linked into a desktop publishing program that

the advertising team uses to create the final piece of collateral.

Participated in project initial knowledge transfer on wide variety of proprietary concepts &

•

frameworks, such as logging, security, persistence, user management.

Managed all processes related to database administration including software installations for

•

development and QA environments, backups, data modeling, DTS, job creation and scheduling,

index tuning.

Prepared initial database scripts.

•

Synchronized SQL changes made between the development and production environments.

•

Environment: SQL Server 2005 (SSIS), Eclipse, Delphi 2006, Araxis Merge, Ant, SSH, Oracle, Mediagrif

Open Server

SLAVA VDAVICHENKA

PAGE 5

12/06 – 1/07 Blue Cross Blue Shield, Eagan, MN

Database Developer

Blue Edge - an agent portal, Independent insurance agents and internal sellers use BlueEdge to develop

quotes to present to individual and small group applicants. They can also use BlueEdge to track the

status of applications within the underwriting process. BlueEdge also serves as a reference repository,

where agents can go to find documentation, paper application forms, etc.

Worked as a database developer on multiple projects: Member Touchpoint Measures, Blue Avenue,

•

Blue Edge, Tribal Portal, and Data Scrubbing.

Designed an approach to copy related tables basing on foreign key dependencies and decoupling.

•

Developed a program to determine natural keys in tables basing on existing data and a program to

•

create transformations for Kettle tool automatically.

Copied data related only to 100 customers stored in more than 50 tables from one schema to

•

another with traceability to original records.

Replaced private health information with generated information.

•

Resolved assigned tickets from database team queue.

•

Created SSIS packages for archiving data and Data Migration and complex TSQL stored

•

procedures and views for reporting purposes.

Environment: SQL Server, SSIS, Oracle, Kettle, Eclipse, Java, yEd

5/03 – 12/05 SAP, Philadelphia, PA

Development Database DBA/Developer

SAP xApps Product Definition (SAP xPD) - a tool for companies focused on Product and Service

Innovations. xPD covers the first phase of the product development lifecycle ranging from idea

generation to the detailed definition of a concept for products or services.

Managed databases (installation, security, patching, and optimization) and associated

•

documentation.

Managed database objects (stored procedures, views) to ensure required performance including

•

indexing, query optimization, data partitioning, and database/table options.

Implemented CAF Security framework using rules approach, integration between xPD and xRPM

•

using web services, several xPD and CAF UI reusable components, integration with xRPM and

cProject via JCO client.

Developed integration with user management framework (UME 4.0).

•

Documented development guidelines, code convention, HOW-TO articles.

•

Proposed performance UME 4.0 improvements.

•

Environment: SQL Server 2000, SAPDB, SAP NetWeaver, SAP GUI, SAP xApps (J2EE, DTR, CBS,

Web Services)

EDUCATION:

1999 – 2004 Belarus State University, Minsk, BELARUS

Master Degree in Computer Science

•

CERTIFICATIONS:

2009 Google

Analytics Individual Qualification

•

2005 EPAM

Leading Development Team

•

2005 BrainBench

Java 2 Platform Enterprise Edition

•

RDBMS Concepts

•

Master Programming Concepts

•

Master Java 2 - Non-GUI

•

Master Java 2 Fundamentals

•

AWARDS:

2000 ACM Competitions

SLAVA VDAVICHENKA

PAGE 6

Opened Programming Contest Moscow, Russia 1st prize

•

North-eastern European Regional Contest, Russia 3rd prize

•

International Olympiad in Informatics, Turkey 3rd prize (1999)

•

International Competition in Informatics, Belarus 1st place (1998)

•

Contact this candidate