Igor Baklikov

*** ******* **, ******** ** *****

Cell: 703-***-**** - adj5es@r.postjobfree.com

Career Overview

Result-driven SQL Server Administrator/Developer with more than twenty years of experience in diverse industries, including Banking, Health Care, and Government.

Extensive expertise in implementing and supporting Microsoft products including: SQL Server, Windows Server, IIS, Hyper-V, Office 365, SharePoint, SharePoint Online, Microsoft Azure.

Strong knowledge of MS SQL Server architecture, and SQL Server development.

Exceptional ability to identify, analyze, and solve problems.

Performs well as team member and independently.

Extremely driven individual with deep passion for creating and delivering programs and solutions that empower team, company, and customer to meet and exceed desired expectations.

Security Clearance

Secret – Active

Qualifications

MS SQL Server administration and development.

SharePoint architecture and product integration.

SQL Server, Windows Server administration.

Managing Cluster, DC, DNS, DHCP, IIS, SMTP.

SharePoint development, and web applications management.

Large data sets management

Data migration to SQL Server and Azure

Optimization and performance tuning.

SQL Server disaster recovery and security.

Microsoft visualization and cloud computing

Technical Skills

DATABASES: SQL Server 2016/2014/2012/2008, DB2, ORACLE 12c, Informix, Sybase, MS Access, Azure Synapse Analytics, Azure SQL Server Managed Instance.

SOFTWARE: SharePoint 2016/2013/2010/2007, SharePoint Online, Office 365, InfoPath, SharePoint Designer, Visual Studio, MS Office, SSIS, Azure Data Factory, Power BI Excel Services.

LANGUAGES: T-SQL, PL/SQL, VB.NET, C#.NET, Python, jQuery.

SYSTEMS: Microsoft Azure, Windows 2012/2008 R2 Cluster, DC, DNS, DHSP, IIS, SMTP, HyperV, VMWare, ESXi, Azure, ERWin.

INTERNET: HTML, XML, XSL

Accomplishments

Designed and implemented automated system for data exchange between SharePoint InfoPath applications and SQL Server Data Warehouse, enhancing contracting price negotiation for acquisition management, average price reduced by 10%.

Multiple successful SharePoint 2013 and SharePoint 2010 Projects, improving overall enterprise data management, and collaboration.

Developed and implemented unified Security application for multiple site collections to simplify security management for site collections administrators, freed up 5%-10% of time for site administrators.

Work Experience

Senior Database Administrator/Data Architect

July 2018 to Present

VETS Inc. Washington DC

www.vets-inc.com

SBA (Small Business Administration Office of Disaster Assistance)

Administered SQL Servers in different environments development, test, and production (on-premises and Azure)

Provided SQL Server performance monitoring and tuning.

Designed and implement DB Scripts for Maintenance.

Analyzed DB Structure, Stored Procedures, Views, and Triggers.

Designed Database structure, and schemas to support data migration efforts

Provided Data migration from Oracle to SQL Server using SSIS and Scripts.

Migrated big volume of date with different datatypes.

Developed Stored Procedures, Views, constraints, indexes to optimize migration

Optimized SSIS packages for best performance using partitioning and bulk load.

Salesforce objects data migration to SQL Server using Kingsway adapters.

Support Database Structure changes for Salesforce objects in SQL.

Maintain big number of packages using Integration Catalog, MSDT, and BIML

Design and implement Data Warehouse structure for reporting and BI.

Analyze and estimate data storage capacity for data migration.

Prototyping projects using AZURE SQL Server managing instances, AZURE SQL Databases, Azure Synapse Analytics, Azure Data Factory, Azure Data Lake Storage.

Sr. Software Consultant

May 2015 to July 2018

InfoReliance Corporation – Fairfax, VA

http://www.inforeliance.com/

NTSB (National Transportation Safety Board) Project

Managed NTSB.gov public web site and content deployment.

Migrated site collection to SharePoint Online.

Provided configuration management for NTSB Product Management Application (PMA)

Administered SharePoint farms and SQL Servers.

Configured SharePoint services and Web applications settings.

Implemented and maintained Office Web Applications, and TFS Servers with SharePoint integration.

Supported Test and Development environment on Microsoft Azure.

Prepared for SharePoint 2013 migration, tested applications functionality.

Wrote PowerShell scripts to automate common SharePoint and SQL Server activities.

Identified, isolated, and solved SharePoint and SQL Server issues.

Moved site and site collection across different SharePoint farms.

Analyzed SharePoint farms' key metrics and provide performance tuning.

Installed, patched, and upgraded SQL Servers and SharePoint.

