Connecting...

Senior Database Administrator

Job Title: Senior Database Administrator
Contract Type: Permanent
Location: Kuala Lumpur
Industry:
Salary: RM Attractive
Reference: A000000 (ACUQ-046870)
Contact Name: Arvinth Gunasegaran
Contact Email: arvinth.gunasegaran@ellwoodconsulting.com.my
Job Published: October 22, 2019 09:28

Job Description

About our client

Our client is the leading global provider of software solutions for the insurance industry, with a strong presence in Europe, Asia and Australia.

 

About the role

Our prestigious client is looking for a senior database administrator to join their vibrant team in Kuala Lumpur. The winning candidate will be required to manage and maintain the company’s as well as hosted clients’ multiple database environments including back-up, data integrity and security, performance tuning, capacity planning, monitoring critical events and documentation.

 

Your responsibilities

  • A minimum of 10 years’ experience in a DBA role, either IT Vendor or Customer (Financial Institution preferred) side would be good
  • Create and manage multiple databases and assist in capacity planning
  • Monitor maintain database systems and troubleshoot problems that may arise
  • Maintain data integrity and security (manage roles and permissions of database users)
  • Use tools like SQL Profiler for database tuning
  • Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
  • Develop strategies and implement solutions for managing back-ups, restoration and replication
  • Create and manage constraints and indexes
  • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures
  • Proactive housekeeping/archiving and shrinking of databases
  • Manage production, QA and development database environments
  • Create detailed documentation including diagrams of database infrastructure
  • Learn relevant business processes and understand the data flow, criticality and dependencies
  • Effectively coordinate and communicate with all the stakeholders (internal teams and clients)

 

You will have

  • Advanced understanding of Oracle 12c and higher versions
  • Experience of creating and managing multiple databases and assist in capacity planning
  • Strong working knowledge of administering Solaris and Linux platforms
  • Management of multiple schemas through system development, test and live environments
  • Experience of identifying and resolving performance issues
  • Experience of Unix Scripting
  • Experience with management of Microsoft SQL server