Vikas Vishwakarma

About Vikas Vishwakarma

Site Reliability Engineer - AWS||DatabaseExperience and leveraging AWS cloud services and a diverse SRE toolset including Terraform, Git, harness, Jenkins CI/CD. Possesses working knowledge of Docker and Kubernetes (EKS) and is driven to apply SRE Database best practices and automation to streamline workflows and optimize client-facing services. And have knowledge and worked as SQL Server Cloud DBA,Couchbase and MySQL rds Database I worked closely with many UK and USA based clients for many issues and tasks and deliver many projects.|| MSSQL DBA, EC2 instance, MySQL db•Working on terraform code, bit bucket repository,GIT bashKnowledge of SQL Installation, backup & recovery, restoring databases. • Implementing SQL Server security & object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users. • Patch installations for standalone and cluster server. • Updating with latest services packs and security patches. • Proficiency in SQL Server backup and restore the databases. • Having knowledge of Always on Configuration & Logshipping. • Troubleshoot SQL performance issue. • Responsible for monitoring the scheduled jobs, identifying the cause of job failure and taking corrective actions for failed jobs. • Checking fragmentation and resolving fragmentation issues. • Rebuilding and reorganizing the indexes at regular intervals for better performance. • Ensuring data consistency in the database through DBCC commands. • Analyze data volume & space requirements. • Experience in working SQL Server 2012, 2014, 2016, 2017,2019.• Creating and Managing Database objects (Tables, Primary Keys, Foreign Keys, Views, Indexes, Defaults and Check constraint). • Finding DMV queries to answer questions about server-level performance. • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes or index/query changes. • Knowledge in troubleshooting & performance monitor SQL Server Database server ( Server Tuning, Disk Performance Monitoring, CPU Bottlenecks etc.) • Managing SQL Server Internals, time out issues. • Database refresh from one server to another server. •Know AWS RDS and daily proper db health checks.•EC2 Instance, S3, monitoring,db health,upgrade,patching etc

Experience

1. Site Reliability Engineer

   Deloitte

   Jul 2022 — Present · Mumbai, IN

Education

• Dr. A.P.J. Abdul Kalam Technical University

  B.tech cse, Computer Software Engineering

  2014 — 2018