Oracle Database Administrator at Xpress Payment Solutions Limited

Location: Ikeja, Lagos

Job Objectives

• To ensure that the Database is maintained and monitored for effective performance, carry out on-going system maintenance to support the efficient day-day running of the organization’s current and future business.

Responsibilities

• Develop and enforce database standards, guidelines and operational policies and procedures.
• Review physical structures and migration plans.
• Review necessary storage media with System Administrator.
• Review SQL performance and Tuning.
• Reviewing application's access to the database structures
• Review, where required, the purge/archive criteria.
• Develop backs and recovery plan adhering to risks policies.
• Assist in developing purge/archive criteria and procedures for historical application data.
• Monitor and tune memory usage for Oracle databases.
• Implement, maintain, and test backup & recovery strategies.
• Create instances and databases with appropriate initialization parameters and database structures (i.e., datafiles, rollback segments, tablespaces, etc.)
• Review and monitor system and instance resources to insure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention.
• Developing & maintaining naming standards for database objects such as tablespaces, tables, indexes & views.

Qualifications

• B.Sc in Computer Science, Electrical / Computer Engineering or any other related discipline. 
• 2-3 years’ experience as a Database Administrator. 
• IT certification and database knowledge and programming language will be an added advantage.

Skills:

• Technical – Oracle 19c, SQLSERVER, Postgres, Mysql, Linux, ETL, SSIS, SSRS
• Excellent interpersonal and Problem-solving skills.
• Experience working in a Linux and windows Environment is an added advantage.