SUMMARY

• Experienced in installing, upgrading, patching, administrating and maintaining MicrosoftSQL Server 2019/ 2016/2 R2 in Production, Test and Development environments
• Knowledge on Microsoft SQL Server 2022.
• Implemented new SQL Server features by performing successful POCs
• Experienced in providing analysis onHigh availability/Disaster recovery & scalability
• Proactively monitoring and troubleshooting database issues and make tuning adjustments to ensure database integrity, security and systemperformance
• Proficient in performance tuning of T - SQLqueries, stored procedures and debugging the poorly written code and helping application teams in development life cycle
• Highly proficient in database Backup, Restore, Point-in-Time Recovery, Linked servers, and Database Maintenance Plans
• Expertise in RDBMS concepts and constructs.
• Working with data modelers on logical and physical data modeling and DBAs/Developers in implementing and updating physical data models in databases
• Experience with SQL/T-SQLfor creating, altering, and maintaining databases and database objects
• Experience of Upgrading and Migration from earlier version ofSQL Server toSQL Server 2012/2014 in different environments
• Solid experience and outstanding knowledge of SQL Server High Availabilityand Disaster Recovery solutions (Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn)
• Experience in creating, supporting and maintaining database administration scripts
• Experience with schema management, database reorganization, Partition, database maintenance and optimization
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Cascading, Conditional, Table, Chart and Sub Reports
• Extensive work experience in applying latest Service Packs, patches and hot fixes
• Manage Security Management: Securing SQL Serversand Databases, manage users, Data encryption, granting/ revoking access, data masking
• Identified alerts / processes that can be automated and then work with concern team in automating them
• Actively participated in Change management process with view to manage risk in production environment
• Build and improved run books for generalists to minimize operational errors and gain fungibility/efficiency
• Developed reports that provide trending statistics to track and managed application health and support service performance
• Provided support for incident resolution and supported production system deployments while ensuring SLAs are met
• Collaborated with other tech peers and support teams to ensure integrated end-to-end availability, reliability, and performance
• Good Windows PowerShell scripting experience
• Hands-on with PowerShell Workflows development
• Excellent ability to work as part of a team and independently and Able to manage time too effectively to meet deadlines and prioritize workload
• Extensively worked in24*7 Production environment

TECHNICAL SKILLS

Database Administration: SQL Server 2019/ 2016/2 /2005/2000 , Azure, MS Access,Oracle 10g, NoSQL Couchbase

Database Tools: Profiler, BIDS,DTS, Management Studio/Enterprise Manager, Query Analyzer,SSIS,Execution Plan,Extended Event

Operating Systems: Windows Server 2012,2008R2, 2003, Windows 7 Professional, Windows XP Professional, NT 4.0, Unix, Linux (RHEL)

Web Technologies: XML, HTML, VBScript

ETL Tools: DTS/SSIS,BIDS,SSDT,BCP

Languages: T-SQL,PL/SQL, XML, JavaScript, ASP, ASP.net and C++

Reporting Tools: Report builder, Crystal Reports, OLAPTools,BIDS,SSDT

Third Party Tools: Toad Data Modeler, Idera, Redgate,Spotlight,SCOM,Proactive DBA, CARA, Control M,Autosys, Control Center, Apps Dynamic, SQL Developer,Tectia,Putty,Solarwinds

Ticketing Tools: Service now, Remedy, JIRA, Call Agent

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Ohio

SQL Server DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2019,2016 on Prod/Test/Dev environments
• Upgraded/Migrated SQL Server 2012 and 2014 to SQL Server 2019,2016
• Applied SP (Service Pack) on SQL Server 2014, 2012, 2008 R2 on a routine basis
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2019/2016 and created documentation and Run book for AlwaysOn
• Performance tuning to optimizeSQLqueries using query analyzer
• Created indexes, Constraints and rules on database objects for optimization
• Performed performance tuning for servers, databases, SQL/TSQL queries and Stored Procedures
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, and Activity Monitor for monitoring, tuning, and troubleshooting purpose
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions
• Plan design, optimize, implement and support all aspects of Couchbase databases, and underlying operating system. Ensure security and compliance within enterprise standards.
• Complete accountability and responsibility to provide technical expertise for resolution of outages, service level issues, and user/customer support needs in coordination with other support teams.
• Experienced in installing, upgrading, patching, administrating and maintaining Couchbase 6.5, 6.6,7.3 in Production, Test and Development environments
• Configure, optimize and maintain Nosql Couchbase clusters
• Experienced in upgrade, troubleshoot performance tuning for Couchbase DB instances
• Experienced in creating buckets and adding data to it
• Configuration Replication for high availability
• Experienced in addition/deletion of node and rebalancing a cluster
• Experienced with Backing up and restoring a cluster
• Experienced in Performing failover and rebalance during failures
• Experienced in Cross Datacenter Replication setup
• Experienced in User Management and RBAC as a part of security
• Experienced in Web Console to administer and monitor Couchbase
• Good understanding of Views and Indexing

