Shamvil Kazmi
New Delhi
Summary
Experienced SQL Developer/Administrator with a decade in IT, specializing in Azure SQL, Synapse SQL, and T-SQL proficiency. Recognized Azure Database Administrator Associate, adept at strategic project leadership, query optimization, and technology adaptation.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Sr. SQL Developer & Database Administrator
Tata Consultancy Services
03.2021 - Current
- Optimizing Leading strategic database support projects with focus on optimising Azure Synapse and ETL implementations to enhance data flow efficiency
- Collaborating with cross-functional teams to optimise SQL queries for improved application performance
- Managing Azure SQL Database instances and Azure SQL Managed Instances for enhanced data processing
- Implementing automated monitoring solutions for Azure Synapse and ETL processes results in 25% decrease in downtime and proactive issue resolution, ensuring continuous data availability and reliability
- Implemented comprehensive performance tuning strategy, resulting in increase in query efficiency
- Revamped SQL queries for enhanced performance, reconfigured SQL servers, addressed deadlock scenarios, and increased connection throughput led to improved overall system efficiency
- Conducted performance tuning and adeptly identified and resolved blockers, ensuring optimised database operations.
- Evaluated and recommended best practices to improve existing SQL codebase, leading to increased efficiency and reduced maintenance efforts.
- Assisted in database migration projects, ensuring accurate data transfer between systems.
- Optimised database performance by analysing and fine-tuning complex SQL queries.
- Streamlined backup and recovery processes enhance overall system stability and availability.
SQL Developer/DBA
HCL Technologies
10.2012 - 03.2021
- Lead core database administration tasks, including provisioning new SQL Server environments and optimizing database access
- Automated routine database maintenance tasks using PowerShell scripts for increased operational efficiency by 20%
- Introduced database partitioning strategies that resulted in improvement in data retrieval speed, optimized database access and enhanced overall system performance
- Developed and implemented database automation framework that reduced manual intervention, increased operational efficiency, and minimized human errors in routine maintenance tasks
- Enhanced database performance through strategic performance tuning initiatives
- Developed database automation framework, reducing manual intervention.
Associate
Wipro
03.2011 - 03.2012
- Offered expert technical assistance to global clientele, resolving complex connectivity challenges and ensuring uninterrupted communication channels
- Conducted troubleshooting for internet connectivity challenges, delivering prompt and effective solutions.
Education
Master’s - business administration (IT
Amity University
New Delhi01.2020
Bachelor of Arts - History
Indra Gandhi National Open University
New Delhi04.2014
Diploma - Engineering (Automobile
G.B. Pant Polytechnic
New Delhi08.2011
Skills
- Database Administration
- Cloud Migration Strategies
- Disaster Recovery Planning
- Data Warehousing Concepts
- Performance Tuning
- T-SQL Expertise
- SQL development
- Patch management
Accomplishments
- Administering SQL Server 2012/2014
- Certificate Number: F763-5128 on Jul’16
- IT SKILLS
- Database Development:
- T-SQL Coding
- Stored Procedure, Functions, Business Logic
- Database Normalization
- Database Design
- Data Integration and Reporting:
- SSIS/SSRS
- Azure Data Factory
- Power BI
- Cloud Services:
- Azure SQL Database
- Azure SQL Managed Instance
- Azure Synapse Analytics
- Azure Infrastructure Administration
- Database Administration:
- SQL Server Administration
- Scripting and Automation:
- PowerShell Automation
- Operating Systems:
- Windows Server
- SQL Server Versions:
- SQL Server 2014-2022
- SHAMVIL HASAN KAZMI
- SR
- SQL DEVELOPER/DBA
Certification
Azure Database Administrator Associate
Certificate Number: 20PE86-220A15 on April’24
Languages
Timeline
Sr. SQL Developer & Database Administrator
Tata Consultancy Services
03.2021 - Current
SQL Developer/DBA
HCL Technologies
10.2012 - 03.2021
Associate
Wipro
03.2011 - 03.2012
Master’s - business administration (IT
Amity University
Bachelor of Arts - History
Indra Gandhi National Open University
Diploma - Engineering (Automobile
G.B. Pant Polytechnic
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Manav SaxenaManav Saxena
Technical Lead at Digicommerce Solution LLPTechnical Lead at Digicommerce Solution LLP