SUMMARY

• Over 7 years of professional experience in SQL SERVER Database Administration and Production Servers Maintenance.
• Experience in implementing Disaster Recovery and High Availability solutions using Replication, Log Shipping, Mirroring, Clustering and Always on high availability groups.
• Expertise in Administration, Database Design, Performance Tuning, and Production Support for Large (OLTP) and Complex Databases.
• Migration of SSRS reports from SQL 2008 to SQL 2012/2014 and SQL.
• Extensive experience with data modeling techniques, logical and physical database design.
• Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in Performance Tuning, Query Optimization, and Database Consistency Checks using DBCC Utilities.
• Experience in Monitoring Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Extensive knowledge of Relational Database Management Systems (RDMS) with in depth knowledge of T - SQL.
• Experience in installing and configuring SQL Server 2014, 2012, 2008R2, 2005, 2000.
• Migrated SQL Server 2012 to SQL Server 2014, SQL Server 2008 to SQL Server 2012 and also SQL Server 2000/2005 to SQL Server 2008 versions.
• Hands on experience in Backup and Restoration of databases, Automation of administrative tasks using SQL Server Agent, Security Management and in Managing server and clients.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Experience in diagnosing and tuning the server for optimal performance using SQL Servers Dynamic Management Views(DMVs)
• Experience in writing T-SQL in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, User defined data types, Cursors and functions.
• Experience in Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Hands on experience in analyzing query plans, using extended stored procedures, managing indexes and locks, and troubleshooting deadlocks.
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the databases.
• Expertise in different scenarios of OLTP, OLAP databases.
• Used MDX to interact with the back end OLAP Services.
• Hands on experience in using Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data ware house environment.
• Experience in Batch processes, BCP, DTS and SSIS utilities to migrate data from Excel, Flat files, Oracle etc.
• Experience of working closely with development team to assist them in various problem-solving and troubleshooting of Web-based applications and Database objects.
• Hands on experience in resolving database performance issues, database capacity issues and distributed data issues
• Proficient with Client/Server tools like SQL Server Enterprise Manager, SQL Server management studio and Query Analyzer to Administer SQL Server.
• Experience in investigating and applying necessary SQL Server database service packs and patches
• Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Complete Administration of Microsoft SQL Server Databases has always been my primary responsibility.
• 24 X 7 Production Database on Call Support.
• Good understanding of team work. Strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Relational Databases (RDBMS): SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0 , MS Access 2000

SQL Server Tools: Management Studio, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Advisor Wizard, SSIS, SSRS, Surface Area Configuration Manager

Programming: SQL, TSQL, C / C++, PLSQL

Operating System: Windows 2003/2000 Advanced Server, NT & Windows 9x, Linux, AIX

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Case Tools: MS Office 2000/XP/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003, Visio

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

Sr. SQL Server DBA

Responsibilities:

• Responsible for migration from SQL Server 2012 to SQL Server 2014, 2008 to SQL Server 2012.
• Involved in various disaster recovery and high availability techniques such as Log Shipping, Database Mirroring, Replication, Clustering and Always on high availability.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008 and SQL Server 2008 to SQL server 2012 SQL Server 2012 to SQL server 2014.
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created SQL Server Reports based on the requirements using SSRS 2012.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2014/2 (SSAS).
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Configured replication methods like snapshot and transactional replication.
• Prepared backup/restore strategies for MS SQL Server databases.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Designed new job process, new database maintenance plans and set up notifications for the same.
• Writing T-SQL queries for the execution of various jobs like tables, stored procedures, triggers, views and indexes.
• Analyzed long running slow queries and tuned the same to optimize the application and system performance.
• Streamlined the server/database level security by creating the windows and SQL Logins with appropriate database roles and object level permissions.
• Created SSIS packages for the extracting, transforming and loading the data from SQL Server 2005 and flat files.
• Converted all existing DTS package of MS SQL 2000 to SSIS packages by using package migration wizard and DePloyed new Package in different Server.
• Involved in Performance Tuning using windows performance monitor and SQL profiler of SQL Server
• Worked with other Technical Teams like Application Admin team, Server team and Network team to solve Performance and/or connectivity issues.
• Responsible for Installation and Configuration of MS SQL Server 2008 R2/2012.
• Worked on SAN and Raid levels and building SQL Cluster servers on SAN environments.
• Prepared and implemented revised and improved Backup Strategy to ensure minimum down time and effective use of available resources.
• Dropped and recreated few tables for the damaged databases to avoid data loss.
• Performed Data partitioning in SQL 2008.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Created temporary tables to perform various tasks on the existing tables.
• Resolving dead lock issues by using various SQL server internal commands.
• Monitoring of database size and disk space in production, staging and development environments.
• Provided Initial Analysis and Planning for database structure under the guidance of Data Architect.

Environment: SQL Server 2014/2012/2008 R2/2008/2005 with clustering, OLAP Cubes, T-SQL, Windows 2003, Windows 2008 R2, Active Directory, Reporting Services, Integration Services.

