Technical Summary

• Certified SQL Server DBA with 6 years of strong experience in administration, design and implementation of SQL Server 2012/2008R 2/2008/2005/200 in small to large database environment. Looking for SQL Server DBA position with new challenges and opportunities to build and implement my extended knowledge.
• 6 years of Experience in Design, Implementation and Administration of SQL Server Database on various versions of MS SQL such as MS SQL Server 2012/2008R 2/2008/2005/2000
• Expert in installing and applying service packs/Cumulative Updates, configuring, managing and troubleshooting SQL Server
• Solid experience on Implementation and administration of SQL Server Failover Clustering
• Worked on setting up and maintaining AlwaysOn Availability Groups as part of High availability and disaster recovery plan.
• Solid experience in automation, creating alerts and maintenance jobs for checking database integrity, scheduling backup, index maintenance and update statistics etc
• Experience in logical and physical database design, data modeling and deployment
• Worked extensively on high availability and disaster recovery solutions including Log Shipping, Mirroring, Replication and Failover clustering
• Experience extend to all levels of database administration in Test, Development and Production environments
• Highly experienced in upgrading and Migrating SQL Server 2000/2005 to SQL Server 2008/2008R2 and to 2012.
• Experience in managing health of SQL Servers including backups, restores, monitoring, Performance Tuning, Query Optimization, etc
• Extensively Worked on Pro - Actively monitoring SQL Server with native tools as well as using third party tools such as NetIQ, Idera DM and Ignite
• Experience in configuring and troubleshooting linked servers between different RDMS
• Solid experience in setting and implementing database security and user management
• Experienced in creating and monitoring job steps and troubleshooting failed steps
• Extensively worked on backup and recovery using both native tools and third party tools
• Hands-on working experience with analyzing query execution plans, minimizing query costs, managing indexes, troubleshooting blocking and deadlocks
• Experienced in Monitoring hard drive and log space, applying DBCC Shrink and other DBCC commands as needed
• Experience in migration of Data from Excel, Flat file to MS SQL Server by using Import and Export Wizard, BCP and Bulk Insert
• Performed Extracting, Transforming and loading of data using SSIS
• Worked with Microsoft SQL Server Reporting Services SSRS and report builder
• Experience in creating and maintaining databases, database objects such as tables, view, stored procedures, triggers by using Transact SQL
• Experience in SQL server database optimization and performance tuning using SQL Server profiler, performance monitor, Database Engine Tuning Advisor DTA
• Monitoring SQL Server error logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully
• Solid Experience in moving a database using backup and recovery, detach/attach methods and T-SQL Scripts based on the business requirements
• Strong Verbal and written communication skills and ability to interact with all organizational level, hard worker and quick learner
• Excellent in team work as well as self-sufficient
• Worked on 24X7 Production support and also involved in on call rotation.

TECHNICAL SKILS OVERVIEW

Database

SQL Server 2012/2008R 2/2008/2005/2000

ETL Tools

SSIS, BCP,DTS

SQL Server Native Tools

SQL Server Management Studio, Database Upgrade Advisor, Query Analyzer, SQL Profiler and Database Tuning Advisor, SQLCMD, Reporting Services Configuration Manager, Business Intelligence Development Studio BIDS, SQL Server Configuration manager, DBCC

Programming

SQL, T-SQL, Store Procedures, Trigger, HTML, ASP, ASP.net

Operating System

Version Control

Windows Server 2012, 2008, 2003, Windows XP Professional, Windows 7 Professional, VMware

VSS Visual Source Safe

Hardware/Storage

SAN, RAID

Third Party Tools

Idera DM, Idera Compliance Manager, SQL Safe Lite, Erwin, Spotlight, Ignite

Professional Experience

SQL Server DBA

Confidential

Currently working as Contractor SQL Server DBA on multiple Migration and consolidation projects. This includes communication with clients, creating implementation strategy and capacity planning. This project is focusing on centralizing data centers and cutting licensing cost on software while maintaining efficiency.

SQL Server DBA

Confidential

Responsibilities:

