SUMMARY

• Microsoft Certified Professional (MCSA) in Administering SQL Database Infrastructure for 6+ years of experience. Experienced in SQL Server 2019/2017/ 2016/ 2014/ 2012R2; skilled at installing, migrating,configuring,and administering on Standalone, Cluster and VMware Servers running on Windows Server
• Experienced in Microsoft Azure platform and Certified with Microsoft Azure Fundamentals Certification (AZ - 900).
• Expertise in database administration and maintenance on Production Servers with server configuration, update patches/updates, performance troubleshooting.
• Hands on experience in upgrading SQL Server in production environment and migration Databases from SQL Server to SQL Server and SQL Server to Azure.
• Architect Disaster Recovery and Backup/Restore plans according to business RTO/RPO to minimize the data loss & faster recovery as per the SLA.
• Expertise in configuring, maintaining, and troubleshootingAlwaysOnAvailability Group in production environment.
• Experience in implementing different types of Replication-Models such as Peer to Peer, Merge, Transactional & Snapshot on basis of the business specification
• Extensive experience in installation, configuration, maintenance, and optimization of SQL Server HA/DR solutions (me.e., Windows Failover Clusters, Mirroring and Log Shipping, Geo-Replication)
• Managed SQL Server security by enabling TDE, DDM, audit, Firewall rule modification, as well as creating and altering schemas, logins, users, roles, permissions.
• Troubleshoot performance glitches, fine-tuning of databases using DBCC, DMVS, Execution Plan, Query optimization, Partition for enhancing performance.
• Proficient in index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Skills in T-SQL programming tasks - Schemas,Tables, Views,Stored Procedures, Functions, Triggers.
• Knowledge of SSIS and SSRS, create packages and reports as company specifications.
• Have experience with data migration from on premise to Azure using DMA and DMS.
• Worked with Azure SQL Database, created Azure virtual machine, storage account, Instances in Azure platform and Configure them in test environment.
• Perform scheduled maintenance and support release deployment activities after hours as required.
• Monitors the nightly jobs run in SQL Server Agent, including nightly backups of the individual databases and batch processing jobs.
• Experienced Database and server decommissioning, Capacity planning, creating policies, linked server, snapshot, Powershell, Central management system.
• Worked with slow/long running queries, Disk space, Blocking, TempBb, Alerts in production environment.
• Excellent communication and interpersonal skills, self-motivated, quick learner, and determination to learn new technologies, strong troubleshooting, conflict resolutions and analytical skill and a good Team player.

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL Server DBA

Responsibilities:

• Installed and configured, maintained SQL Server 2016/2017 in all environments and migrate databases from SQL Server 2012.
• Maintained / monitored indexes and update statistics at regular intervals for better database performance.
• Experienced in monitoringDatabases for Lock,Block,Deadlock, resource utilization by sessions, capturing long running SQL queriesin efficient SQL statements processing.
• Security Administration by creating users, logins with appropriate roles, monitoring the user account, and granting right permission to users and groups.
• Updating database systems by reviewing, planning, testing, and installing database security patches and service packs.
• Worked with database migration from on premise to Microsoft Azure using Data Migration Assistant (DMA) and Data Migration Service (DMS).
• Knowledge of creating SQL Database, Virtual machine, Dynamic Data Masking (DDM), Audit, Alerts in Azure platform and Configure them.
• Verified and maintained database backup and restore, database integrity checks, and scheduled jobs for production databases.
• Configured and maintained transactional replication and troubleshoot replication related issues on regular basis.
• Configured and maintained Always On for production servers to provide high availability and loadbalancing.
• Evaluated Data Collection sets for capacity planning to capture growth of databases and reporting it to operations head for Weekly / Monthly / Quarterly growthreports
• Created Database Objects like Stored Procedures, functions, Views, Triggers, TDE, Linked server.
• Checked Database Health by using DBCC Commands and performance related issues using DMVS, Stored procedure, Alerts.
• Created and maintained Index, monitored Tempdb, slow running queries, alerts for database related issues in a regular basis.
• Deploying new code base release to Testing and Production Environments. Modifying the database structure, as necessary, from information given by application developers
• Created and configure Central Management System using SQL Server Agent to coordinate between servers.
• Coordinate implementation plans, including off-hours support scheduling, to meet needed coverage for installations, upgrades, maintenance, and monitoring of SQL server.
• TEMPEffectively manage day-to-day tasks in coordination with a team of developers and stakeholders to meet deliverables.

Confidential, NY

SQL Server DBA

Responsibilities:

