Consultant-Oracle Apps DBA

Mastek Limited; Pune District; On-site; INR 600,000 - 900,000; Full time

Job summary

Mastek Limited in Pune/Ahmedabad is seeking a Junior Oracle DBA to support UK and NA regions, focusing on Oracle databases on‑premises and OCI.

You will perform day‑to‑day DBA tasks, monitor performance, handle backups and recovery, and assist with patching and upgrades under senior guidance.

3–6 years of relevant experience and strong communication across distributed teams are required.

Qualifications

• 3–4 years hands‑on experience as a Junior Oracle DBA or similar role within 3–6 years.
• Strong Oracle Database Administration skills including user, tablespace, and schema management.
• Experience with RMAN backup, basic restore and recovery, and monitoring backup status.
• Familiarity with OCI services and architecture; knowledge of OCI Console and DB services.
• Good communication to work with distributed teams across UK and NA regions.

Responsibilities

• Perform day‑to‑day administration of Oracle databases.
• Monitor availability, performance, storage, sessions, and resource utilization.
• Manage users, access rights, and security for Oracle databases.
• Handle tablespaces, datafiles, schemas, and database objects.
• Monitor alerts, jobs, locks, sessions, and long‑running queries; basic SQL troubleshooting.
• Assist with patching, upgrades, and routine maintenance under senior guidance.
• Monitor OCI compute resources, storage, networking, and database services.
• Assist with OCI backup, restore, and DR activities; support OCI networking concepts.

Skills

Oracle DBA

Cloud knowledge

SQL troubleshooting

Performance monitoring

Backup and recovery

Communication skills

Patch management

Tools

Oracle RMAN

OCI Console

Exadata Cloud Infrastructure

OCI Monitoring

OCI VCN and Subnets

Job description

Select how often (in days) to receive an alert:

Job Title: Consultant - Oracle (Junior Oracle DBA – Oracle Cloud)Expected Work Experience: 3 to 6 YearsJob Location: Ahmedabad/Pune (Should be open to work in UK and NA timezone)

Job Summary:

Candidate must have relevant experience of 3 to 6 Years. This role is for a Junior Oracle Database Administrator supporting UK and NA regions, focusing on Oracle databases hosted on-premises and on Oracle Cloud Infrastructure (OCI). The Consultant - Oracle will perform day-to-day Oracle DBA activities, basic troubleshooting, and cloud-related administration under the guidance of senior DBAs, ensuring database availability, performance, security, and adherence to operational standards.

Key Responsibilities

Oracle Database Administration

• Perform day-to-day administration of Oracle databases.
• Monitor database availability, performance, storage, sessions, and resource utilization.
• Perform user creation, modification, and access management.
• Manage tablespaces, datafiles, schemas, database objects, and storage.
• Monitor database alerts, jobs, locks, sessions, and long-running queries.
• Perform basic SQL and database troubleshooting.
• Support database startup, shutdown, and routine maintenance activities.
• Assist with database patching and upgrade activities under senior DBA guidance.
• Monitor Oracle RMAN backup jobs and resolve basic backup failures.
• Perform basic restore and recovery activities under supervision.
• Monitor backup status and retention.
• Support database recovery and DR activities.

Basic administration and monitoring of Oracle databases hosted on Oracle Cloud Infrastructure (OCI).

• Monitor OCI compute resources, storage, networking, and database services.
• Work with OCI Console for database and infrastructure monitoring.
• Support Oracle Cloud database provisioning and configuration activities.
• Assist with OCI DB System / Exadata Cloud Infrastructure administration.
• Monitor CPU, memory, storage, and database resource utilization.
• Assist with OCI backup, restore, and DR activities.
• Basic understanding of OCI networking concepts such as VCN, subnets, security lists, NSGs, and connectivity.
• Support OCI-related incidents and service requests under senior DBA guidance.
• Basic knowledge of Oracle Data Guard is preferred.
• Basic knowledge of Oracle RAC is preferred.
• Basic understanding of OCI services and architecture.
• Knowledge of OCI Console and OCI database services.
• Basic understanding of cloud networking and security concepts.
• OCI Compute
• OCI Block Volume
• OCI Object Storage
• OCI VCN and Subnets
• OCI Load Balancer – basic understanding
• OCI IAM and policies
• OCI Monitoring and Logging
• Oracle Base Database Service / DB Systems
• Exadata Cloud Infrastructure – basic understanding
• OCI Backup and Recovery

Qualifications and Skills

• 3–4 years of hands‑on experience as a Junior Oracle DBA or similar role, within the overall band of 3 to 6 years.
• Strong foundation in Oracle Database Administration, including user management, tablespace and schema management, and performance monitoring.
• Experience with Oracle RMAN backup, basic restore and recovery, and monitoring backup status and retention.
• Basic understanding of Oracle Data Guard is preferred.
• Basic understanding of Oracle RAC is preferred.
• Basic understanding of OCI services and architecture.
• Knowledge of OCI Console and OCI database services.
• Basic understanding of cloud networking and security concepts.
• Familiarity with OCI Compute, OCI Block Volume, and OCI Object Storage.
• Basic understanding of OCI VCN and Subnets, OCI Load Balancer, OCI IAM and policies.
• Knowledge of OCI Monitoring and Logging.
• Exposure to Oracle Base Database Service / DB Systems.
• Basic understanding of Exadata Cloud Infrastructure.
• Knowledge of OCI Backup and Recovery.
• Skills in Oracle-Technical and Oracle DBA - Oracle Cloud, including patching, maintenance, cloning, and documentation.
• Good communication skills to work with distributed teams across UK and NA regions.