Junior Oracle DBA

My client based in Cape Town (Northern Suburbs) is currently looking for a Junior Oracle DBA to join them on a permanent basis   IT   Tasks * Perform general Oracle database administration tasks on Oracle 19E installations for a centrally hosted Oracle solution for African countries, as well as support of in-country hosted implementations * Oracle is deployed on both Linux and Windows * This position includes both system - and application database support * Oracle PDB and schema management and maintenance * Database request handling * Starting up and shutting down databases * Database logical and physical storage structure changes and maintenance * Application user access control and reviews, including application user license monitoring * Create, deploy and review DDL and DML to manage user data and schema objects * Perform database backup and recovery, when necessary, as well as monitor implemented backup processes * Proactively monitoring the database's health, report issues to senior DBA and actively take part in preventive or corrective actions * Take part in application and DBMS troubleshooting investigations of business logic and / or performance issues by monitoring user activity and trace application session activity   Qualifications and experience * DBMS Backups * Perform database backups (Hot/Cold Backups) using RMAN * Perform schema-based backups using export and import utilities * Database Security * Implement and maintain database user roles and privileges * Monitored and manage direct database access and database privileges * Disaster Recovery * Understand disaster recovery principles and take part in DR exercises * Linux and MS OS Proficiency * Working knowledge of the underlying Linux - and Microsoft OS to perform basic Oracle DBMS tasks * Sound knowledge of OS level DBMS utilities. (IMPDB, EXPDB, RMAN, etc.) * PL/SQL – DDL and DML * DDL creation for database object manipulation using basic SQL, PL/SQL scripts SQL procedures. (All database schema objects - tables, indexes, views, database link, PL/SQL procedures and triggers) * Work with application teams to implement business logic changes using PL/SQL scripts * Create DML for business user requests and extracts * Database maintenance job creation, scheduling, and monitoring * Management Tool Knowledge * Sound working knowledge of Toad and OEM for daily task management   Competencies * Service Delivery Orientation * Service Improvement mindset * Participation in client forums * DBMS Reporting as required * Solution orientated mindset * Knowledge and basic understanding of available Oracle DBMS products and supporting services * Understanding of service management principles and processes * Client Service Orientation * Respect for self and others * Can-do Attitude * Maintain client relationships * W