Sql Server Engineer

Dmitriy Burtsev

Staten Island, NY *****

*********@*****.*** 347-***-**** linkedin.com/in/dmitriyburtsev

SQL Server Database Engineer

Contribute to bottom line by ensuring business / industry needs are met

Professional who designs and build databases that support business applications and ensure system scalability, security, performance and reliability. Develop database architectural strategies at modeling, design and implementation stages that address business or industry requirements. Develop data models for applications, metadata tables, views or related database structures. Research, design, develop and test software. Set up database clusters, backup or recovery processes. Consider relative costs / benefits of potential actions and choose most appropriate one. Apply principles and techniques of computer science, engineering and mathematical analysis. Passion for new technologies and services. Areas of expertise include:

Database Design / Data Modeling

ETL (Extract, Transform and Load)

Performance Optimization

Troubleshooting / Technical Support

Technical Proficiencies

Platforms:

MS SQL Server 6.5 - 2016, Microsoft .NET, VMware

Tools:

PowerDesigner, Erwin Data Modeler, Embarcadero ER / Studio, SSIS, MS Visual Studio, C#, PowerShell, JavaScript, Team Foundation Server, SqLite

Professional Experience

STIFEL, NICOLAUS & COMPANY, INC., New York, NY 06/2016 – 05/2017

Senior Database Developer

Developed data queries, data transformations, load jobs and data extracts using PowerShell, Python, SSIS, SSRS and SQL and stored procedures in MS SQL server.

Drove data warehouse project development by designing and implementing staging tables for ETL process.

Made code more readable and helped avoid common mistakes by writing SQL coding guidelines and standards for development team to implement best practice guidelines.

Enabled troubleshooting of invalid files from vendors by developing file parsing utilities with C#.

MIZUHO BANK, Jersey City, NJ 11/2015 – 03/2016

Senior Database Engineer (Contractor)

Created ETL SSIS packages that transferred data from Oracle to Microsoft SQL Server.

Automated SSIS deployment by developing deployment script with PowerShell.

Fixed performance problems by tuning Oracle and SQL server query.

BANK OF AMERICA MERRILL LYNCH, New York, NY 04/2015-11/2015

Senior Database Engineer (Contractor)

Served as Senior Database Engineer. Developed SQL Coding Standard and Guideline. Implemented SQL Server policy with PowerShell. Migrated database from SQL 2005 to SQL Server 2012 with code optimization. Developed PowerShell scripts to copy database schema and lookup table data from production to UAT and QA. Partitioned big table with a time-based sliding window. Implemented missing and unused indexes reports.

Made certain business and industry requirements were understood and met by collaborating with system architects, software architects and design analysts.

MCGRAW HILL FINANCIAL, INC. (S&P CAPITAL IQ), New York, NY 02/2013 – 02/2015

Database Engineer

Functioned as Database Engineer for Common Portfolio Repository (CPR) project, which enables portfolios to be shared across different applications. Team was responsible for architecture, design and development of large-scale database systems hosting market data and financial data. Utilized software development lifecycle (SDLC) methodologies like Agile, test-driven development. Introduced NUnit testing framework for Microsoft .NET for T-SQL procedures testing.

Allowed calculation of trade date time world-wide by leading, designing and implementing IANA time zone database on SQL server using Erwin Data Modeler. Created custom C# program for parsing ETL IANA files.

Expanded database development by creating logical and physical data models for SQL server 2008 and SQL server 2012 databases using PowerDesigner.

FIDELITY NATIONAL INFORMATION SERVICES (FIS), New York, NY 01/2010 – 10/2012

Senior Database Analyst

Acted as production DBA and Database Architect for SyndTrak front-office syndicated loan software system. Designed databases using Sybase PowerDesigner and MS Visual Studio, OLTP and VLDB databases with read only file groups and partitioned tables.

Enabled encryption of client data by implementing Transparent Data Encryption (TDE) for databases and encrypting connections to SQL server with SSL.

Improved database performance by creating, monitoring and maintaining complex maintenance plans (index fragmentation, appropriate backup strategies and software and database partitioning).

SAMUEL AARON INTERNATIONAL, Queens, NY 09/2006 – 04/2009

Database Administrator

Fulfilled DBA role for proprietary enterprise system of jewelry company. Managed performance tuning, data modeling, replication, log shipping, reporting and backup / recovery.

Implemented software reusability principles by writing reusable code in T-SQL and C# based on best practices and adopted standards.

Created data warehouse by developing OLAP solution using SSRS, SSIS, Visual Studio, C# and Embarcadero ER / Studio for Microsoft SQL Server 2008.

AMERICAN LAWYER MEDIA, New York, NY 08/2004 – 09/2006

Developer

Was developer for electronic legal reporting service organization. Installed, configured, and administered multiple Microsoft SQL Server databases and named instances of SQL Server in development and testing environments. Installed and administered Oracle 9i in development environments.

Contributed to team development of MA3000 docketing and calendaring system utilized by top law firms nationwide by strategically utilizing knowledge base.

Added to development of data warehouse by skillfully using PowerDesigner, Oracle 9i, ASP.NET, SSRS, Delphi and C#; handled extract, transform and load (ETL) program development.

IDT HORIZON GLOBAL TRADING, New York, NY 01/1999 – 01/2004

Programmer / Analyst

Developed and implemented solutions for company specializing in financial software development. Used Microsoft SQL 2000 and Erwin Data Modeler to design logical and physical databases. Interfaced with key clients and administered client databases, including log shipping and replication. Handled back-up and recovery efforts; performed regular fail-over and consistency checks.

Education

Bachelor of Science (BS) equivalent, Moscow State University of Fine Chemical Technologies, Moscow, Russia

Certifications

-Microsoft’s MCTS, MCAA and MCITP

Contact this candidate