SUMMARY

• SQL Server Databaseand Window Administrator (Service Engineer) having 10+ years of experience, well versed in all phases of System Development Life Cycle (SDLC) including analysis, design, programming, implementation and maintenance of stand - alone and web-based database applications with the management capabilities of handling the team offsite and working closely with customers for the internal applications too. Including the following abilities:
• Played an SME (Subject Matter Expert) role for 5applications and supported, managed the offsite team.
• Proactive in identifying the risks and issues for the applications and determined the solutions well in advance.
• Closely worked with the end customers and internal customers and received many appreciations and Kudos from them.
• Extensive experience in MS-SQL Server Administration including Design and implementation of Distributed/ Replicated Databases, planning/ implementing backup/ recovery strategies, Performance tuning and Data Migration (CLUSTERED MIGRATION).
• Expert in data migration from MS SQL Server /2008, including Replication and clustered SQL Servers.
• Expert in Windows server 2000, 2003, 2008 and 2008 R2.
• Designing, testing and implementation of high availability solutions like Clustering, Database Mirroring, Log Shipping,andReplication of databases for large, medium and small customers to further increase scalability and stability of business critical systems.
• Experience in data migration from existing databases to remote data centers.
• Intensive experience in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Design and develop new ASP.Net MVC/JQuery/Telerik application pages to enhance existing in house line of business freight management web application. High emphasis on calculation (w/ unit testing/logging). Mid-tier/layer is a sophisticated object oriented library consisting of Linq queries for calculation and leveraged through multiple applications.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Expertise in developing drill-through, drilldown reports using SQL Server 2005 Reporting Services (SSRS)
• Experience in working with 24/7 production Environment with thorough understanding of Confidential Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages, BCP, DTEXEC, DTUTIL and BULKINSERT.
• Involved in design and development of DTS and SSIS packages to load and process the data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa.
• Assisting in development of new line of business application to replace existing. Technologies used are ASP.Net 4.0, JQuery, Silverlight 4/5, and SQL 2008 R2.
• Experience in implementing different types of Replication Models.
• Experience in Microsoft Analytics Platform System (APS) HDInsight.
• Has good knowledge in implementing Log Shipping Technique as a part of disaster recovery plan.
• Experience in writing and debugging Stored Procedures, Views and Triggers.
• Experience in performance tuning of very complex SQL statements and procedures using show plan.
• Proven ability in Performance Tuning andQuery Optimization.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expert in performing database consistency checks and planning and scheduling, Backup & Recovery.
• Created clustered and non-clustered indexes for increasing the performance, also monitored the indexes by troubleshooting any corrupt indexes by removing fragmentation from indexes.
• Provided 24/7 database maintenance and support.
• Technologies Used: Windows 2008 R2, IIS 7,ASP.Net4, MVC, C#,SQL2008 R2/2012/2014, SSIS Integration Services, Analysis & Reporting Services with MDX programming, JavaScript, JQuery, Bootstrap, HTML, CSS, Silverlight 4/5
• Good Team Player, Strong Interpersonal, Analytical and Communication Skills combined with self-motivation.
• Self-motivated, creative teamlead player with effective communication and Leadership qualities.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, C,C++,C#.

Database Application Software: SQL Server 7.0/ 2000/2005/2008, MS Access, Oracle

DB Utilities: SQL Server Management Utilities, Query Analyzer.

GUI: DTS Import/Export, SQL Server Integration Services.

Reporting: MS Access, Excel, MS SQL Server Reporting Services 2000/2005, SSIS, SSAS.

ETL Tools: SSIS,DTS

Application Software: Microsoft Office

Change Management Tool: Team Foundation Server (TFS)

Scripting Language: POWERSHELL

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows XP/98/95, MS DOS, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

SQL DBA

Responsibilities:

• Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs
• Worked closely with the customers of the internal applications and maintained the trustworthiness to deliver the requirements within the expected time.
• Proficient in generating reports using Microsoft Office Applications.
• Creation and maintenance of DTS/SSIS and PowerShell jobs.
• Played an SME(Subject Matter Expert) role for 5 applications supporting and managing the offsite team.
• Upgraded Production Server from Azure V11 to the latest version Azure V12.
• Migrated SQL 2014 Databases on Cloud using SQL Server Azure
• Installed SQL Server on Windows 2005/2008/2008 R2 Servers.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Developed various T-SQL stored procedures/functions for the Application.
• Stored procedure tuning on SQL Azure.
• Installed SQL Azure Data Sync client On Premise Database in order to communicate with Azure Database on cloud
• Responsible for database tuning using normalization and application tuning
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler
• Data migration between different environments and Third Party Databases.
• Monitored user accounts, user permissions, table partitions and backup.
• Estimating of Table sizes and Record sizes.
• Developed ASP.Net 1/2/3.5, VB.NET 1/2/3.5, Visual Basic 6 applications that interface with SQL Server backend databases.
• Used System Center Configuration manager SCOM to monitor servers.
• Performed database consistency checks.
• Backup recovery schedules, Backup scripts.
• Developed Database Backup Scripts and automated this process
• Worked on generating MOM and SCOM reports on mission critical servers for CPU usage, Memory (available memory) and disk space.
• Configured SCOM 2012 to create management packs to monitor the SQL Server
• Worked in windows administration environment also.
• Involved in Account Rotation, Password Rotation, application train releases and deployments
• Worked on Mirroring, Replication, Logshipping, Clustering on the SQL Servers
• Worked as a Live Site engineer which means the 24/7 availability.
• Set up BCP environment for the tools I used to support.
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Creating monthly transaction report for all sections.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Managing the users including creation/alteration, grant of system/ DB roles and permission on various database objects.
• Developed business, database objects and security objects using C# and ADO.NET
• Used C# for XML web services in project
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team

Confidential, Newyork City, NY

SQL Server DBA

Responsibilities:

• Worked with Terabytes of Data with over 3000 databases
• Installed, configured and managed MS SQL 2005 and 2008 fail over Clustering for production servers on 64 bit platforms to provide high availability.
• Worked on Active - Active and Active - Passive clustering environment.
• Post deployment Installations on SQL 2008 servers on Windows 2008 servers.
• Installed recommended service packs and security patches on production, test and development servers.
• Migrated Databases from SQL 2005 to SQL 2008.
• Thorough understanding of Confidential SOP’s, SLA’s and change control management process.
• Extensively used Remedy Ticketing and CAMS (internal application) for change requests.
• Generated Performance analysis reports for all the prod servers on a weekly basis using third party tool Quest Diagnostic Managaer..
• SQL Server Documentation Scripting with Powershell
• Deployed the SSIS packages using manifest file in Production environment.
• Created Linked Servers between SQL server 2005/2008 and Oracle servers in the environment
• Created batch files for Veritas Netbackup and scheduled them with SQL Job for both system and User Databases.
• Modified some of the Jobs which have the steps to truncate backup log for the database which is in simple recovery mode as this option is now not supported in SQL server 2008
• Used PerfMon and Profiler trace files to find the blocking issues which occur as a result of I/O and CPU bottle necks and memory leaks.
• Assisting in development of new line of business application to replace existing. Technologies used are ASP.Net 4.0, JQuery, Silverlight 4/5, and SQL 2008 R2.
• Worked on 24 /7 Production support understanding the business SLA’s.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Responsible for Database Backups & Restoration, Backup strategies and scheduling Backups.
• Conversion of the legacy systems data into MS SQL server using SSIS packages.
• Designed databases for different projects and resolve database issues.
• Created SSIS / DTS packages to pull data from Oracle and Flat Files.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Generated different reports using MS SQL Reporting Services (SSRS).
• Performed Database refreshes from Prod to UAT and Dev servers
• Developed business layer and data layer using Object Oriented Programming in C# with Entity Framework 3.5.
• Reviewed and deployed the code provided by developers in Prod and QA servers.
• Involved in handling Work Orders and Documentation of the Change Process by creating Tasks using Service Center.
• Manage security issues by analyzing permission structure and make the necessary adjustments to ensure people have the appropriate privilege.

Environment: SQL Server 2000/2005/2008, MVC, Windows Enterprise Server 2003/2008, Microsoft Visio 2003, Microsoft Integration Services. T-SQL, Query Analyzer, Microsoft APS, SQL-Profiler, Foglight, Citrix application.