Abinash Mishra
Noida,US
Summary
Applying for a job role of Oracle DBA with 3 years' experience in Healthcare insurance and Travel & Hospitality domain. Overall, 4 years of experience in IT industry in which I have provided my services as an Application Support Analyst in Health care domain for 1 year and as an Oracle DBA for 3 years. I have worked in two companies Cognizant Technology solutions and Coforge.
Overview
5
5
years of professional experience
Work History
Oracle DBA
Coforge
06.2023 - 08.2024
- Managed and optimized Oracle Database 19c instances, ensuring the availability and performance of critical travel booking and reservation systems
- Configured and maintained Oracle RAC to provide high availability and load balancing, ensuring uninterrupted access to travel databases during peak booking periods
- Implemented and oversaw Oracle Data Guard setups for disaster recovery, ensuring real-time data protection and quick failover for travel transaction data
- Administered ASM for efficient storage management, optimizing disk space and enhancing the performance of travel-related data operations
- Conducted regular database patching and upgrades on Linux 7.4 systems, maintaining security and compliance while minimizing downtime for travel services.
Oracle DBA
Cognizant
05.2021 - 05.2023
- Managed and maintained Oracle Database 19c environments, ensuring optimal performance, security and availability for critical healthcare insurance applications
- Performed regular database patching and upgrades to keep Oracle 19c instances up-to-date, addressing security vulnerabilities, and ensuring compliance with industry standards
- Implemented and managed Oracle RAC (Real Application Clusters) for high availability and load balancing, ensuring continuous access to healthcare databases even in the event of hardware failures
- Configured and maintained Oracle Data Guard for disaster recovery, providing seamless failover and ensuring data integrity across primary and standby databases in the healthcare insurance environment
- Utilized ASM (Automatic Storage Management) to manage and optimize storage for Oracle databases, ensuring efficient space utilization and high performance for healthcare data operations
- Performed Linux 7.4 administration tasks, including system monitoring, patching, and scripting, to support the underlying infrastructure of Oracle databases and applications
- Optimized SQL queries and database objects for performance
- Provided 24/7 support for the production database, addressing incidents and resolving issues in a timely manner
- Collaborated with different teams to troubleshoot and optimize database-related issues.
Application Support Analyst
Cognizant
02.2020 - 04.2021
- Took care of multiple applications and monitored them to see if the data processing is happening properly
- Wrote and executed SQL queries to investigate and troubleshoot database-related issues, ensuring the integrity and accuracy of healthcare data across multiple environments
- Experience in administering and troubleshooting application servers and environments on Linux & Windows, performing system maintenance, manual reprocessing and applying patches to keep systems secure and up-to-date
- Configured and maintained LDAP directories to manage user access and authentication, ensuring secure and compliant access to healthcare applications
- Handled incident management and service requests using ServiceNow, following ITIL best practices to ensure timely resolution and documentation of all support activities
- Monitored and analyzed system logs and application performance using Splunk to proactively identify and resolve issues, ensuring minimal downtime for critical healthcare applications
- Provided 24/7 on-call support for healthcare insurance applications, ensuring rapid response and resolution to any critical incidents that may impact business operations.
Education
B.Tech - Electrical engineering
KIIT University
12.2019
+2 Degree - Physics, Chemistry, Math
Kendriya Vidlaya Berhampur
12.2015
Skills
- Oracle DB 19c
- Linux 74
- ASM
- Data guard
- RMAN
- Performance optimization
- Multitasking
- Experience in working with multiple applications and handling their DBs
- Worked with other teams to resolve issues
- Oracle DBA & Application support
- Good working experience and understanding of Oracle DBA and Application Support
Websites
Personal Information
Title: Oracle DBA
Languages
English
Native or Bilingual
Hind
Native or Bilingual
Odia
Native or Bilingual
Timeline
Oracle DBA
Coforge
06.2023 - 08.2024
Oracle DBA
Cognizant
05.2021 - 05.2023
Application Support Analyst
Cognizant
02.2020 - 04.2021
B.Tech - Electrical engineering
KIIT University
+2 Degree - Physics, Chemistry, Math
Kendriya Vidlaya Berhampur