SUMMARY:

• As a core SQL Server DBA, with over 8 years of expertise, has been actively involved in database design, implementation and management tasks including (but not limited to);
• Installation/Configurations High Availability Performance Tuning Migration
• Backup and Recovery Clustering Trouble Shooting Disaster Recovery
• Database Upgrades/patches Database Mirroring T - Sql Database Design
• Database Security Replication Store Procedures Partitioning (TDE) Log-Shipping SSIS/ETL AlwaysOn HighAvailability

TECHNICAL SKILLS:

RDBMS: SQL Server 2005, 2008, 2008r2,2012, 2014 and 2016

LANGUAGES: T-SQL

OPERATING SYSTEMS: Windows NT, 2000. 2003. Windows 7, windows 2010

TOOLS: SQL Server Profiler, SSIS, SSMS,SSRS, Idera, Redgate, Ignite

PROFESSIONAL EXPERIENCE:

Confidential

System Administrative and Network Engineers

Responsibilities:

• Supporting SQL Server 2005, 2008r2,2012,2014 and 2016 production environments in a 24x7 on-call basis.
• Installed and configured multiple SQL Server instances in production environments.
• Installed Sql Server Patches
• Managed SQL Server database security by granting permissions on securable to the principals.
• Proactively engaged in various tuning techniques to maintain high performance production database environments and ensuring minimal to zero downtime.
• Automated various routine maintenance tasks like backups, index reorgs, index rebuilds on all production databases.
• Responsible for the daily maintenance tasks and Health Check of all SQL Server databases.
• Ensured that all database related trouble tickets are delivered upon within the SLA.
• Identified issues inhibiting the attainment of project goals, developed and implemented corrective actions.
• Interfaced with Microsoft and other vendors for technical support through service Request tickets and technical
• Assistance TARs).
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Hands on experience in creating logins and assigning roles with least privileges. Coordinating with the Systems Administration team, install and maintain approved application software and systems that integrate with database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.

Confidential

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Coordinating with the Systems Administration team, install and maintain approved application software and systems that integrate with database systems.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2008R2 to SQL Server 2012, 2014,2016
• Setup and maintenance of appropriate database and application monitoring. .
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Worked in Active Passive Cluster environment as a High availability solution.

Confidential

MS SQL DBA Consultant

• Supporting SQL Server 2005, 2008r2,2012,2014 and 2016 production environments in a 24x7 on-call basis.
• Installed and configured multiple SQL Server instances in production environments.
• Installed Sql Server Patches.
• Engaged in disaster recovery (DR) strategic planning and implementation in SQL Server.
• Performed data refreshes on SQL Server production and test databases.
• Responsible for the Production support of more than 200 SQL Server databases.
• Managed SQL Server database security by granting permissions on securable to the principals.
• Proactively engaged in various tuning techniques to maintain high performance production database environments and ensuring minimal to zero downtime.
• Automated various routine maintenance tasks like backups, index reorgs, index rebuilds on all production databases.
• Responsible for the daily maintenance tasks and Health Check of all SQL Server databases.
• Ensured that all database related trouble tickets are delivered upon within the SLA.
• Identified issues inhibiting the attainment of project goals, developed and implemented corrective actions.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views (DMV's).

Confidential

DBA Consultant

• Highly experienced in installing, configuring and administering SQL Server along with the service packs.
• 24/7 On Call Support for Production servers.
• Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non-Clustered environments.
• Extensive knowledge in architecting, designing and administrating in multi node clustering with Active/Active, Active/Passive Architecture.
• Hands on experience in creating logins and assigning roles with least privileges.
• Extensive experience with SQL Server High Availability and Disaster Recovery strategies.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring in both synchronous and asynchronous nodes.
• Implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer-to-Peer
• Replication in SQL Server 2008 and SQL Server 2012 in OLTP environments using different topologies.
• Implemented log shipping as a part of Disaster recovery solution.
• Implemented high availability solutions, including Clustering, Database Mirroring.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Experience in capacity planning, performance tuning, and disaster recovery (DR) and troubleshot performance issues.
• Created Linked Servers for OLEDB Data Source and Native Data Sources.
• Documented Disaster Recovery Plans and Participated In Disaster Recovery Drills.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Strong in creating, monitoring and optimizing the performance of the Queries and Indexes using SQL Server Profiler,
• Database Engine Tuning Advisor, Performance Monitor and DBCC commands and Dynamic Management Views (DMV's).

Confidential

MS SQL DBA Consultant

• Used SQL Profiler for troubleshooting, monitoring, optimizing store procedures.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis.
• Developed, modified, and optimized stored procedures, triggers to handle complex business rules.
• Managed the products and development databases including performance tuning, capacity planning.
• Understand SQL Server clustering environment, database security configuration, and database continuity.
• Designed and implemented SQL Server 2005/2008R2 databases for mission-critical business.
• Developed and optimized stored procedures, triggers, and SSIS packages .
• Troubleshoot databases and custom application issues.
• Developed and created stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Work with end users to define, implement, and maintain their reporting requirements.
• Participated and coordinated the creation, modification and maintenance of database structures with minimal supervision.
• Performed other duties assigned by management.
• Worked with stored procedures and scripts for maintenance and reporting purposes.
• Assisted in Migration Project sql server 2008r2 to 2012.