Vikal Pratap Singh

Experience

• 

  CMC LTD

  Jul 2009 - Jul 2013

  SQL DBA

  On Site for the client Chief Electoral Office, Kashmere Gate, Delhi.)  Configure Log Shipping. Database recovery technique, restore database and Complete backup of database Database backup scheduling for database maintenance Monitoring the condition of the database Using Perfmon, Event view and SQL Error log.  Configure and Trouble shoots on Mirroring. Performance Tuning.  Implement the Transactional Replication of database Decommission of database Installation of SQL Server 2008. Create Maintenance Plan. Show less

• 

  IBM India Pvt Ltd.

  Jul 2013 - Feb 2014

  SQL Server DBA

   Configure Log Shipping. Database recovery technique, restore database and Complete backup of database Database backup scheduling for database maintenance Monitoring the condition of the database Using Perfmon, Event view and SQL Error log.  Configure and Trouble shoots on Mirroring. Performance Tuning.  Implement the Transactional Replication of database Decommission of database Installation of SQL Server 2008. Create Maintenance Plan.

• 

  Wipro Technology

  Jun 2015 - Mar 2017

  Senior Database Administrator

  Configure Alwayson between two server and also configure log shipping on BCP server which has receive transaction log from both server which is part of Alwayson.On weekend basis do a failover over log shipping on BCP server.Configure mirroring with high safety and high availability both mode.Do a Sql patching on every weekend and also resolve MSI/MSP issue before doing patching/hotfix.Configure Two Node cluster on SQL server 2012.Doing almost kind of backup- Full, Differential, Log ,Snapshot, Split Backup, Copy Only.Configure Transactional Replication.Rebuild master database. Show less

• 

  HCLTech

  Apr 2017 - Jan 2020

  Associate Consultant

  • When associated with HCL Technologies, Noida as an Associate Consultant; part of the Practice Team we have migrated SQL Server Instance from On-Premise to AWS Cloud (IaaS), after completion of migration providing handover Instances on SQL databases in Production, Development, Demo, QA, Perf and UAT environment on SQL Server 2016, SQL Server2012.• Now Working on second project on which we have migrating Database\Instance from On-Premise to Azure (IaaS) through lift and shift (Azure Site Recovery-ASR) Show less

• 

  Rackspace Technology

  Jan 2020 - Sept 2022

  SQL DBA-III

  • Microsoft certified professional with more than 9 years of experience in Database Administration • We have performed the Assessment using DMA and shared the pricing tier to the customer for SQL VM, Azure SQL database, and Managed Instance.• I have enabled audit in Azure SQL Database and saved the log in Azure Log Analytics\Event Hub.• I have configured geo-replication in the Azure SQL Database and configured the failover group in Azure Server.• I have Configured log shipping from on-premise to Cloud (Azure VM) to reduce the downtime.• We have migrating Database\Instance from On-Premise to Azure (IaaS) through lift and shift (Azure Site Recovery-ASR)• Migrated SQL Server Instance from On-Premise to AWS Cloud (IaaS). We have configured AlwaysOn availability group. Also, we have configured SQL Failover Cluster in 2012.• After completion of the transition processes, Implement best practices on the database servers.• Expertise in managing a diverse Database Administration (DBA) team personnel with resources in multiple locations• Prepared KB articles for GDPR (General Data Protection Act) and for SQL Injection in SQL Assessment project which was recommended by Microsoft; in this internal project, worked on disabling SA account, Limit assignment of the PUBLIC Role permission, reviewed and resolved orphaned windows login, implemented TDE while configured AlwaysOn Availability Group• Designed, installed, upgraded, administered, monitored, and patched SQL 2005/2008/2012/2014/2016/2017,2019 databases server in cluster and non-cluster environments• Led projects in a multi-national environment; interacted with senior leadership on a global basis and geographies including Norway, Australia, USA, UK & Sweden.• Provided sessions on AlwaysOn High Availability, Replication, Azure SQL Database to the Team. Show less

• 

  NTT DATA

  Sept 2022 - now

  Database Architect