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
Database Deployment
Python Scripting
Cloud Computing
Exadata DBA
Database Patching
Ansible
Data Migration
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