Akshay Verma
SQL\Azure Support Engineer L2
Delhi,Delhi
Summary
A highly energetic, Innovative, results-oriented professional with 3+ years’ experience (including 2+ years’ experience in SQL and Azure) of visible achievements providing knowledge and experience in providing Infrastructure Support in all aspects of Azure, SQL field. My experience includes interaction with customers, as well leading small teams in implementation of various Production Activities. I have a right blend of technical and project management experience to make contributions and helping my leads in all ways I can. Having worked in multi-production environment acitvites, I am capable of handling multiple projects in parallel. Worked in providing Infrastructure assistance to many On Site clients for multiple projects.
Overview
4
4
years of professional experience
Work History
Azure\SQL DBA Support Engineer L2
Launch IT Consulting
Hyderabad, Telangna
10.2017 - Current
- Improved operations through consistent hard work and dedication.
- Responsible for having regular communication with the client for technical aspect.
- Working with Customer Team in providing Infrastructure Support.
- Working in multiple Azure Resources Deployments.
- Also Assisting in SQL Server Deployments as per Client requirements.
- To understand and analyze the business objectives / functional requirements for clients and to ensure successful on-time delivery of agreed deliverables.
- To consistently motivate, develop, and mentor team members.
- Working on maintaining 400+ Azure Virtual Servers, 30+ On premises(Physical) Servers and other Azure Resources.
- Maintaining SQL Databases, Analysis Services Cubes by Backups, Restore and making sure there is no issue wrt space.
- Creating SQL Jobs for maintaining SQL Backup\Restore\Shrink.
- Responsible for Patching for over 400+ Servers. Making Sure Servers are working properly and are up-to-date.
- Maintaining Passwords for Servers and Service accounts.
- Assisting Clients with creating PowerBI Gateways and maintaining it so that Reports Publish without any issue.
- Working as System Admin, so responsible in maintaining permission and access on Server, SQL level.
- Assisting Client in resolving SQL Job Failures and providing them best guidance in fixing the issues.
- Participated in team-building activities to enhance working relationships.
- Actively listened to customers' requests, confirming full understanding before addressing concerns.
- Proved successful working within tight deadlines and fast-paced atmosphere.
- Used critical thinking to break down problems, evaluate solutions and make decisions.
Education
B.Tech -
Maharshi Dayanand University
Intermediate - High
DAV Public School
Skills
Operating SystemsAzure DeploymentsWindows 2012\2012R2\2016\2019Databrick Clusters, Azure Synapse SQL Server, Key Vault, ADW etcSQL Server 2014\2016\2017\2019SSMS, SQL ProfilerProject Management ToolsPower BIMS-Office, Visual Studio
Deploying Gateways, Permission maintenance and Datasets Assistance
SQL Server Maintenance
Windows VMs Maintenance
Windows Servers Patching
Technical Strengths
- Deployment of Azure Resources including Virtual Machines, Azure SQL Servers, Azure Databricks, Azure Key-Vault etc.
- Installing SQL Server on Virtual Machines.
- Installing different SQL Features like SQL Database Engine, Analysis Services, Reporting Services, Integration Services as per client requirement.
- Upgrading SQL Server Versions and performing CU updates as per Client requirement.
- Deploying Azure Synapse SQL Server.
- Deploying Azure Databricks Clusters.
- Experience in working on Windows Server 2008, 2012, 2012R2, 2016 and 2019.
- Experience in working on SQL Server 2014, 2017 and 2019.
- Configuring Master Data Services.
- Maintaining User Permissions and Access on Server and SQL Level.
- Experience in Microsoft SharePoint 2019.
- Experience in migration of SQL Server from old version to new versions.
- Experience in migration of Windows Servers. (Azure to Azure Virtual Machines, On Prem Servers to Azure Virtual Servers)
Projects
Project Title
On Prem to Windows Virtual Machine 2016 Migration
Client
Sonata Software North America
Description
The objective of this project was to plan, backup, deployment, migrate and decommission.
Role
- Planning with Customer on migration activity.
- Taking Backups of DBs and Cubes and other Data.
- Creating Windows Virtual Machine with Windows 2016 OS.
- Restoring DBs and other Data on Virtual Machine.
- Migrating CNames and other important things to new Server.
- Decomissioning On Prem Server after migration Activity was completed.
Team size
4
Project Title
46 Vms Deployment in 1 week
Client
Accenture International Limited
Description
Deploying 45+ Windows 2019 Virtual Servers for Production and Reporting Purpose
Role
- Getting on Call with Customer team on Deploying activity for Windows Server 2019.
- Created solution architecture diagram and presented to Client
- Deploying 7-8 Production(Processing) Servers and 36 Reporting Servers
- Provided detailed estimation to the client.
- Configuring SQL\SSAS on Processing\Production Servers.
- Configuring SSAS on Reporting Servers.
- Configuring TCP Listener and Telemetry Agent on SSAS Servers.
- Configuring CNAMES and opening Firewall Ports for al Servers.
Team size
2
Timeline
Azure\SQL DBA Support Engineer L2
Launch IT Consulting
10.2017 - Current
B.Tech -
Maharshi Dayanand University
Intermediate - High
DAV Public School