Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Certification
Languages
Websites
References
Timeline
Generic
Anjali Pandey

Anjali Pandey

Pune

Summary

With 12 years of experience in MS SQL Server Database Administration, Database Migration Expert. I am a Strategic Programs Associate Manager at Accenture, a global leader in professional services and digital transformation. I hold the MCTS and AZ-104 certifications from Microsoft, and the ITIL v3 Foundation Level certification from HCL Technologies, validating my skills and knowledge in managing and optimizing cloud-based and on-premises databases and infrastructures.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Strategic Programs Associate Manager

Accenture
Pune
07.2022 - Current
  • Managing a team of 7 to ensure task allocation, accountability, and overall efficiency.
  • Install, configure, and upgrade database software (Microsoft SQL Server ) based on system requirements
  • Tune SQL queries, indexes, and database configurations to improve performance
  • Providing optimal solutions to clients for migration of databases
  • Handled installation and configuration on PostgreSQL and MySQL Databases.
  • Experience in Database migration from On-premise to Cloud environment(IaaS and PaaS)
  • Worked on Google cloud platform, VMware Cloud and Lenovo Cloud for DB Migration.
  • Automating Security reports for clients.
  • Provided support for complex issues related to software tools, applications and databases.
  • Created and monitored performance metrics to keep databases functioning at optimal capacity.
  • Developed and implemented security initiatives to protect important company data.
  • Coordinated with IT teams on infrastructure needs for databases.
  • Participated in regular audits to maintain compliance standards.

Senior Consultant - Database Administrator

Infosys
Pune
05.2018 - 07.2022
  • Lead team of 4 for task allocation.
  • Performing core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing
  • Experience in Data Center Migration, planning, and successful execution of project
  • Worked on DB upgrades from SQL 2008\R2\2012\2014 to to SQL 2016\2017\2019 versions
  • Backup and recovery of production databases and tuning them for better performance Maintaining SQL Servers updated to its latest Version and Patches
  • Running DBCC consistency checks, and fixing data corruption in application databases
  • Monitored Disk Capacity, Processor Utilization and Memory usage for the servers Creating and managing schema objects such as Tables, Views, Indexes, SPs and Functions
  • Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes, update statistics, and run DB maintenance plans
  • Worked on High Availability and Disaster Recovery Solutions.

DBA

KPIT Technologies Ltd.
Pune
10.2017 - 05.2018
  • Performing core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and Database designing
  • Backup and recovery of production databases and tuning them for better performance
  • Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes, update statistics, and run DB maintenance plans
  • Solely handled database for Appraisal of KPIT configured High Availability on it and troubleshoot performance related issues on it.

SQL Server DBA

Optum
Noida
01.2016 - 09.2017
  • Working on 48,000 plus SQL Servers including Production, Staged, Development and Test environments
  • Handled database of 12 TB database
  • Support and set up environment with replication (configuring central publisher/ distributor, managing publication, subscription, and troubleshooting)
  • Backup and recovery of production databases and tuning them for better performance
  • Installation of Tivoli Data Protection and Tivoli Storage Manager on newly build servers and configuring backup through TDP
  • Support and set up Database mirroring on all the environment servers for reporting purposes
  • Running DBCC consistency checks, and fixing data corruption in application databases
  • Monitored Disk Capacity, Processor Utilization and Memory usage for the servers
  • Worked on High Availability SQL Server solutions, including Always ON, Log shipping, Replication, Mirroring and SQL Server clustering
  • Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes, update statistics, and run DB maintenance plans
  • Enabling SQL Trace for Deadlock analysis and profiler for analysis of long running queries.

Senior Analyst

HCL Technologies Ltd.
Noida
08.2012 - 01.2016
  • Experience in Designing and Implementing RDBMS Databases on 484 database servers using MS-SQL Server 2005, 2008, 2008 R2, 2012
  • Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing
  • Expert in designing and implementing Backup and Recovery Strategies through Tivoli Storage Manager
  • Expertise in migrating databases from MS SQL Server 2005 to 2008 and SQL Server 2008 to 2008R2/2012
  • Experience in implementing different types DR (disaster recovery) scenarios like Replication models like Snapshot, Merge and Transactional, Log Shipping and Configure Database Mirroring with Witness server to provide automatic failover in Cluster environment
  • Worked on Service Now and BMC Remedy ticketing system software's to track if any problem occurs in the environment
  • Experience in configuring transactional Replication from multiple subscribers for reporting purpose
  • Created linked servers between SQL Server 2005/2008 R2 & Oracle 9i & 10g
  • Perform the Cluster Installation and add the nodes in the respective servers in SQL Server 2005, 2008 and 2008R2
  • Perform the Failover and Failback operations in the cluster environment.

Education

Post Graduate Program - Data Science And Business Analytics

Great Learning And University of Texas
06-2025

Master of Business Administration - Information Technology -

Savitribai Phule Pune University
01.2020

Bachelor of Technology - Computer Science -

Gautam Buddha University
01.2012

Skills

  • MSSQL Database Administration Expertise
  • Performance Tuning
  • MSSQL Database Migration
  • Database Security Management
  • Backup and Recovery Procedures
  • High Availability & Disaster Recovery Planning
  • Database Monitoring and Maintenance
  • Transact-SQL (T-SQL)
  • Indexing and Query Optimization
  • Effective communication abilities
  • Cloud Database Management ( AWS, Azure, GCP, VMware and Lenovo)
  • Continuous learning mindset
  • Team Leadership Qualities
  • Problem-solving abilities
  • Team Collaboration
  • Interpersonal Communication
  • Continuous Process Improvement
  • Adaptability

Affiliations

  • Trekking
  • Travelling
  • Mentoring youth

Accomplishments

SavitribaiPhule
  • Ace Award (Managing team with humility)
  • WYGiWYG Award

Certification

  • DP 300
  • AZ-104
  • MCTS 70-462

Languages

Hindi
First Language
English
Proficient (C2)
C2
Marathi
Beginner
A1
Punjabi
Beginner
A1

Websites

References

References available upon request.

Timeline

Strategic Programs Associate Manager

Accenture
07.2022 - Current

Senior Consultant - Database Administrator

Infosys
05.2018 - 07.2022

DBA

KPIT Technologies Ltd.
10.2017 - 05.2018

SQL Server DBA

Optum
01.2016 - 09.2017

Senior Analyst

HCL Technologies Ltd.
08.2012 - 01.2016

Post Graduate Program - Data Science And Business Analytics

Great Learning And University of Texas

Master of Business Administration - Information Technology -

Savitribai Phule Pune University

Bachelor of Technology - Computer Science -

Gautam Buddha University

Similar Profiles

CREATE PROFILE
Anjali Pandey