Created and maintained Database Maintenance plans.

Managed SharePoint content databases backup and restore.

PDS (Public Defender Service DC) SharePoint 2013 Architecture

Designed SharePoint farm structure.

Installed SharePoint Farms

Designed maintenance plans for SQL Server backups

Installed pates and upgrades

Senior Database Administrator/Data Architect

Fab 2011 to May 2015

VETS Inc. Washington DC

www.vets-inc.com

eFAST program for FAA

Supported and maintained eFAST virtual environment that includes Domain controllers, SharePoint 2010, 2013 farms, TFS 2013, Hyper-V, and Individual Virtual Machines with SharePoint Developers tools

managed accounts and permissions;

Administered SP 2010 and 2013 Farms

Maintained SQL Server Databases for SharePoint, Lync, TFS servers

Managed SAN infrastructure

Designed and implemented Business Intelligence solution for eFAST program

Designed Data structure and Dataflow

Developed Data migration and transformation workflows between Data Warehouse and SharePoint

Developed reports and SharePoint dashboards to present collected data

Created jQuery scripts and InfoPath forms.

Involved in migration to Microsoft Azure and Office 365.

Sr. Database Administrator/SharePoint Administrator

March 2009 to January 2011

AVINEON - Alexandria, VA

www.avineon.com

Quantico DOD Project - VIPER

Led requirements gathering workshops to select and recommend a portal collaboration solution.

Analyzed information architecture, developed Portal Requirements document, recommended solution to business

users, produced solution documentation, diagrams, and PowerPoint presentations.

Designed and implemented SharePoint portal - VIPER.

Supported migration from SharePoint 2007 to SharePoint 2010.

Developed SharePoint Applications using InfoPath, SharePoint Designer and jQuery.

Developed workflows to move documents, assign tasks, send notifications, and create reports.

Provided SharePoint consulting, answered questions, resolved issues.

FIMA DHS Project - ESW

Conducted installation, patching, and Upgrading for SQL Server and MOSS 2007.

Planned migration from SharePoint 2007 to SharePoint 2010.

Created and managed production SharePoint content Databases.

Managed databases backup and restore.

Created and maintained Database Maintenance plans.

Monitored index fragmentation, dataset integrity and database statistics.

Provided disaster recovery planning for FEMA ESW system.

Streamlined SharePoint farm monitoring, troubleshot SharePoint farm performance and other issues.

Designed and developed scripts to support data managing, migration, and data analysis.

Provided support for ESXi environments with SharePoint farm and SQL Servers.

Supported www.theportalsolutions.com SharePoint 2007 Team collaboration site.

Sr. Database Administrator

August 2005 to March 2009

FBR Capital Markets - Arlington, VA

www.fbr.com

Streamlined installations, patching, and upgrading for SQL Servers.

Supported and managed production Databases in the cluster environment.

Managed Databases' security and provided support for SOX auditing.

Designed MS SQL Server/Oracle Security Standards and Polices.

Implemented and supported GUARDIUM MS SQL/ORACLE security monitoring system.

Developed DTS packages for data transformation from/to different sources.

Implementing and monitoring transactional replication.

Conducted SQL Server, Databases, Applications, queries, and stored procedures performance tuning.

Troubleshot slow running T-SQL queries and time-outs.

Senior Software Engineer

June 2002 to August 2005

Fairfax Imaging, Inc - Chantilly, VA

www.ffximg.com

Developed custom applications for Imaging Processing system.

Completed automatic forms tuning for recognition engine.

Implemented document scanning enhancement.

Conducted automated image recognition and uploaded recognized data into the different databases.

Designed process to retrieve images and related information from databases.

Improved monitoring and control imaging-processing steps.

Developed user-specific function for additional image processing.

Developed views, triggers, stored procedures, and database structure for data aggregation.

Team Manager/Senior Software Developer

June 1999 to June 2002

ABT Associates Inc - Tashkent

www.abtassociates.com

Senior Software Developer/System Architect

May 1998 to June 1999

TASIS PIF Project - Tashkent, Uzbekistan

Certifications

Exam 70-534: Architecting Microsoft Azure Solutions, 2018

MCSE : Productivity, 2017

MCSA : Office 365, 2017

MCTS : SharePoint 2010, Configuration, 2011

MCITP: Database Administration 2008, 2009

MCTS: SQL Server 2008, Implementation and Maintenance, 2009

MCDBA, 1999

MCSE + Internet, 1999

MCP, 2012

Education and Training

M.D. : Math

Tashkent Polytechnic Institute

M.D. in Math -Tashkent Polytechnic Institute, Uzbekistan;

Contact this candidate