Highly Skilled Oracle DBA Wanted

This position requires a highly skilled Oracle DBA to work in our on-site office 5 days a week.

We are looking for an experienced professional with 5-8 years of expertise to join our dynamic team.

You'll be well placed in our development team and 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.

• The incumbent is expected to always consider our objectives first when undertaking all duties.
• To communicate effectively, model integrity and respect in all interactions.
• To operate within our framework, policies and procedures and ensure effective transparency and accountability in all activity.
• To collaborate with staff in other departments to achieve common goals and best practice.
• To facilitate business improvements as appropriate.
• To demonstrate analytical problem-solving skills, customer focus and alignment with our strategic objectives.
• To support organisational change and continuous improvement by actively contributing to achieve our vision, mission, and priorities.
• To comply with the requirements of our Code of Conduct and all relevant legislation including EEO, OSH and Records Management.

Database Installation & Configuration:

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

Performance Monitoring & Optimisation:

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

Backup, Recovery & High Availability

• To design and implement backup and disaster recovery solutions using RMAN, Data Guard, and RAC.
• To configure and manage standby databases (physical/logical) for DR readiness.
• To validate backup integrity and conduct regular DR drills.
• To guarantee RPO/RTO compliance and high availability SLAs.

Data Security & Compliance

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

Automation & Scripting

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

Collaboration with Developers & DevOps Teams

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

Troubleshooting & Support

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

Upgrades, Patching & Migration

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

Requirements:

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

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