Database Administrator (DBA)

Full Time, onsite
International SOS (M) Sdn Bhd
Kuala Lumpur, Malaysia

Salary undisclosed

Checking job availability...

Original

Simplified

A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. Keep data secure across national boundaries through multiple data centres and AWS regions.

Key Responsibilities (Critical responsibilities and skills of this position, listed in order of importance)

Design, build, and maintain operational databases for custom and packaged software being implemented by the Enterprise Application Project (majorly .Net based global applications)
Managing and Administering Cloud based relational Database solutions
Provisioning and Capacity planning of Resources for Database infrastructure
Administering and Operating Global Database Systems for about 700 database instances (Microsoft SQL Server & MySQL)
Performance Monitoring of Database Systems and Backups using SolarWinds DPA and other monitoring solutions
Data migration from on-premise databases to Cloud based database platforms
Performing database releases for Application Support and Projects
Be a contributor to the database Projects team for delivering database projects
TSQL and PowerShell Scripting for solutioning on a need basis
Performance Tuning and Troubleshooting of SQL Server Databases and complex T-SQL and Stored Procedures
Designing and Implementing Disaster recovery and Business Continuity Solutions for database systems
24 x 7 support model on rotational on call basis for critical incident handling and emergency support

Required Skills and Knowledge (Brief description of technical knowledge or skills needed to perform the job)

proven experience in designing, developing, and maintaining operational databases
sound working knowledge and experience in handling and managing large enterprise database systems on-Premise and Cloud based (Microsoft SQL Server & MySQL)
Exposure to Azure and AWS technology Stacks with experience in provisioning and capacity planning
Sound knowledge of designing and implementing SQL native and other replication techniques
Exposure to Database Monitoring tools and platforms
Experience in performance tuning and troubleshooting complex database issues
Sound experience and Knowledge of Deployment and troubleshooting SSIS based ETL solutions
Experience in Configuration, implementation and operations of SSRS based reporting platforms with native and SharePoint based integration
Proficient in designing and implementing Disaster recovery and Business continuity solutions for Enterprise Database Systems with Native and third-party platforms. Experience in Arcserve and Zirto will be an added advantage
Knowledge of TSQL and PowerShell scripting for solutioning and troubleshooting
Working experience with the complete MSBI stack, experience in presentation and dashboarding platforms like PowerBI will be an advantage

Required Competencies (Critical behaviours necessary to successfully perform the job)

MS Certification in SQL Server Administration
Strong AWS/Azure Platform Experience
Data Modelling (Basic Level) experience
No SQL – MongoDB, Cassandra
Web Services, Data Warehousing Experience
UML, Use Case Experience
Healthcare and/or Insurance software development experience

Required Work Experience (Brief description of the job-related experience needed to perform the job)

Minimum 8 years’ experience in database administration and production support tasks including Replication, SQL Optimization & Tuning, Monitoring, Backup/Recovery, Troubleshooting and Database Security on large Database environments
Experience of designing scalable solutions with proficiency in use of data structures and algorithms
Experience in cloud-based environment with PaaS & IaaS
Experience with AWS cloud services: EC2, EMR, RDS, Redshift
SQL Always ON and Log Shipping based Solutions for Distributed Systems
Experience in SQL 2019 and 2022 database administration with Replication and SSIS
Experience in Database Monitoring
Experience in developing and interacting with Database Automation platforms
Hands on knowledge for automating database management use cases
Data Integration Patterns
Data Quality/Lineage Solutions
Performance Benchmarking and Tuning
Data Conversion and Migration between different databases
Work iteratively in a team with continuous collaboration
Experience working as part of an international project team with support across time zones