SUMMARY:

• Consolidation of 9+ years of Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014,2016 and 2017 Database Management, T - SQL, Microsoft Azure and Administration experience combined with a blend
• Client handling skills. Addressed all database related IT Infra issues and interacted with various user heads for improvements. Provided technical leadership in solving issues related to Customer requirements.
• Consolidation of 9+ years of Microsoft SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 and 2017 Database Management, T-SQL, Microsoft Azure and Administration experience combined with a blend of Client handling skills.
• Installing, upgrading and migrating databases between different versions.
• Upgrading and Migrating SQL Server 2008R2, SQL Server 2014 on WINDOWS 2008/2008/2012 R2 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Configure, patch, test, monitor, and support multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters
• Migrated Databases from SQL Server to Oracle using SQLways tool
• 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.
• Worked on Optimizing SQL Queries.
• Worked on SQL Azure related concepts like Setting up SQL Azure Environment, Creating Database, creating table, Restoring databases in Azure, Creating maintenance plans etc
• Releasing code from non-production to production environments using internal tools.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• 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.
• Configuring and troubleshooting High Availability solutions in Production environment - Replication, Mirroring, Log Shipping and Clustering.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Used SQLCMD utility in command prompt to access SQL Server.
• Configured and Monitored Database Mirroring for one of the Business Development scenario.
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues.
• Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Experience in upgrading SQL Server using side by side and In-place up gradation.
• Configuring and maintaining Always On availability feature in SQL Server 2012 and 2014.
• Troubleshooting on performance issues, space issues, database issues, capacity planning, indexing and working on SQL Server best practices etc.
• Migration of DTS packages (SQL Server 2000) to SSIS Packages (SQL Server 2005/2008/2012 ) and loading data from different ODBC Servers (like MYSQL, Oracle etc.) and flat files to SQL Servers
• DR planning and implementation for Databases with end to end technical support.
• Perform Audit on SQL Server to ensure we meet SOX compliance.
• Working on scheduled Changes and Problem Records, preparing Root Cause Analysis documents, attend Change Advisory Board meetings.
• Implementing RFC based on the application outage window timings.
• Provided 24 X 7 supports to all production, development, staging, QA and clustered servers and worked on more than 15,000 servers in production environment.
• Worked on Database and Instance Decommissions.
• Automated logins movement from one server to another server which helps in database migration to avoid login connection issues.
• Automated weekly reports with consolidated data as attachments directly to mailbox.
• Conducted many classroom s and Organizational level s to explore and share the technology in SQL Server Environment.

TECHNICAL SKILLS:

Operating Systems: Windows 2016/2012/2008 R2/2003, Windows 7/8 Professional

RDBMS: SQL Server 2017/2016/2014/2012/2008 R 2/2008/2005/2000, MS Access

Cloud: SQL Azure

Database Tools: SQL Sentry, Spotlight, EMC DDboost, Code Release Tools, Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Business Intelligence Development Studio, SSIS, Always On, SQL Ways Ispirer tool

Web Technologies: XML, HTML, JAVA Script

Languages: T-SQL, PowerShell

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Applications: Microsoft Office, Erwin, MS VISIO 2003/2005.

Networking: TCP/IP, Named Pipes, VIA

PROFESSIONAL EXPERIENCE:

Sr. Microsoft Database Administrator

Confidential, Illinois

Responsibilities:

• Performance Tuning tasks on slow running queries
• Lead offshore team and made smooth and flaw less deliverables
• Resolved CPU Spikes issues and made application available in very less time
• Worked on creating jobs using PowerShell
• Created alerts which will capture all the data, log information and will send e - mails to DBA group
• Worked on patching servers to the latest service packs and CUs
• Creation of stored procedures and functions as per requirements
• Worked on balancing data equally on all the data files in a database.
• Worked on code reviews and production releases
• Worked on transactional replication
• Worked on Server builds end to end and QCing servers
• Worked on both Inplace and side by side server Migrations
• Worked on database migrations/upgrades from lower to higher versions
• Worked on Always On High Availability 2014
• Worked on support and maintenance incidents from Remedy tool
• Worked on estimations of the project
• Created many standard templates to be used across the board
• Worked on missing and duplicate indexes and improved the performance of the application
• Worked on capturing performance statistics using SQL server profiler and Performance monitor
• Worked on backups and restore using both Native and third party tools
• Troubleshoot blocking, CPU and dead lock issues
• Worked on access and permission related tasks and maintained security of the company
• Worked on SQL Azure related concepts like Setting up SQL Azure Environment, Creating Database, creating table, Restoring databases in Azure, Creating maintenance plans etc
• Used tools like SQL Sentry, Spot light, EMC DDBoost, SQL Server Information internal tool, code Release tool, Remedy

Sr. SQL Server DBA

