Sql Server Ms

Andrey Vegger 617-***-****

linkedin.com/in/andrey-vegger-92a4201 ******.******@*****.***

Summary of Qualifications

Broad programming and software design experience in MS Windows 2K3/2K8/2K12/2K16 and LINUX environment. Excellent project management, programming, and DBA skills in Oracle and MS SQL Server 2K/2K5/2K8/2K12/2K16. Extensive experience with ASP.NET, EDI, EFT, B2B, B2C, e-Commerce, web-based XML solutions, and cloud AWS. Design, develop, and deploy variety of highly complicated client/server and web-enabled applications. Manage and administer large and super-large commercial database systems on production 24x7 operation.

RDBMS: MS SQL Server 2K8/2K12/2K16, Oracle v8i/9i/10g/11g, Progress RDBMS, Sybase, DB2 Technology: Open Server, Client/Server, Internet/Intranet, e-Commerce, Web Server, .NET Languages: Transact SQL, PL*SQL, Progress 4GL, ASP, XML, Java, VB.NET, and C/C++/C# Environments: MS Windows XP/Vista/7/8/10, Windows 2000/2003/2008/2012/2016, UNIX, Mainframe. Products: MXP, Symix, MFG-PRO, TRAMS, CB+, Siebel, SAP, TMM, FDYN, ATL, COM Modeling (UML): PowerDesigner, Embarcadero, ERWin Data Modeler, Red-Gate, Quest, Case Studio MS SQL Server 2005: SSMS, SSIS, SSAS, Reporting Services, CLR, Notification Services MS SQL Server 2008: OLAP, SSAS, SSIS, SSRS Data Warehouse Infrastructure Management Professional Experience

CONVEXITY CAPITAL MANAGEMENT LP, Boston, MA 2013 to present Principal MS SQL Server Engineer

§ Design, development, deployment, and migration of multi-terabytes MySQL based Market Data Analytical system into SQL Server 2012 platform.

§ Worked with technical and end users to understand business requirements and identify data solutions.

§ Developed strategies for data acquisitions, data recovery, and enterprise-level database implementation.

§ Recommended strategies for optimization and performance tuning for corporate OLTP and DSS systems.

§ Performed RDBMS and index management and data distribution configuration for warehousing systems utilizing MS SSIS, SSRS, SSAS, and 2012 BI tools.

§ Worked with BI developers to analyze corporate user requirements to deliver the most effective solution on critical issues.

§ Assisted the development group in a wide variety of daily operation requirements.

§ Benchmarking and performance tuning for ETL load into cloud based MS platform.

§ Installed SQL Server 2016/2012 on Windows clustered and standalone environments with latest service packs.

§ Upgraded test and development environments and SQL Server databases from 2012 to 2016.

§ Worked with and troubleshot 2TB very large databases (VLDB) in OLTP environment.

§ Configured AlwaysON availability groups in SQL server 2012 and 2016.

§ Configured log shipping for multiple databases as a part of DR.

§ Configured replication and database mirroring for encrypted standalone DMZ based test environments.

§ Provided daily application support for front end feeds and resolved application connectivity issues like connection timeouts, connection pooling issues, memory leaks blockings, and deadlocks.

§ Worked extensively with SQL Profiler, Activity Monitor, Perfmon, DMVs, DMFs, and DTA to tune the databases, queries, and resolve performance issues such as memory CPU and I/O issues.

§ Analyzed long-running poor performing queries and tuned the same to optimize application and system performance.

§ Reorganized and rebuilt the indexes at regular intervals for better performance.

§ Implemented SQL Logins, Roles, and Authentication Modes as a part of security policies for various categories of users.

§ Configured and set up SQL Server configuration settings to resolve various resource allocation and memory issues for SQL Server databases and setup ideal memory min/max server options.

§ Involved in the troubleshooting and fine tuning of databases for improved performance.

§ Improved the performance of SQL Queries and stored procedures using SQL Profiler.

§ Configured tempdb and other systems databases on files and file groups, and conducted capacity planning of databases.

§ Configured and deployed SSIS packages and SSRS reports.

§ Documented procedures in run books.

CSG INTERNATIONAL, Burlington, MA 2012 to 2013

Senior MS SQL Server Consultant

§ Designed and built complex relational databases and data warehouses for e-marketing industry.

§ Worked with technical and end users to understand business requirements and identify data solutions.

§ Delivered technical expertise in analyzing business needs and objectives related to the GMCR project deployment of the marketing solution.

§ Conducted data source analysis sessions and analyzed data.

§ Provided database technical requirements analysis, design, and development services.

§ Developed the database and program stored procedures.

§ Developed the extract, transformation, and load (ETL) routines (initial load and on-going feeds) and processes.

§ Installed and configured end-user campaign management and reporting applications, including metadata development.

§ Delivered complex datasets system required to feed downstream applications.

§ Performed all necessary quality assurance and testing.

§ Provided technical training to the IT staff of various customers.

§ Coordinated technical documentation.

§ Assisted with creating best practices for professional services. VIKING TECHNOLOGIES CORPORATION, Marblehead, MA 2007 to 2012 Principal MS SQL Server Consultant

Architecture/ Database Design

§ Designed and built complex relational databases and data warehouses for e-learning industry.

§ Worked with technical and end users to understand business requirements and identify data solutions.

