Aakash Jain
Bangalore
Summary
Dynamic Architect with a proven track record at Persistent Systems Limited, specializing in cloud architecture and data migration. Expert in automating processes and enhancing database performance, I thrive in Agile environments. My strong project management skills and innovative solutions have consistently improved operational efficiency and reduced technical debt.
Overview
12
12
years of professional experience
Work History
Architect
Persistent Systems Limited
BENGALURU
09.2023 - Current
- Orchestrated Google Cloud transformation initiatives for the client, establishing cloud adoption roadmaps, landing zones, and migration architectures that align with security and compliance standards.
- Managed initiatives leading to a 27% decrease in infrastructure expenses through license and storage minimization.
- Revamped team structure by implementing the T model for cross-skilling in ROC and DBRE.
- Facilitated client workload management during the new TDC formation.
- Facilitated client anti-virus migration from CrowdStrike to Sentinel, encompassing all production servers.
- Improved system reliability (99.98% uptime) through resilient cloud architecture and observability frameworks.
- Collaborated closely with senior management on long-term strategic planning initiatives related to projects in development or execution stages.
- Financial plan, project timeline, resource allocation, and planning.
Support Engineer for Azure and SQL Server
Microsoft India
12.2021 - 09.2023
- Handling all the premier contract customers of India for SQL Server issues.
- Working with SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2017, SQL Server 2019 and SQL Server 2022 and performing database administrator tasks: Installation, Configuration, Maintenance and Administration of SQL server.
- Experience in upgrading SQL server version and edition upgrades.
- Checking the server performance and providing analysis on the High CPU, Memory Pressure and High I/O issues.
- Used DBCC checks to ensure the physical consistency of the database and objects.
- Performing page level restores and working on suspect databases.
- Retrieval of maximum possible data from Corrupt SQL databases.
- Migration of data across different databases and different servers.
- Experience with SQL Server 2022 and trained as first support engineers in India for SQL Server 2022.
- Provided support and administration for Azure SQL databases, including performing regular maintenance, high availability configuration, and disaster recovery planning for cloud-based environments.
- Led and executed migration of SQL Server workloads from on-premises to Azure PAAS and Azure Virtual Machines.
- Designed and implemented automation of regular infrastructure tasks using PowerShell and Azure Automation.
- Utilized Azure Resource Manager (ARM) templates and Terraform to automate deployment and configuration of core infrastructure components.
- Monitored and optimized resource utilization within Azure using Azure Monitor, SQL Insights, and other cloud-native tooling.
- Collaborated with customer technical teams to provide guidance on cloud architecture, security, and cost management best practices.
Senior System Engineer
LTI India
06.2019 - 12.2021
- Migration of SQL On-premise environment to Azure PAAS environment.
- Basic maintenance of more than 100 servers hosting SQL Server databases.
- Managing SCRUM call to ensure the users are completing the story and working on assigned backlogs.
- Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
- Conduct T-SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
- Attend CAB (Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
- Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
- Work on Writing custom stored procedures, t-sql queries, PowerShell scripts, views, and triggers based on requirements for DB maintenance and automate tasks.
- Work on writing technical and RCA (Root Cause Analysis) documentation.
- Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
- Work on performance tuning like provide suggestions to create indexes and tune stored procedures.
- Troubleshoot recurring problems and fix them permanently.
- Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site.
Consultant
Mphasis
07.2017 - 04.2019
- Handle incidents related to SQL Server and resolve the issues with possible RCA-Incident Management.
- Design and document the recovery procedures for quick recovery in case of a server crash - Availability Management.
- Working for automation of CAU using PowerShell scripting and TSQL.
- Implement planned changes to SQL Servers as per client business requirement-Change Management.
- Sending daily backup reports for all the databases.
- Giving triages on every Friday to the freshers on the topic related to SQL server basics.
- Giving knowledge training of the process to the freshers.
- Working on critical issues and coordinating with multiple team to resolve the issue.
Consultant
Capgemini
Mumbai
11.2016 - 07.2017
- Handle incidents related to SQL Server and resolve the issues-Incident Management.
- Design and document the recovery procedures for quick recovery in case of a server crash - Availability Management.
- Implement planned changes to SQL Servers as per client business requirement-Change Management.
- Implement performance tuning process for the clients.
- Implement new projects for the clients such as Migrations or SQL technologies.
- Disk space management - Incident Management.
- Participate in Change Advisory Board(CAB) meeting - Change Management.
- Participate in conference calls with client for various discussions.
- Ensure that the team follows the processes & distribute the workload among the team evenly by DSTUM.
Technical Consultant
Wipro BPS
01.2015 - 11.2016
- Managed installation, configuration, maintenance, and administration of SQL Server 2005 to 2016.
- Executed version and edition upgrades for SQL Server environments.
- Created SQL Agent jobs, alerts, and configured SQL Mail Agent for automated processes.
- Performed integrity checks to ensure database reliability and performance.
- Troubleshot SQL issues utilizing execution plans, trace logs, and analysis tools.
- Applied patches and service packs to maintain current database patch levels.
- Developed maintenance plans for index defragmentation, re-indexing, and updating statistics.
- Scheduled full and transaction log backups in production using Database Maintenance Plan wizard.
Technical Consultant
Wipro BPS
01.2014 - 01.2015
- Providing Technical Paid Support for SharePoint to Microsoft clients.
- Troubleshooting configuration/deployment/customization issues for SharePoint 2010 /Office 365.
- Troubleshoot and Support issues related to configuration, administration and maintenance of SharePoint farms.
- Better understanding of SharePoint designer workflow and out of box workflow.
- Profiles, my site, configure enterprise search.
- Troubleshoot various issues like user permission on SharePoint sites, alerts not working and issues with implementing new solutions in development environment as proof of concept before deploying it into production environment.
- Worked on Backup/restore of SharePoint sites, Migration of SharePoint sites from one domain to another.
- Custom App deployment to SharePoint 2013.
- Basic customization of Master pages through SharePoint designer and troubleshooting issues.
- Branding of the websites and adding banner on the WebPages.
Education
Bachelor of Engineering - Electronic And Communication
Rajiv Gandhi Proudyogiki Vishwavidyalaya
Indore07-2013
Skills
- Database management
- Cloud architecture
- Data migration
- Performance tuning
- Automation scripting
- Agile methodologies
- Cost estimation
- Project management
- Cloud automation
- Change data capture
- Azure management
- PagerDuty management
Designation
Architect
Residence
Bangalore, Karnataka
Personal Information
- Date of Birth: 08/17/91
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Disclaimer
I hereby declare that the information provided by me is true to the best of my knowledge and belief.
Passport
R3599641
Competences
C++, MS SQL, Azure SQL, Windows 2008, Windows 2008R2, Windows 2012, Windows 2016, Windows 2019 Server, Windows NT Server, RDBMS, OOPS
Timeline
Architect
Persistent Systems Limited
09.2023 - Current
Support Engineer for Azure and SQL Server
Microsoft India
12.2021 - 09.2023
Senior System Engineer
LTI India
06.2019 - 12.2021
Consultant
Mphasis
07.2017 - 04.2019
Consultant
Capgemini
11.2016 - 07.2017
Technical Consultant
Wipro BPS
01.2015 - 11.2016
Technical Consultant
Wipro BPS
01.2014 - 01.2015
Bachelor of Engineering - Electronic And Communication
Rajiv Gandhi Proudyogiki Vishwavidyalaya