Nanda Kumar Kuppaswamy
Senior Database Administrator
Bengaluru
Summary
Seasoned Database Specialist with a proven track record driving complex migrations, high-impact optimizations, and robust automation across diverse enterprise environments. Most recently at KONE, architected and optimized SAP Mobilink synchronization between Android field applications and SQL Server, resolving critical P2 failures and eliminating system bottlenecks. Led a major PL/SQL to PostgreSQL migration for Karnataka Bank, delivering performance-tuned stored procedures and upskilling junior DBAs. At Bradley University, directed SAP SQL Anywhere upgrades and rebuilt fragmented databases to restore peak performance and streamline OData integrations. Engineered custom recovery processes at C2AE to reclaim corrupted data, and managed large-scale SAP SQL Anywhere to SQL Server migrations for Transoft Solutions’ 100+ client instances with zero downtime. Orchestrated Microsoft SQL Server to PostgreSQL conversions at Spirion using Python and PowerShell automation, while manually optimizing critical database objects.
Equipped with deep expertise in Sybase ASE, SAP SQL Anywhere, Microsoft SQL Server, Oracle, and PostgreSQL, complemented by advanced scripting skills in PowerShell, Python, and shell. Adept at designing end-to-end solutions—from high-availability clustering and replication setups to performance tuning, backup/recovery automation, and disaster-recovery orchestration—delivering resilient, scalable, and secure database infrastructures. This adaptable summary can be tailored with specific project names, technologies, or metrics to align with targeted job opportunities.
Overview
15
15
years of professional experience
2
2
Certifications
Work History
Senior Database Administrator & T-SQL Developer
Ahana Systems and Solutions Pvt. Ltd.
03.2016 - Current
- SAP Mobilink Synchronization Optimization: Managed sync between Android KFM applications and SQL Server consolidated database
- Critical P2 Issue Resolution: Resolved thousands of sync failures affecting field technicians due to application crashes, SQL Server blocking, and DDoS attacks
- Performance Optimization: Fixed archival job blocking all Mobilink synchronization sessions
- Major Migration: PL/SQL to PostgreSQL stored procedure migration
- Performance Optimization: Optimized converted PostgreSQL procedures to match or exceed Oracle performance
- Team Training: Trained junior DBAs on PL/SQL to PostgreSQL conversion techniques
- System Upgrade: SAP SQL Anywhere 12 → 16 upgrade
- Performance Optimization: Database rebuild to reduce fragmentation; upgraded ODBC drivers resolving application slowness
- Integration Enhancement: Implemented OData connectivity to SAP SQL Anywhere
- Data Recovery: Recovered corrupted SAP SQL Anywhere database data using custom CSV parsing and loading processes
- Massive Migration: SAP SQL Anywhere to Microsoft SQL Server migration for 100+ client instances
- Automation Development: Created T-SQL scripts for reverse engineering, BCP data extraction/loading, and validation
- Seamless Execution: Migrated hundreds of clients over 2 years with zero business disruption
- Complex Migration: Microsoft SQL Server to PostgreSQL migration
- Custom Automation: Developed Python scripts for schema/data migration and PowerShell for DDL generation
- Manual Optimization: Converted stored procedures, triggers, views, and functions with comprehensive unit testing
- System Upgrade: SAP SQL Anywhere 12/16 → 17 upgrade
- HA Implementation: Set up High Availability with failover testing; resolved HA lag issues by adding missing primary keys
- Replication Setup: Implemented SQL Remote replication and CDC mechanisms
- Performance Tuning: Optimized stored procedures for enhanced performance
- 24×7 Critical Support: SAP ASE and Replication Server monitoring with advanced troubleshooting
- Performance Optimization: Resolved Signal 11 errors, job failures, and backup/recovery operations
- Monitoring Automation: Developed PowerShell scripts for SAP ASE and Replication Server monitoring with email alerting
- Enterprise Migration: Led 5-person team for 3TB SAP ASE to Microsoft SQL Server migration
- Zero-Downtime Achievement: Executed production cutover within 8-hour window with seamless business continuity
- Cost Optimization: Identified unnecessary databases, saving migration effort and costs
- System Upgrade: SAP SQL Anywhere 16 → 17 upgrade with HA implementation
- Performance Optimization: Quarterly database defragmentation reducing fragmentation and space usage
- Disaster Recovery: Led one-day ransomware recovery; implemented custom PowerShell DR solutions
- Infrastructure Improvement: Separated data/log drives preventing single points of failure
- License Migration: SAP Sybase ASE license migration to new infrastructure with cost savings
- Process Automation: Custom shell scripts for automated Sybase reorg with resume capability and error alerting
- 24×7 Monitoring: Comprehensive Sybase ASE and Replication Server health checks with detailed reporting
- Data Integration Optimization: Developed Watcom SQL scripts in SAP IQ for Input Tax Credit reconciliation
- Performance Enhancement: Optimized SAP-to-Sybase IQ data loading for faster processing
- Dramatic Performance Improvement: Rewritten Transact-SQL procedures reducing execution time from minutes to 10-30 seconds
- Infrastructure Setup: Configured new Sybase ASE environments across multiple regions
Lead administrator
Wipro Technologies
12.2015 - 03.2016
- Change Management: Handled Sybase ASE script deployments and SAP Replication Server issues
Consultant
Capgemini India Private Limited
05.2014 - 11.2015
- Infrastructure Migration: Installed SQL Server Always-On on Windows clusters
- Automation Development: Created PowerShell scripts for SQL Server refresh automation
- Certification Achievement: Earned Microsoft SQL Server 70-462 certification
- Process Optimization: Streamlined database refresh and decommission processes
Software Engineer
Mphasis an HP Company
01.2011 - 02.2014
- Foundation Skills: Junior Sybase ASE DBA with .NET and SQL Server training
- Performance Optimization: Query rewriting and optimization with data analytics teams
- Security Enhancement: Streamlined Sybase ASE security with role-based access controls
- Automation Development: Created Oracle backup automation scripts
Education
Bachelor of engineering - Information Science
Vivekananda Institute of technology
07.2010
Pre-university course - Electronics
Christ Junior College
06.2006
SSLC - undefined
R.S High School
06.2004
Skills
- Experience in database migrations
- SQL Development
- Cross-database code conversions
- Automation
- AWS Solutioning
- SAP SQL Anywhere
- SAP Mobilink middleware
- SAP SQL Remote
- Python, Powershell scripting
- Building specialized applications using artificial intelligence
Certification
Microsoft Certified Professional
Accomplishments
- AWS Certified: Solutions Architect – Associate
- Microsoft Certified: SQL Server 2012/2014 Administrator (Exam 70-462)
- Completed comprehensive training and certification in .NET and SQL Server fundamentals
- Certified in Sybase ASE database administration through internal Mphasis training programs
Timeline
Senior Database Administrator & T-SQL Developer
Ahana Systems and Solutions Pvt. Ltd.
03.2016 - Current
Lead administrator
Wipro Technologies
12.2015 - 03.2016
Consultant
Capgemini India Private Limited
05.2014 - 11.2015
Software Engineer
Mphasis an HP Company
01.2011 - 02.2014
Pre-university course - Electronics
Christ Junior College
SSLC - undefined
R.S High School
Bachelor of engineering - Information Science
Vivekananda Institute of technology