SUMMARY

• Having 13+ years of experience in MS SQL Server DBA (2017,2016,2014, 2012, 2008,2008R2, 2005, and 2000)
• Expertise in Installation, Configuration, Patches, Upgrades & Administration for SQL Servers in Clustered (Failover) & Non - Clustered Environments.
• Strong experience in Upgrades from lower level to higher level version.
• Worked on Configuration, Implementation and Maintenance for Disaster Recovery solutions Using Log Shipping, Replication technologies like Transactional, Snapshot & Merge replication in SQL Server 2008r 2/2012/2016.
• Experience in scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third-party tools (LiteSpeed, Redgate, and Tivoli Data Protection).
• Experience in configuring Always On with High Availability (HA) and Disaster Recovery and Windows Server Failover Clusters.
• Experience in creating and managing database in Azure platforms.
• Experience in using Change Data Capture (CDC).
• Participated in planning of Disaster Recovery Planning, Execution and Testing.
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Experience in Configuring and Maintaining Database Mirroring and Database Snapshots.
• Experience in Business Intelligence tools like SSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analytical tool (SSAS).
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards.
• Good knowledge of Database architecture & modeling,
• Expertise in building the knowledge management system for all the ongoing issues.
• Experience in solving Database issues with Index fragmentation, CPU Bottleneck, I/O Bottleneck, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Good knowledge in windows server and active directory configuration
• Expert in Database Capacity Planning and maintenance.
• Participated in Server offline Investigation & ERD
• Supporting and configuring SQL Server Analysis Services (SSAS).
• Knowledge about in Dimensional Data Modeling Star and Snow Flake Schemas.
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Experience in creating documentation about the process and environment.
• Experience in tuning performance at Server, Database and Query level.
• Participated in 24/7 on Call Support for Production Databases.

TECHNICAL SKILLS

Databases: MS-SQL Serve 2008R 2/ 2012/2014/2016 /2017.

Languages: T-SQL. PowerShell.

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, SQL Server Configuration Manager (SSCM),Index Tuning Wizard, Database Tuning Advisor Wizard (DTA), Profiler, Query Analyser, Export Import, Business Intelligence tools (SSIS),SSRS,SSAS,DTS,TDE,Web technologies like Internet Information Services (IIS),Surface Area Configuration (SAC),Change Data Capture (CDC)

Operating systems: Windows Servers 2003/20008r 2/2012/2016.

Third-party Backup Tools: EMC Networker, REDGATE SQL Safe, LiteSpeed

Monitoring Tools: Foglight 5.6, HP Site Scope, Perfmon.

Ticketing Tools: Remedy 7.6, HPSM, and JIRA

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. Database Administrator (SQL)

Environment: Microsoft SQL servers 2012/2014/2016 on windows Servers 2012/2014/2016

Responsibilities:

• Involved in Install SQLServer 2008R2/ 2012/2014/2016 /2017 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version 2008r2 to 2012/2016/2017.
• Installed Microsoft Service Packs/Patches/Hot fixes to keep the servers up-to date.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshoot Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Troubleshoot and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2012.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoot Replication Problems.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Created various Jobs scheduled & ran jobs and troubleshoot the failed jobs.
• Experience in handling Critical issues like P1/P2, involved in Recovery bridge calls and Co-Ordinate with respective teams to resolve the issues within the SLA timelines.

Confidential, Arizona

Sr. SQL DBA

Environment: MS SQL servers 2008r2/2012/2014 on windows servers 2008r2/2012/2014

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2008R2/ 2012/2014/2016 Production and Non Production Servers.
• Involved in Migration of SQL Server 2008R2 to 2012/2014/2016 .
• Experience in creating and managing database in Azure platforms.
• Migrated data/databases from Oracle to SQL environments.
• Installed Oracle tools and drivers on SQL server for creating Linked Servers.
• Involved in Configured AlwaysOn Availability Groups for DR and Reporting.
• Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Monitored Log shipping/Transactional Replication and trouble shooting of errors.
• Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Rebuilt indexes with different fill factors and update statistics manually.
• Written T-SQL code to automate the SQL Server failed logins, SQL database restore jobs.
• Debug and fine tune the application code SQL for the optimal performance of the database.
• Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Used Database Consistency Checks - DBCC commands for database maintenance
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
• Running Index Tuning wizard for optimal query performance
• Performed all aspects of database administration, including backups and recovery
• Handled orphan users while moving databases.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Supporting and configuring SQL Server Analysis Services (SSAS)
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data models in adherence with Organization policies
• Proactively monitored, determined and solved issues at SQL/database/server levels

Confidential, Oakland, CA

Sr. SQL DBA

Environment: MS SQL servers 2008r2/2012/2014 on windows servers 2008r2/2012/2014

Responsibilities:

• Installed, managed and administrated the MS SQL Server 2008r2/2012/2014 Production and Non Production Servers.
• Migration of SQL Server 2005 to SQL Server 2008R2, SQL Server 2008r2 to 2012/2014.
• Setting databases with company policies in place and deploy user data as requested by the application teams.
• Experience in creating and managing database in Azure platforms.
• Managed Oracle Databases.
• Migrated data/databases from Oracle to SQL environments.
• Installed Oracle tools and drivers on SQL server for creating Linked Servers.
• Worked on Security Audit Logins, had deployed Audit on Development, QA, UAT environments
• Worked on installation of MSSQL Server Module on Production and Non Production Servers.
• Configured AlwaysOn Availability Groups for DR and Reporting.
• Worked extensively on Data Refreshes from Production to Test environments, automated the whole data refresh process at database level using Power Shell scripts, stored procedures, Backups and SQL Agent jobs without having any performance impact on Production server.
• Monitored Log shipping/Transactional Replication and trouble shooting of errors.
• Implemented Database Mirroring and Transactional Replication as a part of DR plan.
• Rebuilt indexes with different fill factors and update statistics manually.
• Debug and fine tune the application code SQL for the optimal performance of the database.
• Experience in Maintaining SQL Server Security including the creation of logins and users, configuring permissions and assigning roles to users as required.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Used Database Consistency Checks - DBCC commands for database maintenance
• Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
• Running Index Tuning wizard for optimal query performance
• Performed all aspects of database administration, including backups and recovery
• Handled orphan users while moving databases.
• Experience in running backups and database refreshes using RMAN.
• Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
• Supporting and configuring SQL Server Analysis Services (SSAS)
• Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data models in adherence with Organization policies
• Proactively monitored, determined and solved issues at SQL/database/server levels