MANDAR GANESH IDEKAR
Thane,MH
Summary
Senior Database Administrator with over 14 years of experience managing enterprise-scale SQL Server, MySQL, PostgreSQL, and IBM DB2 environments across AWS and on-premises infrastructure. Expert in performance tuning, high availability (AlwaysOn, replication, log shipping), disaster recovery, and automation. Proficient in AWS RDS, EC2, and S3 storage integrations, version upgrades, and DevOps scripting using PowerShell, Shell, and n8n. Strong record of optimizing cloud costs, improving uptime, and standardizing DBA processes across seven AWS accounts. Experienced in multi-account AWS governance, cross-region DR planning, and lifecycle automation.
Overview
14
14
years of professional experience
1
1
Certificate
Work History
Senior SQL Developer / Database Administrator
BNED LoudCloud Systems Pvt. Ltd.
01.2022 - Current
- Core member of a 4-member DBA team managing SQL Server, MySQL, PostgreSQL, and IBM DB2 environments across seven AWS accounts (Production, Pre-Prod, DR, Dev, QA).
- Responsible for high availability, performance optimization, automation, and AWS cloud governance. Manage database backups and retention using AWS S3 with lifecycle policies for cost optimization.
- Oversee automation, replication, and monitoring across multi-terabyte datasets hosted on AWS RDS, EC2, and hybrid on-prem systems.
- Project: DATAVAIL (SQL Server – AlwaysOn High Availability & Version Upgrade Initiative)
- Led SQL Server upgrade from 2017 to 2019, including patching, compatibility testing, and schema validation.
- Migrated from Windows Failover Clustering with Database Mirroring to AlwaysOn Availability Group (AG) architecture.
- Designed and implemented a two-node Windows Server 2022 cluster with AG Listener and MSDTC.
- Automated log backup validation, cluster health checks, and PowerShell-based alerting.
- Achieved 99.99% uptime and improved DR readiness through proactive failover testing.
- Currently leading the pipeline to upgrade AlwaysOn from SQL Server 2019 to 2022, focusing on scalability and distributed AG setup.
- Project: ECS (PostgreSQL – AWS RDS, 2.5 TB, Performance Tuning Initiative)
- Managing large-scale PostgreSQL RDS (2.5 TB) for ECS application.
- Leading an initiative to reduce ~$51,000 AWS Glue job costs by optimizing RDS parameters and query performance.
- Performing workload profiling, parameter tuning, and coordination with data engineering teams.
- Ensuring improved performance, lower costs, and stability during tuning without downtime.
- Project: AIP & FDC (AWS RDS MySQL 8.0.x – Encrypted Backup, Performance & DR)
- Managed identical AWS RDS MySQL 8.0.x environments for encrypted backup and DR validation.
- Designed Docker-based OpenSSL decryption workflows for secure restoration of '.enc' backups.
- Automated checksum verification, parameter tuning, and replication checks using shell and cron jobs.
- Configured and maintained cron pipelines for backup retention and restoration validation.
- Integrated AWS S3 for backup archival and cross-account replication with lifecycle policies.
- Ensured synchronization, recoverability, and standardized backup procedures across environments.
- Project: Courseware (MySQL 5.17 on EC2 – DevOps & Migration)
- Led migration from CentOS to Amazon Linux 2023 across three EC2 servers (two-way replication + DR node).
- Managed MySQL 5.17 upgrade and DevOps tasks during provisioning and migration.
- Deployed MonYog monitoring server for real-time replication and performance tracking.
- Set up cron jobs for backups, replication monitoring, log cleanup, and health checks.
- Improved query performance by 25% and implemented automated recovery and failover workflows.
- Project: MBS (AccessDB → SQL Server Migration – OP400 Data Source, 4+ TB)
- Managing migration of 4+ TB data from OP400 AccessDB to SQL Server.
- Converted 25–26 reports (out of ~250) from Access to optimized T-SQL stored procedures.
- Enhanced report performance and integrated Power BI dashboards.
- Coordinating ongoing report conversions ensuring data integrity and schema optimization.
- Other Projects (OMS, DDP, REX)
- OMS (IBM DB2): Designed ER diagrams, schema modeling, and database structures.
- DDP: Managed replication, maintenance, and performance optimization.
- REX: Handled backup management, performance validation, and query optimization.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Created optimal technical solutions to user needs with in-depth system analysis.
Assistant Manager – Database & DevOps Operations
UFO Moviez India Ltd.
05.2011 - 01.2022
- Served as Enterprise Azure Administrator and Root AWS Account Administrator managing three AWS accounts.
- Built and deployed OpenVPN server on cloud to enable secure private connectivity across internal systems.
- Developed custom PowerShell and T-SQL scripts to implement Log Shipping in SQL Server 2005 Express Edition.
- Introduced cost-optimized DR strategy using Express Edition, still operational in production.
- Oversaw full cloud infrastructure, provisioning, IAM security, and performance optimization.
- Managed SQL Server, MySQL, and PostgreSQL across on-prem and cloud environments.
- Led Plexigo (AWS) and Zinglin (Azure) projects including RDS, EC2, and Azure SQL management.
- Supported Power BI reporting and analytics for cross-platform data integration.
Education
PGDM - E-commerce
Prin. L.N. Welingkar Institute
Mumbai, India01.2017
Bachelor of Arts - Arts
Mumbai University
Mumbai, India01.2010
Skills
- Databases: SQL Server 2017/2019/2022, MySQL 517–80, PostgreSQL, IBM DB2, Aurora, MS Access
- Cloud Platforms: AWS (RDS, EC2, S3, IAM, Glue), Multi-account management (7 accounts)
- High Availability: AlwaysOn AG, Log Shipping, Replication, Clustering
- Automation: PowerShell, Shell Scripting, Cron Jobs, n8n Workflows, Power BI Dashboards
- Backup & Storage: Docker, OpenSSL Encryption, AWS S3 Backup & Lifecycle Management
- Monitoring Tools: MonYog, Power BI, CloudWatch, SQL Agent Alerts
- Operating Systems: Windows Server 2016/2022, Amazon Linux 2023, CentOS
- ETL development
- Performance tuning
Accomplishments
- Collaborated with team of 8 in the development of Couresware.
- Used Microsoft Excel to develop inventory tracking spreadsheets.
- Optimized existing environment to improve performance by 3x.
- Automated processes to reduce workflow by 3 hours.
Certification
- Microsoft Certified: Azure Administrator Associate
- AWS Certified Solutions Architect – Associate
- Microsoft: Querying SQL Server 2012
- Cisco Certified Network Associate (CCNA)
Timeline
Senior SQL Developer / Database Administrator
BNED LoudCloud Systems Pvt. Ltd.
01.2022 - Current
Assistant Manager – Database & DevOps Operations
UFO Moviez India Ltd.
05.2011 - 01.2022
PGDM - E-commerce
Prin. L.N. Welingkar Institute
Bachelor of Arts - Arts
Mumbai University
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Sports & Achievements
- Represented State and District in Table Tennis; active player (4–5 hrs daily training).
- Club-level leather cricket player; participated in multiple tournaments.
- Completed four Full Marathons, 15–17 Half Marathons, and 5–7 10K Runs.
- Completed two triathlons including a 5 km swimming segment.
- Regular participant in corporate sports and inter-company events.
- Sports discipline and consistency reflect in professional dedication and focus.