
satish.patole
About Candidate
· IT Professional having 12 Year 4 months experience in SQL Server Database Administration and having Good experience in Azure database Administration.
· Experience in installation of different version of SQL SERVER (2022,2019,2017,2016,2014 2012,2008R2, 2005, 2000) in both OLTP and OLAP lower regions and Packageion environments.
· Played a major role in database maintenance, Security, upgradation, and Performance Tuning.
· Having Good experience in transaction phase as well as client SME level.
· Implemented High Availability & Disaster Recovery techniques like Always on Availability Groups, Cluster (Both Active-Active and Active-Passive) Database Mirroring, Transactional Replication and Log Shipping.
· Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012.
· Daily routine DBA tasks like handling user’s permissions and space issues on Packageion and Semi-Packageion Servers and handling maintenance Jobs.
· Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012,2014,2016,2019,2022 new features.
· Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and databases Maintenance.
· Experience in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
· Monitoring the different server including backup, disk space, Job failures, connectivity, and performances.
· Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
· Strong expertise in configuring, managing, and restoring backups in critical production environments.
· Experience in implementing and managing database encryption methods to ensure data security and compliance, Working knowledge of SQL Server Service Broker for messaging and queuing applications within the database.
· Proficient in managing SQL Server instances within a Windows Server Failover Clustering (WSFC) environment.
· Experience in setting up, monitoring, and troubleshooting Always on Availability Groups for high availability and disaster recovery.
· Experience in using DMV and Dynamic management function for finding out long running Queries.
· Familiar with ITIL Process and working with BMC remedy tool for ticket.
· Adept at proving database-troubleshooting issues like Locking, Blocking and Deadlocking, fail over maintenance and database recovery and provide 24* 7 Packageion database on call support.
· Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
· Experience in creating Jobs, Alerts, and schedule DTS/SSIS Packages.
· Handling Memory Configuration for SQL Server 2014 and 2012 on windows server 2012.
Education
Bachler in Science
MCA
Work & Experience
Project Name: - Migration of database on SharePoint to the on-promise cloud Description: - Emirates Global Aluminum (“EGA”), for the opportunity to participate in the Migrate SharePoint On-Premises to Cloud RFQ and is very excited to respond to it. We have mobilized a multifunctional team to prepare our response and spent considerable time analyzing the RFQ to understand your specific requirements. We understand EGA's current SharePoint applications, which are still On-Premises and are required to move to Cloud (MyEGA and Azure). The application should work as expected in MyEGA anytime, anywhere, and on any device. Role and Responsibilities: - • Provide database life cycle support for mission critical database Servers using various database tools. • Improve performance of databases and ensure systems & processes are compliant with regulatory requirements and company policies • Administers all database objects, including tables, indexes, views, sequences, packages, and procedures. • Perform data migration from existing database to new database and verify the migrated data. • Perform database tuning as well as complex Query and Complex task and it’s monitoring. • Proficient in PowerShell scripting for task automation, system configuration, and administration. • Create SQL or ETL scripts or using SQL tools to help ease production operations and any data migrations. • Monitor and analyses database activity to proactively identify and prevent potential Incidents and recommend performance improvements.
Project Name: - LafergeHolcim (Reign--Emea, Asia, America) Description: - LafargeHolcim is the global leader in building materials and solutions and active in four business segments: Cement, Aggregates, Ready-Mix Concrete and Solutions & Packages. It is our ambition to lead the industry in reducing carbon emissions and shifting towards low-carbon construction. With the strongest R&D organization in the industry, the company seeks to constantly introduce and promote high quality and sustainable building materials and solutions to its customers worldwide - whether individual homebuilders or developers of major infrastructure projects. Role and Responsibilities: - • Having Good experience in transaction phase as well as client SME level. • Incident, Change, Service Request Management in SNOW. • Handling the P1 incident with client call and resolve the successfully issue. • Creation/Altering/manage of databases according to Client requirement. • Creating database, logins and assigning proper permissions to maintain Database level security. • Monitor the status of maintenance jobs schedule to run on daily and weekly basis. • Maintaining database backups restore storage and space usage information for Capacity Planning. • Solving the database issue if database goes on various suspended mode. • Service pack, CU and security update patching on cluster and non-cluster servers. • Apply the patches on active and passive node. • Migration of databases and tables for different server. • Performing the Import/Export activity for the table on different server and Creating SSIS packages • Performing regular Health Checks for Database Servers • Transferring data using backup and restore method. • Maintain, operate and upgrade as necessary, other automated