SUMMARY

• Over 6 years’ experience in Database Administration, Development Support, Designs and Analysis.
• Highly experienced in HA Solutions and DR setups for Designs and implementations of Always On, MS SQL Server Solutions, Mirroring, Replication Models Transactional / Snapshot, Log Shipping and HADR Set up configuration.
• Experience in Disaster Recovery, planning and setup.
• Support of MS SQL Server 2005/ 2008/ 2008 R 2/ 2012/2014/2016/2017 and 2019 SQL Managed instance in Production, Test, Development, Cluster and Cloud Environment.
• Experienced in supporting Very Large Databases VLDBs and Data Warehouse setups.
• Very experienced in Upgrade and Migration of MS SQL Server and from 2012/2014/2 .
• Fully involved in teh support and Management of Thousands of Databases and SQL Servers.
• Good knowledge of Systems 2008/2008R2/ 2016 Servers.
• Implementation of SQL Login, Roles and Permissions.
• Experienced in setting up Maintenance Plans, Creating Jobs and Automating Processes.
• Knowledgeable in TQSL and Powershell Scripting.
• Experienced in working with SQL Server tools such as Export/Import Wizard, SQL Server Profiler SSTD.
• Experienced in Backup and Restoring, Performance Tuning, Optimization and Job Scheduling.
• Experienced in creating Technical Documentation and process archiving and change.
• Experienced in working with SSRS, Tableau, Power Bi for Reporting and Data Visualization.
• Experienced in setting up Encryption Transparent Data Encryption TDE, Masking and Always Encrypted.
• Excellent Analytical, Communication and Interpersonal Skills.
• Excellent Team Player and Motivator.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Administrator

RESPONSIBILITIES:

• Provisioning Databases and configuring appropriate HA/DR strategy based on teh RTO/RPO of teh business Division
• Configuring, Maintaining and troubleshooting Log shipping, Mirroring, Always On Availability Groups, SQL server Failover cluster on Same and multiple subnet.
• Carrying out performance tuning task on a regular basis on issues ranging from query tuning to index optimization, TempDB issues, to IO, High CPU usage, severe blocking, long running query, Always On out of sync, Mirroring out of sync, Log shipping out of sync.
• Maintaining SQL Server Cluster setup and configuration
• Weekly Patching of Standalone and Cluster instances
• Migrating and Upgrading SQL server from Legacy to 2014, 2016, &2017
• Creating and supporting ETL process from Oracle to SQL server, Sybase to SQL server, Access to SQL server, Excel to SQL Server.
• Managing permissions and security.
• Monitoring daily, weekly, Monthly and quarterly Maintenance Task, ensuring dat its successful and jumping into resolve issues when it fails.
• Automation of repetitive task Using PowerShell.
• Carrying out regular health checks across thousands of servers using PowerShell script.
• Maintaining database space issue, resolving excessive log growth issue, and Normalization of DBs
• Worked with other team members to implement changes to server, instance and databases. Provide regular support to application owners and developers.
• Supporting Reporting Servers (SSRS), Integration Services (SSIS), Analysis Services (SSAS).
• Deploying changes and rolling back changes from production.
• Working with team in an agile environment.
• Creating SOPs for fixing, configuring, and maintaining DBs
• Supporting 2005, 2008, 2012, 2014, 2016, 2017, 2019, Azure SQL, Azure Managed Instance, SQL VM Instances both on premises and in teh cloud.
• Recently started supporting PostgreSQL (Backup and Restore Operations)

Confidential

SQL Server Database Administrator

Responsibilities:

• I was responsible for installing, configuring and maintaining SQL failover clustering for Production Environment.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various users.
• Maintained Database Located in NY4 New York and LD4 London .
• Weekly Refreshing Database for analysis and Developers Update
• Using T - SQL stored procedures to automate task
• Migrated SQL server 2008 to SQL Server 2012, in Microsoft Windows Server 2012 Enterprise Edition.
• Migrated database from on premise to Azure Cloud
• Installed and administered 2-Node cluster Active /Passive on Microsoft Windows Server 2012 Enterprise Edition, Active=NY4, Passive=LD4
• Securing Database with Transparent Data Encryption TDE
• Rebuilding teh indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Perform SQL Server service pack and Windows Service pack patches and upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing teh database.
• Troubleshoot performance problems and fine-tuning of databases.

Environment: SQL Server 2008, SQL Server 2012, windows server 2012 R2, 2014, 2016,2017.

Confidential

SQL Server Database Administrator

RESPONSIBILITIES:

• Implemented Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Performed Regular Backup and Maintenance Jobs across teh 150 Database Managed
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered 3-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Migrated database from on premise to Aws Cloud
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Rebuilding / monitoring teh indexes at regular intervals for better Performance.
• Recovering teh databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction using log shipping.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

Environment: SQL Server 2008, SQL Server 2012, 2014, windows server 2012