SUMMARY

• Having total experience of 10 years in the IT industry.
• Having 8 Years of relevant experience as a MS-SQL Server Database Administrator.
• Experience in SQL Server database administration Configuration.
• Hands on Experience in installing, configuring, managing and troubleshooting SQL Server 2000 2005, 2008, 2008R2 and SQL Server 2012.
• Experience in providing Production support for Database and Applications.
• Outstanding knowledge of high availability SQL Server solutions, including Log shipping, Mirroring and Replication.
• Performing Back-ups, Restores, Scheduling and Maintenance planning.
• Having Good knowledge on clustering.
• Assigning SQL server roles and granting permissions to the users.
• Knowledge to manage Logins across the servers.
• Exposed to Performance Tuning of SQL Server Databases.
• Monitoring and resolving Blocking/deadlock issues.
• Developing successful Backup strategies based on recovery model.
• Experience in supporting Production Servers and Applications 24x7.
• Exhibits strong teamwork and individual drive - highly motivated, articulate and eager to learn.
• Experience in Development of User Interfaces and User Enhancements, including Analysis, Design and Development of Web based E-commerce, B2B, Client-Server, Migration, integration and Distributed Applications.
• Experience in designing or creating entity relationship diagrams and implementing database objects based on an ERD.
• Having knowledge in Importing SSIS packages and deploying the packages in to prod environments.
• Strong troubleshooting and organizational skill.
• Knowledge in T-SQL Powershell Programming.
• Good Communication and Interpersonal skills.
• SQL Server 2012 certified and ITIL V3 foundation process certified.

SKILLS:

• Database : MS SQL SERVER 2000 / 2005 / 2008 2012.
• Database Tools : SQL Server Management Studio, SQL Profiler DTA.
• Operating System : Windows server 2003/2008/2012 and XP.
• Ticketing Tools : Advent Net Manage Engine, CA-SPSD, Remedy, HPSM SNOW.
• Monitoring Tools : Tivoli, HPOV.
• Languages : .Net 2.0 C With ASP.Net
• Web Servers : IIS, Tomcat.

PROJECT DETAILS

Project 1:

Client : Confidential

Domain : Entertainment

Team Size : 9 Onsite, offshore .

Team Name : Production Support Team.

Role : Track Lead -SQL Server DBA.

Project Description:

The Confidential, together with its subsidiaries and affiliates, is a leading diversified international family entertainment and media enterprise with five business segments: media networks, parks and resorts, studio entertainment, consumer products and Corporate. We were having around 210 SQL servers under support including Confidential.

Roles and Responsibilities:

• Administering SQL Server Production Database.
• Maintaining the servers - applying patches and service Packs.
• Backup and Restoration of System and User databases.
• Monitoring SQL Server Jobs and Troubleshooting on failure.
• Installing, Configuring database servers.
• Applying latest Service packs and cumulative updates.
• Troubleshooting SQL Server production issues.
• Monitoring database growth, managing Databases, data files, log files.
• Managing SQL Server security and logins.
• Rebuilding the indexes at regular intervals for better performance.
• Dealing with performance issues on production servers.
• Moving objects from QA to Production databases.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Setting up and supporting weekend/Interval database activities. Reindexing, Backup and Restoration
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security create and maintain users and roles, assign privileges .
• Ensuring high availability of the database using the concepts of mirroring, replication, Log shipping etc.,
• Database application tuning and performance monitoring.
• Plan growth and changes capacity planning .
• Work as part of a team and provide 7 24 supports when required.

Project 2:

Client : Confidential

Domain : Health care Pharmaceutical

Team Size : 5 Onsite, offshore .

Team Name : Production Support Team.

Role : SQL Server DBA.

Client Description:

Confidential is pharmaceutical organization. Shire is having three datacenters two in Confidential,and for SQL Server prospective we were having around 163 Server including dev, test and prod.

Roles Responsibilities:

• Installation and configuration of SQL Server.
• Applying latest Service packs and cumulative updates.
• Creating automated reports as per customer requirements.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Creating linked servers and SQL Server network aliases.
• Configuring TCP ports as per application requirements.
• As a part of the DBA team providing 24x7 production support to the clients.
• Monitoring the Scheduled jobs.
• Migration of databases from one Server to Other Server.
• Ensuring high availability of the database using the concepts of mirroring, replication, Log shipping etc.
• Monitoring the Disk spaces on all the servers.
• Importing and exporting the data.
• Creating SQL Users and providing required permissions.
• Creating maintenance jobs on the production Servers.
• Analyzing, Identifying and Resolving performance issues of the server.

Project 3:

Client : Confidential

Domain : Health care Pharmaceutical

Team Size : 4 Onsite, offshore .

Team Name : Production Support Team.

