Junior Database Administrator Job at WTS Energy

WTS Energy provides recruitment and manpower services for the global oil and gas and energy industries. We supply engineers and consultants to our clients' projects and operations, and perform employment outsourcing services such as workforce management in oil and gas regions around the world. WTS Energy operates globally with offices in 14 countries and is operational in over 50 countries.

We are recruiting to fill the position below:

Job Position: Junior Database Administrator

Job Location: Lagos

Job Objectives

• A junior database administrator works with the database administrator to design database infrastructure and monitor and troubleshoot database systems for a company or enterprise.
• In this career, your duties may include working to improve the performance and efficiency of data storage and access systems.
• Your responsibilities also involve DB maintenance and the development of database security systems.

Job Duties/ Responsibilities / Accountabilities

• General Support
• Establishing the needs of users and monitoring of user access and security
• Maintaining the database definition layer
• Perform daily system and database monitoring, verify the integrity of all server and Vantage Application resources, systems and key processes, review System and application logs.
• Analyse data to improve overall efficiency and propose business opportunities from the analytics.
• Minimise database downtime and manage parameters to provide fast query responses.
• Assist with application fault diagnosis.
• Loading data unto the system from flat files
• Conduct periodical backup operations.
• Determine, enforce and document database policies, procedures and standards.
• Perform tests and evaluations regularly to ensure data security, privacy and integrity.
• Investigate and troubleshoot issues with the Vantage Application
• Define users and enable data distribution to the right user, in appropriate format and in a timely manner.
• Minimise database downtime and manage parameters to provide fast query responses.
• Monitor database performance, implement changes and apply new patches and versions when required.
• Excellent knowledge of data backup, recovery, security, integrity, and SQL, PLSQL, MSSQL.

Key Performance Indicators / Performance Goals

• Availability of infrastructure (Infrastructure, Information systems, application)
• Duration of database and application down time
• Customer Satisfaction Level
• Average response time to resolve complaints logged.
• Problem detection time
• Backup integrity
• No of SQL Performance tuning done per quarter
• Average lead time to acknowledge and respond to help desk complaints ( ! support)
• No of successful backup restore operations done per quarter.
• Development of efficient and short queries

Requirements

• B.Sc/HND in Computer Science/ Management Information system / Computer Engineering from an accredited university.
• Minimum of two years of experience in Systems / Database Administration Minimum 1 year experience in IT roles
• Any one of these recognized professional certifications is required. Oracle Database Administration (OCA, OCP), Linux RHCSA, RHCSE, LINUX+ CompTIA, LPIC- 1: Linux Administrator.