Database Administrator

Database Administrator

Jobline Resources Pte Ltd
Singapore
5-8 years
Not Specified

Job Description


Responsibilities
Database Analysis
  • Database Performance analysis, tuning and optimization
  • SQL Coding
  • Database Migration
  • Database security features implementation
  • Database backup and recovery
  • Technical database documentation
  • Daily health checks on the database
  • Verification of database status and integrity during application upgrade or maintenance
  • Database housekeeping/optimization activities including but not limited to:
  • Highlight and ensure sufficient data growth
  • Create/reallocate DB files, tables, indexes, rollback segments, (auto)extent management and other database objects
  • Providing advice to Operations Manager and Customers on database related issues as well as new technology and innovations

Documentation
  • 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 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
Requirements
  • Bachelor Degree in Information Technology/Information Systems/Computer Science/Business IT or equivalent
  • At least 5 years of Oracle and SQL Database support administration
  • Good understanding of a services business in a high tech environment from a supplier, integrator or operator’s perspective
  • Demonstrated leadership ability and achievement oriented
  • Strong analytical and problem solving skills, combined with ability to provide quick resolution to problems Experience in database backup and disaster recovery implementation
  • Good knowledge of Windows and UNIX operating systems
  • Effective verbal and written communication skills
  • Customer service oriented and an effective team player

Job Details

Similar Jobs

Career Advice to Find Better