Description :

Role : Oracle Database Administrator

Experience : 6+ years

Employment Type : contractor (3 Months)

Location : Open To all Mastek location

CTC : 24LPA

Notice : Immediate

We are seeking an experienced Oracle Database Administrator (DBA) with a strong background in database access controls, auditing, privilege management, and security process design.

The ideal candidate will help us build and document a new process to audit, monitor, and secure database access, including implementing password rotation, privilege reviews, and automated monitoring mechanisms using modern Oracle 19c capabilities.

This is a hands-on role requiring strong technical depth, the ability to interrogate and analyse database connections and privileges, and experience implementing best practices aligned with security and compliance needs.

Key Responsibilities :

1. Database Access & Security :

- Analyse, design, and implement database access controls, including user management, roles, and least-privilege models.

- Review and validate existing accounts, privileges, grants, and authentication methods.

- Implement secure mechanisms for password rotation, credential storage, and access lifecycle management.

- Monitor and report on unusual database access patterns and potential security gaps.

2. Auditing & Compliance :

- Design, implement, and document a new auditing process for Oracle databases, focusing on :

i. User activity monitoring

ii. Privilege usage tracking

iii. Access logs and anomaly detection

- Leverage Oracle 19c audit features such as :

i. Unified auditing

ii. Fine-grained auditing (FGA)

iii. Database Vault (if enabled)

- Provide audit reports to internal security, compliance, and technology leadership teams.

3. Process Documentation & Governance :

- Create detailed documentation covering :

i. Access models

ii. Audit workflows

iii. Password rotation processes

iv. Monitoring procedures and escalation paths

- Work with cross-functional teams (Security, Compliance, DevOps, Infra) to embed new processes into BAU operations.

4. Implementation & Technical Ownership :

- Implement the proposed access/audit solution depending on timelines and project priorities.

- Configure and tune audit policies for minimal performance overhead and maximum visibility.

- Work with development and operations teams to validate application-to-database connections.

- Ensure alignment with Oracle 19c best practices and modern features/technology.

Core Skills & Experience :

Technical Skills :

- 6+ years Oracle DBA experience, with strong knowledge of Oracle 19c.

Expertise in :

i. User/Role/Privilege management

ii. Unified Auditing & FGA

iii. Database Vault / Transparent Data Encryption (TDE)

iv. SQL & PL/SQL scripting

v. Oracle Enterprise Manager (OEM)

- Experience interrogating :

i. Database connections

ii. Service accounts

iii. Privilege escalations

iv. Session/session history

- Familiarity with modern security tooling or integration (SIEM, identity platforms, audit log exporters).

Security & Compliance Skills :

Experience designing or supporting :

i. Access review processes

ii. Password rotation workflows

iii. Audit trails and regulatory reporting

- Ability to work in environments requiring strong data governance and compliance.

Soft Skills :

- Strong documentation and process design capabilities.

- Ability to collaborate with cross-functional teams.

- Strong analytical and troubleshooting skills.

- Proactive approach to identifying risks and recommending improvements.

Preferred Qualifications :

- Oracle Certified Professional (OCP) 19c or 12c.

- Experience with cloud-hosted Oracle environments (OCI/Azure/AWS).

- Knowledge of identity platforms (CyberArk, Azure AD, etc.) for DB password rotation.

- Exposure to DevOps CI/CD integration for database security automation.