Oracle Database Administrator

Ziksu; Mumbai; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading fintech company in Mumbai is seeking an experienced Oracle DBA to contribute significantly to the mobile payments industry. You will install, configure, and upgrade Oracle databases while ensuring database health and availability. The role requires a minimum of 4 years of hands-on experience in mission-critical environments and strong expertise in Oracle database administration. Ideal candidates will have knowledge of performance tuning, security standards, and DevOps practices.

Qualifications

• Minimum 4 years of hands-on experience as an Oracle DBA in mission-critical environments.
• Strong expertise in Oracle 12c/19c database administration.
• Knowledge of database security standards & compliance frameworks.

Responsibilities

• Install, configure, and upgrade Oracle databases in Development, QA, UAT, and Production environments.
• Proactively monitor database health and availability using OEM.
• Design and implement backup and disaster recovery solutions.

Skills

Oracle 12c/19c database administration

Performance tuning

Data Guard

RAC

Linux/Unix administration

Shell scripting

Education

Bachelor’s / master’s degree in engineering (Computer Science, Computer Engineering or related)

Tools

OEM (Oracle Enterprise Manager)

RMAN

Terraform

Ansible

Jenkins

Job description

ON-SITE: Working in the office 5 days / week.

Overview

You will make significant contributions to the mobile payments industry by bringing engineering excellence in innovating new features and functions in customer centric applications.

You will be part of a very innovative, dedicated, and high-performance team and need to match their level of excellence and thoroughness in delivering world-class banking applications.

Requirements of the position

The incumbent is expected to:

• Always consider Ziksu’s objectives first when undertaking all duties.
• Communicate effectively, model integrity and respect in all interactions.
• Operate within Ziksu’s framework, policies and procedures and ensure effective transparency and accountability in all activity.
• Collaborate with staff in other departments to achieve common goals and best practice.
• Facilitate business improvements as appropriate.
• Demonstrate analytical problem-solving skills, customer focus and alignment with Ziksu’s strategic objectives.
• Support organisational change and continuous improvement by actively contributing to achieve Ziksu’s vision, mission, and priorities.
• Comply with the requirements of Ziksu’s Code of Conduct and all relevant legislation including EEO, OSH and Records Management.

Role specific responsibilities

• Install, configure, and upgrade Oracle databases (12c/19c and later) in Development, QA, UAT, and Production environments.
• Configure RAC (Real Application Clusters), ASM (Automatic Storage Management), and clustering for high availability.
• Manage Oracle listener, network services, and connectivity.

Performance Monitoring & Optimisation

• Proactively monitor database health and availability using OEM (Oracle Enterprise Manager) and custom monitoring scripts.
• Perform advanced SQL query tuning, indexing strategies, and optimizer statistics management.
• Utilize AWR, ASH, ADDM reports for performance diagnostics and tuning.
• Optimize schema design, partitioning strategies, and storage allocation.

Backup, Recovery & High Availability

• Design and implement backup and disaster recovery solutions using RMAN, Data Guard, and RAC.
• Configure and manage standby databases (physical/logical) for DR readiness.
• Validate backup integrity and conduct regular DR drills.
• Guarantee RPO/RTO compliance and high availability SLAs.

Data Security & Compliance

• Implement data encryption (TDE, Data Redaction, Network Encryption) and access control policies.
• Enforce security standards aligned with PCI-DSS, GDPR, SOX, RBI, and other regulatory guidelines.
• Manage database auditing, logging, and compliance reporting.

Automation & Scripting

• Develop shell scripts, PL/SQL scripts, and Ansible/Terraform playbooks to automate recurring DBA tasks.
• Automate database cloning, user provisioning, backups, and monitoring tasks.
• Support integration of database operations into CI/CD pipelines (Jenkins, GitLab CI/CD).

Collaboration with Developers & DevOps Teams

• Partner with developers to optimize queries, stored procedures, and schema design for high transaction systems.
• Support database integration in microservices architectures and APIs.
• Work with DevOps teams to build infrastructure-as-code (IaC) for Oracle DB deployments.

Troubleshooting & Support

• Serve as L3 escalation point for database-related issues in production.
• Perform root cause analysis (RCA) and document incident resolutions.
• Provide 24x7 on-call support in a rotational model for critical issues.

Upgrades, Patching & Migration

• Plan and execute Oracle patching, PSU, CPU, and version upgrades with minimal downtime.
• Perform cross-platform database migrations (on-prem to OCI/AWS/Azure).
• Validate application compatibility post-upgrade.

Preferred Skills

• Exposure to NoSQL databases (MongoDB, Cassandra) or Big Data ecosystems (Hadoop, Spark).
• Prior experience in fintech, banking, or lending domain.
• Knowledge of GoldenGate or advanced replication solutions.
• Familiarity with Kubernetes and containerized database deployments.
• Certifications (Preferred)

Oracle Certified Professional (OCP) or Oracle Certified Master (OCM).

Cloud certifications (OCI, AWS, or Azure DB Specialist).

Qualifications & experience

• Bachelor’s / master’s degree in engineering (Computer Science, Computer Engineering or related)
• Minimum 4 years of hands-on experience as an Oracle DBA in mission-critical environments.
• Strong expertise in Oracle 12c/19c database administration.
• Strong knowledge of:

RAC, Data Guard, ASM, OEM, RMAN, Data Pump

Performance tuning and troubleshooting (AWR, ASH, ADDM)

Linux/Unix administration and shell scripting

• Familiarity with cloud-hosted Oracle DB solutions (OCI, AWS RDS, Azure).
• Knowledge of database security standards & compliance frameworks.
• Exposure to DevOps practices and tools (Jenkins, Ansible, Terraform, Git).