Environment: MS SQL Server 2019, 2016/2014/2012 , Windows Server 2016,2019, Linux Red Hat7, Application in JavaScript, ASP and ASP.net, SSRS, SSIS,SCOM, ZENOS, Comvault, JIRA, ServiceNow, Couchbase db

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2019,2016, 2014, 2012 on Prod/Test/Dev environments.
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed.
• Implemented new SQL Server features by performing successfulPOCs.
• Experienced in providing analysis onHigh availability/Disaster recovery&scalability
• Configured Log Analytics for Virtual Machines and SQL AZURE Pass databases.
• Having knowledge on storage accounts and storage replications.
• Experience in moving on premises Sql Server databases to Azure using bacpac files.
• Experience in creating the database maintenance tasks using Azure Automation.
• Experience in working with Azure SQL Database Import and Export Service.
• Performance tuning to optimizeSQLqueries using query analyzer
• Created indexes, Constraints and rules on database objects for optimization
• Applied SP (Service Pack) on SQL Server 2016,2014, 2012, 2008 R2 on a routine basis
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2016 and created documentation and Run book for AlwaysOn
• Worked on Database Refresh in DEV/UAT servers with PROD data and reinstate the server
• Implemented SQL Server Security, Creating and Managing users, granting/revoking access on database level or server level
• Performed performance tuning for servers, databases, SQL/TSQL queries and Stored Procedures
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, and Activity Monitor for monitoring, tuning, and troubleshooting purpose
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions
• Assisted and reviewed Developer SQL queries (T-SQL) and Stored Procedures for optimization and security purposes
• Worked extensively on SSIS Packages for extracting data of file system and transformed that data and loaded it into OLAP system
• Exported data from/to SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Provided 7 x 24 Production support for the database and application issues

Environment: MS SQL Server 2019, 2016/2 R2, Windows Server 2012/2008 R2, Application in JavaScript, ASP and ASP.net, SSRS, SSIS, Visual Studio 2010, IIS 7.5,SentryOne, IDERA, UltraBac, JIRA, ServiceNow, Oracle

Confidential, Plano Texas

SQL Server DBA

Responsibilities:

• Installed, Configured SQL Server 2014, 2016 in Development, Test, and Production environment
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues
• Worked on Database refresh in Dev/Test servers with PROD data and reinstate the server
• Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks
• Have used TFS to deploy script in different environments( prod/test/dev)
• Migrate/Upgraded SQL server instances from SQL Server 2008/20012 to 2014/2016
• Managed Security of SQL Serversand Databases Logins, Users, Granting/ deny/ revoke access
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space management and backup verification etc.
• Assisted Database Developers to optimize and troubleshoot SQL Server slow running queries /Stored Procedures/index/Function/Views
• Involved in report migration from Dev to Test/Prod and adding Data source/ managing security of report and create data driven subscription
• Fine Tune and improve Database Performance using SQL Server Profiler, Execution Plan, DMV, DBCC, indexes, Activity Monitor
• Optimized the database by creating various clustered, non-clustered indexes and indexed views
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2016/2014 with Synchronous automatic-failover mode
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Developed, maintained and implemented database backup and recovery plans for Production, Test and Development environments including mission critical databases
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Imp
• Provided 7 x 24 Production support for the database and application issues

Environment: Windows Server 2012, 2008r2, 2003r2, IIS 7.5, SQL Server, 2016, 2014, 2012, 2008r2, 2008, AD (Active Directory), and Application in JavaScript, ASP and ASP.net. Service-Now, BMC Control-M, TFS, SharePoint, DBartisan, Precise, SQL SentryOne, Oracle, DB2, Sybase

Confidential, Tampa FL

