Responsibilities:
- Database Performance analysis, fine tuning and optimization
- Database Migration, database patchesDatabase security features implementation(hardening)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 ManagementIncident detection and confirmation of production database systems shall include timelyescalation 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 resolutionVerify and validate databases backup, recovery and replication statusReview, improve and document the database administration and operational guide on new or revised processes and procedures regularly
Requirement:
- Bachelor Degree in Information Technology/Information Systems/Computer Science/Business IT or equivalent
- At least 5 years of Oracle and SQL Database support administration
- Must be subject matter expert on databases, preferably Oracle 12c,19c, Oracle RAC, MicrosoftSQL databases 2016,2017,2019,2022, Azure, AWS
- Good understanding of a services business in a high-tech environment from a supplier, integratoror operator’s perspective
- Demonstrated leadership ability and achievement oriented
- Must be able to work independently with minimal supervision.
- Strong analytical and problem-solving skills, combined with ability to provide quick resolution toproblems
- Experience in database backup and disaster recovery implementation
- Good knowledge of Windows and UNIX operating system
Shortlisted candidates will be offered 1 Year Agency contract employment.\
License No :12C6060
