Job Description

Database server configuration standards;

Disk partitioning (volume ID, size and purpose) and file directory structures;

Server hardware configuration standards;

Storage system configuration standards;

Perform logical/physical database design/creation, changes or removal of database,
provide technical consultancy/advice on the usage of database software, advice
application developers on optimization of database access codes etc.

Improve and enforce database standards and procedures to achieve optimum
database performance.

Monitor and analyze the disk storage usage of all production databases including
database objects etc. closely and alert users promptly of potential application failure
due to data outgrowing the allocated space etc. to pre-empt problems

Generate monthly reports to inform all application developers about the database
utilization of each application, for necessary actions to be taken by the latter as and
when necessary.

Perform weekly diagnosis on the databases to ensure data integrity and proper
functioning of the databases.

Perform data patching whenever required to correct any data corruption errors.

Perform all necessary database maintenance tasks for all database related systems
and applications based on industry best practices, on a quarterly basis.

Maintenance of clustered System should be done after office hours and weekend
whenever possible;

Maintenance should be done one server after another within a cluster, in order not to
impact the on-going operations, with the server to be maintained detached from the
cluster during maintenance and reattached to the cluster after the maintenance;

If the clustering service fails to trigger off the fail-over process, the fail-over process
should be triggered off manually by shutting down the failed server, disconnecting it
from the LAN or private network shared between the clustered servers, whichever way
is appropriate;

Backup strategy

Backup tape inventory and movements;

Batch jobs and scripts

Troubleshooting of clustered servers should be done off-line with the failed server
detached from the cluster or after office hour and weekend, to minimize the impact on
on-going operations;

After the fault has been rectified, the failed server shall re-join (fail-back) the cluster
after office hour, as a scheduled task, to minimize the impact on on-going operations.
Perform validation of the cluster resources to ensure the health of the cluster.

Perform data migration for application owners from development/staging servers to
production servers within three (3) working days upon user request.

Run batch jobs based on a predefined schedule and user specifications.

Monitor and ensure the successful completion of all batch jobs. If the batch jobs fail,
inform the affected users immediately and take corrective actions to complete the
jobs.

Data Backup and Archiving for all System used in the Employer’s operating
environment and test it to ensure data recoverability.

Perform quarterly data recoverability tests to ensure the recoverability of all data
stored on the backup media. The Employer may specify which system/servers to be
included in Data recovery test. The Contractor shall document all procedures and test
results, and present in monthly report

Daily data backup & recovery and on-site & off-site backup media management
services for the Employer at the Data Centre.

Job Requirements

Candidate must posses at least Diploma/Advanced/Higher/Graduate Diploma, Bachelor's Degree/Post Graduate Diploma/Professional Degree in Engineering(Computer/Telecommunication), Computer Science/Information Technology or equivalent.
At least 2 years of relevant working experience.
Preferably Senior Executive specialized in IT/Computer - data backup or equivalent.

Job Type: Permanent

Pay: $3,800.00 - $5,300.00 per month

Benefits:

Health insurance

Schedule:

Monday to Friday

Experience:

Database administration: 2 years (Required)

Work Location: In person

Office Productivity Solution Sdn Bhd