Sql Server Manager

Manoj Kumar Sadhu

Phone: +1-551-***-****

Email Id:-***********@*****.***

Career Summary

• 8+ years of experience in Database Administration for different applications as a SQL Server DBA Consultant.

• Experience in Installation of SQL Server configuring server options, Creating and managing Database for SQL Server. Applying SQL Server latest Service Packs and Security updates.

• Good Experience in high availability and recoverability of databases in 24/7 environment by using clustering, replication, mirroring, log shipping, backup and restore to meet RTO/RPO objectives.

• Experience in deploying, configuring and administering Always On: Availability Groups.

• Upgrading/Migrating SQL Server to higher versions 2008, 2012, 2014.

• Strong command of performance tuning and proven experience in troubleshooting performance problems (Indexing, Optimizer, server configuration, Profiler, DMV etc.) including TSQL programming and debugging skills.

• Expert in implementing High Availability options Failover Clustering, Log shipping, Mirroring and Replication (Transactional, Snapshot & Merge) and migration.

• Experience in SSIS packages and SSRS reports deployment.

• Experience in creating Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.

• Expertise in dimensional modeling in Star and Snowflake models.

• Administered and supported 150+ number of instances.

• Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.

• Excellent T-SQL skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions.

• Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.

• Experience in Managing and Configuring Backup and Recovery strategies for Databases.

• Played a key role in business requirements analysis, physical and logical Data modeling, application development, testing, training, production support and Project review with client.

• Working knowledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.

• Proficient with Client/Server tools like SQL Server Enterprise Manager, SQL Server management studio and Query Analyzer to Administer SQL Server.

• Exposure to multiple database platforms like Oracle, MySQL and Mongo DB.

• Experience in working with huge databases, troubleshooting issues and documenting the causes.

• 24 X 7 Production Database on Call Support.

• Excellent communication and inter-personal skills, technical documentation and reporting skills, accustomed to working in both large and small team environments.

• Good leadership qualities to support the goals of the organization.

Technical Skills:

Databases

MS SQL Servers 2000, 2005, 2008, 2008r2, 2012 and 2014, Oracle 11g, 10g, 9i, PostgreSQL, SQL Azure and AWS.

SQL Server Tools

SQL Server management studio, SQL Profiler, SQL Query Analyzer, Index Analyzer, Perfmon, DTA, TOAD, TKPROOF, Enterprise manager and IMPORT/EXPORT.

Languages

SQL, T-SQL, PL/SQL, SQL*Loader, XML, Shell scripting, Visual Studio, ASP.NET, LINQ,VB.NET, C#.

Design Tools

Magic Draw, Rational Software Architect, Visio, Erwin

Operating Systems

Windows, Linux, Ubuntu

Professional Experience

Client: Bed Bath & Beyond, Union, NJ

Designation: Sr.SQL Server DBA July 2014– Current

Description:

Bed Bath & Beyond Inc. is an American chain of domestic merchandise retail stores in the United States, Puerto Rico, Canada and Mexico Formed in 1971, the stores sell goods primarily for the bedroom and bathroom, as well as kitchen and dining room. The company is included in the S&P 500 and Global 1200 Indices and the NASDAQ-100 Index. It is also counted among the Fortune 500and the Forbes Global 2000 as well.

Responsibilities:

• Working as a Production DBA and Responsible for performance of the SQL Server instance and safety of the data in database.

• Installed and Configured SQL Server 2014, 2012 and 2008r2 in enterprise cluster and standalone environments.

• Migration of databases from SQL Server 2005 to SQL Server 2008r2 and SQL Server 2012.

• Working Knowledge on AWS and Azure cloud technologies.

• Configured, tuned and maintained MySQL database servers.

• Solid hands-on skills in migrating/upgrading SQL Server 2005 to 2008/2008R2&SQL Server 2005, 2008/2008R2 to 2012 and .2014 and applying service packs, extensive experience in migrating and new installations of SQL Server on Hyper-V and VMWARE environments.

