Responsibilities:

• Document daily checks and status update

• Develop and update all necessary DB documentation (including checklist, deployment rollout

document, operations manual and relevant changes to configuration settings) and DR setup

• Report monthly on database size and DB Uptime and Performance

• Generate ad-hoc non-standard reports for incident/problem investigations, DB capacity planning

or audit purposes

Database Management

• Create new DB creations, database network configuration, determine/adhere to guidelines for

database structures and file layout, review and enhance scripts and procedures, proper

management of transaction and redo/archive logs

• Assist in database purging and collaborate with Solutions Team to define the purging policy for

each individual system, database re-indexing and database tuning, if required

• Review daily on log irregularities and follow-up actions

• Maintain regular database maintenance schedules

• Monitor the performance to discover and detect from on-start, the possible system anomalies

which may impact business operations. This shall include system resource usage, Basic CPU

utilization, Disk I/O, Basic network I/O, memory utilization of database buffers, shared pool,

memory cache, inefficient SQL, long running queries, in-doubt transactions, temporary table

space usage, job query analysis, lock and latch analysis, alert log errors, availability of required

start-up services/components for low disk space/archive logs, blocking locks, core dump,

interfaces and batch jobs

• Monitor backups, recovery and replication for successful completion

• Data Management

• Monitor object fragmentation, invalid objects and extent of failure detection

• Perform Disaster Recovery (DR) for all the critical systems and ensure successful rebuilt of

Production or DR servers, if necessary

Incident/Problem Management

• Incident detection and confirmation of production database systems shall include timely

escalation to the Managed Helpdesk, and performing the DBA onsite services on physical

database facilities, to rectify the incidents with root cause analysis in order to ensure permanent

resolution

• Verify and validate databases backup, recovery and replication status

• Review, improve and document the database administration and operational guide on new or

revised processes and procedures regularly

• Work with customers/clients, service desk and third-party solutions vendor to resolve on the

disrupted service and rectify the database integrity for the users promptly, to minimize business

impact. This shall include applications that are undergoing upgrades.

• Assist the Operations and Project Lead on the issues related to database in daily operations or

new projects implementation

• Any other ad-hoc duties as required or assigned