Summary
Overview
Work History
Education
Skills
Certification
Interests
Personal Information
Timeline
Generic
Ayan Bhattacharjee

Ayan Bhattacharjee

SITE RELIABILITY ENGINEER
Tokyo,13

Summary

Database Engineer specializing in Oracle Database Administration | Expert in Optimizing, Automating, and Securing HighScale Systems for Unmatched Reliability and Performance. Eager to leverage expertise to drive success and innovation.

Overview

8
8
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
3
3
Languages

Work History

Database Engineer

Rakuten
01.2025 - Current
  • Developed custom scripts to automate routine tasks, resulting in significant time savings for the team, in Troubleshooting and resolution scenarios.
  • Automated deployments and configuration management using Python, Shell Scripting, Chef, Ansible, and Jenkins.
  • Managed over 5000+ Linux servers across multiple OS versions and distributions, ensuring high availability and reliability.
  • Troubleshot and resolved critical production issues, including infrastructure performance bottlenecks, reliability concerns, and application-level failures.
  • Implemented automation architectures using Ansible that were used to execute activities like Database Patching, Database Refresh with execution of one single line command from a centralized server.
  • Developed automation solutions for single-click scaling, application deployments, and data migrations from legacy systems to modern cloud infrastructure.
  • Designed and implemented hybrid cloud infrastructure, integrating on-premise and cloud-based solutions for enhanced scalability and resilience.
  • Maintained all infrastructure as code using Terraform and other automation tools, ensuring repeatability and consistency.
  • Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.
  • Reduced query execution time by analyzing and fine-tuning SQL statements in complex applications.

Infra Managed Service Sr. Analyst (Sr. Oracle DBA)

Accenture
06.2021 - 01.2025
  • Managed comprehensive database and Grid Infrastructure patching, leading the Oracle Database Patching team to ensure efficiency and minimize downtime across all environments.
  • Automated database patching and upgrades, ensuring seamless and secure database operations. • Designed and implemented an end-to-end CI/CD pipeline for automated application deployments and server provisioning. •
  • Developed Terraform code for automated infrastructure provisioning in public clouds.
  • Set up comprehensive monitoring and observability using Prometheus, Grafana, Thanos, Alertmanager, and integrated with PagerDuty and Slack for real-time alerts.
  • Led the Ansible Automation team for Oracle in ongoing project, overseeing all automation processes.
  • Automated patching processes with Ansible, reducing time complexity by 50%, and deployed solutions to enhance efficiency across multiple environments.
  • Collaborated with Oracle Engineers to address critical performance issues and severe patching challenges, ensuring optimal database performance and reliability.
  • Performed key database activities, including performance tuning, disaster recovery drills, space management at ASM and tablespace levels, and user access management.
  • Developed and optimized Oracle SQL queries and PL/SQL scripts to improve application performance.
  • Conducted server patching & resolved performance issues, contributing to database stability and uptime.
  • Implemented security measure, compliance check, to safeguard database integrity & protect sensitive data.
  • Developed an automated smoke test framework to validate application health before routing real traffic to pods.
  • Optimized infrastructure costs by implementing Kubecost, Horizontal Pod Autoscaler (HPA), and auto-scaling strategies across environments.
  • Ensured Pod Disruption Budgets (PDBs) were in place to maintain service availability during infrastructure maintenance.

System Engineer (Oracle DBA)

TATA Consultancy Services
03.2018 - 06.2021
  • Managed the Oracle Database Administration, including Linux systems and cloud environments.
  • Provided production support, overseeing installation, configuration, upgrades, and patching processes.
  • Ensured smooth backup an recovery operations, guaranteeing uptime for clients in accordance with SLAs.
  • Automated deployment scripts using Shell & Python to enhance operational efficiency and reduce errors.
  • Implemented robust database security measures, auditing protocols, and space management strategies to maintain optimal system performance and compliance.

Software Test Engineer

JustDial
01.2017 - 02.2018
  • Implemented test practices for the JdOmni Digital Business Manager project, ensuring software reliability.
  • Managed and executed test scenarios across multiple phases to ensure functionality and performance.
  • Developed & maintained 500+ test cases based on new specifications, including database-level scenarios.
  • Collaborated with developers to identify and resolve bugs, enhancing overall product quality.

Education

Master of Engineering - Software Engineering

BITS Pilani
01.2020 - 01.2022

B.Tech - Computer Science & Engineering

Manipal Institute of Technology
01.2013 - 01.2017

Skills

Shell Scripting

undefined

Certification

08/01/23, Exadata Database Machine X9M Implementation (1Z0-092)

Interests

Photography and Videography
Playing Violin

Personal Information

  • Date of Birth: 06/21/94
  • Nationality: Indian

Timeline

Database Engineer

Rakuten
01.2025 - Current

Infra Managed Service Sr. Analyst (Sr. Oracle DBA)

Accenture
06.2021 - 01.2025

Master of Engineering - Software Engineering

BITS Pilani
01.2020 - 01.2022

System Engineer (Oracle DBA)

TATA Consultancy Services
03.2018 - 06.2021

Software Test Engineer

JustDial
01.2017 - 02.2018

B.Tech - Computer Science & Engineering

Manipal Institute of Technology
01.2013 - 01.2017

Similar Profiles

CREATE PROFILE
Ayan BhattacharjeeSITE RELIABILITY ENGINEER