PROFESSIONAL SUMMARY:

• 10+ years of experience in SQL server Database Administration using MS SQL Server versions 2008 R2, 2012, 2014, 2016, 2017, 2019.
• Strong experience on designing and implementing the backup and disaster recovery strategies as per RPO and RTO values.
• Experience on configuring and maintaining Full backup, Transactional log backup, Differential backup and creating the maintenance plans for index rebuild, index reorganize based on fragmentation.
• Strong experience on identifying and troubleshooting database health, integrity checks and fixing them.
• Expert in implementing Transparent Data Encryption in Production and non - production environment (TDE)
• Implemented row level and column level encryption
• Implemented AlwaysOn encryption in Production environment
• Experience in Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Created reports, sub reports, charts, Tablix, Matrix, Hyperlink reports.
• Created jobs, alerts to run SSAS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job
• Experienced in setting up high availability and DR options like log shipping, mirroring, replication (Transactional or Snapshot) and AlwaysOn Availability Groups.
• Proficient with SQL Server Disaster Recovery, Backup/Restore and creating Business Continuity Planning.
• Experience in Database Migration, Migrated SQL Server 2008R2 to 2012 and to 2016.
• Proven experience in creating implementing Database objects like Stored Procedures, Triggers, Views, User Defined Functions.
• Well experienced in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV's.
• Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automated administrative tasks and Configuring Database Mail.
• Experienced in using Joins and Subqueries for the simplification of complex queries including more than one tables.
• Experience in implementing SQL Server security and managing permission to the Database through Database roles, Creating Users and Logins.
• Experience in writing and tuning T-SQL (Transact-SQL) (DML/DDL/DCL) Queries.
• Hands-on experience in maintaining SQL Server Clustering (Active-Active/Active-Passive).
• Experience in ETL (Extract, Transform and Load) using SSIS (SQL Server Integration Services) in SQL Server 2012 with Import/Export Data, Bulk Insert.
• Solid experience in troubleshooting and performance tuning by using activity monitor, performance monitor, DBCC, DMVs, DMFs and third party tools such as Spotlight, IDERA monitoring.
• Experienced on working with production Servers and 24 x 7 On-Call environments.
• Applied Service Packs and security updates for SQL server instances.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills as well as flexibility to learn advancements in the IT industry.

TECHNICAL SKILLS:

CORE TECHNICAL SKILLS: Windows R2, SQL Server, T-SQL, AWS-RDS, AWS-EC2, IDERA SQL diagnostic Manager, SQL safe 6.0, Red-gate SQL Compare 10 and Data Compare 10, DataEdo, ERWIN,SSDT, Azure, SSIS, SSRS, SSMS, DTA, JIRA, RAID, MYSQL, LiteSpeed, AZURE VM, Azure managed instance, MuleSoft, Salesforce, API.

WORK EXPERIENCE:

Confidential, Denver CO

SQL Server DBA

Responsibilities:

