Tech Lead (DBA) at AtoS (2023-02 – Present)
Team Lead (DBA) at AtoS (2011-04 – 2023-02)
Client: Standard Chartered Bank Environment: PostgreSQL, IBM DB2, Oracle, MSSQL server
- Led Production PostgreSQL DB administration for mission-critical banking systems.
- Designed and implemented high-availability PostgreSQL clusters.
- Performed logical & physical backups, Point-in-Time Recovery.
- Conducted performance tuning (vacuum, analyze, reindex, bloat)
- Managed database migrations, upgrades, and rollouts with minimal downtime.
- Managed and supported Oracle, MSSQL Server in high-availability production environments.
- Implemented HA/DR SQL Server, log shipping, clustering.
- Automated DB backups, maintenance, monitoring using shell scripting.
- Administered DB2 production DB, reorgs, runstats, compression.
- DB2 configuration, performance tuning, and production optimization.
- Led BCP/DR planning & execution, achieving near-zero downtime.
- Database support for Application team 24x7 production banking systems.
- Database audit management and non-compliance remediation.
- Managed DBA team and functioned as SPOC for client escalation.
- Managed incident, change, RCA, and production crisis management.
- Achieved 99.9% availability and reduced database high severity incidents to zero.
- End-to-end database BCP/DR managed with minimal downtime.
DB2 DBA Lead (IT Analyst) at Tata Consultancy Services (2007-05 – 2011-04)
Clients: SBI, ICC, NSDL Environment: IBM DB2, Oracle | RedHat Linux, AIX, Windows
- Designed enterprise DB2 EDW architecture and infrastructure.
- Implemented DB2 DPF environments for large data warehouses.
- Led capacity planning, partitioning, indexing strategies.
- Data compression and large tablespace conversion for enterprise databases.
- Installed and configured DB2 & Oracle databases (HA setups)
- Executed version upgrades, fix packs, and special builds.
- Integrated IBM TSM with DB2 to implement centralized, reliable backup and recovery.
- Implemented TSA for DB2 cluster management.
- Shell scripting to automate routine DBA and maintenance tasks.
- Delivered L3 production support and mentored L1/L2 teams.
- Conducted internal technical training sessions.
DBA & System Admin at DIREM Marketing Services (2006-08 – 2007-05)
- Supported DB2 and Oracle databases.
- Linux administration, Samba domain, email systems.
- Backup, Tivoli monitoring, and system maintenance.
Data Centre Admin at ORIENT HR Consultant (2006-01 – 2006-08)
Client: Tata Internet Data Centre
- Database administration and support for IDC clients.
- Backup management, monitoring, and server administration.
System Support Engineer at TELE-VENTURES P. Ltd (2004-03 – 2006-01)
- Customer support for databases and Linux/Windows servers.
- Monitoring, backup, and incident management to ensure system availability.