Database Administrator

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)_
- 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

**Required Qualifications**(Brief description of the educational background needed to perform the job)
- Formal, degree or higher qualification in computer science, Statistics, Informatics, Information Systems or another quantitative field

**Required Languages**(Brief description of the language skills needed to perform the job)
- Good documentation, verbal and written skills

**Job Type**: Permanent

Pay: RM10,000.00 - RM15,000.00 per month

**Benefits**:

- Cell phone reimbursement
- Health insurance
- Maternity leave
- Opportunities for promotion
- Professional development

Schedule:

- Monday