• Installed, Configured and Maintained SQL Server 2017/2 / 2008 R2 in multiple database environments.
• Participated in a data center migration and SQL server 2019 upgrade project from older versions of SQL servers.
• Installed and configured SQL Server in a standalone and Clustered Environment.
• Handled Performance Tuning and Optimization of slow running queries.
• Detected and resolved CPU, memory, I/O, disk space and other resource contention issues.
• Migrated SQL server 2008 R2 to SQL server 2019.
• Worked on Priority 1 and 2 Critical Incidents to meet the Response and Resolution Service Level Agreements (SLA)
• Resolved Security related issues to logins, users and application roles and linked Servers.
• Created SQL server Agent jobs and maintenance plans to automate tasks such as to run Index Maintenance, Index Defragmentation, Rebuild, Update statistics and capturing deadlocks using Trace flags.
• Performed Database Consistency Checks (DBCC), scheduling the scripts to run daily or weekly depending on the need.
• Performing routine tasks like disk space check, Consistency checks, looking for slow/long running queries and hung jobs.
• Performed SQL server post-installation activities (Configuration changes) and best practices to improve the overall server and database performance.
• Performed service packs update, security updates and hotfixes on clustered and standalone servers.
• Diagnose system problems, evaluate alternative solutions, and take initiative to solve problems.
• Monitored index usage and tuned them where appropriate
• Experts in Database refresh from prod to lower environment as per the business requirements. Automated quarterly/monthly database refresh.
• Managed and involved in SQL performance Tuning, identifying locking and blocking issues using Native and Third-party tools to enhance and boost performance of SQL Dbs.
• Managed and Implemented Ola Hallengren's Industries best SQL server maintenance plan and created schedules for all environments.
• Implemented always-on encrypting on SQL server 2019.
• ManagedSQL server Logins, Database users & rolesand involved in Daily User Maintenance.
• CreatedDatabase Maintenance jobsto perform full & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Providing weekly status information on all projects to Project Manager
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Logical and Physical design of database for projects on basis of user requirements using ERWIN
• Reporting on a weekly basis to the project manager.
• Extensively worked on troubleshooting and fine-tuning of databases for optimal performance.
• Worked withPerformance Tuning/Query tuning,execution plans, trace flags and SQL Profiler
• Installation ofService packsto all environments.
• Used log shipping for synchronization of databases.
• Designed and developed ETL process using SSISto load data from various sources like MS Access and SQL Server 2014, Oracle database
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS)
• Experience in migrating SQL Server 2012 and 2014 to SQL Server 2016 with AlwaysOn Availability
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases
• Performed production code deployments, verification and rollback when needed.

Environment: SQL Server 2008 R2, 2012, 2014, 2016, Windows 2008 R2, and 2012 R2, Spotlight, SharePoint 2003, ServiceNow, SSIS, SSRS, Management Studio, SQL Profiler and Database Engine Tuning advisor

Confidential, PA

SQL Server DBA

Responsibilities:

• Installed, configured, and maintained MS SQL Server on clustered and standalone production servers, Staging and development environment.
• Optimized slow running queries and stored procedures.
• Excellent experience on configuring and maintaining replication like Merge, transactional and snapshot replication.
• Implemented High Availability and Disaster Recovery solutions with SQL Server DB Mirroring, Log Shipping and Failover Clustering (Active-Passive / Active-Active).
• Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Created Database and Server level Audit specification using the SQL Server Audit Feature and analyzed the audit results.
• Rebuilding /reorganize indexes to reduce fragmentation and enhance SQL server performance
• Created triggers, views, and stored procedures,
• Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications, and configured database Mail.
• Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
• Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.
• Created a SQL Batch Job and maintained to the optimal needs.
• Used new features like row and page compression mechanism, Data Compression, and Backup compression.
• Worked closely with the development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures and data changes.
• Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory.
• Experienced with SSIS and SSRS package creation and deployment.

Environment: SQL Server 2008, 2008R2, 2012, SSRS SSIS, TSQL, TFS (Team Foundation Server), Windows Server 2008, 2008 R2, 2012.

Confidential, Cincinnati OH

SQL Server DBA

Responsibilities:

• Installed and configured SQL server 2008 and 2008/R2.
• Installed and configured window server 2003 and 2008
• Created and updated databases, tables, stored procedures, triggers, functions, and views.
• Configured, administered, and troubleshoot multiple databases in production and staging environments in clustered and standalone environments.
• Prepared documentation for disaster recovery plan.
• Involved in installing failover clustering on multiple nodes.
• Implemented database mirroring and log shipping
• Planned backup strategies, scheduled backups, and performed restore operations.
• Managed security of SQL server databases by creating logins, creating database users, creating roles, assigning proper permissions, creating server and database audits.
• Worked on creating, reorganizing, and rebuilding indexes.
• Worked on database space management, performance monitoring, and alert management.
• Planned the location of files and increased the size and number of files.
• Performed tasks of query optimization, troubleshooting client/server connectivity issues, and performance tuning.
• Monitored and troubleshoot database and server performance at system-wide scale and effectively identify network, databases, Memory, CPU, Disk Space, and I/O related bottlenecks.
• Transferred data between several servers using BCP and DTS.
• Generated reports extensively using SSRS.
• Providing resolution to assigned tickets (JIRA, Team Track and Service Desk) as per their severity and meet the deadline before SLA is due.