shamvil kazmi
sk
s kazmi
shamvil
kazmi
new delhi
Delhi
India
09818677472
shamvilkazmi.wordpress.com
shamvil-kazmi-431aa128
new delhi
Delhi
India
Phone
p 09818677472
Email
e shamvilkazmi@gmail.com
Website
  • w shamvilkazmi.wordpress.com
Socials
  • LinkedIn l shamvil-kazmi-431aa128 (LinkedIn)
Skills Skills

Primary Skills

  • SQL Server Database Administration
  • SQL Server Performance Tuning
  • PowerShell Automation
  • Azure SQL Database
  • SQL Server T-SQL Development

Secondary Skills

  • SQL Server Reporting Services
  • SQL Server Integration Services
  • SQL Server Analysis Services
  • Oracle Database Administration (L1)
  • PostgreSQL and MongoDB (L1)
  • Linux
  • Windows Server
  • Active Directory
  • PowerBI
  • System Center Operations Manager
  • Microsoft System center Orchestrator
Experience Experience
10/2012 – present
Noida
SQL DBA
Noida
HCL Technologies Ltd
10/2012 – present
Noida
SQL DBA
10/2012 – present

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
03/2011 – 03/2012
New Delhi
​Technical Support Executive
New Delhi
Wipro BPO
03/2011 – 03/2012
New Delhi
​Technical Support Executive
03/2011 – 03/2012


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 Education
2018 – 2020
Masters in Business Administration (IT)
Masters in Business Administration (IT)
Amity University
2018 – 2020
Masters in Business Administration (IT)
2018 – 2020
2011 – 2014
Bachelor of Arts (History)
Bachelor of Arts (History)
Indra Gandhi National Open University
2011 – 2014
Bachelor of Arts (History)
2011 – 2014
2012 – 2015
Software Engineering
Software Engineering
GNIIT
2012 – 2015
Software Engineering
2012 – 2015
2008 – 2011
Diploma Engineering ( Automobile)
Diploma Engineering ( Automobile)
G.B. Pant Polytechnic
2008 – 2011
Diploma Engineering ( Automobile)
2008 – 2011
2007 – 2008
10+2
10+2
Dr. Radhakrishnan International School
2007 – 2008
10+2
2007 – 2008
Interests and Miscellaneous Interests and Miscellaneous

Github

In my personal free time, I would explore the boundaries of my skills, combining them and finding new ways to make my work as a DBA more challenging and interesting while also easier to do. (or automated) I write and maintain three repositories


  • shamvil89/backup_restoresqldb: I have written a stored procedure that will make backup/restore easier. The stored procedure will create a script that will include all restore script based on parameters passed. It is also designed to ignore copy-only backup or ignore regular LSN and only go for copy-only based on parameter input. You can read more about it here - https://shamvilkazmi.wordpress.com/2020/08/15/sql-backup-restore-made-easier/

    I have also written another stored procedure sp_dbundo. It creates a point in time restore option , if executed can restore the database easily to a point where mistake hadn't occurred. By default - it will take it back to 15 minutes prior to current time and because of this behavior I decided to call it "dbundo". You can read more about it here - https://shamvilkazmi.wordpress.com/2020/08/20/sp_dbundo/

  • shamvil89/first-repo - I write and maintain miscellaneous T-SQL or PowerShell Scripts here. An example would be that I wrote a Trigger that would not only capture who altered the SQL Job, but also record all the changes it caused to sys.sysjobs table (enabled, date modified, version, etc). You can read more about it here - https://shamvilkazmi.wordpress.com/2020/08/21/sql-job-insert-update-delete-trigger-with-modification-capture/

  • shamvil89/SQL_Compliance_checker - I once wrote a very good SQL Server hardening report generator using PowerShell for a client. The feature was accepted and integrated in their process and since I had no ownership, I decided to write another and with more robust features and record development over Github. Once a more user friendly report is built, I will write a blogpost about it.


Blog


I also write a technical blog - shamvilkazmi.wordpress.com

The blog covers all topics related to skills I am well-versed with. It's not a teaching blog - I consider it to be like a technical "dear diary" to me.

Certifications Certifications
  • Microsoft Certification
    • Administering SQL Server 2012/2014
      • Certificate Number: F763-5128
      • Date of Achievement: July 22, 2016