Summary:

• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in providing Good production support for 24 x 7.
• Experience in installation, configuration of MS SQL Server on Windows NT, and 2008 servers.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities, Capacity Planning.
• Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and standalone environment.
• Experience working with MS SQL Server 2000, 2005, 2008, 2008 R2 and 2012 versions.
• Expertise in upgradation from lower version to higher versions.Having very good expertise in Migration and Upgradation.
• Prepared templates for migration process Non Production and Production environments.
• Expertiseto enhance the SOP's for Migration process checklist.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL server 2005/2008.
• Implemented Database Mirroring as a High Availability Solution.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in implementing RAID 1-5 10 technologies.
• Experience in creating packages, jobs, sending Alert using SQL Mail and Database mail.
• Creation and Maintenance of Databases, Creating Roles and managing user Permissions, resolving deadlocks
• Working with MSBI team to develop SSIS, SSRS and Data reports.
• Worked on SAN EMC, IBM and HP Arrays for SQL Server Databases and good understanding in capacity planning.Worked experience in HPSD, ITSM and ITG ticketing tools.
• Experience in Microsoft SQL Server CLUSTERING and experience in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server.
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model the requirements.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and Unattended Installations.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and related errors.

Technical Skills:

Professional Experience:

Confidential

Senior SQL Server DBA

Responsibilities:

• Working with MS SQL Server Database Security and Auditing SQL server Systems.
• Working with Microsoft SQL Server Mirroring,Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server
• Working on data integration SSIS with Data HUB team to prepare Data growth report.
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Prepare the build release checklist for Non Production and Production environments.
• Handling 2TB database size and average DB size more than 600 GB for MSBI environment.
• Implementing CDC for few databases in Production Environment.
• Working on missing indexes and fine tune the server to access the application.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
• Monitored performance and optimizedSQL queries for maximum efficiency, worked with SQL Server 2008 R2 Service Broker Applications and hands on experience in Foglight.
• Implementing Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
• Responsible for the management of the database performance, backup, replication, capacity planning and giving guidance for the developers.
• Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and addedIndexes to improve performance on tables.
• Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity
• Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance in SSIS and SSRS.
• Checking the status of Backup troubleshooting the failed backups and Restoration of databases
• Deployed the generatedreports on to the server and fine-tuned the database objects and server to ensure efficientdataretrieval.

Environment:

MS SQL Server 2008 R2 Enterprise Edition, Windows Server 2008 R2, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler and Index Tuning Wizard.

Confidential

Senior SQL Server DBA

Responsibilities:

• Worked with MS SQL Server Database Security, Encryption Keys and Auditing SQL server Systems.
• Worked with Microsoft SQL Server CLUSTERING,Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server
• Creation of schema objects, granting roles and privileges to the users, compilation of procedures.
• Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
• Expertise migration from SQL 2008 to SQL 2012 environment.
• Prepare the Migration checklist for Non Production and Production environments.
• Enhance the SOP's as per new version development.
• Handling 1.2TB database size and average DB size more than 500GiB.
• Refreshed databases when necessary, worked in SQL ServerPerformance Tuning and Query Optimization.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups.
• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures
• Monitored performance and optimizedSQL queries for maximum efficiency, worked with SQL Server 2005 Service Broker Applications
• Implementing Log Shipping and Database Mirroring. Monitoring with SQL Profiler to capture and save data about the event to a file or table to analyze later
• Responsible for the management of the database performance, backup, replication, capacity planning and security.
• Worked in Tracing SQL Server events and SQL Profiler to monitor events in an instance of Microsoft SQL Server, involved in Performance Tuning of Code using execution plan and addedIndexes to improve performance on tables.
• Installing and configuring MS SQL Server 2005/2008 and 2012 Personal, Standard and Developer Editions
• Excellent skills in Optimization of T-SQL procedures, removing the deadlocks, Client/Server Connectivity and guidance to developers.
• Performance analysis and evaluation of queries and databases in a slow running application and monitoring/optimizing/tuning the performance of SQLServer
• Checking the status of Backup troubleshooting the failed backups and Restoration of databases
• Deployed the generatedreports on to the server and fine-tuned the database objects and server to ensure efficientdataretrieval.

Environment:

MS SQL Server 2008 R2 Enterprise Edition,Idera SQL Diagnostic manager, Windows Server 2003, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler,Index Tuning Wizard.

Confidential

Senior SQL Server DBA

Responsibilities:

