drjobs Senior DBA

Senior DBA

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Singapore - Singapore

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

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

Required Experience:

Senior IC

Employment Type

Full-Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.