Server Welding

Name: Panial Macwan

Mobile No: +1-224-***-****

E-Mail Id : adl8a9@r.postjobfree.com

PROFESSIONAL SUMMARY:

Having 5+Years of experience as Microsoft SQL Server Database Administrator in production support. 24 X 7 Production Database on Call Support.

SQL Server DBA Production Support, issue resolution tickets with in the SLA’s Expertise in Database Administration of SQL Server installation & configuration, of SQL Servers 2012, 2008 R2, 2008 and 2005.And applying service packs. Implementing the Backup strategy and restoring the databases whenever required and experience in backup and restoring.

Administering SQL Server High Availability and Disaster Recovery setup. Experience in using DMV and dynamic management functions for finding out long running queries. SQL Server proactive performance monitoring and SQL Server Migration Expert for in Place & Side by Side

SQL Server Security Administration and Auditing on weekly and monthly processes Experience in Disaster Recovery Planning and Security Management operations. Having hands on experience configuring and monitoring the disaster recovery and high availability solutions like Replication, Log Shipping and Mirroring. Worked on configuring SQL Server with minimum privileged access. Troubleshoot performance problems, fine-tuning of databases and index Analysis. Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

SQL Server Development or Change Script deployment on production servers. Experience in supporting Very Large databases (VLDB) and troubleshooting the problems. SQL Server, Reporting, Integration, Analysis Services Installation and Service Pack upgrade Strong experience in mentoring team members and writing documentation. Upgrading SQL server from various versions like, 2005 to 2008R2 and 2008 to 2012. Certifications:

• Exam 70-764: Administering a SQL Database infrastructure

• Exam 70-765: Provisioning SQL databases

• MCSA: SQL 2016 Database Administration-Certified 2021 Technical Education:

Bachelors in Engineering

Technical Expertise:

Databases: MS SQL Server 2019, 2017,2016,2014,2012,2008/R2,2005 and 2000 Operating System: Windows Servers 2016,2012/R2,2008/R2,2003 SQL Server Tools: SQL Server Enterprise Manager, Query Analyser, SQL Server Management Studio, SQL Profiler, Business Intelligence Management Studio,DTA, Perf Mon. Ticketing Tools : BMC Remedy, TFS, Lotus notes, Change Management Process, CA Service Desk Manager.

Network Topologies : TCP/IP, DNS, WINS, DHCP, FTP, SMTP Professional Experience:

Worked with “Waltair Information Technologies Pvt Ltd” . Project #1:- New York Life Insurance

Company : Waltair Information Technologies Pvt Ltd Client : DANA Companies

Role : Process specialist

Duration : DEC-2017 to till date

Team Size : 10

Description:

New York Life Insurance(NYLIC) is largest mutual life-insurance company in the United States, and one of the largest life insurers in the world, ranking #80 on the 2015 Fortune 500 list, with about

$550 billion in total assets under management, and more than $21 billion in surplus and AVR. In 2007, NYLIC achieved the best possible ratings by the four independent rating companies

(Standard & Poor's, AM Best, Moody's and Fitch). Other New York Life affiliates provide an array of securities products and services, as well as institutional and retail mutual funds. Responsibilities:

We are supporting nearly 3000+ Databases which includes Prod/Dev/QA environment. Installation and configuration of SQL Server 2019 and 2017 on Windows Servers 2016. Installing and updating the Mandatory Patches in SQL Servers. Created new user accounts, profiles, and roles and assigned them to different users and enabled auditing to monitor the system privileges and roles granted. Log shipping configuring and monitoring.

Managing replication in SQL Server 2008/2008R2/2012 and monitoring replication server. Creating procedures and SSIS packages

Monitoring SQL Server Backups, upgrades to new version, apply service packs to correct server bugs and trouble-shoot SQL Server issues.

Communicating regularly with all teams to ensure database integrity and security. Have created Jobs, Alerts, SQL Mail Agent and scheduling DTS. Implemented Physical and logical Standby databases on standalone databases to ensure high availability, data protection and disaster recovery. Implemented AlwaysON, Log Shipping, Mirroring and Replication for High Availability, Data Protection and Disaster Recovery in MS SQL Server.

Worked on Windows Server and Sql Server Clustering and Balancing the Clusters by doing Failover and Failback during maintenance activities.

Expert in Using DMVs, Performance dashboard, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / monitoring the indexes at regular intervals for better performance. Designing Backup & Recovery and for point in time recovery. Providing Security by giving access permission to users at various levels. 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. Project #2:-ESAB

Company: Waltair Information Technologies Pvt Ltd

Client: ESAB

Duration: SEP 2015 to DEC 2017.

Team Size: 4

Description:

ESAB is a world leader in production of welding consumables and equipment. ESAB is represented in almost every country by subsidiaries or agents. Sales and support is established in 80 countries and there are 26 manufacturing plants across four continents. With operations in a large number of countries, the brand is synonymous with world leading expertise in the following key areas: Manual welding and cutting equipment, Welding consumables. Welding automation, Mechanized cutting systems for each discipline, continuous development of methods, materials and know-how is being directed to meet the challenges posed by a diversity of industry sectors. ESAB is organized to deliver efficient, high-productivity solutions to meet their requirements in a manner that exceeds their expectations. ESAB customers are found in the Automotive, General, abdication

& civil construction, Pipelines, Pipe mills Power Generation Process Industry Repair &maintenance Shipbuilding & offshore Transport & mobile machinery. The ESAB group was acquired by Colfax Corporation

Responsibilities:-

Installation and configuration of SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition. Standalone HP servers in enterprise Data Centres. Installing and updating the Mandatory Patches in SQL Servers Migrated SSIS packages from SQL Server 2005 to SSIS 2008 R2. Worked on Analysis Services and Reporting Services installations and configurations Expert in Using DMVs, Performance dash board, Mirroring, and tracking Performance Counters. Rebuilding / monitoring the indexes at regular intervals for better performance. Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions Expertise in designing databases and capacity planning. Rebuilding the indexes at regular intervals for better performance. Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). 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. DECLARATION:

I hereby declare that the information furnished above is true to the best of my knowledge and Belief.

Contact this candidate