Astek logo

Oracle Database Administrator

Astek

4 - 7 years

Kochi

Posted:1 week ago

Job Description

Role Summary

We are seeking an experienced Oracle Database Administrator to support production database environments for enterprise digital applications.

The candidate will be responsible for database monitoring, performance optimization, incident troubleshooting, backup and recovery support, and ensuring database availability and reliability in an SLA-driven production environment.

Key Responsibilities

  • Provide L2/L3 production support for Oracle database environments.
  • Monitor database availability, performance, storage utilization, sessions and resource consumption.
  • Investigate and resolve database connectivity failures, slow queries, locking issues and performance degradation.
  • Perform SQL performance analysis, query optimization and execution plan reviews.
  • Support database backup, restoration and recovery procedures.
  • Monitor database jobs, tablespaces, alerts and database error logs.
  • Assist with database patching, maintenance and configuration changes through approved change processes.
  • Support application teams in troubleshooting database-related production incidents.
  • Coordinate with Java/backend engineers and DevOps teams during critical incidents.
  • Support database high availability, disaster recovery and failover validation.
  • Participate in root cause analysis, post-incident reviews and problem management.
  • Maintain database operational runbooks, troubleshooting documentation and recovery procedures.
  • Provide on-call support and participate in rotational shifts as required.

Required Technical Skills

  • 4-7 Years of Experience.
  • Strong hands-on experience in

    Oracle Database Administration (Oracle 19c or equivalent)

    .
  • Good knowledge of Oracle database architecture and administration.
  • Strong SQL and PL/SQL troubleshooting skills.
  • Experience with RMAN backup and recovery.
  • Knowledge of database performance tuning, AWR, ASH and execution plans.
  • Experience monitoring database sessions, locks, tablespaces and storage.
  • Familiarity with Oracle Data Guard and high-availability configurations.
  • Good Linux administration and shell scripting knowledge.
  • Understanding of database security, access management and patching.
  • Experience supporting business-critical production database environments.

Good to Have

  • Experience with Oracle RAC.
  • Familiarity with Oracle Enterprise Manager.
  • Knowledge of database migration, replication and data synchronization.
  • Experience supporting Java/Spring Boot applications.
  • Understanding of microservices-related database architecture.
  • Exposure to database automation and infrastructure monitoring.
  • Experience in telecom or high-volume transactional applications.


Skills Required

Oracle Database Performance Optimization Troubleshooting Backup and Recovery Production Support SQL Performance Analysis Query Optimization Java Backend Devops High Availability

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Java Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Java Skills

Practice Java coding challenges to boost your skills

Start Practicing Java Now
Astek logo
Astek

RecommendedJobs for You

Winjit Technologies logo

Mumbai, Navi mumbai

Winjit Technologies logo

Mumbai

Quantum Integrators logo

Nagpur

Path Infotech logo

Noida, Delhi

Anvik Technologies logo

India

Team Computers logo

Hyderabad

Profinch Solutions logo

Bengaluru

Quantum Integrators logo

Nagpur