High Performance Oracle Database Administrator

This is a Database Administrator position in a dynamic and friendly environment.

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

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

The incumbent is expected to:

• Consider the objectives first when undertaking all duties.
• Communicate effectively, model integrity and respect in all interactions.
• Operate within our 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 our strategic objectives.
• Support organisational change and continuous improvement by actively contributing to achieve our vision, mission, and priorities.
• Comply with the requirements of our Code of Conduct and all relevant legislation including EEO, OSH and Records Management.

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

Qualifications:

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

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.