Wing Bank ថ្ងៃនេះ

Senior Database Administrator

កម្រិត៖Senior
ភាសា៖English
ទីតាំង៖ Phnom Penh
ប្រាក់ខែ៖ មិនបញ្ចេញប្រាក់ខែ
ឧស្សាហកម្ម
🏢 ការងារពីទំព័រអាជីពរបស់ក្រុមហ៊ុន

ព័ត៌មានលម្អិតការងារ

JOB RESPONSIBILITIES

  • CDC and Data Streaming (Core)
  • Design, build, and maintain real-time CDC pipelines from Oracle and PostgreSQL to Oracle, Kafka, and Big Data platforms using Qlik Replicate, Debezium, and Oracle GoldenGate (OGG).
  • Install, configure, troubleshoot, and support CDC replication across different Oracle Database versions and tool releases.
  • Manage Debezium connectors on Kafka Connect, including snapshots, offsets, and schema changes.
  • Work with Kafka topics, partitions, and consumer groups to ensure reliable, ordered, and scalable data delivery.
  • Build and support data flows in Apache NiFi for routing, transforming, and loading streamed data.
  • Monitor end-to-end pipeline health, replication lag, throughput, and data consistency between source and target, and resolve issues quickly.
  • Upgrade CDC tools and re-set up replication without any data loss.
  • Execute near-zero-downtime migrations of Oracle databases (on-premises and cloud) using CDC tools, including OGG Microservices.
  • Automate deployment, monitoring, and recovery of streaming pipelines through scripting.
  • Document pipeline designs, SOP, and recovery procedures.

JOB REQUIREMENTS

  • Education
  • Bachelor’s degree in Information Technology, preferably in Computer Science.
  • Technical Requirements
  • Minimum of 4 years of experience with Oracle Database.
  • 3+ years of experience implementing and maintaining Change Data Capture (CDC) replication across multiple Oracle environments using tools such as Qlik Replicate, Debezium, and Oracle GoldenGate (OGG).
  • Proficiency in engineering and managing CDC and replication technologies, including:
    • Qlik Replicate: configuring tasks, endpoints, and full-load plus CDC pipelines, and monitoring latency and errors.
    • Debezium: deploying and managing connectors on Kafka Connect, handling schema changes, and resolving offset or snapshot issues.
    • Oracle GoldenGate 19c/21c: setting up GoldenGate Microservices replication (Oracle to Oracle and Oracle to Big Data), troubleshooting issues, and maintaining trail files in ACFS/DBFS.
    • Experience with Kafka, Apache NiFi, and Big Data clusters as CDC targets and streaming platforms.
    • Experience in database architecture, problem diagnosis and resolution, shell scripting, PL/SQL development, and backup and recovery.
    • Ability to troubleshoot Oracle database problems that originate in the supporting infrastructure, including application servers, network, storage, and operating systems.
    • Experience upgrading, patching, and migrating databases.
    • Experience writing scripts to automate routine database and replication tasks.
    • Strong skills in building complex SQL queries.
    • Soft Skills and Work Style
    • Self-starter who can work with minimal supervision.
    • Extremely detail-oriented, with strong analytical and problem-solving skills.
    • Excellent verbal and written English, and the ability to collaborate with a range of stakeholders.
    • Strong organization and time-management skills, with the ability to handle multiple assignments.
    • Able to work under pressure and meet tight deadlines.
    • Able to coach and mentor team members.
    • High level of confidentiality, integrity, and business ethics.
    • Understanding of the industry and alignment with company values and culture.
    • Flexible to work in a 24x7 environment, including on-call support as required.

     

នេះជាប្រកាសរបស់អ្នកមែនទេ? កែប្រែ ឬលុបនៅទីនេះ

⚠ ដើម្បីសុវត្ថិភាពរបស់អ្នក

ដាក់ពាក្យតែនៅលើទំព័រផ្លូវការរបស់និយោជកប៉ុណ្ណោះ កុំបង់ប្រាក់ឲ្យអ្នកជ្រើសរើសបុគ្គលិក ហើយកុំប្រគល់ប្រាក់ ឬឯកសារណាមួយ ដើម្បីបានការងារ

មិនបញ្ចេញប្រាក់ខែ
ដាក់ពាក្យនៅប្រភពដើម ↗