Manager Sql Server

Yakov Ushakov

Phone: 267-***-****

Email: *******@*****.***

Education : Master’s degree, computer science .

Professional Summary:

10+ years of experience in Development and Database Administration for very large and complex databases in SQL Server 2012/2008 R2/2008/2005/2000 for production

and development environment.

Installation of new Sql Servers 2012/2008R2/2008/2005 or upgrade from the low to highest version.

Experienced in developing Microsoft.Net Technology web applications, windows applications, interfaces (console applications) and Web Services

Experienced in Developing .Net windows and console application to load data into the database from Flat Files, Excel and XM with rows by rows verification using C#, ADO.NET, Linq.

Experience in implementing Normalization and De-normalization

Expert in writing and tuning of all kinds of Transact-SQL

Experience in Developing SSIS Packages to Extract, Transform, Load (ETL) data into the databases, Flat Files, Excel and XML

Proficient in Creating, Configuring and Fine-tuning SSIS Packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Tuning advisor

Setting RSSS service, security, access to service, managing users.

Expertise in writing SRSS tools for batch loading and unloading repots files(.rdl) to/from database.

Highly proficient in writing Stored Procedures, User Functions, Views, Triggers and SQL Joins, sqlagent jobs for efficient Data Manipulation and Data Integrity

Implemented Data Validation and Database Mirroing techniques

Strong experience in Designing and Developing enterprise reports (SSRS/Business Objects) .

Experienced in logical and physical database design and development, normalization SQL Server Enterprise Manager

Experienced in Database Backup, Restoration, Linked Servers and Database Maintenance Planning

Extensively used Red Gate SQL Compare, Data Compare tools and VS2012 ultimate to compare and synchronize SQL Database schemas.

In addition to tools Red gate I had wrote my application MagicDbaUtility as MsSql dba assistant . Application has great features to connect to remote server, open the database,

perform operations necessary for DBA: it can remove the table,

to write the script to create a table, to copy the table data into another database

or another server, get foreign key of single table or all tables in dabase,

to remove or restore foreign key.

Experienced in developing projects uses Filestream and maintenance Filestream table .

Experienced in setting Database Mail, writing Stored Procedures to send email and sms to mobile device.

Experienced in analysis, design, development and unit testing of application systems in Client/Server and Internet/Intranet environments using Microsoft .Net Technologies

