PROFESSIONAL SUMMARY

• 10 years of experience in designing and maintaining enterprise class database infrastructure.
• Experience in Performance Tuning and Optimization PTO , using native monitoring and troubleshooting tools.
• Experience in implementing all High Availability HA and Disaster Recovery DR options for MSSQL Server 2005 to MSSQL Server 2014.
• Work with production teams to develop specific Disaster Recovery plans that meet the overall strategy of the enterprise.
• Define security standards for SQL Server databases to create a highly locked down environment.
• Define and implement standards for the SQL Server farm.
• Extensive experience in automation of installation and patching.
• Experience in troubleshooting and resolving SQL Server Instance and Windows Server issues.
• Expertise in implementing operational automation using scripts.
• Excellent in design and maintenance of database replication.
• Experience in data migration using tools like DTS, BULK INSERT and BCP between homogeneous and heterogeneous systems.
• Experience in Service Broker administration.
• Experience in managing security, creating security policies and rules.
• Experience in NAS technologies like NetApp SnapManager for SQL Server and SnapDrive.
• Experience in migrations from SQL 2000 to SQL 2005/2008, SQL 2005/2008 to SQL 2012 and SQL 2008/R2 to SQL 2014.
• Experience in working closely with developers and business users.

TECHNICAL SKILLS

Operating System : Microsoft Server platform

Languages : T-SQL, PowerShell, XML and HTML

RDBMS : SQL Server 2000, 2005, 2008/R2, 2012 and 2014, SQL

Azure and MS Access

Tools/Utilities : SQL LiteSpeed, SnapManager for SQL Server, TFS

Virtualization : VMWare, Oracle Virtual Box

CRM : OVSD, ServiceNow and Remedy

Performance Monitoring Tools : Precise, SCOM

BI Tools : SSRS, SSIS and SSAS

PROFESSINAL EXPERIENCE

Confidential

Database Specialist

Responsibilities

• Designing SQL Server infrastructure to host business critical applications.
• Planning, Implementing and managing Backup Strategies.
• Automation of DBA tasks with PowerShell and T-SQL.
• Creating various security reports using Powershell.
• Working on continuous improvements initiatives related to DB Audit Controls and Database Security.
• Implementing and monitoring Transactional Replication.
• Manage SQL Server upgrades, service pack / hot fix installation.
• Work with the application support and development teams to test the compatibility and performance impact for every upgrade or patch being applied to the environment.
• Monitoring and fine tuning server performance, evaluating memory, CPU, disk and tempdb usage.
• Manage SQL Server Analysis Services databases, configure and manage Reporting Services.
• Conducting timely and effective root cause analysis.
• Documentation of process, technical articles to build a centralized knowledge base for the process.
• Installation and configuration of SQL Server 2012, 2008 R2, 2008 and 2005 as per best standards, includes Standalone installation and Failover Cluster Instance.
• Design and implement cost-effective high availability and disaster recovery solution like AlwaysOn AG, Mirroring, Failover Clustering, Replication and Log shipping based on business needs.
• Participating in Business Continuity/Disaster recovery tests, Data center power down, data center migration activities.
• Using NetApp's SnapManager for SQL Server to backup and restore SQL databases.
• Virtualization of SQL Server environments VMWare ESX .
• Providing support to Service Broker and setup service broker on DR servers.
• Migration of SQL 2000 DB's to SQL 2005/2008/2012 and SQL 2005, 2008 DB's to SQL 2008 R2/2012.
• Monitoring SQL Servers through SCOM and working on alerts.
• Troubleshooting Performance issues and fixing/providing solutions to users.

Environment SQL Server 2000/2005/2008/R2/2012/2014, Windows Server 2003/2008/2008R2/2012/R2, T-SQL, SSMS, SCOM, SQL Profiler, NetApp, SSRS, SSIS, Powershell, TFS, Precise I3, MIR3, Service Now, VMWare. CNSI, Gaithersburg, MD Aug 2011 - Oct 2012

Confidential

Senior SQL Database Administrator

Responsibilities