• Managed and worked across more than 130 servers and 600 databases in production, development and test environment.
• Implemented and installed SQL Server Failover Cluster of 2008 R2 and 2005
• Setup AlwaysOn Availability Groups for HA and DR solutions on SQL 2012.
• Add nodes to an existing SQL Server clusters R2
• Apply periodic patches to failover cluster and standalone SQL Servers of Server 2008 R2 2012
• Created linked servers from SQL Server to Oracle and SQL Server databases
• Troubleshoot and provide solutions for linked server connectivity issues
• Participated in identifying requirements and cost analysis for new projects
• Build and configure SQL Server database server and apply company standard checklists
• Configured transactional replications between data centers
• Configured and troubleshoot Log Shipping and Mirroring for DR solutions and high availability
• Deployed SSIS packages to SQL Servers and scheduled an SSIS job to run regularly
• Troubleshoot SSIS Package issues and worked with developers in solving then in BIDS
• Deployed Reports on SSRS and provide access to users on Report servers
• Refreshed UAT servers with Production data based on request
• Deploy databases from Dev to UAT and then to Production environments after approval
• Managed and provided user permission based on company regulations
• Worked on Data base migration from 2000 and R2 and to 2012.
• Managed, monitored, extrapolate data growth and requested storage for data, log and backup drives accordingly
• Troubleshoot and provide solutions for automated alerts from NETIQ monitoring tool
• Identify bottleneck and solve performance, connectivity and any kinds of issues raised by clients
• Worked with developers in deploying codes and assisted in providing better performing and issue free scripts
• Worked on Remedy ticketing system, managed SQL Server team's Remedy queue and assigned tickets for team members
• Setup SQL Server jobs, troubleshoot and fix failed jobs
• Daily monitored backup jobs, SQL Server Error logs and event logs
• Monitored performance issues using both SQL Server native tools and third party tools such as Idera dm and Ignite
• Run profiler for persistent performance issues and review and apply recommended Indexes and statistics using Tuning Advisory
• Monitored index fragmentation and rebuild and reorganized as necessary
• Worked on on-call rotation for 24x7 production support

SQL Server Database Administrator

Confidential

Responsibilities:

• Upgraded SQL Server 2000/2005 to SQL Server 2008 and applied service pack.
• Involved in database design and modeling and developed E-R Diagram using ERWin and SQL Server Data Diagram
• Tuned queries by following best practices and finding missing indexes, checking fragmentation level and reindex tables as necessary for efficient application access methods.
• Created database objects including tables, indexes, constraints, stored procedures, views, triggers, and maintained relationships between tables
• Build and deploy SQL Server tabular reports using SSRS and Report Builder
• Build and deploy SSIS Packages
• Verify, maintain troubleshoot database backups, integrity checks, and scheduled jobs.
• Identified, tested and resolved database performance issues to ensure optimization
• Experienced with Point-in-Time and Point-in -Failure Recovery
• Develop and document disaster recovery plan as per the company requirement
• Documented changes and deployment steps in production environment in an organized manner
• Managing day to day SQL Server operations such as review SQL Server Error log, check database consistency, check and verify SQL Server Job status and so on
• Configured Log Shipping as a solution for disaster recovery
• Configured database mail and set up alerts system through SQL Server agent
• Imported and Exported data from various sources to SQL Server using SSIS and Import and Export Wizard
• Experience in Database Design activities including Data Files and File group organization
• Deployed and scheduled SSIS Package
• Interacted with developer team in fixing problems associated with applications and database issues
• Give appropriate server role and database role for different users.
• Involved in deploying SQL Server Databases from Test Server to Development Server and from Development to Production Server and vice versa for database refresh
• Managed multi-Server environment
• Involved in setting up Transactional Replication for offloading report activities to secondary server.
• Scheduled jobs to automate different database related activities including backup, DBCC checks, disk space utilization, backup and verification, index defragmentation, update statistics etc and created automated alerts for issues and passed-thresholds accordingly
• Provided 24 x 7 Production support for the database and application issues

Jr. Database Administrator

Confidential

Responsibilities:

• Installed, configured, managed and apply periodic patches on SQL Server 2000, 2005 and 2008.
• Installed and configured SQL Server Reporting Services SSRS
• Participate in data collection and database design.
• Worked on Creating, modifying and managing tables, Index, Constraints and Views
• Configured and Maintained Mirroring and Log Shipping as part of a high availability solution
• Setup Replication on multiple database for reporting purpose.
• Upgraded and migrated databases from SQL Server and 2008 in test and production environment
• Extensively worked on database backup and restore automation and other recursive maintenance jobs
• Worked on security administration, created roles for various user groups.
• Monitoring Server Activity, Error Log, space usage, and solving problem as needed
• Export Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, and SSIS