Santanu Das

Project: Net Banking Solutions for one of the leading banks of India.

Responsibilities:

• Database restorations across multiple environments, ensuring High Availability and Data Integrity.
• Database cloning to troubleshoot issues effectively, using Blue-Green deployment strategies to implement changes with minimal downtime.
• Leveraged Aurora features such as read replicas and auto-scaling to handle changing traffic demands, improving system resilience during peak loads.
• Disaster recovery (DR) mock drills, verifying DR setup to maintain business continuity in critical scenarios.
• Aurora Serverless for dynamic scaling to meet reporting demands, optimizing resource allocation.
• Data partitioning to enhance query performance, and archived historical data, reducing active server load and improving response times.
• Optimized query performance bottlenecks through indexing and analysis, achieving faster query processing and reduced latency.
• Troubleshooting Aurora cluster connection issues, minimizing disruptions to application connectivity.
• Backup configurations and schedules, routinely conducting restoration drills to ensure backup reliability.
• Database performance monitoring using AWS Performance Insights, proactively identifying and addressing potential issues.
• Implementing AWS security best practices, to ensure a robust and compliant database environment.
• Analyzing database logs for RCA.

Projects: Media Inventory System for OTT platform on AWS, Mobile Banking Solutions for one of the leading banks of India on-premise, AI Solutions for an object-recognition application using NoSQL database, eHealth and Fitness Solutions on AWS.

Responsibilities:

• Migrated database objects from SQL Server to PostgreSQL on AWS, converting stored
  procedures and functions for compatibility.
• Analyzed query performance bottlenecks and optimized to improve database response times.
• Collaborated with the engineering team to analyze, design, develop, test, and deploy
  solutions from lower environments to production.
• Created guidelines for developers to write database scripts with minimal errors and conducted script reviews.
• Refreshed databases across multiple environments to maintain data consistency and
  support testing.
• Automated recurring tasks through stored procedures, enhancing efficiency in
  developed functionality.
• Supported management with database-related decision-making and developed production reporting capabilities.
• Designed appropriate NoSQL databases for backend storage for AI solutions.
• Configured databases in lower environments to support development progress.
• Assisted developers in crafting efficient AQL queries for backend operations.
• Performed database configuration, backup, recovery, security, upgrades, and tuning
  to ensure data integrity and system performance.
• Migrated on-premises databases to AWS Cloud, reducing infrastructure costs and increasing scalability.
• Conducted DB server class selection reviews and applied auto-scaling policies to
  optimize costs and manage workload distribution.
• Developed scripts for back-end work management.
• Built reporting capabilities for production databases using AWS Lambda and handled
  SSL certificate updates, Aurora engine upgrades, and other maintenance tasks.
• Documented all server-level activities for audit readiness and knowledge sharing.

Projects: eCommerce Solutions for B2C websites

Responsibilities:

• MySQL database design, installation, configuration, backup, recovery, security, upgrades, schema changes, tuning, and data integrity checks to maintain a stable and efficient database environment.
• Collaborated with the engineering team to implement new database designs through
  the full SDLC process, from requirement analysis to deployment.
• Manage and troubleshot MySQL databases across production, development, and testing environments, ensuring minimal downtime and smooth operations.
• Optimize database performance using MySQL configurations and implementing replication to improve data accessibility.
• Query optimization, and database tuning for performance enhancement, preventing issues through regular performance monitoring and capacity planning with MySQL Enterprise Monitor.
• Configure Transparent Data Encryption (TDE) to secure data at rest, enhancing data protection and compliance.
• Created physical backups of production databases using MySQL Enterprise Backup,
  ensuring reliable disaster recovery.
• Developed custom scripts for backend work management to streamline operations
  and enhance efficiency.
• Set up AWS EC2 and RDS with secure access configurations, ensuring cloud-based
  infrastructure compliance and accessibility.
• Documented configurations, processes, and maintenance actions for all servers and
  databases, providing a clear record for audit and reference.