• Installed SQL Server 2005 in production and development environments.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database for Disaster Recovery.
• Creating back up strategies and scheduling them for execution.
• Performance Monitoring using SQL Profiler, Windows System Monitor, System Stored Procedures, Foglightand DBCC Commands.
• Migration experience from SQL 2005 to SQL 2008.
• Prepare the checklist and enhance the SOP's for Migration Template.
• Managing average 500 GiB to 600 GiB database in Production and Stage servers.
• Monitored SQL server LOGS, Application logs and analyzed the logs.
• Wrote stored procedures, Triggers, Cursors to implement business logic.
• Monitoring disk space alerts and act as according to the space management.
• Implementing alerts for backup fail/success, disk space, agent jobs fail/success...etc.
• Implemented and documented proactive monitoring scripts for production databases
• Provided support for ETL developers in loading of client's data into SQL Server using ETL tool.
• 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.
• Fine tuning the Database Settings as well as the Server Settings.
• Configured Mail Profile for sending automatic mails to the respective people when a job is failed or succeed. Maintaining SQL Script for creation of Database Objects.
• Configured customized log shipping for SQL Server 2005importing and exporting of the Database using DTS utility.
• Creating, maintaining the users, roles and granting privileges.

Environment:

MS SQL Server 2005/2008 R2 Enterprise Edition, MS Integrated Services 2005, MS Analysis Services 2005, SQL SERVER Reporting Services, MS Access, Import Export Data

Confidential

SQL Server DBA

Responsibilities:

• Performed backups and restoration, developed backup strategies, scheduled transfer of backups and tested their viability
• Created system procedures for databasemaintenance and monitoring them
• Installed and configured SQL Server 2005 on Windows 2003 Servers, applied service packs and security fixes
• Managed index, statistics and optimizing queries by using execution plan for tuning the database.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Handling not more than 500 GiB in Production Environment.
• Implemented different types of constraints on tables.
• Created complex Stored Procedures, Functions and other T-SQL code and SQL joins for applications.
• Created and managed Schema object such as tables, views, indexes, procedures and triggers through Query Analyzer
• Worked with lead developers to help in their applications in terms of Data modeling and designing.
• Performed tuning of SQL statements and Stored Procedures
• Worked as a developer to tune the queries, run scripts and move the database from production to development servers
• Managing SQLServers in development and production
• Security Implementation. Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups
• Testing the application for deployment, Function and behavior testing
• Backup and Recovery: Designing Backup/Restore Strategy. Setup backup and recovery scripts. Setup exports
• PerformanceTuning: Analyze, tuning and optimizing for SQLServer code by using performance and index tuning wizard
• Up-gradation of SQL Servers database from version2000 to 2005
• Migration experience from SQL 2000 to SQL 2005
• Database creation and location of database file
• Monitoring of SQL Server/NT performance/deadlock tracing

Environment:

MS SQL Server 2000/2005, Windows NT, Crystal Report 8.5, Windows Server 2003.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Created complex Stored Procedures, Functions and other T-SQL code and SQL joins for applications.
• Created and managed Schema object such as tables, views, indexes, procedures and triggers through Query Analyzer
• Responsibilities include tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Installing, Configuring and Maintaining SQL Server 2005 with latest Service Packs, Hot Fixes.
• Implement Log Shipping in SQL Server 2005 from primary server to Standby server.
• Worked with on-site personnel or internal project manager to review problems, define and test solutions, and developed Ad hoc Queries and reports for user management.
• Responsibilities include Upgrading for two applications from MS SQL Server 2000 to MS SQL Server 2005.
• Responsibilities include advising in Planning and designing the Logical and physical Data Modeling.
• Help the team to write and tuned Stored Procedures, Triggers, UDF, Queries.
• Extensively involved in documenting upgrading procedures and project plans from MS SQL Server 7.0 to MS SQL Server 2000.
• Performed Structural changes to Database like creating tables, adding columns accordingto business requirement.
• Monitored growth of data and managed space allocation accordingly.

Environment:

MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2000, Windows Server 2003.

Confidential

Senior Software Engineer

Responsibilities:

• Transformed the complex business logic and calculations into coding.
• Responsible for writing T-SQL code for creating cursor and handling the data validations and developed complex T-SQL code for the application.
• Implemented calculations to aggregate physical measures, defined the Browsing Prospective and Browsing Translations and responsible for Process Database Objects Security Role.
• Defined Granularity with in a measure group and drill through actions.
• Automatic generation of grouping attribute members.
• Defined the Referenced Relationships with the measure groups and fact tables.
• Involved in creating SQL server Analysis Projects using MS SQL Server 2005.
• Involved in writing scripts for the clients requirements for reporting purposes.
• Managing of database objects Tables, Views, Indexes
• Installing and configuring of SQL Server2000 on Windows 2000/NT OS
• Implementing backups and restoring when necessary
• Deployed DTS Packages to transfer the Data between SQL Server database and Files
• Creation and management of database maintenance plan for various database consistency checks
• Used SQL profiler to monitor the Server performance, debug T-SQL and slow running queries
• Extensively used Joins and SubQueries to simplify complex queries involving multiple tables

Environment:

MS SQL Server 2000 Enterprise Edition, Oracle 7.1, Windows XP , .Net Framework 1.1 , Windows Server 2000.