Database Administrator

Straits Financial Group; Jakarta Pusat; On-site; IDR 167,400,000 - 234,360,000; Full time

Job summary

Straits Financial Group, headquartered in Singapore with a presence in the United States and Indonesia, seeks a Database Administrator to manage all databases used in Applications. You will maintain, optimize and monitor performance, working closely with the development team to deliver outcomes.

Responsibilities include maintenance across multiple environments, query optimization, indexing, and setting up resilient multi-master replication.

Qualifications

• Minimum 2 years’ experience in Database Administration.
• Must possess can do attitude and focus on delivering realistic outcomes.
• Self-motivated with strong communication and problem-solving skills.
• Familiar with MySQL, Postgres, Mongo, Redis and willing to learn other databases.
• Strong team player and able to work in an international environment.
• Experience with commodity futures trading platforms is a plus.

Responsibilities

• Define and perform daily, weekly, monthly, annual maintenance of all databases for Development, UAT and Production environments.
• Measure, evaluate and assess all database queries used in all applications.
• Create indexes in databases to optimize query performance.
• Perform optimization on all databases used in all applications.
• Set up resilient Multi-Master DB servers with real-time replication for Postgres, MySQL, Mongo, Redis, MS SQL.
• Collaborate with the development team to deliver project outcomes.
• Understand infrastructure including servers, storage, middleware, Kubernetes, and related technologies.

Skills

Teamwork

Multitasking

Problem-solving

Communication

Self-motivation

Tools

MySQL

PostgreSQL

MongoDB

Redis

MS SQL

Job description

Headquartered in Singapore with presence in the United States and Indonesia, Straits Financial serves as the financial services arm of the CWT Group, a global leading provider of integrated logistics and financial services. We provide a fully integrated service for our clients to access the financial and commodity derivative markets and will continue to expand into key financial and commodity markets.

We are looking for a Database Administrator to manage all databases used in Applications. This individual will need to be able to manage, maintain, and optimize any database in use as well as measure the performance of the database. This individual will be working closely with the development team to deliver the desired outcome.

Responsibilities:

• Define and perform daily, weekly, monthly, annual maintenance of all databases used for Development, UAT and Production environments
• Measure, evaluate and assess all database queries used in all applications
• Create indexes in Databases to optimize query performance
• Perform optimization on all databases used in all applications
• Familiar and have experience in performing maintenance and optimization of databases including but not limited to MySQL, Postgres SQL, Mongo DB, MS SQL, REDIS. Postgres and MySQL experience is a mandatory requirement
• Familiar with setting up from scratch for a resilient Multi-Master DB server with real-time replication for Postgres, MySQL, Mongo, REDIS, MS SQL
• Work closely with the development team to deliver the project outcome
• In-depth understanding of infrastructure, including but not limited to servers, storage, Middleware, Kubernetes, etc

Candidate Skills/Requirements:

• Minimum 2 years’ experience in roles similar to Database Administration
• Must possess can do attitude and focus on delivering realistic outcomes set
• Self-motivated, high level of dependability, organization, attention to detail, strong communication and problem-solving skills required. Candidate must be able to multitask in a fast-paced and challenging environment efficiently
• Familiar with MySQL, Postgres, Mongo, REDIS and willing to learn about any databases.
• Strong team player
• Working knowledge of commodity futures trading platforms is a plus
• Good command of English
• Travel and team-building activities in accordance with the company's guidelines and policies
• Work in an international environment, utilizing English for seamless interaction with professional departments from diverse countries
• Working time: 8:00 AM - 5:00 PM, Monday to Friday