Database Engineer

Roles & Responsibilities : 

1. Responsible for PostgreSQL and other relational database administrations and management (capacity planning, installation, backup, recovery, monitoring, optimizations, troubleshooting, etc).
2. Support development teams and production teams for database designs and implementations.
3. Review existing system architecture and contribute to improve on the future architecture for database stability and a maximum of performance.
4. Define and develop projects that reduce database operational costs and automate regular tasks.
5. Research and develop new technologies and approaches for building highly available data persistence systems.

Requirements:

1. Bachelors degree or higher in Computer Science or a related field.
2. Minimum 2 years of hands-on experience with PostgreSQL in an online production environment.
3. Solid understanding of relational database theory, including normalization, indexing, transactions, and ACID properties.
4. Proficient in writing complex SQL queries and performing performance tuning and optimization.
5. Experience in high availability and disaster recovery configurations (e.g., replication, failover).
6. Familiar with Kafka, MySQL, and data warehousing concepts.
7. Able to perform basic ETL tasks, including data migration and transformation.
8. Proficient in scripting (Shell or Python) for automation.
9. Comfortable working in a Linux environment with strong troubleshooting skills.
10. Functional English communication skills (written and verbal).
11. Strong analytical and problem-solving skills; able to perform under pressure.
12. Detail-oriented, adaptable, and able to prioritize multiple tasks effectively.

Preferred (Nice-to-Have) Skills:

1. Familiarity with other RDBMS platforms (e.g., MySQL/MariaDB, SQL Server, Oracle).
2. Experience with data modeling tools (e.g., MySQL Workbench, dbdiagram.io).
3. Basic familiarity with NoSQL databases (e.g., MongoDB, Redis, Cassandra).
4. Exposure to ETL tools (e.g., Talend, Apache NiFi).
5. Experience with cloud-based databases (e.g., Amazon RDS/Aurora, Google Cloud SQL/BigQuery, Azure SQL Database).
6. Basic experience with Git for version control of database scripts.

Information :

• Company : TIXid
• Position : Database Engineer
• Location : Jakarta
• Country : ID