Amit Anand
Noida
Summary
Data architecture expert with a strong background in enterprise solutions and cloud migrations at Deloitte. Skilled in SQL Server to PostgreSQL transitions and ETL implementations, leading modernization projects. Focused on team collaboration and data governance, delivering scalable architectures for improved operational efficiency.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Manager – Data Architecture & Cloud Platforms
Deloitte Touche Tohmatsu Limited
Noida
01.2025 - Current
- Leading Data Architecture design and governance for large-scale Skill India digital platforms, supporting national-level citizen and training data
- Defining end-to-end data architecture including OLTP systems, reporting layers, and integration architecture
- Driving legacy system modernization and upgrade initiatives, replacing outdated database designs with scalable, cloud-ready architectures
- Architecting and executing SQL Server → PostgreSQL migration for government systems to enable open-source adoption and cost optimization
- Designing migration strategy, including schema conversion, data validation, reconciliation, and low-downtime cutover planning
- Implementing Informatica-based ETL architecture for data integration across multiple source systems
- Designing source-to-target mappings, transformation rules, and data quality validation frameworks
- Leading on-prem to Azure Cloud migration (IAAS & PAAS) for legacy government applications
- Establishing data governance, security controls, and audit compliance aligned with government and Big4 standards
- Architecting High Availability & Disaster Recovery (HA/DR) solutions to meet defined RPO/RTO objectives
- Participating in Change Advisory Board (CAB) meetings for architecture review and approval of data platform changes
- Leading and mentoring DBA, ETL, and data engineering teams, providing architectural direction and technical oversight
- Coordinating with application, security, and infrastructure teams to ensure architecture alignment and performance scalability
- Program: Skill India / Government of India
Tech Led – Data Architecture & Migration
AURIOPRO SOLUTION LTD
Noida
04.2024 - 12.2024
- Translated functional and reporting requirements into database and integration designs
- Led hands-on execution of database and ETL workloads for a high-volume government system
- Designed and implemented Informatica ETL mappings and workflows for multi-source data ingestion
- Executed data migration activities including data cleansing, transformation, and reconciliation
- Supported application data flows between transactional systems and reporting layers
- Implemented database-level security controls and access segregation
- Performed legacy database version upgrades and schema refactoring
- Supported operational HA/DR setup and DR readiness activities
- Acted as single point of technical coordination between application, DBA, and infrastructure teams
- Program: MGNREGA – Government of India
Associate Team Lead – Database & Data Operations
Tech Mahindra
Noida
07.2022 - 03.2024
- Led day-to-day database operations for large enterprise applications
- Performed SQL Server performance tuning, index optimization, and query remediation
- Supported Azure Synapse Analytics performance improvements from a data processing perspective
- Executed SQL Server upgrades, patching, and version standardization
- Implemented and supported Always on Availability Groups and Log Shipping
- Planned and executed DR drills, failover testing, and recovery validation
- Supported SQL Server to PostgreSQL feasibility assessments and pilot migrations
- Built monitoring, alerting, and maintenance automation for production systems
- Managed P2/P3 incidents, root cause analysis, and preventive fixes
- Ensured SLA adherence and operational stability across environments
Senior Specialist – Database Platforms
HCL Technologies
Lucknow
06.2020 - 06.2022
- Supported enterprise-scale SQL Server and PostgreSQL databases for manufacturing and ERP systems
- Assisted in basic data architecture activities, including schema design reviews and data flow understanding
- Participated in logical and physical database design discussions with application teams
- Performed PostgreSQL administration basics: user management, backups, restores, and performance monitoring
- Supported PostgreSQL query tuning and index creation under senior guidance
- Executed SQL Server and PostgreSQL database upgrades, patching, and version alignment
- Assisted in data migration activities between environments (SQL Server ↔ PostgreSQL exposure)
- Supported capacity planning and storage optimization exercises
- Implemented monitoring, alerting, and maintenance jobs for both SQL Server and PostgreSQL
- Coordinated with global teams for production support, releases, and change activities
- Client: Emirates Global Aluminum (EGA), UAE
Assistant Manager – Application & Database Management
STJ Electronics Pvt. Ltd.
Delhi
10.2019 - 05.2020
- Managed application and database operations for multi-client environments
- Supported database architecture improvements, including schema optimization and design review
- Prepared technical documentation and RCA (Root Cause Analysis) for production issues
- Defined and enforced database standards, procedures, and operational guidelines
- Designed backup, recovery, and restoration processes aligned with business requirements
- Investigated and implemented performance optimization initiatives
- Worked closely with application teams to align database setup with application architecture
Database Administrator – Enterprise Data Platforms
EMAMI FRANKROSS LTD (EMAMI GROUP)
Kolkata
02.2017 - 10.2019
- Administered enterprise SQL Server databases supporting ERP and business applications
- Supported basic PostgreSQL environments for reporting and auxiliary systems
- Assisted in database architecture improvements, including schema optimization and redesign
- Implemented and supported High Availability & Disaster Recovery (HA/DR) solutions
- Always On Availability Groups
- Log Shipping
- Replication
- Designed and maintained backup, recovery, and restore strategies
- Performed database performance tuning, index maintenance, and statistics updates
- Supported database structure redesign initiatives for improved scalability
- Worked closely with application teams to align database design with application behavior
- Managed database deployments across Dev, QA, UAT, and Production environments
- Provided 24×7 support for high-volume OLTP systems, including RCA for production issues
Team Leader – Software & Database Operations
STJ Electronics Pvt. Ltd.
Delhi
01.2011 - 02.2017
- Led day-to-day database operations for HRMS systems in a hospital environment
- Managed SQL Server installations, upgrades, and patching
- Ensured database availability, backup integrity, and recovery readiness
- Conducted server health checks (CPU, memory, disk, job monitoring)
- Supported incident management and SLA-driven operations
- Executed database refresh and environment synchronization activities
- Coordinated with L2/L3 teams during critical P1 / P2 incidents
- Assisted in basic database design and structure improvements
- Built strong fundamentals in production support, stability, and operational discipline
- Project: HRMS Database Support
- Client: Apollo Hospital
Education
MCA - First Class
01.2012
BCA - First Class
01.2009
Skills
- Enterprise Data Architecture
- Data architecture design
- ETL implementation
- Database optimization
- Data integration
- Logical & Physical Data Modeling
- OLTP/OLAP Design
- Data Warehouse Architecture
- Informatica PowerCenter
- SSIS
- Source-to-Target Mapping
- Incremental & Full Loads
- SQL Server → PostgreSQL Migration
- On-Prem → Azure Migration
- Low-Downtime Cutover Strategy
- Azure SQL DB
- Azure Managed Instance
- Azure Synapse
- Hybrid Cloud Architecture
- Always On AG
- Failover Clustering
- Log Shipping
- Replication
- DR Drills
- Data Governance Frameworks
- Data Quality Checks
- Audit & Compliance
- Query Optimization
- Index Strategy
- Capacity & Cost Planning
- Index Design
- Autovacuum Tuning
- Performance Optimization
- PowerShell
- SQL Agent
- Automated DB Deployments
- RBAC
- Encryption
- Auditing
- Secure Data Architecture
Certification
- Microsoft Azure Fundamentals (AZ-900)
- Microsoft Azure Data Fundamentals (DP-900)
- Microsoft Certified Azure Database Administrator (DP-300)
Personal Information
- Date of Birth: 01/02/86
- Nationality: Indian
- Marital Status: Married
Hobbies and Interests
Outdoor sports
Disclaimer
I hereby declare that the information furnished above is true and correct to the best of my knowledge and belief.
Languages
- Hindi
- English
- Hindi
Core Skills
Enterprise Data Architecture, Logical & Physical Data Modeling, OLTP/OLAP Design, Data Warehouse Architecture, Informatica PowerCenter, SSIS, Source-to-Target Mapping, Incremental & Full Loads, SQL Server → PostgreSQL Migration, On-Prem → Azure Migration, Low-Downtime Cutover Strategy, Azure SQL DB, Azure Managed Instance, Azure Synapse, Hybrid Cloud Architecture, Always On AG, Failover Clustering, Log Shipping, Replication, DR Drills, Data Governance Frameworks, Data Quality Checks, Audit & Compliance, Query Optimization, Index Strategy, Capacity & Cost Planning, Index Design, Autovacuum Tuning, Performance Optimization, PowerShell, SQL Agent, Automated DB Deployments, RBAC, Encryption, Auditing, Secure Data Architecture
Languages
Hindi
Advanced (C1)
C1
English
Upper Intermediate (B2)
B2
BANGALI
Beginner (A1)
A1
Custom Section 1
I hereby declare that the information furnished above is true and correct to the best of my knowledge and belief.
Amit Anand
Timeline
Manager – Data Architecture & Cloud Platforms
Deloitte Touche Tohmatsu Limited
01.2025 - Current
Tech Led – Data Architecture & Migration
AURIOPRO SOLUTION LTD
04.2024 - 12.2024
Associate Team Lead – Database & Data Operations
Tech Mahindra
07.2022 - 03.2024
Senior Specialist – Database Platforms
HCL Technologies
06.2020 - 06.2022
Assistant Manager – Application & Database Management
STJ Electronics Pvt. Ltd.
10.2019 - 05.2020
Database Administrator – Enterprise Data Platforms
EMAMI FRANKROSS LTD (EMAMI GROUP)
02.2017 - 10.2019
Team Leader – Software & Database Operations
STJ Electronics Pvt. Ltd.
01.2011 - 02.2017