Summary

• Senior MS SQL Server DBA with 8 years of IT experience in Database Administration, Design, Development, Installing and Support of MS SQL Server 2012/2008/R2/2005/2000 in Production, Testing and Development Environment's.
• Experience in Data Migration from MS SQL server 2000/2005 to 2012/2008 R2.
• Extensive experience in Implementing, Upgrading, Migrating to SQL Server 2012
• Implemented AlwaysOn availability groups and replicas for reporting, backup and performance
• Expert in managing SQL Server in Physical and Virtual Environments
• Experience in implementing different types of Replication topologies involving Snapshot, and Transactional replication.
• Expert in monitoring SQL Server with Diagnostic Manager and FOGLIGHT tools
• Expert in Installing and configuring SQL Server Cluster in Active/Passive and Active/Active environments.
• Implemented Sync and Async MIRRORING for Disaster Recovery Implementation
• Implemented Backup and Restore in SQL Server using Native SQL Backups and also using Third party tools like Veritas NetBackup, Sandpiper, TSM and LITESPEED.
• Expert in using Ticketing and Change Management software.
• Expert in Using extensive SQL Server DMV's for performance tuning and Monitoring
• Experience in Performance Tuning, Query Optimization, Database Consistency Checks using DBCC Utilities, Linked Servers.
• Expert in implementing Full, Differential, Log and Compressed backups
• Experience in using different Transformation tools like DTS Packages, SSIS and also, BCP and BULK INSERT.
• Expert in Creating, Deploying, Scheduling solid ETL Packages in SSIS
• Experience in creating reports in SSRS and deploying in various servers
• Has good knowledge in implementing Log Shipping, Data Mirroring Techniques.
• Experience in Software Development Life Cycle SDLC and configuring Alerts using SQL Mail.
• Expertise in planning and implementing MS SQL server Security and database Permissions.
• Well aware of SOX compliance, SQL Server change control management and Reporting Services.
• Expert in T-SQL writing and developing Database Objects, Triggers, stored procedures, Functions and Views.
• Sound experience of writing POWERSHELL scripts
• Extensively involved in writing SQL queries Sub queries and Join conditions , T-SQL programming and Query Level Performance tuning
• Experienced in Loading data into multiple tables using DB Management Tool like Import and Export, SSIS Packages

Technical Skills

• Operating Systems : Win2000, Win2003, Win2008, WinXP, UNIX, UBUNTU
• Database : MS SQL Server 2000/2005/2008/2008R2/2012
• Database Tools : VERITAS Net Backup, SQL Nexus, Perfmon,
• SQL Lite Speed 5.1, Red gate, Spotlight
• Languages : T-Sql, Java, C .NET, ASP.NET, VB.NET, MVC, Powershell
• Networking : TCP/IP, LAN, WAN, Citrix, VM Ware-virtualization

PROFESSIONAL EXPERIENCE

Confidential

Role : System Analyst, SQL Server

Roles and Responsibilities:

• Responsible for supporting over 350 SQL instances which include SQL 2000 / 05 / 08 / R2 2012.
• Migrated Databases from SQL Server 2005 to SQL Server 2008R2/2012 in Production and test Environments.
• Installation of SSIS 2008R2 Active/Passive cluster on a Windows 2008R2 cluster and Performed in place upgrade of SSRS from 2008 to 2008R2.
• Installed SQL Server 2012 Cluster and configured 'Always On' availability group set up on Windows Server 2012 in Development SIT environments.
• Configured Monitored Supported and Troubleshooting of Database Mirroring and Log Shipping for multiple databases on Geo-graphically separated cluster environments to provide High Availability and Disaster Recovery. Support and troubleshooting for Transactional replication.
• Designed and implemented backup plans as per the data- retention policy outlined in the BRD Business Requirement Document .
• Supported Load Testing activity by setting up and scheduling Performance Monitor Data Collector Sets and SQL Server Profiler Trace and monitoring them during the activity.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Created Maintenance Plans to checking database integrity, rebuilding indexes and updating statistics
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
• Extensively worked on Profiler, Perfmon Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creating new Databases and Migrated SQL Server 2005 databases to SQL server 2008R2 by using Backup-Restore, Detach-Attach, Management Studio Wizards and custom scripts.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Worked on Migrating Oracle MYSQL databases to MSSQL using SSMA tool.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Used Quest Lite speed to set up Log Shipping and create Backup Job's.
• Implemented Pager options to inform corresponding DBA basis on each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments Development, QA, UAT and Production are in sync DB Refresh when requested .
• Monitored the Performance of the SQL Server by using Performance Monitor, SQL Profiler, Foglight Performance Analysis and Spotlight.
• Managing Security of SQL Server Databases by creating Server Logins, Database Users, Roles and assigning permissions in compliance with standards and resolving Account Locking issues by coordinating with Active directory Group.
• Define db scripts versioning system to keep track of database versions for all environments.

