Summary
Overview
Work History
Education
Skills
Certification
Intrests
Timeline
Generic
Amitabh Sarangi

Amitabh Sarangi

Bengaluru

Summary

Result-oriented software professional with 13 years in the IT industry.Specializing in database administration, migration, and performance optimization. Extensive hands-on expertise across Oracle, PostgreSQL, MariaDB, and MySQL, with deep knowledge on database internals. Always keen to learn new technologies and put them to use.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Staff Database Engineer

ServiceNow
07.2022 - Current
  • Working as a database SME within a high-impact SWAT team, resolving high-risk database issues across multiple platforms.
  • Led load simulation testing on databases to benchmark performance metrics and identify potential bottlenecks prior to PostgreSQL migration.
  • Led in-depth performance evaluations of databases and underlying infrastructure to identify and resolve bottlenecks.
  • Developed and executed a comprehensive database migration strategy, including impact analysis, downtime planning, and rollback procedures for Postgres migration.
  • Executed comprehensive performance and scalability assessments across critical systems, enhancing database throughput and resource utilization.
  • Prevent escalation and handling critical escalated issues and providing insights.
  • Performance tuning and evaluation of performance and infrastructure.



Senior Software Engineer

Oracle India Pvt. Limited
11.2019 - 06.2022
  • Working as a Database Performance Engineer with speciality on Oracle Optimizer for OLTP and Data warehouse.
  • Handling service requests for diagnosing and fixing Database level Performance tuning issues and SQL query performance issues.
  • Handling highly escalated customer issues for database performance and performing deep analysis of the issue to provide optimal solution within speculated time period.
  • Troubleshooting and tuning Exadata and Supercluster server performance.
  • Preparing Test case scenarios for customer issues for troubleshooting and raising bug if not reported yet.
  • Work with Product Management teams to help define product directions as it relates to performance and architectural improvements.
  • Providing consultation to customers for designing the database for best performance.

IT Analyst

Tata Consultancy Services (TCS)
01.2012 - 10.2019
  • Worked primarily on Oracle 11g/12c DC-DR RAC with ASM architecture, SQL server 2008/2012 versions on Sun Solaris and Windows platform.
  • Installation, Configuration and Administration of Oracle 11gR2/11gR1/10G/9i on Unix/Linux/AIX/Solaris including very large databases (Terabytes DB).
  • Performing database administration day to day activities on production servers and maintenance with outstanding troubleshooting capabilities.
  • Experience in specific DBA Activities as Patching, Schema Design, Roles and profiles, Index rebuilding, allocation of database memory parameters, statistics generation etc.
  • Setting up Standby Database/Data Guard to protect against failures. Configured the Standby Database in such a way that the database is kept synchronized with the Production Database by regularly transferring archived log files from the Production Server to the Standby Database Server.
  • Performing failover and switchover of Primary and Standby databases for checking DC- DRC integrity.

Education

Bachelor of Technology - Chemical Engineering

Biju Patnaik University of Technology
08.2011

Skills

  • Performance Tuning
  • SQL
  • Database Administration
  • Oracle
  • Postgres
  • Maria/MySQL DB
  • Decision making

Certification

Oracle Cloud Infrastructure Foundations Associate (03/2021 - Present)

Intrests

Photography, Hiking, Outdoor Sports

Timeline

Staff Database Engineer

ServiceNow
07.2022 - Current

Senior Software Engineer

Oracle India Pvt. Limited
11.2019 - 06.2022

IT Analyst

Tata Consultancy Services (TCS)
01.2012 - 10.2019

Bachelor of Technology - Chemical Engineering

Biju Patnaik University of Technology

Similar Profiles

CREATE PROFILE
Amitabh Sarangi