MADHUCHANDA BANERJEE
Kolkata
Summary
Skilled Database Administrator with extensive experience in SQL Server performance monitoring, disaster recovery planning, and database migration. Proven ability to optimize database performance and implement effective recovery strategies.
Results-driven Database Team Lead with a strong focus on cross-team collaboration and technical documentation. Adept in administering 300+ SQL instances and enhancing database performance through strategic tuning and monitoring.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Database Administrator/Database Team Lead
Southern California Edison
09.2014 - Current
- Administered Sybase instances ranging from ASE version 12.0 to 12.5
- Administering 300+ SQL instances ranging from version 2005 to 2022.
- SQL server upgradation/migration
- SQL Disaster Recovery setup
- SQL installation and always on configuration
- SQL Server Reporting Service installation, configuration and migration
- Database backup and refresh
- SQL Server Monitoring/Alert setup/SQL Health check up/Database Mail Configuration
- Database Encryption
- SQL performance tunning
- Migration from Sybase to SQL Server, Sybase to Oracle, SQL on-premise to Azure PaaS migration etc.
- Managed database performance tuning and optimization for critical systems.
- Implemented backup and recovery plans to ensure data integrity and availability.
- Developed and maintained documentation for database configurations and procedures.
- Assisted in upgrading database systems to improve functionality and efficiency.
- Resolved customer queries related to database issues promptly and accurately.
- Coordinated with other teams such as network administrators and system admins for resolving complex issues.
- Created and monitored performance metrics to keep databases functioning at optimal capacity.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- PostgreSQL Access provisioning
- Azure PaaS access provisioning
- Trained junior staff on best practices for database management and maintenance.
- Migrated existing databases from one platform to another with minimal downtime.
Senior SQL Server Database Administrator
Tata Consultancy Services Ltd.
Kolkata
- Current
Technical Expert
Department of Post
07.2013 - 06.2014
- Installation of Syabse ASE 15.7 Cluster Edition ESD#1 in Linux 6.3 system (64 bit)
- Installation of SQL Anywhere in Windows and Linux system
- Sybase ASE & SQL Anywhere Database dump and transaction log management
- SQL Anywhere Database Mirroring
- Configuration of Backup server for Sybase ASE in linux system
- Configuration of Job Scheduler for Sybase ASE in linux system
- Configuration of Mobilink Synchronization with Consolidated (Sybase ASE) and Remote (SQL Anywhere) database with FIPS Encryption.
- Create License keys and Create Certificate.
- Creating linux service to start at boot time in linux system / Taking ASE database dump using linux cron job
- Mobilink Server setup and DSN creation in linux system
- Mobilink File Transfer utility
- Department of Post is basically a modernization of Post Office. The Point of Sales solution has been designated to enable Post Offices to perform all sales operations seamlessly. The solution will operate in online and offline mode and provide all designed services as ear marked for the respective mode. This will integrate with other applications like external and internal Portal to provide all required information in single place. The banking and financials are also integrated through options within the solution. The solution supports multilingual capability.
Developer
Bank of America
06.2010 - 07.2012
- Backend code development using Sybase
- Bank of America project was basically a Banking and Financial Domain project. It was basically a Development and Maintenance project.
- Technical Skills: Sybase Database, HTML, UNIX and JAVASCRIPT.
Developer
Johnson & Johnson
02.2009 - 06.2010
- Frontend Portal Development using JavaScript, HTML
- Johnson & Johnson project was basically a Healthcare domain project. It was basically a Development and Maintenance project.
- Technical Skills: JavaScript, HTML.
Education
Bachelor’s in technology - Computer Science
West Bengal University of Technology
Skills
- Microsoft SQL Server
- Database migration
- Disaster recovery planning
- Database encryption
- Performance monitoring
- Technical documentation
- User access management
- Cross-team collaboration
- Problem resolution
- Customer support
- Process optimization
- Employee training
- Time management
- Critical thinking
- Presentations
- Database locking
- Disaster recovery
- Data security
- Process automation
- Running backups
- Database troubleshooting
- Root-cause analysis
- Patch management
- Backup and recovery
- Capacity planning
- Database monitoring
- Query optimization
- Cross-platform skills
Certification
- Microsoft Certified: Azure Database Administrator Associate, 05/01/23
- Microsoft Certified: Azure AI Engineer Associate, 05/01/25
Disclaimer
I hereby declare that the statements made herein are true, complete and correct to the best of my knowledge and belief.
Projects
Southern California Edison, 09/01/14 - Current, Database Administrator/Database Team Lead, Administering 7 Sybase instances ranging from ASE version 12.0 to 12.5, Administering 800+ SQL instances ranging from version 2005 to 2022., SQL server upgradation/migration, SQL Patching/cumulative update/SQL service account password renewal, SQL Disaster Recovery setup, SQL installation and configuration, Access provisioning/BAU activities, SQL/Sybase Database in SCE stores the data generated from front end applications of Southern California Edison. Department of Post, 07/01/13 - 06/30/14, Technical Expert, Installation of Sybase ASE 15.7 Cluster Edition ESD#1 in Linux 6.3 system (64 bit), Installation of SQL Anywhere in Windows and Linux system, Sybase ASE & SQL Anywhere Database dump and transaction log management, SQL Anywhere Database Mirroring, Configuration of Backup server for Sybase ASE in linux system, Configuration of Job Scheduler for Sybase ASE in linux system, Configuration of Mobilink Synchronization with Consolidated and Remote database., Department of Post is basically a modernization of Post Office. Bank of America, 06/01/10 - 07/13/12, Developer, Backend code development using Sybase, Bank of America project was basically a Banking and Financial Domain project. Johnson & Johnson, 02/01/09 - 06/01/10, Developer, Frontend Portal Development using JavaScript, HTML, Johnson & Johnson project was basically a Healthcare domain project.
Personal Information
Passport Number: S1127715
Languages
English
Advanced
C1
Hindi
Upper Intermediate
B2
Bengali
Proficient
C2
Timeline
Database Administrator/Database Team Lead
Southern California Edison
09.2014 - Current
Technical Expert
Department of Post
07.2013 - 06.2014
Developer
Bank of America
06.2010 - 07.2012
Developer
Johnson & Johnson
02.2009 - 06.2010
Senior SQL Server Database Administrator
Tata Consultancy Services Ltd.
- Current
Bachelor’s in technology - Computer Science
West Bengal University of Technology