Arijit Banik
Bangalore
Summary
Senior Database Reliability Engineer | Results-driven Database Reliability Engineer with 9 years of experience in designing, managing, and optimizing databases across on-prem and cloud environments. Expertise in PostgreSQL and Oracle administration, cloud migration, performance tuning, and architecture, ensuring high availability and scalability. Proficient in AWS services like Lambda, Glue, and CloudFormation, enabling database modernization, workflow automation, and efficient deployments. Skilled in query optimization, operational automation, and infrastructure as code (IaC) to enhance system reliability. Experienced in Prompt Engineering, leveraging AI-driven solutions for database optimization. Passionate about cloud-based database management, automation, and AI-driven analytics, driving innovation and business value. Seeking to further specialize in cloud automation, performance tuning, and AI-powered database solutions for data-driven enterprises.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Consultant
Deloitte Consulting India (Offices of the US)
Bengaluru
01.2020 - Current
- Project: CalHEERS (California State Health Insurance and Eligibility Portal) – January 2020 to present. - This is a project that caters to the population of the state of California, with options to choose health insurance from various vendors.
- Orchestrated the migration of 60+ TB-sized databases from Oracle (AWS EC2) to Aurora PostgreSQL (AWS RDS). As part of this, I used AWS SCT and DMS services for the primary migration, collaborated extensively with developers to optimize the code base, and rewrote 400+ SQLs, resulting in improved performance and a reduced response time of 40%.
- PostgreSQL database administration on AWS EC2 and RDS instances.
- SME on DB Performance Tuning.
- Developed a Proof of Concept (PoC) leveraging AWS Bedrock AI to analyze and infer insights from voice recordings, transforming the results into an interactive Amazon QuickSight dashboard.
- Designed a serverless data pipeline using AWS Lambda, Glue, and Athena, enabling seamless data extraction, processing, and visualization.
- This innovative solution automated speech-to-insight conversion, enhancing data-driven decision-making, and showcasing the potential of AI-powered analytics within cloud environments.
- Microsoft SQL Server Administration.
- Backup and replication management.
- Instance setup and configuration.
- Database patching, Windows Server patching.
- Database migration from Oracle to Aurora Postgres DB using SCT and DMS.
- Oracle 12.1.0.2 database administration on Exadata machines and AWS EC2 instances.
- MS SQL Server management using SSMS.
- Automation through Python, shell scripting, Jenkins, Glue, and Lambda.
- Offices of the U.S.
- Project: CalHEERS (California State Health Insurance and Eligibility Portal) – January 2020 to present.
Database Administrator
Tata Consultancy Services Ltd.
10.2015 - 12.2019
- Project: Ultimatix (TCS internal project) – January 2016 – December 2019.
- Ensure 100% uptime for all production databases.
- Perform regular Oracle DBA tasks, such as DBMS installations and upgrades, migrating databases, changing server configuration parameters, cross-platform migration of databases, monitoring database performance, and managing users and logins.
- Configure HP-UX/Linux servers for optimal performance.
- Install and set up the PostgreSQL database on Linux servers.
- Backup and restore the PostgreSQL database.
- Manage ETL workflows through Informatica PowerCenter.
- Implement appropriate backup and restore strategies through clone servers, RMAN.
- Maintain synchronization with the disaster recovery setup.
- Automate general tasks through shell scripting.
Education
B.Tech - Electrical Engineering
Maulana Abul Kalam Azad University of Technology
01.2015
Cleared - science major
Hem Sheela Model School, CBSE
01.2011
Skills
- Databases: PostgreSQL, Oracle, and DynamoDB
- AWS (RDS, Lambda, Glue, Athena, CloudFormation, EC2, S3, IAM, CloudWatch)
- Database performance tuning and optimization
- Cloud Migration and Modernization
- Infrastructure as Code (IaC) with AWS CloudFormation
- Query optimization and indexing
- Monitoring Tools: AWS CloudWatch, AWS Performance Insights, and Dynatrace
- High Availability and Disaster Recovery
- Database security and compliance
- Automation and scripting (SQL, Shell, Python)
- Prompt engineering and AI-driven automation
Certification
- AWS Certified Database - Specialty, 03/01/23
- AWS Certified Solutions Architect - Associate, 03/01/22
- AWS Certified Cloud Practitioner - Foundational, 03/01/21
Personal Information
- Date of Birth: 08/27/92
- Gender: Male
- Nationality: Indian
Languages
Bengali
First Language
English
Advanced (C1)
C1
Hindi
Intermediate (B1)
B1
Timeline
Senior Consultant
Deloitte Consulting India (Offices of the US)
01.2020 - Current
Database Administrator
Tata Consultancy Services Ltd.
10.2015 - 12.2019
- AWS Certified Database - Specialty, 03/01/23
- AWS Certified Solutions Architect - Associate, 03/01/22
- AWS Certified Cloud Practitioner - Foundational, 03/01/21
B.Tech - Electrical Engineering
Maulana Abul Kalam Azad University of Technology
Cleared - science major
Hem Sheela Model School, CBSE
Similar Profiles
Tanvi GupteTanvi Gupte
Consultant at Deloitte Consulting India (Offices of the US)Consultant at Deloitte Consulting India (Offices of the US)
Parul GoswamiParul Goswami
Oracle HCM Cloud Technical Analyst at Deloitte Consulting India Pvt Ltd (Offices of US)Oracle HCM Cloud Technical Analyst at Deloitte Consulting India Pvt Ltd (Offices of US)
Soumendu SarkarSoumendu Sarkar
Consultant, Operations Transformation at Deloitte Consulting (US Offices in India)Consultant, Operations Transformation at Deloitte Consulting (US Offices in India)