Confidential - Charlotte, NC

Sr. SQL Server DBA

Responsibilities:

• Installed and Configured MS SQL Server 2008/2008R2.
• Performed daily tasks including backup and restore by using native SQL Server.
• Implemented high availability solutions for mission critical SQL Server databases with Clustering and Mirroring.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Worked with developers to tune the queries, run scripts and move the database from production to development servers.
• Created SSIS Packages to migrate slowly changing dimensions
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies.
• Designed new job process, new database maintenance plans and set up notifications for the same.
• Did trouble-shooting of Client connections, viewing error log and applications.
• Handled routine administration of SQL Server 2000/2005/2008.
• Using Sql server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
• Involved in resolving dead lock issues and performance issues.
• Monitored, set and controlled system capacity plan for future system requirements. Made recommendations for space management and monitoring.
• Resolved existing problem in SQL 2000 production box with the Log shipping getting out of sync by making design changes.
• Analyzed requirement of AWE on servers where it was feasible and enabled the same to resolve memory issues.
• Initiated a process of Inventory Management of SQL Servers.
• Assisted development teams in deploying Reports on Production Servers.
• Effectively used Remedy tool to update all the database administration- operational activities in Incident Management and Change Management.

Environment: SQL Server 2008R2/2008/2005 with clustering, OLAP, SQL Server SSIS/SSRS/SSAS, Litespeed, T-SQL, Windows 2003, Active Directory, Reporting Services, Integration Services, Remedy

Confidential, Chicago, IL

SQL Server DBA

Responsibilities:

• Installed and Configured MS SQL Server 2008.
• Migrated SQL Server 2005 data bases into SQL Server 2008.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintained Replication in SQL 2005/2008.
• Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
• Designed and created the table schema and stored procedures that will be used in Data QC.
• Experience in integrating SharePoint Server with SSRS and deploying SSRS reports on to SharePoint Server
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Maintained the database consistency with DMV and DMF’s at regular intervals.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.

Environment: SQL Server 2008/2005 with clustering, CA Erwin 7.2, Litespeed, T-SQL, Windows 2003, Autosys, Active Directory, Quest LiteSpeed.

Confidential, Richmond, VA

SQL Server DBA

Responsibilities:

• Successfully installed SQL servers 2008 on cluster server.
• Migrated SQL Server 2005 database to MS SQL Server 2008
• Handling user requested issues through Service Tickets.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created SSIS Packages to migrate the data from database to Text files.
• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors
• Deployed builds in Production servers for schema changes and worked in CMR (Change Management Request) department.
• Successfully implemented Database Mirroring in SQL Server 2008
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication.
• Created Maintenance Plans for production servers (Full, Differential and Transactional Backups) using Litespeed.
• Monitored and modified Performance using execution plans and Index tuning.
• Generated various monthly reports with the help of SSRS 2008.
• Installation of 32 bit and 64 Oracle 10g client and applied DST Patches for Oracle Linked servers
• Created Linked servers for retrieving data from other Servers including Oracle
• Co-ordinating with the programmer analyst for optimizing query, writing stored procedures.
• Conducting Root Cause Analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.

Environment: Windows Server 2008 Enterprise Edition, SQL Server 2008, SQL Server 2005, SSAS, SSIS, SSRS, OLAP, OLTP, ETL, Replication, Clustering, Litespeed 4.8.3.0025 .

Confidential

SQL Server DBA

Responsibilities:

• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Worked on Migration of packages from DTS using SQL Server Reporting Service (SSIS).
• Done CPU Performance tuning for the servers as disk space.
• Designed and developed the Data QC Maintenance website that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Setup replication within the SQL databases.
• Did trouble shooting of Client connections, viewing error log and applications.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented Database Mirroring and worked with Stored procedures, triggers, cursors etc
• Monitored, set and controlled system capacity plan for future system requirements. Made recommendations for space management and monitoring.
• Code reviews to move it to the production developed by developers.
• Setup the database with suitable memory and hard disk space allocation, creating different user and security profiles for the team.

Environment: - SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003,, IIS 6.0, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

Confidential

SQL server DBA

Responsibilities:

• Successfully implemented database mirroring between Primary server and Mirror Server.
• Implemented log shipping in standby mode to support DR servers.
• Installed and configured different edition of SQL Server 2005 like Express edition, Enterprise edition with the latest service pack.
• Successfully migrated from SQL Server 2000 to SQL Server 2005 on Development and Testing Environment.
• Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in Replication.
• Created Maintenance Plans for production servers (Full, Differential and Transactional Backups).
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system using diagnostic manager from Idera.
• Created logins and roles with the appropriate permissions.
• Monitored & Analyzed SQL Log, Perform counters and Performance Tuning for all development and staging environment.
• Responsible for resolving blocking and locking issues.

Environment: MS SQL Server 2000/2005, Enterprise Manager, and System Monitor/Performance Monitor, Event Viewer, SQL LiteSpeed, T-SQL, Windows 2003/2000 server, Window 2000