POSITION SUMMARY:
Senior Database Administrator is responsible to maintain the performance, integrity and security of all databases systems and data platforms to provide stable environment for all applications in GEG. Perform Day-to-day monitoring and healthcheck on all database systems. Provide Proper training and guidance to Database Administrator to perform daily duties.
PRIMARY RESPONSIBILITIES:
•Maintain a high availability database system by performance tuning, pro-active monitoring, bottleneck identifying and backup/restore method fine-tuning.
• Assist or undertake maintenance management on database servers and data platforms including evaluation of new releases and patches.
• Manage database security and audit access management.
• Provide technical advice and expertise on development, implementation and maintenance of database and data platform solutions that support business needs.
• Maintain data platforms and data integration between application systems and external entities.
• Performs on-call technical support and other duties as required.
• Provide Guidance and Training to juniors.
• Other duties may be assigned as required.
REQUIREMENTS:
• University degree Computer Science or equivalent.
• Minimum of 3 years of experiences working in database administration, analysis and programming.
• Different DBMS Certification of Profession is required. e.g. OCP, MCSE
• Strong communication, presentation, leadership and analytical skills is required.
• Solid and proven experiences in Microsoft SQL Server, MySQL, PostgreSQL, Oracle and Clickhouse administration, Database Replication, Database HA, Data Migration and ETL process.
• Experience in writing T-SQL, PL/SQL, triggers, stored procedures, functions and ETL are required.
• Experience on data warehouse design and management is an advantage.
• Experience in maintain and implement in Kafka, Elasticsearch, Grafana, Power BI or other BI Tools is an advantage.
• Experience in casino and hotel management system is absolutely an advantage.