SUMMARY:

• With 8+ years of IT experience specializing in SQL Database administration, Disaster recovery, Technical support, Storage, Data center management, Data Migration, Risk management, installation/Configuration, Data Warehouse architecture and Troubleshooting. Solid expertise in System analysis, Design, Development of MS SQL servers in Production, QA, Reporting services, Development environments, Replication and Cluster Server environments.
• Experience in SQL Server security by assigning logins, server/database roles and server permissions.
• Experience in upgrading SQL Server 2012 from SQL Server 2008 and 2005.
• Provided 24/7 support in monitoring, troubleshooting, optimizing and tuning of SQL server environments and Good hands on performance and tuning issues, developing and implementing emergency fixes, resolving database problems.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in High availability using Database Backup and Restore, Database Snapshot, Partitioning, Replication, Log shipping, Clustering (Active/Passive), Database Mirroring and SQL Server 2012 Always On.
• Implementing high availability with Always On Availability Groups and failover clustering.
• Experience in trouble shooting SQL Server Jobs, and job monitoring tool.
• Involved in automation of administrative tasks such as creating jobs, schedules, alerts using SQL Server agent, monitoring and troubleshooting the jobs.
• Implementation of Database maintenance plan for Database consistency.
• Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
• Experience in SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in applying patches and service packs to keep the database at current patch level.
• Extract, Transform and Load (ETL Tools) data using DTS Import/Export utility, deployment utility DTS Packages and SQL Server Integration Services (SSIS).
• Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Good verbal, written communication, presentation, problem solving and conflict resolution skills.
• Detail oriented with client interaction and knowledge transfer.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012/2008 R 2/2008/2005/2000

Operating systems: Windows Server 2012/2008/2008 R2/2003.

Programming SQL, PL/SQL:

Tools: Management Studio, SQL Profiler, Performance Monitoring, SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), Query Analyzer, Enterprise Manager.

Reporting Tools: SQL Server Reporting Services, Cognos

Data Migration: DTS, SSIS, BCP, Import/Export Wizard.

Domain Knowledge: Banking, Finance, Healthcare, Manufacturing, High Technology, IT

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

SQL Server DBA

Responsibilities:

• Installation, configuration and administration of SQL Server 2012/2008 on windows, applying service pack and security fixes as necessary.
• Day - to-day management of a centralized MSSQL Server platform.
• Implementing high availability with Always On Availability Groups and failover clustering.
• Install, manage & troubleshoot multi node multisite SQL Server clusters (Active/Passive).
• Deploy and scheduled SSIS package and reports as per user requests. Migrated SSIS package from SQL Server from Dev to higher environments.
• Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs.
• Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults
• Create and manage user databases and their sizes. Migrate databases from Dev to Higher environment.
• Used query execution plan to improve query performance by identifying expensive operators and optimizing them by restructuring the query and adding necessary indexes.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Review Stored Procedure, analyze and create recommendation on it to improve performance such as creating indexes to avoid deadlock, key lookup.
• Expertise in SQL server Reporting Services (SSRS).
• Used SQL Profiler to identify long running queries and optimize them, capture and analyze deadlock graphs to resolve deadlocks and blocking.
• Using PowerShell scripts on regular basis for getting instance specific details.
• Perform code reviews on the database objects created by developers, enforcing best practices and coding standards.
• Working with Avamar team for backup and restore of Database for all environments.
• Implemented yearly password management/maintenance procedures involving production updates of password changes for SQL Services, Replication, Reporting services and Database connection strings.
• Used DBCC to troubleshoot issues related to database consistency.
• Participated in the organization’s change management process for production releases with different application groups. Managed version upgrades working with Development, Extract and Testing Teams.
• Work with individual application resources to coordinate testing of new releases and upgrades from application perspective.

Environment: SQL Server 2012/2008, SSAS, SSRS, SSIS, Windows 2012/2008R2/2003, SQL Profiler, DTS/SSIS, T-Sql.

Confidential, Tampa, FL

SQL Server DBA

Responsibilities:

• Installed Microsoft SQL Server 2005 and 2008 R2 on New Production and Test servers with latest Security updates involving Service Packs and Security patches as they are released.
• Involved in the SQL Migration Process (both in-place and side-by-side).
• Upgraded SQL servers from R2 SP1 version.
• Enabled Resource Governor to manage SQL Server 2008 database workload and evaluating critical system resource consumption.
• Evaluated indexes at regular intervals and rebuilt as necessary for performance improvement.
• Analyzed and identified unused indexes in the databases using Catalog Views and DMV’s and dropping them.
• Archived/purged data in database tables using TSQL and executed as a job.
• Used Windows Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Performed code reviews on the database objects created by developers, enforcing best practices and coding standards.
• Troubleshoot Database connectivity issues from the applications and resolve the same.
• Designed and implemented comprehensive Backup plan.
• Monitored Double-take console to check the status of mirroring/replication of backup files cross the network.
• Reviewed DBA Daily status report to troubleshoot the low disk space, consistency checks, server configuration and DB growth in proactive and submitting to Manager.
• Responded to issues that have been escalated with Change Control Processes and adherence to standards and documentation.

Environment: SQL Server 2008/2005, Windows Server 2008/2003 Enterprise/Standard Edition, SSIS, SSRS, Visual Studio 2008/2010, Double-Take, SQL Profiler, BMC Ticketing System.

Confidential, St. Petersburg, FL R

SQL Server DBA

Responsibilities:

• Responsible for 24*7 production support.
• Actively involved in different stages of Project Life Cycle.
• Upgraded databases from SQL Server 2008 to SQL Server 2012.
• Created Users, Roles and managed security and permissions of the database.
• Installation of SQL Server, applying service pack and security fixes as necessary.
• Involved in Database optimization, performance tuning, monitoring and capacity planning.
• Worked with development team to create Stored Procedures and triggers as per application needs and deploying the same.
• Worked with SQL Profiler for troubleshooting and performance tuning.
• Worked with Index tuning wizards for development databases.
• Involved in analyzing execution plans for database optimization.
• Participated in Query tuning processes for SQL developers.
• Configured and maintained transactional replication for production servers.
• Performed Backup, Restore and Disaster Recovery.
• Prepared Step by Step Installation document.

Environment: MS SQL Server 2008/2005, Windows Server 2003, SSAS, SSRS, SSIS, T-SQL, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• 24*7 critical production supports for production and test servers
• Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 servers. Installed service packs.
• Upgrade SQL Server 2000 servers to MS SQL Server 2005 servers.
• Maintained critical production SQL servers and troubleshoot database problems
• Created a procedure to recover databases in the disaster situations
• Used SQL Server tuning techniques to optimize SQL queries and stored procedures
• Created the SOP (Standard operating procedures) for all SQL Server activities like Backup and Restores, Security and regular Database administration tasks
• Installed SQL Server, applied service packs and security fixes as necessary
• Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk and memory devices
• Created the maintenance plans for optimization and integrity checks for all available SQL Servers
• Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects.

Environment: MS SQL Server 2005, Windows Server 2003, SQL Profiler.

Confidential

SQL Server DBA

Responsibilities:

• DBA for SQL Server serving 4 remote locations and 15 SQL Servers
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
• Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
• Monitoring SQL server, Application logs and analyzing the logs.
• Maintaining both Dev and Production servers in sync.
• Resolving various performance issues and running DBCC commands, SQL Profiler and NT monitoring tools.
• Provided administrative support for Oracle database in UNIX environment.
• Actively participate in all major oracle database activity like 9i to 10g migration and creation of physical standby