Confidential, New Jersey

Responsibilities:

• Migrating databases from SQL Server 2005 to SQL Server 2014
• Migrating databases from SQL Server to Oracle, MySQL using SQL Ways tool
• Working on SSIS packages and deploying SSIS packages
• Working on Always on Configuration and Maintenance
• Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting sql server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Auditing of database for user transaction, login and database action and removing orphan users.
• Expertise in using DBCC trace flags, handling blocking and dead lock situations.
• Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, Index Tuning Wizard and Windows Performance Monitor.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Creation and maintenance of Databases, creating Roles and managing user permissions.
• Experience in Troubleshooting and documenting root cause analysis.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
• Worked on SQL Azure related concepts Creating Azure Database, creating table, Restoring databases in Azure and basic Azure related concepts
• Installed and configured SQL Server Active/Active and Active/Passive clusters
• Migrating Databases from SQL Server different versions of SQL Server to Oracle using SQLways tool
• Configured Transactional replication with separate Distributor server.
• Experience in troubleshooting replication problems.
• Worked on various SQL Query performance issues by examining execution plans, indexes tuning, creating plan guides, adding hint words, finding CPU details.
• Working on submitting daily, weekly and monthly reports to the client

Sr. SQL Server DBA

Confidential, Illinois

Responsibilities:

• Migrated SQL server 2005/2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Upgraded SQL Server 2005/ 2008/ 2008 R2/ 2012 to the latest service packs
• Performed SQL Instance decommissions in the clustering Environment.
• Created maintenance plans to perform Index De - Fragmentation, Re-Indexing and update the Index Statistics.
• Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, SSRS, DTS, BCP, BULK INSERT etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages.
• Good hands on experience on Resolving database performance issues and monitoring the growth of the database to ensure the smooth running of daily activities.
• Worked extensively on monitoring the databases, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases in response to the Tivoli Alerting System.
• Experience in strong SQL debugging skills, application level troubleshooting skills, experience with monitoring tools and techniques, good understanding of security practices.
• Experience in successfully resolving SQL Server problems in conformance with in SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, backup/restore, database corruption, security etc
• Experience in using tools like SQL Profiler and Performance counters for Monitoring, Fog light, Performance Analyzer and Tuning MS SQL Server Performance.
• Experience in working with Windows Server 2000/2003/2008.
• Experienced in creating/maintaining automation Scripts with SQL.
• Hands on experience in trouble shooting deadlock issues, resolving performance issues, data archival on every three months, rebuilding indexes.
• Self-motivated person with strong analytical, problem solving and communication skills. Capable of working under pressure and a good team player who can be flexible and work individually.
• Experienced in ITIL process (Change Management, Release Management, Problem Management, and Incident Management) and IT Infrastructure, Networking, and RAID environment.
• Experienced in query optimization, DMV s, Maintenance Plans, Upgrades
• Designed and documented a Disaster Recovery Plan for the databases and also modified scripts for all jobs including Backup restore.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA)

MS SQL Server DBA

Confidential, Indianapolis

Responsibilities:•

• Installed, configured, administered and secured SQL Server 2005/2008 on Server and Clients.
• Designed, implemented, and administrated databases in SQL Server 2005/2008
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery
• Involved in creating Schemas, Logins, Tables, Clustered and Non - Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedures
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors
• Configured Log shipping from one production server to the reporting server
• Monitoring and troubleshooting SQL Agent Jobs including backup and batch jobs
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Documented the security standards and roles depending on Development, UAT and Production environment: s.
• Helping application teams in query analyzing and its optimizat

MS SQL Server DBA

Confidential, Hartford

Responsibilities:

• Installed SQL Server 2005 on the servers according to the requirements.
• Configured SQL Server 2005 according to the requirement.
• Performed the hardening on the SQL Server 2005.
• Changed SQL directories owner to Administrator account.
• Implemented audit policy in the system registry for SQL Server 2005.
• Performed Full backup and restore on the SQL Server.
• Transferred the logins, jobs, linked servers.
• Responsible for maintaining 2 - node Clusters in SQL Server.
• Created SQL admin accounts and dropped the Built-in-Admin.
• Changed all jobs owner from sa account to administrator account.
• Disabled SA account.
• Successfully Configured Snapshot, Transactional and Transactional with updatable subscription in
• Replication.
• Created Maintenance Plans for production servers (Full, Differential and Transactional Backups) using
• Lite speed.
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Created maintenance plan for user databases and system databases.
• Implemented database mail.
• Created operator and assigned the operator for jobs.
• Created various reports using SSRS and scheduled them as daily & Monthly.
• Delivered the final SSRS Report using the Request Handler.
• Implemented database mirroring.
• Supported on call on rotational basis and supported the databases 24x7
• Transferred the database objects from development to QA to production.