+2 more
Clear All Filters
Premium Ad
Verified Ad
Job Summary
What will make you successful in this role?Strategy & Planning
- Assess and develop long-term strategic goals for production databases in conjunction with data owners and department managers
- Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
Acquisitions & Deployment
- Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Specific daily tasks will include, but is not limited to
- General Oracle multi-tenant and schema administration tasks, management and maintenance.
- Application database request handling.
- Starting up and shutting down databases routines as part of the OS patching routines.
- Oracle Patching routines – N-1 requirement in line with application certification.
- Database logical and physical storage structure changes and maintenance.
- Oracle user access control and review.
- Create, deploy and review DDL and DML to manage user data and schema objects.
- Database backup and recovery process implementation and monitoring.
- Database health monitoring and reporting issues to senior DBA, as well as actively take part in preventive or corrective actions.
- Implement and review DR capability and participate in twice annual DR exercises.
- DBMS performance troubleshooting, monitoring user activity and trace application session activity.
Upskill & / or participate in Oracle DBMS component support
- Data Guard (Recovery)
- Advanced Security (Encryption)
- Database Vault (DAM)
- Multi-Tenant (PDB & CDB)
- Masking & SubSetting (Data Obfuscation)
Qualifications:
- Matric
- Degree or Diploma in the field of computer science and/or 2 years equivalent work experience
Knowledge & Experience:
- DBMS Backups
o Perform database backups (Hot/Cold Backups) using RMAN.
o Perform schema-based backups using export and import utilities.
o TDE – Wallet encryption for file encryption
- Database Security
o Implement and maintain Oracle database user roles and privileges (i.e.. c##, etc.) for adherence to the company’s data access- and data security policies
- Disaster Recovery
o Understand disaster recovery principles and take part in DR exercises
- Linux and MS OS Proficiency
o Working knowledge of the underlying Linux - and Microsoft OS to perform basic Oracle DBMS tasks.
o Sound knowledge of OS level DBMS utilities. (IMPDB, EXPDB, RMAN etc.)
- PL/SQL & SQL – DDL and DML
o 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)
o Database maintenance job creation, scheduling and monitoring.
- Management Tool Knowledge
o Sound working knowledge of Toad / SQL Developer for daily task management
o Good working knowledge of OEM Cloud Control will be advantageous
- Cloud knowledge and skills are advantageous
- Oracle specific
o Working knowledge of Oracle DBMS, Sound working knowledge of the operating system Oracle server resides on and usage of underlying infrastructure
o Knowledge of general database concepts
o Understanding up to Oracle DMBS v19C
o Working knowledge and understanding of Oracle DMBS v19C
o Working knowledge and sound understanding of all available products, services and resources in the Oracle DMBS v19C Server suite of products
o Knowledge to advise and execute on integration to the Oracle environment including ODBC, JDBC, ODBO and other Oracle supported connectors
o Knowledge of the Oracle manager to monitor database performance and troubleshooting
Knowledge and Skills
- IT Data Analysis
- Database Knowledge and Monitoring
- Data Security
- Risk Management
- Project Oversight
Personal Attributes
- Organisational savvy - Contributing through others
- Manages complexity - Contributing through others
- Plans and aligns - Contributing through others
- Optimises work processes - Contributing through others
Core Competencies
- Cultivates innovation - Contributing through others
- Customer focus - Contributing through others
- Drives results - Contributing through others
- Collaborates - Contributing through others
- Being resilient - Contributing through others
Recruit-It
Recruiter
Error!
Success!
You have successfully created your alert.
You will receive an email when a new job matching your criteria is posted.
Please check your email. It looks like you haven't verified your account yet. Here's what you're missing out on:
- Response from employers
- Being able to log in and update your profile
- Apply for more jobs
Didn't receive the link? Resend Verification Link