Oracle Dba - Ahmedabad, Gujarat, India - Online PSB Loans ltd

Online PSB Loans ltd

Verified Company

Ahmedabad, Gujarat, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

About Company:

Online PSB Loans, is a revolutionary digital credit infrastructure company that develops and integrates cutting-edge technology to automate and digitize lending for both borrowers and lenders.

The company addresses the challenges of credit distribution to MSMEs and retail borrowers. With a view to expanding its digital footprint and utilizing its infrastructure, company is diversifying into several industries segments.

Role:
DBA - Oracle

We are seeking a professional DBA with the technical skills and knowledge that extends across Application/ Server/ Storage/ Network technologies to administer a large, complex production DB environment and troubleshoot and provide system level guidance/ solutions.

This includes all databases for production, testing, and staging environments across the company.

Responsibilities:

Maintain our SQL / PLSQL processes. Ensure DB availability.
Proactively manage and maintain security standards and controls.
Actively seek to optimise and simplify our architecture.
Take ownership of performance and capacity monitoring aspects of the DB.
Execution of data migration jobs and scripts as required.
Assist the infrastructure team in sizing hardware used for the DB.
Support and collaborate with product developers.
Contribute to the creation and maintenance of disaster recovery plans.
Create a reliable backup strategy.
Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality.
Determine and document DB policies, procedures and standards.
Performance testing and evaluation to ensure data security, privacy and integrity.
Identification of bottle necks and deadlock issues. Ensure SLA's & operational KPI's are met, working as necessary with internal and external support functions when major incidents occur.

Requirement:

Oracle Ideally Oracle Certified DB Professional (OCP) with more than 5 years' experience with Oracle, preferably in a lead role.
Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, backup and recovery, managing schemas, report generation and DB clustering technologies.
Operating system experience in Linux. Oracle management tools (Data Guard, RMAN, Data pump). Partitioning. Architecture design principles.
Good problem solver focused and dedicated developer with ability to work on your own as well as with a team.
Strong practical experience of ORACLE in a production RAC (ASM) environment (11gR2).
Must be a selfstarter with a strong attention to detail.
Experience with an organisation with a key reliance on 24x7 reliability on its database.