Senior Cassandra Database Administrator l Penang

Job Purpose:

As a Senior Cassandra Database Administrator, you will be a part of a growing international team based in Kuala Lumpur Center. We are seeking candidates with wide range of expertise and skills in Cassandra database support such as day-to-day administration, performance tuning, monitoring and Backup/restore. You will be mentoring other database administrators sharing your expertise and work in a big database team.

Key Activities:

• Database Administration support for Cassandra databases.
• Database Maintenance, housekeeping, troubleshooting.
• Identify and resolve database performance issues, including tuning SQL queries, optimizing indexing, and implementing necessary database changes.
• Incident, problem and change management of database-related incidents and problems, both in collaboration with other technical teams.
• Provide operational support, including capacity planning, system performance analysis, and resource utilization monitoring.
• Develop and maintain documentation related to database administration procedures, configurations, and troubleshooting steps.
• Installation, configuration and lifecycle migrations/upgrades and patch management
• Conduct ongoing monitoring and proactive management of database systems to ensure high availability and performance.
• Support database backup and recovery activities, ensuring appropriate backup strategies and disaster recovery plans are in place.
• SQL (CQL) database programming
• Unix/Linux, Python, Shell scripting
• Participate in an on-call rotation schedule to ensure 24/7 availability and response to critical incidents.
• Implement and maintain Cassandra disaster recovery and high availability solutions.
• Ensure compliance with data protection regulations.

Formal Education:

• Official acknowledged university / college qualifications
• Certified corresponding post education or training in Cassandra database administration areas.

Essential Skills:

• At least 5 years of experience working in Cassandra database
• Cassandra Administration, backup/recovery and Monitoring
• Database installation and configuration including patching
• Backup and recovery, cloning and duplication

Additional Skills:

• Problem analysis resolution and error debugging including skills in raising support requests with vendors.
• Database performance tuning (configuration related and application code tuning)
• Space management analysis and object reorganization
• Database patching and migrations
• Database user management (authorisation and authentication)
• Analysis of database performance reports
• Advanced Unix/Linux, Shell scripting, Python programming skills
• SQL (CQL) database programming
• Comprehensive knowledge of database security.

Preferred Skills:

• Knowledge of another database technology: PostgreSQL, Redis Cache is a plus.
• Experience in software methodology, processes and quality assurance
• Knowledge in the area of IT security
• Profound interest in new technologies and self-motivated troubleshooting
• Experience with cloud applications (Azure and GCP)

Personal Skills:

• Goal-oriented and organised working methods
• Good analytical skills

Critical Skills/Work Attitude:

• English language skills
• Teamwork
• Cloud technology knowledge