锦鲤求职岗位描述
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. Maintain and build data integration between systems for system integration. Perform Day-to-day monitoring and healthcheck on all database systems and data sync and integration operations. Provide Proper training and guidance to Database Administrator to perform daily duties.
Primary Responsibility
•Maintain a high availability database systems and all data integrations between systems / databases 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 and Implement 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/Software engineer/Data 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.