Summary
Overview
Work History
Education
Skills
Certification
Languages
Timeline
Generic
Abhijeet Mishra

Abhijeet Mishra

Oracle Database Administrator
Bhubaneswar

Summary

Accomplished Oracle Database Administrator with a proven track record at Tata Consultancy Services Ltd., enhancing database performance and automating critical processes. Expert in Oracle Database (10g, 11g, 12c, 19c), SQL optimization, and strategic problem-solving. Recognized for exceptional team management and receiving multiple accolades for dedication and innovation.

Overview

15
15
years of professional experience
1
1
Certification

Work History

Oracle Application Database Administrator

Tata Consultancy Services Ltd.
11.2013 - Current

[Project: Diligenta Transformation Project]

  • B@NC's application DBA for Oracle Database production support, issue analysis, and reporting/resolving.
  • Participation in policy migration from the legacy system to B@NCs via test environments, dress rehearsal, and production environment.
  • Involved in capacity planning activities in order to forecast future needs of resources.
  • Installed and configured Oracle Database software, components, and tools.
  • Created tablespaces, users, roles and profiles to manage database security.
  • Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
  • SQL query tuning for performance enhancement.
  • Refreshing Non-Prod databases with production database using Data-Cut routine
  • Performed backup and recovery operations using the RMAN utility and EXPDP-IMPDP.
  • Developed scripts for the automation of tasks with PL/SQL or shell scripting languages, and jobs in Jenkins.
  • Achievement: Received client appreciation by implementing the BAT database refresh in Jenkins, reducing a 4-day manual task to a 14-hour automated single-click job.

Oracle Database Administrator

Tata Consultancy Services Ltd.
12.2009 - 10.2013

[Project: Bank of Maharashtra CBS Facilities Management]

  • Installed and configured Oracle Database software, components, and tools, like Oracle 10g/11g RAC (RDBMS + CRS), and non-RAC software.
  • Creation and maintenance of databases on RAC and on non-RAC in Oracle 10g and 11g using the command line and DBCA.
  • Upgrading, patching, and migrating Oracle databases to higher versions (9i to 10g, and 10g to 11g).
  • Implemented data replication solutions like GoldenGate or DataGuard.
  • Periodic DR Drill (Physical Standby Database switchover), as well as near-site testing (Physical Standby Database failover).
  • Daily, weekly, monthly, and quarterly backup policy implementation.
  • Performed backup and recovery operations using RMAN, EXPDP, and the EXP utility.
  • Implemented various scripts using Shell scripting for automation and optimizing regular tasks.
  • Provided 24x7 on-call support for critical incidents related to databases.
  • Achievement: Received the Star-of-the-Month award for two consecutive months for exceeding dedication in issue resolution.

Education

B.Tech. -

C.V. Raman College of Engineering
Bhubaneswar

Skills

  • Tools: TOAD, PL/SQL Developer, Jenkins, PUTTY, FILEZILLA, Microsoft Office (Word, Excel, PowerPoint)
  • OS: IBM AIX, Red Hat Linux, Windows
  • Domain: Core Banking System, Insurance (Life & Pension)
  • SQLPlus Expertise
  • Shell scripting
  • Relational Database Management
  • SQL Optimization Techniques
  • Oracle Database 10g, 11g, 12c, 19c (RAC and Non-RAC)
  • Backup and recovery (RMAN, DataPump)
  • Team management
  • Training and development expertise
  • Strategic problem-solving

Certification

  • ORACLE DATABASE SQL CERTIFIED EXPERT
  • MICROSOFT CERTIFIED: AZURE DATA ENGINEERING ASSOCIATE

Languages

Odia
First Language
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Bengali
Elementary (A2)
A2

Timeline

Oracle Application Database Administrator

Tata Consultancy Services Ltd.
11.2013 - Current

Oracle Database Administrator

Tata Consultancy Services Ltd.
12.2009 - 10.2013
  • ORACLE DATABASE SQL CERTIFIED EXPERT
  • MICROSOFT CERTIFIED: AZURE DATA ENGINEERING ASSOCIATE

B.Tech. -

C.V. Raman College of Engineering
Abhijeet MishraOracle Database Administrator