Database Administrator at Xpress Payment Solutions Limited

About the job

• The successful candidate for this role will 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 in both Linux and Windows environments.

Responsibilities:

Database Administration

• 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:

• BSc 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.
• Technical Skills: Oracle 19c, SQL Server, Postgres, MySQL, Linux, ETL, SSIS, SSRS
• Experience in both Linux and Windows Environment.