Experienced in developing webclients with multithreading (C#,ADO.NET,Linq,XML)

automatically cheduled for populating data into the database

with row by rows verification.

Experienced in using LINQ to perform database operations from code.

Experienced in developing Service Broker application .

.

Education Qualification:

Master’s degree of Belorussian State University.

Technical Skills:

•Operating Systems : Windows NT/2000/2003/XP/2008,, Windows 7, Windows server 2008 R2

•Languages : C#, C, Java script.

•Windows Technologies : Windows forms, WPF

•Web Technologies : ASP.NET, Silverlight, AJAX, Blend, WCF, XML/HTTP, HTML.

•Scripting languages : JavaScript, Jquery

•Database Technologies : SQL Server 2012/2008R2/2008/2005/200.

•Source Control : MS Visual Source Safe 6.0/Team Foundation Server

•Development Tools : Visual Studio .NET 2012 Ultimate/2010 Ultimate/2008/2005

Professional Experience:

Client: : Welcome center For New Pennsylvanians Jan’15

Role: .Net,DBA and sql Developer. Description:

The Welcoming Center for New Pennsylvanians is dedicated to serving new Americans in the metropolitan Philadelphia area .

Project : Teacher and administrator helper.

Client: Tehila of Ministry of Finance Israel. Jerusalem. Jan’08 – Aug’13

Role: Lead DBA and sqldeveloper.

Description:

The Israeli E-Government Project, called "Tehila" is a unit which belongs to the Ministry of Finance. Tehila's aim is to improve the online interaction between the government and the citizens. Tehila is known to have decreased bureaucratic difficulties. The two main roles of Tehila are as following:

1. Being the Internet Service Provider for the government's different ministries.

2. Hosting the government's ministries websites and services.

In addition to these main roles, Tehila is a key participant in every IT project that involves communication between the government and the citizens (i.e. PKI Infrastructure for citizens and the computerized Elections project).

Role: SQL DBA and SQL Server Developer

Briefly about my experience.

I worked as dba MSSQL with all version from MSSQL2000 to MSSQL2012

MSQLSERVER Enterprise 2000

MSQLSERVER Enterprise,

MSQLSERVER Enterprise 2008,

MSQLSERVER Enterprise 2008R2,

MSSQLSERVER Enterprise 2012,

SSRS,SSIS.

I have performed the installation of servers, database development, maintenance,

Performance tuning, monitoring for production and development support, sp, views, functions, trigger, reports, sqlagent jobs for monitoring data and manage changes and screen every second.

I specially created and managed the development server for development purpose.

It contains the 4 instance of sqlservers 2005, 2008, 2008R2, 2012,

SSRS, SSIS with which worked about 15 programmers remotely.

I was busy with many Projects about performance, coding, access to database,sql, connection problems.

Company managers often given me a special assignment to work independently,to solve key problems for architecture, coding and Technology and then share my results with team.

Thus had developed very interesting applications. There're only the most important

For example:

Webclient with multithreading (C#,ADO.NET,Linq,XML)

automatically scheduled for populating data into the database

with row by rows verification,

WPF application - call website dispatcher(WPF,C#,Ado.ne)

application to recover forgotten password access to site,

tools SRSS for batch loading and unloading repots files(.rdl) to/from database,

Silverlite application which reads the excel file as input

and make sql script as output for recording data to/from data base,

I was the first who used Filestream and then helped introduce to other Projects,

pages for site Menora that automatically update the screen

after changes in the database(.NET 4.5,ASP.Net,AJAX,C#,sql) and sql job,

which every second (really already over 3 years) has been

scaned data table for notifications about database changes

to cause reloading the page screen.

I have the original experience of reading and

Writing files of different types(.NET 4.5,C#,XML,EXCEL,image) from webservice

to the database with rows by rows verification.

But I think the my most interesting work, it is my own Windows application MagicDbaUtility as MSSQL DBA assistant . Application has great features to connect to remote server, open the database, perform operations necessary for DBA: remove the table, to wrote script create a table,to copy the table data into another database or another server, get foreign key of single table or all tables of database, to remove them for input actions and then restore them.

Project: Magnum.

Site Magnum - contain information about the structure of the Ministry, Employees, the country budget’s, an allocation financial audits.

Project: Menora.

Site Menora - contain information at which the government departments

announce their desires to purchase some equipment on a competitive basis and provide all necessary actions.

Project: Auction.

Purpose is the same as Menora, but performed in real time.

Project: Elections.

Project to collect voting information and results.

Project: of the Ministry of Transport.

Site timetable showing bus traffic in the Jerusalem and between Jerusalem and cities.

Project : MagicDbaUtility

In addition to tools like Red gate I had wrote my application MagicDbaUtility as MsSql dba assistant . Application has great features to connect to remote server, open the database perform operations necessary for DBA: it can remove the table, to write the script to create a table, to copy the table data into another database or another server, get foreign key of single table or all tables in dabase, to remove or restore foreign key.

Project: Server for developer.

It contains the 4 instances: sqlservers 2005,2008,2008R2,2012

SSRS,SSIS,SSAS with which worked about 15 programmers remotely.

And etc.

Responsibilities:

Involved in analysis, database design, creating database and tables.

Installation of new Sql Servers 2012/2008R2/@008/2005 and upgrade from the low to highest version.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions

Used Joins, corelated and non corelated sub queries for complex business queries

Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization

Involved in creating Synonyms and Linked Servers to communicate between different databases across different servers

Setting RSSS service, security, access to service, managing users.

Developed SSIS Packages (ETL) to load the Enterprise Order XML files to database and process them to generate content authorizations

Developed tools (script) SRSS for batch loading and unloading repots files(.rdl) to/from database.

Developed many SSRS,SSIS projects

Developed web pages as refrence how call RSS report from webpage.

Used Bulk Insert and BCP to load data from flat files

Migrated packages from development server to production server using package configuration

Setting Database Mail, writing Stored Procedures to send email and sms to mobile device.

Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler

Create application for Import and Export utility, for transferring data from code (C#,ADO.NET,Linq)

Continuous Support for Database Programming related issues

Conducted user training sections and supported the requests for enhancements, modifications and new tools.

Implemented C#.Net interfaces to connect with other enterprise systems and web services .

Solved problems for many Projects about performance,,access to database,

sql and sql connection .

Environment: SQL Server 2012/2008 R2/2008/2005, Visual Studio .Net 2012/2010/2008, C#.Net, Windows Server 2008 R2, Business Intelligence Development Studio, SQL Enterprise Manager, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), XML and my application MagicDbaUtility.

Client: Hi-G-Tek Computers/Technology. Jan’07 – Jan’08

Role: Lead DBA and SQL Server Developer

Description:

Hi-G-Tek, The Highly Intelligent RFID Solutions Provider, goes above

and beyond traditional asset monitoring platforms with its Pro-Active line

of RFID solutions. The company provides real-time information using

patented remote sensing wireless technology to monitor high-value cargo

while in-transit or at fixed locations. Hi-G-Tek's Pro-Active Visibility

and Security solutions deliver precise and immediate information on

logistics, business operations, and cargo condition. Hi-G-Tek's unique

capabilities ensure visibility, security and value for valuable assets.

Project: Develop the HI-G-TEK system of working with database.

Higtek developed a system for wireless security the process of transporting containers and tracks.

A key part of the system must be database. It was necessary to develop a structure of database,

Its interaction with the incoming information.

Responsibilities:

Involved in creating databases and tables

Involved in SQL Programming to develop Stored Procedures, Dynamic Management Views and User-defined functions

Involved in developing Service Broker application for transfer data between servers .

Designed and developed database, database maintenance for development and production,

stored procedure, Functions, Views, Triggers and database administrative tasks.

Developed windows applications(C#, ADO.NET, Win. forms) for transferring data .

Used SQL Joins and Sub queries for complex business rules

Identified, tested and resolved database performance issues (monitoring and tuning) to ensure data optimization

Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler

Worked on Multi-tier Application Architecture

Used Bulk Insert and BCP to load data from flat files

Continuous Support for Database Programming related issues

Environment: SQL Server 2008/205, Visual Studio .Net 2008, Business Intelligence Development Studio, SQL Enterprise Manager, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Client: Automoti Jan’06 – Jan’07

Role: DBA and SQL Programmer

Project:

Site was disigned for car sales after the lease. The site belongs to American customer.

Here I have worked to develop and support the American site(www.automoti.com) and American owner for selling cars after lease in the USA (website for the American customer).

Responsibilities:

Developed Stored Procedures, Views and User Defined Functions using T-SQL statements

Used SQL JOINs, Temporary tables and Sub Queries

Used performance optimizations tools like SQL Profiler to improve the performance

Involved in performance tuning of Stored Procedures and T-SQL statements

Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance.

Worked on importing/transferring the data to database tables using DTS, Import and Export utility

Support for Database programming related issues

Environment: SQL Server 2005, Windows Server 2003, SQL Enterprise Manager, SQL Query Analyzer, SQL Profiler, Data Transformation Services (DTS)

Contact this candidate