PROFESSIONAL SUMMARY:

• Microsoft Certified SQL Server DBA with 8+ years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server 2014/ 2012 / 2008 R 2 / 2008 / 2005 / 2000 in Development, Test and Production Databases on various business domains like Healthcare, Insurance, Marketing and Manufacturing.
• Performed migrations from SQL Server 2000 to 2005 and 2008 R2, SQL Server 2005, SQL Server 2008 to SQL Server 2012 and Expertise in applying Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Installed and maintained SQL Server failover clustering (active/active and active/passive) for SQL Server 2005 and SQL Server 2008R2, SQL Server 2012 versions and have a good understanding of SQL Server 2014 features always ON, user defined server roles.
• Strong experience in monitoring database performance and tuning using various native tools namely Performance Monitor, Activity Monitor, SQL Profiler and Third Party Tools.
• Experience in Query Optimization techniques using DMV’s and DMF’s, DBCC commands, Index Rebuild / Reorganising and also used tools to identify slow running queries using Server - side tracing.
• Experience on Database Mirroring and Log shipping, SQL Server Replication that is Snapshot, Transactional.
• Experience in SQL Server Azure Subscription.
• Created Databases on SQL Azure and setting up Azure’s firewall.
• Create, manage SQL Server AZURE Databases and Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Has experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services, Package Configurations, Logging, System and User Defined variables for SSIS packages.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 by creating SSIS packages.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Index, Views, User Functions, SQL joins, Relational Database Systems following Data Integrity and normalization.
• Filtered bad and inconsistent data using complex T-SQL statements and implemented various constraints and triggers to maintain data consistency and to handle complex business rules, history data and audit analysis.
• Created stored procedures and used Common Table Expressions (CTE) and various kinds of User Defined Functions (UDF) in the stored procedures to make the code easy to understand and reliable.
• Configured Security at Active Directory and SQL Server by Mapping users to roles. (Securable and Permissions).
• Experience in Production Support for very large (VLDB) and Complex Databases.
• Provided Disaster Recovery through Replicated SAN and Multi Subnet Clustering.
• Implemented SQL Server Failover Cluster Installation.
• Has experience in using SCOM (System Center Operations Managers) for monitoring performance.
• Has experience in 24*7 Production Support and in mentoring junior SQL developers.
• Experience in analyzing blocking issues, concurrency and locking.
• Has configured resource governor I/O enhancements.
• Have experience in all phases of software development life cycle including project management, functional requirements definition, technical design, development, testing, quality assurance, system certification, systems implementation and system validation.
• Develop or modify SQL queries and stored procedures to meet business requirements and achieve desired performance
• Commendable experience on ITIL methodologies in regards to IT infrastructure management.
• Performed Hardening of servers after migration of data.
• Has worked as SQL Server DBA in Vmware environment and Hyper V.
• Flexible, Enthusiastic and project oriented team player withexcellent communication skills and analytical skills to develop creative solution for challenging client needs.
• Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.

TECHNICAL SKILLS

Languages: C, C++, DDL, DML, T-SQL,SQL, PL/SQL, J2SE

RDBMS: MS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000, SSAS, SSIS, SSRS, MS Access.

Front End: HTML 3/5, CSS, MS Visual Basics 6.0, SharePoint 2010,2013

Web Technologies: ASP.Net, WCF Web Forms, XML Web Services

Middle Tier: Servlets, JSP, JAAS, JTA, JSTL, JTA, EJB 2.0/3.0,MSMQ, Microsoft .Net Technology.

Tools: SQL DB Access, SQL Profiler, Query Analyzer, Performance Monitor, Backup Utility,, Lite Speed, Red Gate, Fog Light,, SSRS, SSMS, SQL Server Data Tools, SQL Server BIDS, Microsoft Visual studio 2008/2010/2013 T-SQL, VB Script, Database Tuning Advisor, Upgrade Advisor, SQL Configuration Manager and Service Manager, Activity Monitor, Resource monitor,PowerShell, Tivoli Storage Manager, Microsoft Solution Center, JIIRA, TFS, SSIS, SSAS, BCP, Red Gate, Lite Speed.

Web Server Technologies: IIS 5.1/6.0., MTS.

Data Modeling Tool: ERWIN 4.0, Visio 2007.

PROFESSIONAL EXPERIENCE

Confidential, CA

MS SQL Server DBA

Responsibilities:

• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Re-porting Services (SSRS).
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Managing alerts and security, Re-indexing/Reorganizing Indexes, performing DBCC checks.
• Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
• Performed Scheduling jobs and monitoring and troubleshooting them.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and built in performance reports.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Moving/Copying of Databases from one server to another server using Backup-restore, Attach and detach methods and refreshing databases in development, QA and stage environments using production backup.
• Generated daily and weekly monthly reports involving customized and on-demand reports using SSRS and also involved in analyzing multi-dimensional reports in SSRS.
• Worked on Subscriptions of Reports and automated the Jobs for Running the Reports.
• Performed migration of databases to SQL AZURE.
• Has created relational queries against stored data in SQL AZURE.
• Connected SQL Server Agent on local server to SQL Azure server to run jobs.
• Implemented row level security and dynamic data masking on SQL AZURE.
• Performed handling metadata through Metadata Management Systems such as Structural, Descriptive and Administrative.
• Performed Multi Server administration.
• Configured ALWAYS ON setup between different Data Centres and on Multi Subnet Cluster.
• Created linked servers between SQL Server & Oracle 11g.
• Used Business Intelligence Development Studio (BIDS) graphical user interface (GUI) to design SSIS packages for data management applications
• Used BCP utility to publish table output to text files.
• Migrated VLDB’s from SQL Server 2008 R2 to SQL Server 2014.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Environment: SQL Server 2005/2008R2/2012/2014, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013,T-SQL,VB Script, PowerShell, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, SSRS,SSIS,SSAS,TFS,JIIRA.

