Database Administrator (Bandung)

Staffinc; Kota Bandung; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

An established industry player is seeking a skilled Database Administrator to manage and optimize database systems. This role involves ensuring database performance, security, and availability while administering Postgres, Oracle, or MSSQL databases. You will also work on query optimization and financial transaction flows, ensuring data integrity and compliance. In this dynamic position, your programming skills in languages like Golang, Python, PHP, or JavaScript will be essential for automating database management tasks. Join a forward-thinking team in Bandung and make a significant impact on database operations.

Qualifications

• Extensive experience with Postgres, Oracle, or MSSQL databases.
• Strong understanding of database replication and financial transaction flows.

Responsibilities

• Administer and maintain database systems for performance and security.
• Implement database replication and optimize query performance.

Skills

Postgres

Oracle

MSSQL

Golang

Python

PHP

JavaScript

Database Management

Query Optimization

Problem-Solving

Education

Bachelor’s degree in Computer Science

Bachelor’s degree in Information Technology

Job description

Staffinc is looking for a skilled Database Administrator (SysDBA) to be outsourced at our client in IT company. The ideal candidate will have extensive experience with Postgres, Oracle, or MSSQL databases, as well as a solid understanding of replication concepts, financial transaction flows, and query optimization. Proficiency in at least one programming language such as Golang, Python, PHP, or JavaScript is also required.

Key Responsibilities:

• Database Management:
  • Administer and maintain database systems, ensuring their performance, security, and availability.
  • Manage and configure Postgres, Oracle, or MSSQL databases to meet the organization’s needs.
  • Perform regular database backups, restores, and disaster recovery procedures.
• Replication & Connection Management:
  • Implement and manage database replication, ensuring data consistency across environments.
  • Configure and maintain replication settings, including slot_name and connection pools, to optimize performance.
• Financial Transaction Flow:
  • Understand and manage the flow of financial transactions within the database, ensuring accuracy and compliance with industry standards.
  • Monitor transaction processing to prevent errors and ensure data integrity.
• Query Optimization & Performance Tuning:
  • Analyze and optimize database queries, functions, and table views to improve performance.
  • Develop and implement query optimization strategies to enhance database efficiency.
• Programming & Automation:
  • Utilize at least one programming language (Golang, Python, PHP, or JavaScript) to develop scripts for database management and automation.
  • Create and maintain database-related functions, triggers, and stored procedures.
• Troubleshooting & Support:
  • Diagnose and resolve database-related issues, providing timely support to development and operations teams.
  • Monitor database performance and implement necessary optimizations.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Extensive experience with Postgres, Oracle, or MSSQL databases.
• Strong understanding of database replication concepts, slot_name configuration, and connection pooling.
• Knowledge of financial transaction flow and its implications on database management.
• Proficiency in query logic, functions, and table views, with experience in query optimization.
• Proficiency in at least one programming language (Golang, Python, PHP, JavaScript).
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Able to work on site in Bandung