Playing badminton
SHAIK ZAIF AHAMED S
Microsoft SQL Server Database Administartor
Bengaluru
Summary
- Over 5.2+ years of experience as a SQL Server DBA in a Production Environment supporting L2 Support, primarily working with SQL Server 2022,2019,2017,2016,2014,2012 versions.
- Applying SQL Server patches and security patches in standalone and cluster servers.
- Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.
- Verifying and resolving the SQL Server Blocking issues and finding and fixing the root cause.
- Resolving the Disk space issues and finding the root cause and permanent fixes.
- Expertise in Database backup, Recovery, Restoration, and Disaster Recovery Plans.
- Restoring the Databases from Production to test environment and vice versa.
- Experience in User Management activities like adding the user and managing the permissions.
- Experience in Creating and scheduling the jobs and troubleshooting the failed jobs.
- Good Experience in Performance tuning activities like verifying the slow running queries, fragmentation, and reindexing the fragmented indexes.
- Experience in tools like Performance Monitor, Profiler, Import and Export wizard, and Copy database wizard.
- Experience in usage of DBCC commands and DMVs for troubleshooting.
- Configuring, monitoring, and troubleshooting the TRANSACTION REPLICATION and DR activities.
- Configuring and Maintaining and troubleshooting the Database mirroring and experience in Mirroring DR activities.
- Configuring and Maintaining and troubleshooting the Database Log Shipping and experience in Mirroring DR activities.
- Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2012, 2016,2017,2019.
- Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.
- Experience with upgrades from SQL Server 2008 to 2012 and 2012 to 2022.
- Experience in SQL Server migration activities.
Overview
1824
1824
years of professional experience
3
3
years of post-secondary education
Work History
DBA
KARYA TECHNOLOGIES PVT LTD
07.202 - Current
Company Client: MASTER DRILLING, SOUTH AFRICA
Team Size: 4
Environment: SQL Server 2012, 2014, 2016, 2017, 2019, 2022
Role: Database Administrator
Duration: August 2021 to Present
- Master Drilling, established in 1986, is a global drilling technology solutions-driven company, focused on delivering a fully mechanized range of services to the mining, infrastructure, and energy sectors.
- As the trusted partner of choice, our business model is characterized by cutting-edge technology, innovative solutions, and tailor-made designs, coupled with a flexible support and logistics chain.
- We partner with our clients during every project touchpoint - from the exploration phase to the production and capital stages
- Our leading experts and advisors are able to provide a solution for every operational challenge - be it access, transportation, ventilation or analysis - focusing on the continuous research and development of new techniques and methods.
DBA
KARYA TECHNOLOGIES PVT LTD
08.202 - Current
Company: KARYA TECHNOLOGIES PVT LTD.
Client: MDC PRECISION, UNITED STATES
Team Size: 4
Environment: SQL Server 2012, 2014, 2016, 2017, 2019
Role: Database Administrator
Duration: March 2022 to present.
- MDC Precision is a world leader in delivering high-quality products to the research, semiconductor, aerospace, life sciences, and food processing sectors.
- We also offer comprehensive design and manufacturing solutions to augment our customers' needs.
- Our customers rely on us to provide the precision components that are required for operation at the atomic scale.
- Our products are critical to systems that produce semiconductors that are less than 20 atoms in size, physics apparatus that must see at the sub-atomic level, imaging of organic tissue at the cell level – all to enable science to change the world for the better
- We enable innovation by bringing our expertise in vacuum science, ultrapure and ultra-hygienic materials fabrication, ceramic-to-metal sealing along with our design and manufacturing partnerships.
DBA
CONCENTRIX PVT LTD
10.202 - 07.2021
DBA
REDBUS INDIA PVT LTD
12.201 - 10.202
Education
Bachelor’s Degree -
SRM Institute of Science And Technology
Chennai 07.2015 - 09.2018
Skills
TECHNICAL SKILLS
Operating Systems : Windows Family (XP/2000/2003/2008)
Languages : T-SQL
RDBMS : MS SQL Server 2012,2014,2016,2017,2019
SQL Server Tools : Enterprise Manager, Query Analyzer, SSMS, Profiler and DTA Other Tools : Service Now, Goss, Remedy and HPSM, Tivoli, TDP
Personal Information
- Date of Birth: 01/07/99
- Gender: Male
- Marital Status: single
Interests
Disclaimer
I hereby declare that the information given above is correct to the best of my knowledge.
(Shaik Zaif Ahamed).
Timeline
Bachelor’s Degree -
SRM Institute of Science And Technology
07.2015 - 09.2018
DBA
CONCENTRIX PVT LTD
10.202 - 07.2021
DBA
KARYA TECHNOLOGIES PVT LTD
08.202 - Current
DBA
KARYA TECHNOLOGIES PVT LTD
07.202 - Current
DBA
REDBUS INDIA PVT LTD
12.201 - 10.202
Similar Profiles
Gokul PGokul P
Senior Business Analyst, Power BI & Scrum Master at KARYA Technologies Pvt LtdSenior Business Analyst, Power BI & Scrum Master at KARYA Technologies Pvt Ltd
Praveenkumar RPraveenkumar R
Infrastructure & Cloud Support Manager at Karya Technologies Private LimitedInfrastructure & Cloud Support Manager at Karya Technologies Private Limited
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)