Confidential

Role : Sr. Database Administrator, SQL Server

Roles and Responsibilities:

• SQL Server 2008 R2/05 installation configuration on windows system.
• Setup and administrate/support SQL Server versions 2000 thru 2008R2, with Log shipping, mirroring, clusters, partitioning.
• Responsible for SQL installations, SOX security compliance, backup/recovery, migrations, procedural documentation, and tuning.
• Upgrading of SQL database from SQL Server 2005 to SQL Server 2008.
• Provided all support for SQL Server day-to-day issues, and support of the 400 production / development server and closely working with app. team s
• Developed and supported existing monitoring, performance maintenance backup, tuning, recovery, disaster avoidance methodologies on all DB platforms
• Leads the offshore DBAs and provides co-ordination with the client. Being a part of on-call rotation.
• Diagnose corruption and perform repairs.
• Handlings tickets and troubleshoot and Provide resolutions. Install and Configure SQL SERVER as per standards and guidelines per ITIL process, SR, Incident and CR.
• Diagnose and recommend suggestions for performance bottlenecks.
• Setting up maintenance plans, notifications for job failures through DB Mails.
• Deploying and setting up SSIS packages. DTS in legacy systems. Setting up databases using separate file groups.
• Indexing and maintenance setup, monitoring scripts with .bat, OSQL and PowerShell, creating PowerShell scripts for automating tasks.
• Integrated with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database.
• Designed and documented a Disaster Recovery Plan for the databases and also modified scripts for all jobs including Backup restore.
• Implemented Database Mirroring, Log shipping between Primary Server and a Standby Server.
• Created Database Snapshots to delta load data from the snapshot database to the report database

Confidential

Role : Sr. Database Administrator, SQL Server

Environment : Microsoft SQL Server 2000, 2005 and 2008, MS Visual Source Safe, MS Visual Studio.NET on Win Server 2003

Roles and Responsibilities:

• Production support for SQL server environment.
• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2005 and 2008 environments.
• Involved in Migration from SQL 2005 to SQL 2008.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
• Used Data Transformation Services DTS an Extract Transform Loading ETL tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services SSIS as a part top transfer logins from SQL server 2005 to 2008 and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Used DBCC commands to check physical and logical consistency of the databases
• Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using Wizards and SQL Profiler
• Involved in coding complex stored procedures and debugging for optimum performance
• Implemented Backup and restore in SQL Server using Third party tool Idera SQL safe.
• Maintained multiple instances SQL Servers with maximum availability.
• Involved in 24x7 on call support.

Confidential

Role : Database Administrator, SQL Server

Environment : Microsoft SQL Server 2000, 2005, 2008 on Win Server 2003

Responsibilities:

• Daily responsibilities include administration and monitoring of Database servers.
• Fine-tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
• Used Activity monitor and SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Created Users and Roles, and managed security and permission of database
• Involved in Migration from SQL 2000 to SQL 2005.
• Implemented and Monitored Transactional Replication in SQL Server 2005
• Tuning database and SQL statements for optimal performance.
• Created SQL Server Jobs to automate the running of routine tasks such as backups, restores.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
• Maintained log shipping for disaster recovery.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
• Transferred logins and passwords between instances of SQL Server 2005.
• Monitoring the event logs and Server error logs for troubleshooting purposes.
• Created various maintenance plans for the regular databases maintenance jobs in the SQL server.
• Used different kinds of SSIS packages in order to move the data from one server to another.
• Providing Mentoring and guidance to the other staff personnel and help desk on database related issues.