Production Support Analyst/SQL Server DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014, 2012, 2008R2 on Prod/Test/Dev environments
• Monitored Server Activity, Error Log, space usage, database health, backup verification, cleaning history and solving problem as needed
• Supports day to day operational activities for the database platform like service requests and tickets, monitoring, performance tuning, troubleshooting long running queries, locks, deadlocks and performance issue like CPU, I/O, Memory bottlenecks
• Upgraded/Migrated SQL Server 2005 and 2008R2 to SQL Server 2012/2014/2016
• Applied SP (Service Pack) on SQL Server 2014, 2012, 2008 R2 on a routine basis
• Configured and Maintained AlwaysOn Availability Group using SQL Server 2014/2016 and created documentation and Run book for AlwaysOn
• Worked on Database Refresh in DEV/UAT servers with PROD data and reinstate the server
• Implemented SQL Server Security, Creating and Managing users, granting/revoking access on database level or server level
• Implemented Transparent Data Encryption(TDE) on Production Server and Managed Keys and Certificates
• Performed performance tuning for servers, databases, SQL/TSQL queries and Stored Procedures
• Worked and maintained VLDBs, Partitioned table.
• Have used TFS to deploy script in different environments (prod/test/dev.)
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, and Activity Monitor for monitoring, tuning, and troubleshooting purpose
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Used DMVs and DMFs to monitor the health of a server instance, diagnose problems, and tune performance
• Proficiently worked on T-SQL scripting, creating and modifying Tables, Index, Views, Stored Procedures, Triggers, Functions
• Assisted and reviewed Developer SQL queries (T-SQL) and Stored Procedures for optimization and security purposes
• Involved in Database developing and Data Modeling project defining Data architecture and developed Normalization Form data redundancy and improve data integrity.
• Performed regular backups, restores and automated different day to day tasks
• Exported data from SQL Server to multiple destination/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources
• Imported data from SQL Server from multiple destinations/format such as Flat file, CSV file, Oracle, MySQL, ODBC/OLEDB data sources

Environment: MS SQL Server 2016/2 R2, Windows Server 2012/2008 R2, Application in JavaScript, ASP and ASP.net, TFS, Visual Studio 2010, IIS 7.5, Foglight, SentryOne, Apps Dynamic, JIRA, ServiceNow, Oracle, Sybase,Unix

Confidential, Chicago IL

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2016, 2014 on Prod/Test/Dev environments Provided application databases support and resolve problems related to the RDBMS platform environments like SQL Server, Sybase, and Oracle
• Setup, Configured and maintained AlwaysOn in SQL Server 2012,2014 and 2016
• Performed databases refresh on request: Refresh data from one environment to another at the request of the development team
• Managed SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems
• Provide solution and correct issues in real time resolution end-to-end users
• Performed scheduled maintenance and support release deployment activities after hours
• Used Quest Spotlight and SCOM monitoring tools to assist various aspects of system performance on numerous SQL Server instances
• When performance issues arise, determine the most effective way to increase performance including hardware, server, and databases
• Performed performance tuning for servers, databases, SQL/T-SQL queries and Stored Procs
• Used Query Analyzer, Execution Plan, Extended Events, SQL Server Profiler, Database Tuning Advisor, PerfMon, and Activity Monitor for monitoring, and troubleshooting purpose
• Used database performance third party tools like Solarwinds to monitor the database performance.
• Experienced in using DBCC commands to manage database consistency and repair as needed
• Used DMVs and DMFs to monitor the health of a server instance, diagnose problems, and performance tune
• Reviewed TSQL scripts and staged the script for CARA code migration also advice developers in code optimization.
• Diagnosed Control M job errors and implemented solutions and worked with developers to solve break/fix and other issues
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements
• Capacity planning and reporting: Monitor file system space, database allocation etc. verify efficient use of disk storage, reclaim unused space, optimize space allocation and avoid out-of-space conditions
• Ensured all database servers are backed up that meets the business’s Recovery Point Objectives (RPO)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Configured SQL Server monitoring utilities to minimize false alarms
• Providing 24X7 production On-Call support on a rotational basis

Environment: Windows Server 2012, 2008-R2, 2003-R2, IIS 7.5, SQL Server 2016,2014, 2012, 2008-R2, 2008, AD (Active Directory), and applications in ASP and ASP.net, Unix, Sybase ASE. Solarwinds.

Confidential, Washington DC

SQL Server Database Administrator

• Installed, Configured, and Maintained SQL Server 2008 R2, 2012, 2014, 2016 in test, development and production environment.
• Upgraded/Migrated SQL Server Instances/Databases from older version of SQL Server to new version like R2 to 2012/2014
• Migrated Oracle 10gR2/11gR2,MySQL and Sybase databases to SQL Server 2008 R2/2012
• Applied SP (Service Pack)/ hot fixes on SQL Server Instances to address security and upgraded related issues
• Setup, Configured and maintained AlwaysOn SQL Server 2012.
• Delivered reports to users in variety of formats like Report Server (Web based), excel, pdf, html, excel and CSV formats
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements
• Experience in SQL ServerSSIS package design, constructing, and deployment
• Developed thedimension,fact tablesand designed thedata warehouseusingstar schema
• Good understanding on data modeling projects and generated E-R Diagram
• Performed database and SQL/TSQL Performance Tuning using Profiler, Execution plan, DMV, DBCC, Activity monitor, Performance monitor
• Experienced in SQL/T-SQL queries, Stored-Procedures, functions, and Triggers
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, cleaning history, deleting old files, index and fragmentation managements
• Experienced in working with TFS server

Environment: Windows Server 2012, 2008-R2, 2003-R2, IIS 7.5, SQL Server 2016,2014, 2012, 2008-R2, 2008, 2005, AD (Active Directory), and applications in ASP and ASP.net.