Database Principal Engineer (SDE 4)

Kredivo; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading financial technology company in Jakarta is seeking a Database Principal Engineer to manage over 250 databases. This role involves designing automation processes for database management, ensuring reliability, and optimizing performance. Candidates should have strong skills in SQL, database systems, and scripting languages like Python or PowerShell. The position offers opportunities for significant impact as the engineering organization grows.

Qualifications

• Strong understanding of database concepts and DBMS.
• Familiarity with CI/CD tools.
• Ability to diagnose complex automation issues.
• Proficient in scripting languages for automation tasks.

Responsibilities

• Develop automation scripts using programming languages.
• Implement and configure database automation tools.
• Automate data migration processes.
• Establish performance monitoring systems.
• Ensure compliance with regulatory standards.
• Participate in the creation of database instances.

Skills

Database management systems (DBMS)

SQL

Python

PowerShell

DevOps principles

Tools

Database automation tools

Monitoring systems

Job description

Database Principal Engineer

We are looking for someone who could help manage our 250++ databases as the engineering organization grows. You will be involved in operational tasks and leading in designing and implementing automated processes to manage database tasks like data modification requests, provisioning, configuration, backups, monitoring, performance optimization, and deployment, aiming to streamline operations, reduce manual intervention, and improve overall database reliability and efficiency.

About the job:

• Developing automation scripts: Writing scripts using programming languages like Python, PowerShell, or SQL to automate repetitive database management tasks.
• Integrating with tools: Implementing and configuring database automation tools to manage database lifecycle, including provisioning, scaling, and patching.
• Data migration automation: Automating data migration processes between different database environments.
• Envisioning database engineering roadmap: Imagining the potential futures, outlines the short-term and long-term team roadmap that align with the organization’s vision.
• Performance monitoring and optimization: Setting up automated monitoring systems to identify performance bottlenecks and implementing optimization strategies.
• Backup and recovery automation: Automating database backup and restore processes to ensure data integrity and disaster recovery capabilities.
• Security automation: Implementing automated security measures to control database access and protect sensitive data.
• Compliance management: Ensuring database operations comply with relevant regulatory standards through automated checks.
• Troubleshooting automation issues: Identifying and resolving issues related to automated database processes.

About you:

• Strong understanding of database concepts, SQL, and database management systems (DBMS).
• Familiarity with DevOps principles and tools for continuous integration and deployment (CI/CD).
• Assisting in hardware capacity planning as well as re-sizing.
• Ability to diagnose and troubleshoot complex database automation issues.
• Creating documentation for database design, implementing, and maintaining database structures to meet business requirements.
• Proficiency in scripting languages like Python, PowerShell, or other automation tools.
• Analyze and improve efficient, scalability, and stability of application relational databases.
• Contributing to database replication, database migration, performance optimization, tuning, and database troubleshooting.
• Regularly monitoring and detecting performance issues related issues both during working hours as well as scheduled on call times.
• Participate in the creation of development, staging, and production database instances and the migration from one environment to another.
• Responsible for developer SQL code(DDL, DML) review to ensure queries are optimized and tuned to perform efficiently before the production release.