Posted on Singtel website on 15 Mar 2025 (about 1 month ago)
Responsibilities:
Document daily checks and status update
Develop and update all necessary DB documentation (including checklist, 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
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 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
Job Requirements:
Diploma / Degree in Information Technology, Computer Science or equivalent
7 - 10 years of experience in Oracle DBA or Microsoft SQL server
Possess hands-on technical exprience for L1 - L3 support
Singapore Telecommunications Limited, doing business as Singtel, is a Singaporean telecommunications conglomerate, the country's principal fixed-line operator and one of the four major mobile network operators operating in the country.