Confidential, CA

MS SQL Server DBA

Responsibilities:

• Performed migrations from SQL server 2008R2 to SQL server 2012
• Implemented and Maintained Clustering (active/active, active/passive) as a high availability procedure.
• Implemented and Maintained Transactional and Snapshot Replication and Performed troubleshooting and fine-tuning of databases for its performance and concurrency.
• Performing query optimization and performance tuning using native tools like performance monitor, resource monitor, profiler, DMV’S and performance reports.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers and managing SQL server usingPowerShell scripts
• Creating logins and database users, roles and providing permissions to users and roles according to the requirement and security policy.
• Has implemented TDE (Transparent Data Encryption) and column level encryption.
• Deploying reports in reporting server and Creating and providing permissions to users on reports in a reporting server.
• Configured report manager for creating report subscriptions, snapshots, and caching.
• Uploaded Reports on to Report manager and Organized them based on Business Rules.
• Integrated and transformed data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages.
• Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points.
• Created SSIS packages to load data into staging table and data mart and also Performed logging in SSIS packages to capture error data and for error handling.
• Performed Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Created maintenance plans for Re-indexing/Reorganizing Indexes and for performing DBCC checks on databases and updating statistics for smooth execution of queries and purging old files for preventing space issue.
• Designed scripts using T-SQL for getting information about history of backups and restoration, database space utilization, alert for critical errors or events, resource intensive queries and general monitoring and maintenance tasks.

Environment: SQL Server 2005/2008R2/2012, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2013, T-SQL,VB Script, PowerShell, SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, SCOM, Microsoft Solution center, TFS, SSRS, Crystal Reports, SSIS.

Confidential

MS SQL Server DBA\SQL Developer

Responsibilities:

• Responsible for installing and maintaining SQL 2008 R2 Cluster environment and Performed migrations from SQL server 2005 to SQL server 2008R2/2012.
• Applying existing servers with relevant Service Packs, Hotfixes and any Critical Security Updates released by Microsoft.
• Implemented High availability & Disaster Recovery procedures, Cluster (active/active, active/ passive), DB Mirror, Replication and implemented log shipping using Litespeed.
• Used BCP utility to publish table output to text files and created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in configuring report manager for creating report subscriptions, snapshots, and caching and optimized Performance and Capacity planning of Various Data processes related to Reports.
• Uploaded Reports on to Report manager and Organized them based on Business Rules.

Environment: SQL Server 2005/2008/2008 R2/2012, Windows 2008 server, Windows Server 2008(x64), SQL Server Management Studio, Visual Studio 2010, T-SQL,VB Script, PowerShell,SSRS, Crystal Reports, SSIS,SQL Profiler, Activity Monitor, Data Collector, Performance Monitor, Database Tuning Advisor, Tivoli storage manager, lite speed tool.

Confidential, New York

SQL Server DBA

Responsibilities:

• Managed and Administrated the SQL Server 2008/2008R2/2005/2000 production and Non-production servers.
• Tuned aggressively stored procedures in order to increase the performance with no cost effective.
• Administered and maintained production/Development servers with more than 2 TB of database size with complex structures.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Worked with SQL Server 2005 side by side upgrade from SQL server 2000.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Expertise in setting up and troubleshooting Database mirroring.
• Optimized working process.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance based on level of fragmentation.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Memory Configuration for SQL server on 32-bit boxes.
• 24/7 on call support.
• Created various jobs to check health of the server and to troubleshoot.
• Developed SSIS packages, stored procedures, functions, triggers.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
• Hands of experience in writing batch files.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.

Environment: SQL Server 2008/05/00,Windows 2003, Windows 2008 Server, MS SQL Server 2000/2005, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, Fog Lite.

Confidential

MS SQL Server DBA

Responsibilities:

• Monitor Server capacity and Daily health checks for the Database servers.
• General Maintenance i.e. Re-indexing/Reorganizing Indexes, Monitor and support client server databases on Windows 2003 server.
• Used SQL script to find heavily fragmented indexes and have re-organized the indexes accordingly to get desired performance from the tables.
• Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Controlling access permissions and privileges and resolving security issues such as orphaned users, creating roles and granting permissions on various objects.
• Checking backups and making sure enough space on the disks and resolving space management issues and Troubleshooting failed jobs and Locking/Blocking issues.
• Checking SQL Logs and Event Viewers for any errors.

Environment: SQL Server 2000/2005/2008 , Windows Server 2003(x64),SQL Server Management Studio, T-SQL, Query Analyser, SQL Profiler, Performance Monitor, Resource

Confidential

SQL Server DBA/Developer

Responsibilities:

• Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2005.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005 database.
• Created and optimized SSIS packages for data flow between SQL Servers.
• Extensively used SSIS and DTS packages for Data Archiving.
• Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Provide 24 X 7 dedicated support to all Production, QA & Development MS SQL Server Environments.
• Installed, configured and maintained Transactional Replication Server.
• Configured Different RAID Levels
• Checking Database Health by using DBCC Commands and DMV.
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Created Triggers to enforce data and referential integrity.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analysis and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.

Environment: SQL Server 2000/2005, T-SQL, Excel, Advanced Windows 2003 Server & PVCS Version Control Management.