Sql Server Development

Dmitriy Burtsev

*** ****** ******, ****** ******, NY 10305

718-***-**** . *********@*****.***

Microsoft SQL Server Database Analyst

Demonstrated technical expertise designing, deploying, administering,

tuning, and optimizing complex databases supporting a range of business

needs. Develop reports, stored procedures, jobs, triggers, indexes, and

packages to execute routine processes and maximize productivity. Monitor

database performance and proactively mitigate issues and bottlenecks to

eliminate downtime. Effectively communicate with users and colleagues to

troubleshoot, diagnose, and repair problems and errors.

Areas of Expertise:

Database Design / Management Security / Access Management

Troubleshooting / Technical Support Disaster Recovery Planning

Technical Proficiencies

Certification MCITP Database Administrator 2008, MCTS SQL Server 2008 BI, MCSA

s: Windows Server 2003, Tekmetrics Delphi.

Platforms: Windows 2008 R2, Microsoft SQL Server 2008 R2, VMware

Tools: Sybase PowerDesigner 16.1, Erwin Data Modeler r7.2, Embarcadero ER

/ Studio 8, Microsoft Visual Studio, C#, PowerShell, Delphi,

Hardware: SAN, DAS, RAID

Professional Experience

Senior Database Analyst, Fidelity National Information Services (FIS), New

York, NY 1/2010 - 10/2012

Served as production DBA and Database Architect for SyndTrak. SyndTrak is

a front-office syndicated loan software system.

Key Achievements:

. Designed databases using Sybase PowerDesigner and MS Visual Studio.

OLTP and VLDB databases with read only filegroups and partitioned

tables.

. Implemented Transparent Data Encryption (TDE) for databases and

encrypting connections to SQL Server with SSL.

. Designed and implementing disaster recovery for production

databases. Failover applications between different datacenters.

. Monitor production, staging and UAT environment with System Center

Operations Manager (SCOM)

. PowerShell scripting administrative task.

Database Administrator, Samuel Aaron International, Long Island, NY

9/2006 - 4/2009

Served as DBA for proprietary enterprise system for jewelry company with

responsibility for performance tuning, data modeling, replication, log

shipping, reporting, and backup / recovery. Provided 24 / 7 maintenance

for production database as well as Microsoft Navision (NAV) SQL Database;

troubleshot and diagnosed technical issues, providing user support to

minimize business interruptions. Drafted detailed technical documentation

for existing environment. Collaborated with management and led planning

for future growth and system enhancements. Created roles and privileges to

manage database security and access. Designed reports using SSRS. Provided

basic assistance with network administration.

Key Achievements:

. . Created and optimized stored procedures using Transact-SQL (T-

SQL) and CLR (C#), triggers, indexes, packages, jobs and CLR User-

Defined function to address complex business needs..

. Wrote reusable code based on best practices and adopted standards.

. Developed data warehouse/OLAP solution using SSAS, SSRS, SSIS,

Visual Studio .NET 2005 C# and Embarcadero ER / Studio for Microsoft

SQL Server 2008 for reports.

. Expertly utilized Profiler and 3rd-party tools, including SQL

Heartbeat server monitoring tool.

. Used Spiceworks 3 network management software for network

administration.

. Successfully implemented IBM DB2 for iSeries in Microsoft SQL

environment.

. Oversaw procurement and maintenance of servers for Storage Area

Network (SAN) HP MSA 1500 / 1000 and Direct-attach Storage (DAS)

PowerVault MD 3000 / 1000, including RAID configuration and firmware

upgrade, configuring SAN and Cluster server.

. Established comprehensive disaster recovery / Business Continuity

program to address a range of potential issues and minimize

downtime.

Developer, American Lawyer Media, New York, NY 8/2004 - 9/2006

Served as DBA and developer for electronic legal reporting service

organization. Installed, configured, and administered multiple Microsoft

SQL Server databases and and named instances of SQL Server in development

and testing environments. Additionally installed and administered Oracle

9i in development environments.

Key Achievements:

. Played key role in development of MA3000 docketing and calendaring

system utilized by top law firms nationwide.

. Contributed to development of data warehouse using Sybase

PowerDesigner, Oracle 9i, and C#; handled extract, transform, and

load (ETL) program development.

Programmer / Analyst, IDT Horizon Global Trading, New York, NY 2/1999

- 4/2004

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. Managed deployment of database changes from

development to production environment. Conducted performance monitoring

and optimization.

Key Achievements:

. Assisted with development of GovCLEAR application to calculate start-

of-day positions, settle trades, and automate clearance with BONY or

Chase in real time using Windows NT interfaces and IBM MQSeries

communications software.

. Served on team designing, developing, and implementing Financial

Trading Platform using Embarcadero ER / Studio, Microsoft SQL Server

and Delphi.

. Education and Training

Bachelor of Science in Biotechnology, Moscow Institute High Chemistry

Technology, Moscow, Russia

Contact this candidate