SUMMARY

• 5+ years of SQL Server DBA (SQL 2000/2005/2008/2008 R2/2012 and 2014) in Development, Test and Production Environments
• Experience in installing, migration, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008 R2/2012/2014 databases
• Installed and configured a SQL 2012 clustered environment with availability groups
• Hands on experience on Decommission of SQL Server and Database
• Performed ad - hoc database backups and restores
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and integrity of the company databases
• Experience with disaster recovery and high availability SQL Server solutions, using Always-on High-Availability groups, SQL Server clustering, Mirroring, Log shipping and, replication
• Maintain SLA’s to support timely and quality customer service
• Configure SQL Server monitoring utilities to minimize false alarms/alerts
• Experience working on databases/instances with different collation settings
• Automated checks of the database environment to identify system issues which include Database Availability, Database Space allocations and Automated backup and maintenance
• Installed, configured and administered multi Clustered instances with Active/Passive environments
• Worked on SSIS/SSRS tools
• Extensive experience in backup and restore procedures using native and third party Backup tolls (Net backup, lite speed, Idera) products
• Experience in controlling the user privileges, roles, monitoring the security and Audit issues in SOX environments
• Experience in using SQL profiler, ORACLE Enterprise Manager, System monitor, Query analyzer for troubleshooting, monitoring, optimization and tuning of SQL Server
• Experience in troubleshooting long running queries and resolving locking and blocking issues
• Extensive knowledge on using SQL IDERA tools like Diagnostic Manager Tool, SQL Compliance Manager
• Experience in providing SQL Server Security - Permissions with database roles, server Roles and e-mail configurations

TECHNICAL SKILLS

Databases: MS SQL server 2014/2012/2008 R 2/2008/2005/2000 , Oracle

ETL Tools: SQL Server Integration Services (SSIS)

Other Tools: SSMS, RDMS, DB2, Windows Performance Tool

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, SQL Server Agent, SSRS Log Shipping, DDL, SQLCMD

PROFESSIONAL EXPERIENCE

Sr. Specialist DBA

Confidential, NY

Responsibilities:

• Installation of MSSQL Server 2016, 2014 2012, 2008R2 on Production, UAT and Development environments
• Working on tickets\incidents within the SLA's, as a part of operations support DBA
• Maintained database consistency with DBCC at regular intervals, Managed Disk space, Memory and User connections, and Monitored SQL server performance using Profiler to find Performance and Deadlocks
• Strong knowledge in working on Very Large databases (OLTP) and involved in troubleshooting the problems and dealing with complex databases
• Migrated databases from SQL server 2008, 2008R2, 2012 to SQL Server 2014
• Implemented & managed Database Clustering, Failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering
• Mirroring experience with both synchronous and Asynchronous and applying service packs. Handful of experience in configuring Log shipping and troubleshooting the related issues
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance
• Assigned for Database Optimization that involved re-engineering the databases, data and index organizing, Performance Tuning and Query Tuning
• As a part of the team, configured Transactional Replication with multiple Publishers and centralized Subscriber for real time reporting
• Also implemented Mirroring for DR Plan
• Good knowledge and handful of experience in configuring and working with Always On Availability Groups
• Familiar with Virtualization Technology and running Windows inside a Virtual Machine
• Fixed the failed Principals (Logins), User Permissions and Security in Active Directory and SQL Server Level.
• Used the Power shell scripting to get the most consistent production environment
• Created Logins and Roles with appropriate permissions
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies
• Resolving blocking and deadlocks using DMVs, Profiler and killing respective SPIDs and also optimizing the queries, which are involved in blocking and deadlock issues
• Good knowledge and handful of experience on implementing Always on High availability starting from SQL server 2012 and 2014 versions
• Created and managed Schema Objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity
• Documentation, and mentoring the staff
• Confirmed all servers/databases are up and running fine on 24*7 environment

Confidential, Somerset, NJ

Responsibilities:

• Administration of 250+ instances of SQL Servers around the globe
• Experience with SQL Server 2000, 2005, 2008R2 and 2012 installations, configuration on WINDOWS 2003, 2008 servers, applied service packs and security fix on cluster environments
• Worked on Decommission of SQL Servers and databases
• SNOW ticketing tool was used to raise Requests
• Involved in Migration from SQL 2005 to SQL 2008
• Implementation of SQL Logins, Roles, Permissions and Authentication Modes as part of Security Policies for various categories of users
• Maintained Reporting services on MSSQL 2008/2008 R2 Platform
• SQL Server performance monitoring and troubleshooting
• Involved create tables, views, stored procedures, functions and also support SQL deployment to multiple environments
• Worked on setting up and managing Snapshot and Transactional Replication
• Implemented Database mirroring and Log shipping for disaster recovery
• Good knowledge on Lite speed backup tool, Commvault & Native Backups using SSMS
• Good experience in resolving user requests like, login issues, database access issues, disk space issue, blocking issues, WMI alerts and performance issues
• Scheduled Full and Transactional log backups for the user defined and system databases using the Database Maintenance Plan Wizard, by running backup and restore commands
• Performing checks on Error log based on issues
• Rebuilding the indexes at regular intervals for better performance
• Scheduled Jobs and alerts using SQL Server Agent
• Ensuring all scheduled jobs are running/completed for SQL Servers(PEOPLESOFT Servers)
• Worked on resolving issues on reporting services (SSRS) related to permissions
• Monitored and managed the use of space disk issues

Confidential, Wauwatosa, WI

Responsibilities:

• Administration of 350+ instances of SQL Servers around the globe
• Installation, Configuration and Maintenance of SQL Server instances on cluster, stand-alone servers
• Proactive monitoring of SQL Server instances (Production, Stage, Development) using monitoring tools like Idera SQL Diagnostic Manager
• Ensuring compliance of all Production instances using tools like Idera SQL Compliance Manager
• Timely backup of the databases using Idera SQL Safe tool
• Adhering to HIPAA Compliance in Security, Access Control, Data Integrity for sensitive healthcare databases
• Maintain SLAs to support timely and quality customer service
• Securing SQL Server instances and databases by granting limited permissions to users and application logins and revoking permissions that are no longer required by conducting quarterly security audits
• Maintained and Monitored Mirrored servers
• Implementing Log Shipping from Primary Server to Standby Server to support DR Solution
• Configuring SQL Server alerts to monitor and notify errors and failures
• Rebuilding the indexes at regular intervals for better performance
• Recovering the databases from backup in disasters
• Set up SQL Server configuration settings for better server management

SQL Server DBA

Atlanta, GA

Responsibilities:

• Administration of 30+ instances of SQL Servers
• Performed Daily Health Checks of Servers and Databases
• Monitoring Database Activities and troubleshooting any SQL related Issues in Client
• Configured Database Mail to receive Job alerts from SQL Server
• Performed Database Restore & Refreshes
• Updated SQL Server related Documents and shared the same with Clients
• Creating Maintenance Plans to automate jobs like Backups, Check DB, Index Reorg
• Generating reports of SQL Server using Idera Tool (SQL Diagnostic Manager)
• Managed security tasks like granting and revoking permissions

Confidential, Roanoke, VA

Responsibilities:

• Setting business dates for stores by running queries through SQLDeveloper
• Involved in recovery process
• Running backups, checking backup files
• Editing and executing scripts
• Validate and perform system checks
• Involved in restarting the hung servers
• Involved in checking log files to support month end process
• Assured the availability of servers (Sql & Oracle)
• Interact with client in process implementation and issue escalation