- Job Requirements
- Bachelor Degree in Information Technology/Information Systems/Computer Science/Business IT or equivalent
- Good understanding of a services business in a high tech environment
- 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
- Standby Duty required for off-hours support
- Willing to relocate abroad.
- should be adept at problem-solving.
- will work well within a team of fellow software engineers in an Agile/Scrum flow
Job Responsibilities
- 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 size and DB Uptime and Performance
- Generate ad-hoc non-standard reports for incident/problem investigations, DB capacity planning or audit purposes.
- 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 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
- Assist other team on the issues related to database in daily operations or new projects implementation
Tentang Perusahaan
Software And Web Technology Solution
Karir Komunika Pratama