PROFESSIONAL SUMMARY:

• 12+ years of experience in Development and Database Administration for very large and complex databases in SQL Server 2012/2008 R 2/2008/2005/2000 for production and development environment.
• Installation of SQL Server 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, write the script to create a table, copy the table data into another database or another server, get foreign key of single table or all tables in database, 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 scheduled 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, HTML,VB6, 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/2008R 2/2008/2005/2000.

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

SQL DBA and SQL Server Developer

Responsibilities:

• I worked as dba MSSQL with all version from MSSQL2000 to MSSQL2012 MSQLSERVER Enterprise 2000
• MSQLSERVER EnterpriseMSQLSERVER Enterprise 2008MSQLSERVER Enterprise 2008R2MSSQLSERVER Enterprise 2012,
• SSRS, SSIS, Service Broker.
• 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 SQL SERVER 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, 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 automatically scheduled for populating data into the database with row by rows verification.

Tools: SRSS for batch loading and unloading repots files (*.rdl) to/from database Silverlight application which reads the excel file as input and make SQL script as output for recording data to/from data base.

Confidential

Responsibilities:

• Involved in analysis, database design, creating database and tables.
• Installation of the SQL Server 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 reference 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, T-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

Lead DBA and SQL Server Developer

Responsibilities:

• Involved in creating databases and tables
• Involved in SQL Programming to develop Stored Procedures, Service Broker,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)

Confidential

DBA and SQL Programmer

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)