{"id":5678,"date":"2022-09-19T09:59:38","date_gmt":"2022-09-19T01:59:38","guid":{"rendered":"https:\/\/www.opusit.com.my\/?post_type=awsm_job_openings&p=5678"},"modified":"2022-09-19T12:24:48","modified_gmt":"2022-09-19T04:24:48","slug":"database-administrator","status":"publish","type":"awsm_job_openings","link":"https:\/\/www.opusit.com.my\/index.php\/jobs\/database-administrator\/","title":{"rendered":"Database Administrator"},"content":{"rendered":"\n

Summary of the role<\/strong><\/p>\n\n\n\n

The Database Administrator (DBA) must be a Certified Oracle Database Administrator and\/or Microsoft SQL Administrator in administration and troubleshooting, in a 24×7 enterprise setting (inclusive of manual discovery or post actions from automatic alerts).
Incumbent is expected to perform Level 1 and Level 2 database related issues and be experienced in the following areas, but not limited to the following competencies:
\u2022 Database Analysis
\u2022 Database Performance analysis, tuning and optimization
\u2022 SQL Coding
\u2022 Database Migration
\u2022 Database security features implementation
\u2022 Database backup and recovery
\u2022 Technical database documentation
\u2022 Daily health checks on the database
\u2022 Verification of database status and integrity during application upgrade or maintenance
\u2022 Database housekeeping\/optimization activities including but not limited to:
o Highlight and ensure sufficient data growth
o Create\/reallocate DB files, tables, indexes, rollback segments, (auto)extent management and other database objects
\u2022 Providing advice to Operations Manager and Customers on database related issues as well as new technology and innovations<\/p>\n\n\n\n

Responsibilities<\/strong><\/p>\n\n\n\n

Documentation
\u2022 Document daily checks and status update
\u2022 Develop and update all necessary DB documentation (including checklist, operations manual and relevant changes to configuration settings) and DR setup
\u2022 Report monthly on database size and DB Uptime and Performance
\u2022 Generate ad-hoc non-standard reports for incident\/problem investigations, DB capacity planning or audit purposes<\/p>\n\n\n\n


Database Management
\u2022 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
\u2022 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
\u2022 Review daily on log irregularities and follow-up actions
\u2022 Maintain regular database maintenance schedules
\u2022 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
\u2022 Monitor backups, recovery and replication for successful completion
\u2022 Data Management
\u2022 Monitor object fragmentation, invalid objects and extent of failure detection
\u2022 Perform Disaster Recovery (DR) for all the critical systems and ensure successful rebuilt of Production or DR servers, if necessary<\/p>\n\n\n\n


Incident\/Problem Management
\u2022 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
\u2022 Verify and validate databases backup, recovery and replication status
\u2022 Review, improve and document the database administration and operational guide on new or revised processes and procedures regularly
\u2022 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.
\u2022 Assist the Operations and Project Lead on the issues related to database in daily operations or new projects implementation
\u2022 Any other ad-hoc duties as required or assigned<\/p>\n\n\n\n

Requirements<\/strong><\/p>\n\n\n\n

\u2022 Bachelor Degree in Information Technology\/Information Systems\/Computer Science\/Business IT or equivalent
\u2022 At least 5 years of Oracle and SQL Database support administration
\u2022 Good understanding of a services business in a high tech environment from a supplier, integrator or operator\u2019s perspective
\u2022 Demonstrated leadership ability and achievement oriented
\u2022 Strong analytical and problem solving skills, combined with ability to provide quick resolution to problems
\u2022 Experience in database backup and disaster recovery implementation
\u2022 Good knowledge of Windows and UNIX operating systems
\u2022 Effective verbal and written communication skills
\u2022 Customer service oriented and an effective team player<\/p>\n","protected":false},"excerpt":{"rendered":"

Summary of the role The Database Administrator (DBA) must be a Certified Oracle Database Administrator and\/or Microsoft SQL Administrator in administration and troubleshooting, in a 24×7 enterprise setting (inclusive of manual discovery or post actions from automatic alerts).Incumbent is expected to perform Level 1 and Level 2 database related issues and be experienced in the […]<\/p>\n","protected":false},"author":25,"template":"","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":""},"_links":{"self":[{"href":"https:\/\/www.opusit.com.my\/index.php\/wp-json\/wp\/v2\/awsm_job_openings\/5678"}],"collection":[{"href":"https:\/\/www.opusit.com.my\/index.php\/wp-json\/wp\/v2\/awsm_job_openings"}],"about":[{"href":"https:\/\/www.opusit.com.my\/index.php\/wp-json\/wp\/v2\/types\/awsm_job_openings"}],"author":[{"embeddable":true,"href":"https:\/\/www.opusit.com.my\/index.php\/wp-json\/wp\/v2\/users\/25"}],"wp:attachment":[{"href":"https:\/\/www.opusit.com.my\/index.php\/wp-json\/wp\/v2\/media?parent=5678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}