SUMMARY

• SQL Server Database Administrator having 8 years of experience, well versed in all phases of System Development Life Cycle (SDLC) including analysis, design, programming, implementation and maintenance of stand - alone and Clustering with the following abilities:
• Extensive experience in installation and configuration of SQL Server 2000/2005/2008/2012/2014.
• Expertise in installing, configuring and maintaining SQL Server Cluster in 2005, 2008 and 2012.
• Expertise in installing service packs, cumulative updates in both standalone and cluster servers.
• Expert in data migration from MS SQL Server /2012/2014 and data migration from existing databases to remote data centres.
• Experience working on Azure SQL Databases and Azure SQL Data Warehouse.
• Extensive experience in migration of several on-premise data centers to Microsoft Azure.
• Designing, testing and implementation of high availability solutions like Database Mirroring, Log Shipping,and Replication of databases for large, medium and small customers to further increase scalability and stability of business-critical systems.
• Intensive experience in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Managed databases on multiple disks using Disk Mirroring and RAIDtechnology.
• Responsible for database backups and restore strategy to meet business' Recovery Point Objectives (RPO) & Recovery Time Objectives (RTO).
• Experience in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA).
• Expert in using different Transformation tools like SSIS, DTS packages, BCP and BULKINSERT.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expert in performing database consistency checks, planning and scheduling, Backup & Recovery.
• Created/suggested clustered and non-clustered indexes for increasing the performance, also monitored the indexes by troubleshooting any corrupt indexes by removing fragmentation from indexes.
• Implementing high availability with AlwaysOn Availability Groups and failover clustering.
• Extensive experience in space allocation, database migrations and database security.
• Good understanding of Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Worked in CommVault galaxy, LiteSpeed tools and performed database refresh using the tool.

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP/ 2003/2008/2008 R2/2012, IBM AIX

SQLServer Technologies: SQL Server 2000/2005/2008/2008 R2/2012

Tools: SSIS, SSRS, BMC Remedy Management, Service-Now

Backup Tools: CommVault Galaxy, Redgate

Performance Tools: Idera SQL Diagnostic Manager, Foglight, SQL Compliance Manager (audit), Perfmon

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. SQL Server DBA/Analyst

Responsibilities:

• Working on Installing and configuring SQL Server Active/Active and Active/Passive clusters.
• Upgrading and Migrating SQL Server 2008R2, SQL Server 2012 on WINDOWS 2008/2008 R2 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Working on SQL server 2014. Helped in migrating from server and deployed it.
• Managed hundreds of SQL Server and Oracle data center migrations to Microsoft Azure.
• Worked on various Azure services like Compute (Web Roles, Worker Roles), Azure Websites, Caching, Sql Azure, Storage, Network services, Azure Active Directory, API Management, Scheduling, Auto Scaling, PowerShell Automation.
• Configure, patch, test, monitor, and support multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Ensure high-availability and data security by implementing Windows and SQL Server Failover Clustering and SQL Server 2012 AlwaysOn Availability Groups, rigorous backup and recovery plans.
• Configured Transactional Replication between primary servers and read only server, with separate Distributor server and experience in troubleshooting replication problems.
• Fixed several SQL Query performance issues by examining execution plans, tuning indexes, creating plan guides, adding hint words.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• 24 X 7 Production Database On Call Support.
• Involved in Data Center Migration and Consolidation Project
• Designed and populated reporting tables, views and stored procedures.
• SQL Query Performance Tuning, system Performance Analysis, analysing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Work with responsible applications personnel, coordinate testing of new releases and upgrades from applications perspective.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• Worked in implementing yearly password changes on the production in updating passwords for SQL Services, replication, Reporting services database connection strings
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.

Environment: SQL Server 2012, 2008/2008R2, Visual Basic, .net, Windows 2008 data Centre/advance server, SQL Server integrated services, SQL Server Reporting Services, Internet Information Server 6, HTML, .Net Framework 2.0, VB.Net.

Confidential, Wilmington, DE

SQL Server DBA

Responsibilities:

• Involved in Administering the servers by creating User logins with appropriate roles, logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Installed and configured SQL Server 2008R2 on WINDOWS 2008 servers
• Created list of SQL Server Agent jobs that are running on all SQL Servers and determine stored procedures, remote procedure call and SQL statements executed, in order to establish a strategy for improving current SQL Server performance.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring on SQL server 2008R2
• Worked individually on the Clustering project and implemented it successfully without the Help of team members. Also, documented the project.
• Helped the Jr.DBA’s and other team members whenever they encountered problems with clustering. This project gave me experience as a Team lead and also the potential in me as an individual DBA.
• Configured Merge and Transaction Replication from Production to DR Servers and Reporting Server with Multiple subscribers on SQL server 2008R2.
• Installed and configured SQL Server 2005, 2008 on Standalone and Clustered Environments.
• Performed Back-up, Restoration of Databases in Full Recovery and Bulk-Logged modes.
• Configured Database mirroring, multi-instance SQL Server clusters as part of high availability solutions for mission critical database Servers.
• Installed, Configured SSRS and Created and Deployed SSRS Packages
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Established relationships and worked closely with application development teams.
• 24 X 7 Production Database On Call Support.
• Used Microsoft BizTalk Server to automate business processes.
• SQL Query Performance Tuning, system Performance Analysis, analysing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Environment: MS SQL Server 2008R2/2005, PL/SQL, SSIS, SSRS, SQL Profiler, SQL Server Agent MS Excel,6.0, .Net, Java, Tivoli, Foglight, SQL Litespeed and Crystal Reports.

Confidential, Pittsburgh, PA

Programmer Analyst

Responsibilities:

• Generated and debugged complex stored procedures and functions for performance tuning and optimization.
• Created complex functions and views based on the business requirements.
• Developed stored procedures for complex sub queries and joins using multiple tables.
• Migrated data from SQL server 2005 to SQL server 2008.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas.
• Created MDX queries to access the cube information.
• Created and configured cubes using SQL Server 2008 analysis services.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.
• Developed and maintained various cubes using MDX complex queries in SSAS.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the Problems.
• Tested and standardized the data to meet the business standards using Fuzzy /exact lookups.
• Designed and deployed various reports using SSRS.
• Worked closely with business users in defining and documenting reporting requirements in order to design, develop and maintain SQL Server 2008 reporting services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and MS Excel format using Reporting Services (SSRS).
• Defined relationships between Measure groups and Dimensions.
• Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.

Environment: SQL Server 2005/2008 R2/2012, Windows Server 2003/2008, 32 bit and 64 bit Servers, SSIS, SSAS, SSRS, SCOM monitoring system

Confidential

Database Developer

Responsibilities:

• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at high level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing for different modules.
• Implementing user training and providing technical support.
• Prepared proper backup and recovery plans.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
• Designed the Logical and Physical design of database for projects on basis of user requirements.

Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel.