Oracle Database Administrator

This position is ON-SITE Working in the office 5 days / week.

Immediate Start preferred

We are looking for an experienced Oracle DBA with 5 – 8 years of expertise to join our team.

You'll be well placed in our dynamic and friendly Development Team.

Situated in the prestigious Silver Utopia Building, Chakala,

Andheri East, Mumbai – 400099, Maharashtra

Overview of the position

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

Database Installation & Configuration:

- 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 5 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

SQL & PL/SQL development

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).

You MUST ANSWER the QUESTIONS attached and PROVIDE YOUR RESUME. Please note: Preference will be given to availability for an IMMEDIATE START (within 7 Days).

For any queries, please reach out to work@ziksu.com

---