SUMMARY

• Over 4 years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2014, 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues.
• Having hands on experience in DR processes including Log Shipping and Replication.
• Proficiency and expertise in SQL Server Backup/Recovery, Disaster recovery and planning.
• Handled multiple SQL Instances on Cluster environment.
• Worked on SQL Server 2014 migration from SQL Server 2008.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Experience working with Production (24 x 7) and Development environment.
• Worked closely with management, applications development staff, and users on database solutions to business problems.
• Results oriented application developer with the primary focus in delivering the projects and providing excellent support for the business users.
• Consistently received Outstanding/Above Expectations ratings in various roles in the career.
• In-depth utilization of the Software Development Life Cycle (SDLC). Practical experience with utilizing the best practice policies and procedures for product development and support of systems.
• Experienced in working with large development teams and long-term projects, as well as small teams and quick-turnaround projects.
• Excellent analytical, interpersonal and communication skills, desire to excel, fast learner, hardworking and versatile team player.
• Maintained Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Strong technical and business development skills with strong experience in leading the development of web based n-Tier Enterprise applications and client/server products. Areas of expertise include SQL Server VB, and ASP.

TECHNICAL SKILLS

Programming Languages: C, BS, SQL, TSQL

RDBMS: MS-SQL Server 2005/2008/2008 R2/2012/2014, Microsoft Access.

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008/2008 R2/2012, DTS.

OLAP Tools: SQL Server Analysis Services (SSAS) 2005/2008/2008 R2/2012.

Reporting Tools: SQL Server Reporting Services (SSRS) 2005/2008, Crystal Reports.

Database Tools: SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer.

Operating Systems: Windows Server 2003/2008/2008 R2/2012, Linux, Unix.

Performance Tools: Spotlight, Foglight, Idera, Tivoli, SCOM, Erwin

Backup tools: Idera, Litespeed, Native Backup, RedGate.

PROFESSIONAL EXPERIENCE

SQL SERVER DBA

Confidential

Responsibilities:

• Install and maintain SQL Server 2008, 2012 and 2014, development and production environments and apply Service Packs (SP) and hot fixes on SQL Server 2005, 2008, 2012, 2014 Instances.
• Manage Database Log File Size and Virtual Log Files (VLFs).
• Configure server memory for maximum performance and effective utilization.
• Configure Tempdb to increase the performance of SQL Server.
• Working knowledge on Erwin modeling tool.
• Scripting T-SQL stored procedures triggers and functions(UDFs) and views
• Perform T-SQL techniques using different expression, CTE, cursors, loping, temp tables.
• Work closely with the developers and testing team to resolve Bugs and defects.
• Create SQL logins for windows authentication, SQL authentication and Active Directory.
• Implement TDE (Transparent data encryption) SQL Server databases.
• Perform day to day activities such as check OS event logs and SQL Server logs, failed SQL Server Agent Jobs, disk space, blocking issues and scheduled job.
• Perform in troubleshooting client connections, viewing error logs and application logs.
• Monitor SQL Server performance using profiler to find performance and deadlocks.
• Monitor and modify performance using execution plans and Index tuning.
• Design and Partition tables in the database along with DBA as part of performance tuning.
• Configure Peer-to-peer replication from scratch and troubleshot as problems arise.
• Configure SQL server's Data Collection utility to gather information about disk usage, query statistics, and server activity.
• Setup High Availability and disaster recovery solutions using Log shipping, Mirroring, AlwaysOn and clustering environments.
• Configure and manage SQL Server snapshot, transactional and merge replication and troubleshoot issues.
• Implement side-by-side migration and in-place upgrade of MS SQL Server.
• Perform Database Upgrades from 2008R2 to 2012 and 2012 to 2014.
• Create Maintenance plan and SQL Agent Jobs to automate re-indexing, backup, statistics, integrity and cleanup tasks
• Automate database refreshes from production to UAT servers using SQL agent job
• Perform data transformation from various data sources to SQL Server using SSIS, Import/Export, Bulk insert and BCP utilities.
• Work on SQL server tools like enterprise manager and SQL query analyzer.
• Implement performance tuning tasks in optimizing the long run queries.
• Work on DBCC commands and Dynamic Management Objects.

Environment: MS SQL Server 2005 /2008/2008 R2/2012/2014, SSIS, SSRS, VMware instances, MS Clustering Services, Virtual Servers, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint Windows 2013

SQL SERVER DBA

Confidential

Responsibilities:

• Installed and configured SQL server 2005/2008/2008 R2/2012 and apply periodic service packs and hot fixes (cumulative updates) for Dev, Staging and Prod environments.
• Provided SQL Server Database Administration and monitoring support across production, development and staging environments.
• Managed SQL Server security by granting appropriate server and databases roles/permissions and by having frequent security checks for inappropriate access.
• Managed users and groups (roles) on SQL Server, provide appropriate server roles, mapped them to specific databases and granted specific privileges over selected database securable objects to ensure security and integrity.
• Deployed, managed, and operated scalable, highly available, and fault tolerant systems on clustering, Replication, Log shipping and mirroring.
• Performed daily checkups on SQL jobs, replication, and hardware diagnostics for hard drives, backups, and disk-space, SQL and windows error logs as part of the proactive maintenance plan.
• Scheduled and automated maintenance plans using SQL Server Job Agent.
• Designed, implemented and managed database maintenance and disaster recovery plans including replication, full /differential /transactional log backups with recovery procedures.
• Configured and managed log shipping, Mirroring (Synchronous/Asynchronous), Failover clustering and replication as part of disaster recovery plan.
• Used SQL native tools like Index tuning wizard, Database tuning advisor (DTA), SQL profiler, Performance monitor, Activity monitor, Event viewer, dynamic management views and dynamic management functions for monitoring, performance tuning/analysis, and troubleshooting.
• Handled performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics, partitions, Client/Server Connectivity and structure modification.
• Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level.
• Analyzed and deployed scripts and packages in prod/test environments provided by developers Implemented database refresh for logins, user's transactions, and resolved orphan users.
• Configured SMTP Server for Database Mail setup, notifications, and received Alerts.
• Developed automated procedures to produce client data files on schedule using SQL agent.
• Identified recommended, and implemented new database administration technologies.
• Worked with a team of ETL developers, application developers, network engineers, server administrators, analysts and testers.

Environment: SQL Server 2000, SQL Server 2005, SQL Server 2008/R2, SQL Server 2012Redgate SQL backup Pro, ServiceNow ticketing tool, MS Outlook, MS Word, MS Excel, MS Project, MS PowerPoint Windows 2003, Windows 2008/R2.