shamvil kazmi
Mr.
New Delhi
Message
Connect
Profile:
Summary
I am SQL DBA with 8 years of experience along with variety of other skills.
Experience
2012
Oct
-
Present
SQL DBA
HCL Technologies Ltd / Noida
Client 3: Norway based leading company in hydropower internationally and Europe’s largest generator of renewable energy. The Group produces hydropower, wind power, solar power, gas-fired power and supplies district heating (2018- Present)
- Supported 2008 R2, 2012, 2014, 2016, 2017, Azure SQL Database
- Secondary support involves - SSIS, SSRS, SSAS, Oracle 11g, Oracle 12c, Oracle 19c, PostgreSQL, MongoDB
- Performance Tuning in SQL Server - Involves Index tuning, Server tuning and Query Tuning
- Testing and proposing new solutions to client
- Creating and maintaining technical documents, Database Inventory and runbooks
- Database Automation using PowerShell
- DR - Availability Groups, Replication
- Migration - P2V, V2V, V2C
- Handling EOL and EOS and upgrading
- Handling regular DBA responsibilities with On-call Support for priority issues
Client 2: German Bank supported Globally (2014-2018)
- Supported SQL Server 2000, 2005, 2008, 2008R2, 2012
- Editions: Enterprise Editions, Standard Editions
- Handled installation and hardening of SQL Servers
- DB backup and Maintenance
- Handling ad hoc backup and restore requests.
- Handled DB size up to 7 TB
- Configuring DR - Log shipping, Mirroring, Clusters
- Security Administration - providing and revoking access
- Database capacity management and ordering new storage as and when required
- handling DB refresh requests
- Also supported basic Oracle 10g, 11g and Sybase ASE15
- PowerShell - created automated scripts that would run on multiple servers and provide details as and when required
Client 1: Texas, US based power generator through coal and nuclear power plants (2012-2014)
- Supported SQL Server 2005, 2008, 2008R2
- Installed, upgraded and migrated SQL Servers
- Creating and troubleshooting on maintenance plans for SQL backup jobs and others.
- Handling ad hoc backup and restore requests from client
- Configuring DR - Log shipping, Mirroring and Replication
- Access Administration - granting revoking access as and when required
- Configuring Database Mail
- Database capacity management
- Handling database refresh requests
- Creating reports
2011
Mar
-
2012
Mar
Technical Support Executive
Wipro BPO / New Delhi
Worked as a technical support executive with a US based client that is one of the major Internet Service Provider in East and West Coast.
- Handled Remote Desktops
- Walked through with Network configurations and Modem/Router configurations
- Helped with Virus issues and installing antivirus
- Handling B2C in-bound calls
- Creating Excel reports
- Mentored fresh recruits
Education
2018
-
2020
Amity University
Masters in Business Administration (IT)
2012
-
2015
GNIIT
Software Engineering
2011
-
2014
Indra Gandhi National Open University
Bachelor of Arts (History)
2008
-
2011
G.B. Pant Polytechnic
Diploma Engineering ( Automobile)
2007
-
2008
Dr. Radhakrishnan International School
10+2
Skills
