Ambarish Dey

Experienced and results-driven as Database Administrator with 6 years of hands-on experience in managing, optimizing, and securing mission-critical PostgreSQL database, MS SQL Server & IBM DB2 databases across production, staging, and development environments. Proven expertise in high availability solutions, performance tuning, backup and recovery strategies, automation, and compliance.

Database Administrator at Accenture (2019-08 – Present)

PostgreSQL Database: Installed, configured, and managed PostgreSQL databases in production and non-production environments with expertise in backup strategies and recovery. SQL Server Database: Installed, configured, and maintained SQL Server instances across all environments. IBM DB2 Database: Installed and configured IBM DB2 environments to support various applications and workloads.

• Installed, configured, and managed PostgreSQL databases (v11 to v17) in production and non-production environments. Along with experienced in implementing robust backup strategies using WAL archiving and performing Point-In-Time Recovery (PITR) to ensure data protection and availability.
• Skilled in analyzing and tuning SQL queries using EXPLAIN ANALYZE, optimizing indexes, and implementing efficient query execution plans to enhance database performance.
• Hands-on experience configuring and managing PostgreSQL Log-Based shipping, Streaming Replication and Logical Replication to maintain highly available database clusters.
• Implemented secure access control with role-based permissions, SSL encryption, and compliance auditing.
• Troubleshot performance issues, deadlocks, replication lag, and resource bottlenecks using logs and monitoring tools.
• Automated regular maintenance tasks (vacuum, reindex, health checks) via shell scripts and crontab jobs.
• Successfully performed PostgreSQL minor patching and major version upgrades with minimal downtime.
• Installed, configured, and maintained SQL Server instances (2012 - 2019) across all environments.
• Configured and managed AlwaysOn Availability Groups, database mirroring, replication, and log shipping.
• Designed and implemented full, differential, and transaction log backups; proficient in recovery models and point-in-time restore strategies.
• Developed an automation framework using PowerShell, SQL scripts, Windows Task Scheduler, and Power BI to capture and analyze SQL Server database instance growth across multiple servers region-wise, enabling monthly trend prediction, anomaly detection, and proactive capacity planning.
• Applied CU/SPs and performed version upgrades with minimal downtime following rollback strategies and best practices.
• Managed logins, roles, permissions, enforced encryption, auditing, and data masking to meet compliance standards.
• Automated maintenance tasks using PowerShell and SQL Agent jobs.
• Installed and configured IBM DB2 environments to support various applications and workloads and performed basic troubleshooting for DB2-related issues.
• Configured & scheduled database backups and tested restore/recovery procedures. security management by creating user, granting privileges & managing authentication.
• Applied fix packs and minor version upgrades under supervision to keep environments patched and secure.

B. Tech in Computer Science & Engineering – University of Engineering & Management, Kolkata (2015 – 2019)

Higher Secondary Education in Science – Bally Jora Aswatthatala Vidyalaya (2014 – 2015)

Secondary Education in General – Bally Jora Aswatthatala Vidyalaya (2012 – 2013)