§ Developed strategies for data acquisitions, data recovery, and enterprise-level database implementation.

§ Provided leadership and direction to database developers.

§ Provided an in-depth expertise in data security, storage solutions, database virtualization, and replication, as well as other complex technical tools and solutions.

§ Defined enterprise-level standards (coding, architectural, migration), platform, and tool selection. Development

§ Performed tasks related to the full life-cycle development of software for internal and client use.

§ Planned, analyzed requirements, designed solutions, and developed and tested application code. Experience with Windows platforms using SQL T-SQL, ANSI-SQL, Microsoft SQL Server, and other commercial and desktop databases.

§ Maintained many ETL solutions, including enterprise-level tools (Informatica) and database built-in utilities (DTS, SSIS, etc.) Performance Tuning

§ Monitored performance of database management systems. Performed restructuring as necessary.

§ Performance tuning of database systems for query and data loading performance, including data partitioning, indexing, etc.

§ Deployed several refactoring tasks of the legacy parts of the system. BNY CONVERGEX, Boston, MA 2006 to 2007

Senior SQL Server Developer

§ Set up SQL Server 2005 64-bit development environment, including all SQL Server 2005 features and services.

§ Initiated and encouraged move of SQL Server development team from a legacy development environment to agile development techniques and lifecycle.

§ Initiated and facilitated the creation and adoption of an Enterprise Application Framework, MS SQL Server best practices, and standards for all database design/development/deployment processes using AllFusion ERWin DataModeler v 7.2.

§ Supported in-house implementation of MS SQL Server 2005 standards, best practices, and application development techniques by all teams responsible for application design, development, and deployment lifecycle.

§ Oversaw support of full suite of traders console flagship product for hedge fund operation using MS SQL Server 2005, Biztalk, C#, ASPX, .NET 2.0, MS Project, Visual Studio 2005, and Visual Studio Team Foundation Server.

§ Hands-on development of SSIS-based performance monitoring MS SQL Server 2005 tool.

§ Leader in migration of existing legacy apps to ASPX, .NET 2005, and MS SQL Server 2005.

§ Optimization and performance tuning of a variety of legacy T-SQL code to reduce blocking/deadlocking activities, maintain scalability, and increase reliability of the application.

§ Performance monitoring dashboard deployment managing reporting and notification services. DILIGENT SYSTEMS, INC. Boston, MA 1996 to 2006

Principal SQL Server Database Consultant

§ Member of Database Development Team conducting conversion, design, and development. MS SQL Server 2000/2005, EPIC, ETL, .NET, CodeSmith, ER Studio, stored procedures, and DTS/SSIS deployment.

§ Developed conversion strategy from legacy applications to MS platform. Migrated database objects, procedural code, and data. Automated most of the migration processes, deployments, and releases. Transact-SQL, VB.NET, VSS, and scripting.

§ Developed scripts, procedures, and DTS/SSIS packages to handle business logic and utility functions.

§ Defined corporate application development, database design, and modeling. DTS (SSIS) design, standards (coding, architectural, migration).

§ Mentored and trained employees on MS SQL Server 2K/2k5 database development/architecture.

§ Optimized/tuned complex database processes. PerfMon, Profiler, Quest Foglight, dataloader, etc.

§ Developed procedural logic, and managed and maintained source in multiple environments, including but not limited to OLAP, OLTP, CRM, and LightSpeed.

§ Diagnosed, troubleshot, and maintained core database logic. Created/deployed database rollout packages for distribution.

§ Provided database support and assisted with integration of SQL Server with front-end .NET applications.

§ Architectural design and modeling, normalization, and database development/performance tuning in VLDB transaction- intensive environment.

§ Database maintenance backup/recovery architecture and definition of data security requirements.

§ Participated in business needs analysis and implementation of the Microsoft CRM solution. IRON MOUNTAIN INC., Boston, MA 1995 to 1996

Atlantic Area Systems Analyst/Programmer

§ Solo on-site integration of SafeKeeper III-IV applications, providing system analysis, process flow re-design and implementation, data mapping and conversion, software customization, and core staff training.

§ Technical leader of a group of 5 system integrators, providing internal training and support, advance coordination of integration visits, all “rescue missions’, and emergency jobs.

§ Maintained SQL-based programs to meet customer requirements (MS SQL Server 5.o, SQL*Plus, Power Builder, VB).

§ Technical services in MS SQL ODBC-Advanced Design Environment involving installations, programming, upgrading, training, and hotline support of financial, distribution, and manufacturing applications (SCO UNIX-Novell TCP/IP environment).

§ Designed, Implemented, and supported GUI application in the ADE. VARIANT PUBLISHING CO., Odessa, Ukraine 1992 to 1993 Leader of Software Management Department

SPECIAL DESIGN BUREAU, Odessa, Ukraine 1985 to 1992 Leader of Special Project Development Group

Education

BOSTON UNIVERSITY 2000 to 2003

MS in Administrative Studies (e-Commerce)

MOSCOW STATE TECHNICAL UNIVERSITY 1986 to 1989

MS in Computer Science

ODESSA STATE TECHNICAL UNIVERSITY 1980 to 1985

BS in Electronic Engineering

Other

Member of AOPA

Licensed Pilot

US Citizen

Contact this candidate