Database Administrator

Design, develop, implement and maintain our core Oracle applications.

Maintain our SQL / PLSQL processes.

Ensure DB availability.

Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.

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.

Work closely with the application vendors, co-ordinate and manage the DBA activities.

Own and follow up with Vendors/Stakeholders & their DBAs when required.

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.

Install upgrades and security patches.

Alter storage structures to meet the evolving needs of the company.

Set up database user accounts.

Train users on how to access the information in the database.

Find and debug malfunctioning programs affecting the database integrity.

Create autonomous database backups.

Regularly update the database security protocols.

Desired Skills:

Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.

Technical degree preferable (B.E. / B. Tech).

Must experience with an organisation that has 24x7 reliability on its database.

Must have experience with Oracle Exadata.

Must Operating system experience in Linux.

Must hands on knowledge of Shell scripting on Linux Platform

Must hands on knowledge of Oracle management tools (Data Guard, RMAN).

Must hands on knowledge of SQL / PLSQL.

Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.

Knowledge of Partitioning.

Knowledge of architecture design principles.

Good problem solver, focused and dedicated developer with ability to work on

your own as well as with a team.

Hands on experience with DB standards and end user applications-translating

capacity requirements into infrastructure deployment technology.

Strong practical experience of ORACLE in a production environment (Ver 19c).

Must be a self-starter with a strong attention to detail.