Amanpreet Walia profile photo 1 on Tal

Amanpreet Walia

Technical Manager | Azure Data | Ex-SQL DBA | AI-driven optimization

Gurgaon

10+ years of work experience

Accenture
Dec 20214 yrs 6 mosPresent

India

Accenture
Jun 20192 yrs 6 mosNov 2021

Gurgaon, India

• Implementing and Maintaining Replication /Log Shipping | Database| Clustering | Always On HADR • Experience in upgrading SQL Server from version 2008 to 2016 · Suggested Disk Capacity, Processors, and Memory based on the Capacity planning. Involved in installation and configuration of SQL Server 2008/2016 on all the client servers. • Responsible for design resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning, planning, and implementing failover between database instances. • Experience in Database backup and restoration, resolving the deadlock and blocking issues. Handling the Maintenance tasks like policy checked, indexes or capacity planning for couple of data centers · • Working on Cloud platform (LaaS and PaaS(aws and azure)) • Handling the team of 12 people along with that rich experience for bridge calls and presentations. • Strong communication skill which help to interact with clients and application teams. • Planning and executing new technology implementation projects for streamlining related activities as per required quality standards • Maintaining strong working relationships with internal & external stakeholders, technology partners, service providers, business units & peer organization • Managing overall service operations, driving business transformations, coordinating R&D functions and providing quality training to project teams to upgrade their skills levels
Accenture
Jan 20163 yrs 5 mosMay 2019

Gurgaon, India

• Implementing and Maintaining Replication /Log Shipping | Database| Clustering | Always On HADR • Experience in upgrading SQL Server from version 2008 to 2014 · Suggested Disk Capacity, Processors, and Memory based on the Capacity planning. • Involved in installation and configuration of SQL Server 2008/2012 on all the client servers. • Creation of Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types, and functions. • Responsible for General Database Administration and Performance tuning. • Experience in Database backup and restoration, resolving the deadlock and blocking issues. • Handling the index Maintenance task for couple of data centers · • 5 x 24 Production support for the database and application issues. • Expert in technical problem-solving skills. • Executed Change management scripts/ deployment on weekly basis. • Created online automated reports to fetch the server information with the help of SSRS. · • Helping application team to deploy the SSIS packages. • Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.

Education

Master of Science (MSc), Computer Science

Guru Nanak Dev University

20042 yrs2006

Join Amanpreet and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Amanpreet Walia on Tal

Headline

Technical Manager | Azure Data | Ex-SQL DBA | AI-driven optimization

About

With over 15 years of experience in cloud and data technologies, I am an Technical Manager at Accenture, where I provide end-to-end solutions for various clients across industries. I am a certified Azure Data Engineer and have expertise in setting up database infrastructure on AWS and Azure platforms, as well as migrating data across different systems. As a Technical/delivery manager, architect, and consultant, I have successfully delivered multiple projects, working closely with business and technical stakeholders, service providers, and peer organizations. I leverage ITIL standards and agile methodologies to ensure quality, efficiency, and customer satisfaction. I also have strong people management skills, leading a global team of over 70 system engineers and providing executive coaching and training. My goal is to use my knowledge and skills to solve complex business problems and create innovative solutions using cloud and data technologies.

Location

Gurgaon

Work experience

Technical Delivery Manager at Accenture, Dec 2021 - Present · 4 yrs 6 mos, India

Technical Specialist at Accenture, Jun 2019 - Nov 2021 · 2 yrs 6 mos, Gurgaon, India, • Implementing and Maintaining Replication /Log Shipping | Database| Clustering | Always On HADR • Experience in upgrading SQL Server from version 2008 to 2016 · Suggested Disk Capacity, Processors, and Memory based on the Capacity planning. Involved in installation and configuration of SQL Server 2008/2016 on all the client servers. • Responsible for design resource management, security, backup and recovery, performance monitoring and tuning, data management and capacity planning, planning, and implementing failover between database instances. • Experience in Database backup and restoration, resolving the deadlock and blocking issues. Handling the Maintenance tasks like policy checked, indexes or capacity planning for couple of data centers · • Working on Cloud platform (LaaS and PaaS(aws and azure)) • Handling the team of 12 people along with that rich experience for bridge calls and presentations. • Strong communication skill which help to interact with clients and application teams. • Planning and executing new technology implementation projects for streamlining related activities as per required quality standards • Maintaining strong working relationships with internal & external stakeholders, technology partners, service providers, business units & peer organization • Managing overall service operations, driving business transformations, coordinating R&D functions and providing quality training to project teams to upgrade their skills levels

Senior IT Analyst at Accenture, Jan 2016 - May 2019 · 3 yrs 5 mos, Gurgaon, India, • Implementing and Maintaining Replication /Log Shipping | Database| Clustering | Always On HADR • Experience in upgrading SQL Server from version 2008 to 2014 · Suggested Disk Capacity, Processors, and Memory based on the Capacity planning. • Involved in installation and configuration of SQL Server 2008/2012 on all the client servers. • Creation of Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types, and functions. • Responsible for General Database Administration and Performance tuning. • Experience in Database backup and restoration, resolving the deadlock and blocking issues. • Handling the index Maintenance task for couple of data centers · • 5 x 24 Production support for the database and application issues. • Expert in technical problem-solving skills. • Executed Change management scripts/ deployment on weekly basis. • Created online automated reports to fetch the server information with the help of SSRS. · • Helping application team to deploy the SSIS packages. • Proposed technical feasibility solutions for new functional designs and suggested options for performance improvement of technical objects.

Education

Master of Science (MSc), Computer Science, Guru Nanak Dev University