• Installation, Patching, migrations and upgrades of SQL Server 2005 / 2008/R2 / 2012 on both 32bit and 64 bit operating systems.
• SQL Server performance benchmarking
• Automation of all database maintenance tasks Improved and added more functionality to existing setup.
• Backups and restoration DB refresh of databases based on the user Requests.
• Setup and Administration of Transactional Replication, Periodical Troubleshooting of customer data issues.
• Monitoring SQL SERVER Performance using profiler, perfmon to solve performance issues
• Configuration and maintenance of CDC Change Data Capture .
• Working with Storage team on increasing the storage space and expanding the LUNs.
• Design and implement DR solutions based on business requirement using Always On FCI, Availability Groups, Database Mirroring and Log shipping.
• Installing the Microsoft SQL Server clustering on both the versions SQL Server 2008 2012.
• Identify poorly Performing Queries by tracing server activity, Analyzing Execution plan and working with DMV's etc.

Environment

SQL Server 2000/2005/2008 Enterprise, Windows Server 2003/2008 Enterprise, SQL Server Management Studio, Business Intelligence Development Studio, TFS, SSIS, SSRS, T-SQL, SQL Profiler, Agile Methodologies.

Confidential

SQL Server DBA

Responsibilities

• Part of the Pilot production team, updated existing databases from SQL server 2000 2005 instances to SQL server 2008 R2.
• Design and implement DR solution
• Periodic analysis of server health using Management Data Warehouse MDW .
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Part of the database design team - Logical Physical Database modeling for in-house application. Optimizing Stored Procedures and long running queries indexes and query-optimization techniques.
• Implemented a secure production environment using Kerberos authentication, locked down application logins to ensure they have granular access through database roles
• Extensively designed data feeds using SSIS, BCP from heterogeneous data sources
• Plan and execute change requests / releases in strict accordance with ITIL policies and procedures implemented.
• Configure, deploy and manage Service Broker on Production and DR servers.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Generated reports by using SSRS and provided them on web server Report manager.
• Providing high availability SQL Server solutions, including Log shipping, Mirroring, Snapshot Replication.
• Intensively used DBCC commands, SQL Profiler, Trace Analysis and Execution plans as part of trouble shooting and performance tuning.
• Troubleshoot all Database, SQL Server instance and Windows Server related issues

Environment

Windows 2008R2, MS SQL Server Management Studio 2008, T-SQL, DTS, SSIS, SSRS, SSAS, NetBackup, Replication, Remedy, Batch Scripting, IIS, ASP.net, NetApp.

Confidential

Operations DBA SQL Server

Key Responsibilities

• Involved in updating existing databases to SQL Server 2008.
• Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
• Experienced in using Data Manipulation Language DML for the query and update commands and the Data Definition Language DDL .
• Design and develop SSIS packages, store procedures, configuration files, tables, views and functions implement best practices to maintain optimal performance.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the data warehouse.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user's client critical databases. Also changed configuration of databases, increased physical memory, and enabled text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities i.e. export /import and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Audited database users using SQL profiler tool and customized stored procedures and packages. Hide tables columns from the developers and non - technical staff member using views.
• Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services SSIS for data integration from heterogeneous data sources, ETL related operations.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.

Environment

SQL Server 2005/2008, Windows Server 2003/2008, SQL Server Management Studio, Business Intelligence Development Studio, SSIS, T-SQL, SQL Profiler, NetIQ, AlarmPoint

Confidential

SQL Server Database Administrator

Key Responsibilities

• Provide On-Call support for all issues in the database environment.
• Plan and Implement Backup strategies to ensure database recovery.
• Troubleshooting database server issues.
• Installing, configuring and Managing SQL Server, installing service packs.
• Upgrading SQL Server 2000 databases to SQL Server 2005.

Environment

SQL Server 2000/2005 Enterprise, Windows Server 2003, SQL Server Management Studio, T-SQL, Performance Monitor, OVSD, OpsCentre, Remedy

Confidential

Database Engineer

Key Responsibilities

• Installation, configuration and upgrading SQL server software and related patches.
• SQL Server maintenance and support

Environment

SQL Server 2000/2005, Windows Server 2000/2003/2008, Enterprise Manager, SSMS, T-SQL, NetIQ