Job Purpose

Database administrators job purpose is to develop, implement, and maintain a company’s databases such as oracle and microsoft sql databases.

The database admin will be tasked with implementing structured policies and procedures to ensure the integrity and security of the entire database.

Responsibilities

• Design and implement Oracle and MSSQL databases.
• Install and configure server software and related products.
• Ensure availability and performance of database systems.
• Monitor database performance and recommend improvements to increase efficiency.
• Perform database as well as application tuning to ensure performance standards.
• Conduct capacity planning to accommodate growth and changes.
• Update, enhance and modify database as required in order to meet service levels.
• Establish sound recovery procedures and policies for backup.
• Perform user management, including role and privilege assignment.
• Troubleshoot and maintain databases, including regularly checking for errors.
• Work with internal and external teams for technical support.

• This role requires 24/7 on-call standby duties upon fault reported.

• Junior Level may also be apply.
• B.C.Sc. (Software Engineering)
• Degree in Computer Science or any relevant discipline.
• Extensive experience in Oracle performance tuning including server configuration and tracing
• Experience in Oracle and Microsoft SQL databases.
• Experience with Oracle GRID Control, ASM, Recovery Manager, Import / Export and Datapump
• Experience with Linux in a multi-domain environment including basic commands, perl and shell scripting
• Knowledge of DB maintenance in High volume OLAP and OLTP systems
• Knowledge of implementing operational automation using scripts- SQL and TSQL
• Outstanding knowledge of Oracle 11g / 12c / 19c, Oracle 11G RAC, Oracle 12c RAC, Oracle 19c RAC
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL and Oracle Server (All types of replications)
• Reasonable understanding of database design,
• backup, security and disaster recovery.
• Knowledge of indexes, index management, statistics and execution plan analysis
• Good understanding of business requirements.
• Ability to communicate well and work effectively in a team setting.