Database Administrator (Bandung)

Staffinc

Kota Bandung

IDR 200,000,000 - 300,000,000

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