Professional Summary:

• Installation of new Sql Servers 2012/2008R2/ 008/2005 or upgrade from the low to highest version.
• 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.
• 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 .

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:

Confidential

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 Server Developer

Confidential

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

Confidential

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.

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
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
• Setting Database Mail, writing Stored Procedures to send email and sms to mobile device.
• Migrated packages from development server to production server using package configuration
• Used Bulk Insert and BCP to load data from flat files
• Developed web pages as refrence how call RSS report from webpage.
• Developed many SSRS,SSIS projects
• Developed tools script SRSS for batch loading and unloading repots files .rdl to/from database.
• Developed SSIS Packages ETL to load the Enterprise Order XML files to database and process them to generate content authorizations
• Setting RSSS service, security, access to service, managing users.
• Involved in creating Synonyms and Linked Servers to communicate between different databases across different servers
• 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 .

Confidential

Role: Lead DBA and SQL Server Developer

Description:

Hi-G-Tek, The Highly Intelligent RFID Solutions Provider, goes aboveand beyond traditional asset monitoring platforms with its Pro-Active lineof RFID solutions. The company provides real-time information using patented remote sensing wireless technology to monitor high-value cargowhile in-transit or at fixed locations. Hi-G-Tek's Pro-Active Visibilityand 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
• Developed windows applications C, ADO.NET, Win. forms for transferring data .
• stored procedure, Functions, Views, Triggers and database administrative tasks.
• Designed and developed database, database maintenance for development and production,
• Involved in developing Service Broker application for transfer data between servers .
• 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

Confidential

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 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