# Senior Specialist, *Database Administrator*Kuala Lumpur, MalaysiaPermanent#### Duties & Responsibilities* The Specialist, DBA is responsible for managing and optimizing company’s databases and to ensure availability, performance and security. This role includes both operational and support responsibilities such as troubleshooting, data management and protection, housekeeping and backup. The role will also require executing disaster recovery plan.* KEY RESULTS AREA* 1) Database Management and Maintenance* a) Maintain and configure database systems (i.e. MySQL, PostgreSQL, MongoDB, NoSQL Database)* b) Apply security patches, updates and version upgrades as needed* 2) Performance Tuning and Optimisation* a) Monitor database performance, optimize queries, indexes and storage* b) Analyse slow queries and improve database performance* c) Optimise indexing and partitioning* 3) Database Design and Implementation* a) Implement database best practice and security policy* b) Collaborate with software developers and system architects to ensure database designs are efficient, scalable and optimised* 4) Security and Compliance* a) Implement security control and enforce database security policies (i.e. Access control, encryption, audit logging, secure connection)* b) Conduct periodic backup and restoration test* c) Ensure compliance with industry standards (i.e. BNM, PCIDSS, SOC 2, PDPA)* d) Support security audits and vulnerability assessments* 5) Troubleshooting and Incident Management* a) Investigate and resolve database issues quickly* b) Perform root cause analysis for database failures* c) Provide technical support and assistance for database related queries* 6) Capacity Planning and Scaling* a) Forecast database storage and performance needs* b) Forecast event-based database usage, needs and cost* c) Optimise database costs in cloud environments* 7) Automation and Scripting* a) Automate routine DBA tasks (i.e. monitoring, failover, backup, restoration, maintenance)* b) Automate approval and account creation#### Requirements* Qualification:* Bachelor's degree in computer science, database management, or related field* Professional cloud certification on DBA* Experiences:* Proven 3 experience in a DBA or SRE related to DBA experience* In-depth knowledge of MySQL database management systems and their associated tools.* Skills:* In-depth knowledge of MySQL, PostgreSQL, NoSQL database management systems and their associated tools* Good knowledge in managing and design database cluster* Strong understanding on cloud database* Proven implementation of database design principles, data normalisation and indexing techniques* Proficiency in writing and optimizing SQL queries and stored procedures.* Familiarity with database security best practices and principles.* Experience with database performance tuning and optimization.* Knowledge of data backup and recovery strategies.* Able to use automation tool to automate routine tasks* Personality:* Passionate, agile, flexible, and positive attitude.* Assertive, driven individual with a strong sense of urgency* Self-starter with continuous improvement mindset* Flexibility to adapt to changing business requirements and priorities* Ability to work independently and manage multiple tasks simultaneously* Strong problem-solving skills and the ability to handle high-pressure situations calmly and effectively.* Strong attention to detail and a commitment to delivering high-quality results.