• Administered, performed troubleshooting operations and maintained uptime for databases andservers.
• Schedule maintenance tasks like Index/Statistics Maintenance, Backups/Restores, DB integrity checks, tracing long running/deadlock queries, Capacity planning, Monitoring Tempdb, Cleanup tasks, Patch and hotfix installations, Disaster recovery solution maintenance, etc.
• Oversaw production to UAT, Test and Development Database activities using backup /restore
• ImplementedAlwaysOnAvailability Groups for High Availability and replicas for reporting and backup.
• Deft in design and administration of SQL Servers in multi node clustering with Active/Active, Active/Passive architecture.
• Experienced in configuring and maintaining log Shipping for production databases.
• Design and deploy SSIS Packages to export/import data from various databases and files.
• Manage security of SQL Servers and databases by creating logins, users and assign permissions
• Enforce Policy-Based Management at Database Level as well as Table Level
• Creating automated processes and jobs to import/export data to/from SQL Tables
• Review and optimize SQL queries, stored procedures, functions, Indexes, views, and triggers for better performance.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• noledge of RDBMS concepts, database architecture and SQL/T-SQL. Also worked with server and database decommissioning.
• Involved in troubleshooting, fine-tuning database performance and concurrency and root cause analysis using SQL Profiler, Perfmon, Database Engine Tuning advisor, Activity Monitor & analyzing execution plan
• Implement enterprise-level functionalities like Database Partitioning on Analytical systems for better performance also Sustain database health by using DBCC Commands and DMVs
• Analyze database growth and perform capacity planning.
• Recover the databases from backup in disaster by implementing Point-In-Time Recovery solutions.
• Working on day-to-day tactical break/fix and troubleshooting issues related to SQL Server production

Confidential, NY

SQL Server DBA

Responsibilities:

• Installed, configured SQL Server 2012 for all environments and upgraded 2008 R2 to 2012.
• Closely work with business analysts and developers to deploy databases and manage availability.
• Experienced working with SQL Server High Availability solutions such as Windows Clustering, Log Shipping and Mirroring.
• Monitor and optimize database performance in production, and test environment.
• Worked with developers to tune-up database performance.
• Worked extensively with Execution Plan to optimize SQL queries and Procedures.
• Setup and configured Database mail for notification purposes.
• Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs.
• Monitor databases for block, deadlock, resource utilization by sessions, and captured long running queries.
• Experience in maintenance plans to perform index defragmentation, reorganize index, rebuild index, and update the index statistics.
• Configured and maintained maintenance plan for incremental backup plan for all databases.
• Involved in capacity planning and monitoring data/log files size, growth, and disk space.
• Apply Windows and SQL Server service packs and cumulative updates.
• Created and managed database security, data encryption, and applied object level security.
• Provide 24/7 on-call support for all the Production Servers.
• Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis

Confidential, NY

SQL Server DBA

Responsibilities:

• Handled daily routine DBA tasks like handling user's permissions and space issues on production and semi-production servers and handling maintenance jobs.
• Executed SQL Logins, Roles & Autantication modes as a part of Security Policies for various categories of users.
• Provided technical troubleshooting and consultation to development teams.
• Developed, monitored, and maintained backup and recovery for all assigned databases to include the appropriate transaction logging.
• Configured & Monitored Transactional Replication, Database Mirroring and Log Shipping on production environment.
• Frequently Monitor Connections, Locks and Database Performance.
• Checking Database Health by using DBCC Commands and DMVS
• Participate in capacity planning for storage, servers and network components as needed to ensure performance
• Implemented and scheduled Replication process to update our parallel servers.
• Create and maintain detailed documentation including diagrams of database infrastructure.
• Tuned queries which are running slow using Profiler and Statistics by using different methods in terms of evaluating joins, indexes, updating statistics and code modifications.
• Frequently Monitor Connections, Locks and Database Performance using execution plans and index tuning.
• Obtain data from internal and external sources; analyze, validate, and distribute data, and use internal and external data to create, update, and maintain databases primarily using Access and SQL.
• Performed SQL Server service pack and Windows Service pack upgrades.
• Monitoring all the SQL Server alerts like disk space issue and SQL job failures and fixing the issues.
• Participate in implementation of new releases into production.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008 R2/ 2012 R2/2016, Windows XP/8/10

Database Tools: SSIS, SQL Server Management Studio, Database Engine Tuning Advisor, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication Monitor

Data Modeling: SQL Server Database Diagram, Erwin, MS Visio

Other Tools: MS Office, MS Project, Remedy, JIRA, LiteSpeed, Redgate, SolarWinds, JAMS, ServiceNow, Splunk, Azure Portal, Teams

Other skills: Performance Tuning, High Availability/ Disaster Recovery, Always on, Replication, Clustering, Log shipping, Mirroring, Maintenance plan, T-sql, Powershell, Query optimization, TDE, Azure, Backup and Restore, SSIS, SSRS, Security, Migration, Index, Database design, Cloud, Documentation, Capacity planning, etc.