• Responsible for working on different kinds of Replication on the Production Servers.

• Involving in Database creation, Backup, Restoration, Recovery and Space Management.

• Creating SQL jobs to extract data from available databases to tables and flat files.

• Performing various point in time recoveries of various SQL Server databases in production and test environments.

• Work with windows team to failover the cluster if needed after windows patching.

• Working with developers to tune SQL queries to improve the performance.

• Working on LINQ for query the data objects in C++, C#, VB.net.

• Distributing huge tables to different file groups to maximize the performance.

• Monitored and modified performance using execution plans with query hints and index tuning.

• Migrated Oracle databases to SQL Server for SAP migration.

• Worked on High Availability Disaster Recovery during SQL 2014 migration.

• Frequently maintaining the databases and reorganizing the defragmented the data.

• Created SSIS packages to load robust data from different Heterogeneous data sources like Oracle, DB2 to SQL Server.

• Creating views, store procedures and optimizing them as required by the front-end developers for easier implementation on web pages and performance testing on store procedures, indexes, and triggers.

• Performing database consistency checks with DBCC, Defrag, Index tuning and monitoring error logs.

• Configured and managed virtual servers.

• Experience in implementing and migration databases to Microsoft Cloud Environment.

• Created DB master key, symmetric keys, asymmetric keys and certificates for encryption.

• Scheduling the jobs using SQL Server agent and providing the security to databases.

• Maintaining database consistency with DBCC at regular intervals, Managed Disk space and memory, User connections and Monitored SQL Server performance using profiler to find performance and deadlocks.

• AWS migration- RDS and EC2 instance creation and administration.

• Troubleshooting the issues using outputs of SQL Trace, SQL Diag, error log, Blocker script and event log.

• Performing partition for efficient management database tables and indexes.

• Utilizing the SQL Server tools like SQL Server Profiler, Perfmon, and Index tuning wizard, Database tuning advisor and Activity monitor to optimize the queries and improve the performance of database servers.

• Created a dimensional data warehouse and converted the Oracle database to Amazon AWS Redshift cloud environment due to enterprise data move to cloud solution.

• Scheduling and Maintaining FULL, DIFF, and LOG database backups as per the company strategy to meet the recovery point objectives.

• Providing 24/7 support for critical production databases (OLTP and OLAP).

Environment: SQL Servers (2014,2012 and 2008r2), DBCC, Defrag, SQL Server profiler, Perfmon, SQL Diag, SQL Trace, VMWare, Index Tuning Wizard, DTA, AWS, Oracle, OLTP and OLAP.

Client: UBS, Weehawken, NJ

Designation: Sr. SQL DBA Aug 2012 – Jun 2014

Description:

UBS AG is a Swiss global financial services company, incorporated in the Canton of Zurich, and co-headquartered in Zurich and Basel. The company provides wealth management, asset management, and investment banking services for private, corporate, and institutional clients worldwide, and is generally considered to be a bulge bracket bank. In Switzerland, these services are also offered to retail clients. The name UBS was originally an abbreviation for the Union Bank of Switzerland, but it ceased to be a representational abbreviation after the bank's merger with Swiss Bank Corporation in 1998. The company traces its origins to 1856, when the earliest of its predecessor banks was founded.

Responsibilities:

• Database Administrator/Database Programming/Product specialist.

• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.

• Extensively worked on compliance issues.

• To analyze long running slow queries and tune the same to optimize application and system performance.

• Worked on key performance indicators for customizable metrics.

• To set up SQL Server configuration settings.

• Monitoring SQL server performance using profiler to find performance and dead locks.

• Rebuilding the indexes at regular intervals for better performance.

• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

• Monitored and modified Performance using execution plans and Index tuning.

• Rebuilding the indexes at regular intervals for better performance.

• Using log shipping for synchronization of database.

• To setup, implement, and maintain industry standards in database management.