Role : SQL Server DBA.

Project Description: Confidential Healthcare specializes in providing oncology practices with comprehensive customized solutions that increase efficiencies and enhance the quality of patient care. CONFIDENTIAL Healthcare's online tools and resources connect physicians, patients, pharmaceutical companies and payers. In this project we have provided the support for CONFIDENTIAL Health care Prod,Dev,QA Servers, preparing a lot of documentation for space related issues, Database migration pre-requisites, Backup servers and many more. We had around 60 SQL Servers in the environment including Prod, Dev QA .

Roles Responsibilities:

• Setting up new SQL Servers 2005 and configuring the required users.
• Configuring Log Shipping, Maintain and troubleshoot Log shipping issues by continuous Monitoring Transaction Log Update's.
• Configuring DATABASE MIRRORING, Maintain and troubleshoot MIRRORING issues by Continuous monitoring Transaction Log Update's
• Managing security, monitor server performance and activities,.
• Administering the SQL Server by Creating User Logins with appropriate roles, dropping and Locking the logins, monitoring the user accounts, creation of groups, granting the privileges to Users and groups. SQL Authentication etc.,
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary creating backup strategies and scheduling them for execution.
• Resolving various performance issues and running DBCC, DMV commands.
• Indexing, Import/export data, backup restore database, managing servers.

Project 4:

Client : Confidential

Domain : Health care

Team Size : 9 Onsite, offshore .

Team Name : Production Support Team.

Role : SQL Server DBA.

Client Description:

Confidential services works on Health care domain. It gives support to number of outside clients. So as a part of Confidential we support different outside clients of Confidential.We support 200 servers including Production, Test and Dev environments, they will have different applications and each application will have one primary DBA for Major applications like Facets, Signa, NHP, CAE, and QNXT.

Roles Responsibilities:

• Installation, configuration and maintenance of MS SQL Server.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Monitoring the Scheduled jobs.
• Performing BCP in and BCP out on different environments.
• Performing Database refresh between Production, Test and Dev Environments.
• Implementation of Database maintenance plan
• Good experience in resolving blockings and Deadlock Issues by using SQL commands.
• Managing Security Creating users, logins and roles, granting permissions .
• To analyze long running slow queries and tune the same to optimize application and system Performance
• Involved in SQL Server Technologies like Log Shipping, Replication.
• Worked on disk space alerts, Job failure alerts.
• Daily Log checking for errors on Production Server.
• Rebuilding the indexes at regular intervals for better performance.
• Dealing with performance issues on production servers.
• Moving objects from QA to Production databases.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Setting up and supporting weekend/Interval database activities. Reindexing, Backup and Restoration
• Work closely with other team in other region to deliver the service.
• Monitoring SQL server performance using profiler to find performance and deadlocks.

Project 5:

Client : Confidential

Domain : Sales Retail

Team Size : 4

Team Name : Production Support Team.

Role : SQL Server DBA.

Project Description:

The main purpose of the project was to Install Implement Quantum, Configure Apache Tomcat with SQL Server for synchronization with RSunify Application, system maintenance and Troubleshooting the Software and guidance.

Roles and Responsibilities:

• Implementing the Software to over 20 Redistribution Stockiest in Eastern.
• Installation, Configuration and Up-gradation of SQL server 2005 Enterprise Edition.
• Backup client databases and perform database restore and run consistency checks from SQL Server and application.
• Maintaining High Availability of Databases using Mirroring concepts.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitoring SQL server performance using Profiler to find performance and dead locks.
• Regular checking of the database consistency using DBCC commands to minimize complexity.

Project 6:

Client : Confidential

Domain : Sales Retail

Team Size : 4

Team Name : Development Support.

Role : .Net Developer.

Environment: C , ASP.Net, ADO.Net, SQL Server 2000, IIS, JavaScript, CSS, Visual studio 2003, Windows SharePoint services, Visual source safe, Windows 2003.

Description: The project provides an alternative electronic means to Confidential to support customer interactions with delivery teams. It is not intended to replace Help Desk or face-to-face delivery interaction of Account or Delivery teams, however it is envisaged that its use could reduce the demand for certain face-to-face customer interactions. The project uses the document sharing feature of WSS for sharing documents between multiple people.

Roles Responsibilities:

• Designed user interface screens and implemented application.
• Developed DB Utility libraries using C and ADO.Net which is used by Business layer for all data manipulation.
• Used ADO.NET and data objects such as Data Adapter, Data Reader, Dataset, data table, stream reader for consistent access to SQL data sources.
• Developed generic user controls using C which is used in all modules of the system.
• Implemented logging mechanism.
• Prepare the test cases and reviewed the results.
• Perform Unit test, integration test and System test.