• Monitoring SQL server performance using profiler to find performance and dead locks.

• Monitoring the servers using spot light third party Quest software.

• Implemented the online indexing on 24X7 environments.

• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.

• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.

• Involved in DATA Analysis like Analyzing and Accessing collection of Data.

• To analyze long running slow queries and tune the same to optimize application and system performance.

• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.

• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.

• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases

Environment: SQL Server with clustering, Replication, T-SQL, Windows 64-bit, SQL, PL/SQL, DTS, SSIS, Profiler.

SQL Server DBA

FORD MOTOR COMPANY - Detroit, MI (March 2010 to July 2012)

Description: FORD MOTOR COMPANY is the largest auto maker. FORD MOTOR COMPANY is 8th ranked in the S&P 500 index.

Responsibilities:

• Installed and Upgraded from SQL Server 2000 to SQL server 2005, 2008 and 2008 R2.

• Migrated Databases from SQL Server 2000 to SQL server 2005 and 2008.

• Worked in Active-Passive and Active-Active Cluster environment as a High availability solution.

• Created and maintained Database mirroring with automatic failover, Metro Mirroring (SAN Mirroring) and Resilient infrastructure as a High availability

• Worked with the table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.

• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.

• Used Policy Based Administration feature (SQL Server 2008).

• Worked with SCOM Monitoring

• Created Table Valued Parameters (SQL Server 2008) of a table value data type and be able to pass this variable into a stored procedure.

• Rendered Reports to Microsoft Word using SQL Server 2008.

• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.

• Used DTS Exchange tool for migrating DTS packages to SSIS

• Worked in Active Passive and Active Cluster environment as a High availability solution.

• Performing Backup/Restore to/from Legato server (Tape) and Disk

• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.

• Extensively used TSM backup

• Expert in configuring Temp DB.

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development

• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

• Expert in Performance Tuning of the Stored Procedures.

• Checking Database Health by using DBCC Commands and DMVS

• Monitored and modified Performance using execution plans and Index tuning.

• Experience in Database security and integrity planning

• 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 Reporting 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.

• Routine DBA jobs like Backups and Restores

• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2008, 2005 and 2000, T-SQL, Erwin, ASP.Net, C#, SSAS, SSIS (ETL), SSRS, Windows 2003 Server.

SQL Server Developer/DBA

Inovalon -Herndon, VA (October 2008 to February 2010)

Description: is a technology company based in Bowie, Maryland. It uses cloud-based analytics and technology to help clients achieve insights that improve clinical and quality outcomes, utilization, and financial performance in the field of healthcare.

Responsibilities:

• Installed MS SQL Server 2008 R2, 2012, updating with latest service packs and security patches.

• Managed Databases spread across multiple servers in Production, Development, staging & testing environments.

• Worked extensive with database design team and development team for database design and implementation, used Erwin and Visio for database design and SQL 2008 for development.

• Implemented the Data Partitioning for large tables in SQL Server 2008.

• Created custom log-shipping to manage Disaster Recovery and Production Support restores

• Scheduling the DBCC commands to run daily, weekly basis. Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification.

• Expert in using DMV's, Performance dash board, Mirroring, database snapshot.

• Worked file and file group Backup/Restore. Maintained the database consistency with DBCC at regular intervals

• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

• Involved in logical designing and physical designing the databases using Erwin.

• Performing DB Security, creating users, roles, and assigning permission.

• Worked on SQL server 2008 T-SQL new features such as MERGE statement and Date time offset Data type.

• Implemented new T-SQL features added in SQL Server 2008R2 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).

• Extensively worked on SQL Server Integration Services (SSIS).

• Implemented new topics like CLR integration on Development server.

Environment: MS SQL server 2005/2008R2/2012, Windows 7/XP, VB, .Net, Enterprise manager, Query Analyzer, DTS, SQL profiler

Education: Bachelor of Education in computer Science.

Contact this candidate