IT Database Administrator (DBA) (Shifting)

PT-Lawencon-Internasiona; Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PT-Lawencon-Internasiona in Jakarta is seeking an IT Database Administrator (DBA) to design, implement, and manage scalable, highly available databases across on‑premises and cloud environments. You will monitor performance, optimize queries, implement backup and disaster recovery, and collaborate with development and infrastructure teams to ensure data integrity and reliability.

The ideal candidate has a Bachelor’s degree in CS/IT and at least 1 year of DBA experience with Oracle, SQL Server,

Qualifications

• Bachelor's degree required in CS/IT or related field.
• At least 1 year of DBA experience.
• Hands-on with scalable/HA database systems.
• Strong RDBMS knowledge (Oracle, SQL Server, MySQL, PostgreSQL, DB2) and Redis.
• Cloud database experience (AWS RDS, Google Cloud SQL, Azure) is preferred.

Responsibilities

• Design, implement, and manage scalable, highly available databases.
• Monitor performance; troubleshoot and optimize queries.
• Develop, optimize, and maintain SQL queries for efficiency.
• Implement backup, recovery, and disaster recovery strategies.
• Collaborate with development and IT teams to support applications.
• Stay up to date with database technologies and best practices.

Skills

SQL performance tuning

HA databases

Cloud DB

Linux

Windows

NoSQL

Education

Bachelor's degree in Computer Science or Information Technology

Tools

SSMS

HeidiSQL

Oracle SQL Developer

SQLyog

Redis Insight

Job description

IT Database Administrator (DBA) (Shifting)

• Design, implement, maintain, and manage scalable, highly available (HA), and reliable database systems.
• Monitor database performance, troubleshoot issues, and ensure optimal database availability, security, and integrity.
• Develop, optimize, and maintain SQL queries to ensure efficient database performance.
• Perform database design, including indexing, partitioning, and performance tuning.
• Manage relational and non-relational databases across on-premises and cloud environments.
• Implement database backup, recovery, and disaster recovery strategies to ensure data availability and business continuity.
• Collaborate with development, infrastructure, and other IT teams to support application requirements and ensure database reliability.
• Identify and resolve complex database-related issues and recommend improvements to database architecture and performance.
• Stay up to date with the latest database technologies, tools, and industry best practices.

Requirements

• Bachelor's degree (S1) in Computer Science, Information Technology, or a related field.
• Willing to work in a 24/7 shift rotation
• Minimum of 1 year of work experience as a Database Engineer or in a related role.
• Hands-on experience in designing, implementing, and managing scalable and highly available (HA) database systems.
• Strong knowledge of relational database management systems (RDBMS), such as Oracle, Microsoft SQL Server, MySQL, PostgreSQL, and DB2, as well as NoSQL databases such as MongoDB.
• Strong knowledge of in-memory databases, particularly Redis.
• Proficiency in Linux and Windows operating systems.
• Strong SQL skills, including the ability to analyze, troubleshoot, and optimize queries for performance and efficiency.
• Good understanding of database design principles, including indexing, partitioning, and database normalization.
• Experience with cloud database technologies and services, such as AWS RDS, Google Cloud SQL, and Azure Database.
• Familiarity with database management tools such as SQL Server Management Studio (SSMS), HeidiSQL, Oracle SQL Developer, SQLyog, and Redis Insight.
• Strong analytical and problem-solving skills, with the ability to troubleshoot complex technical issues.Good communication and interpersonal skills, with the ability to work effectively in a team.
• Ability to learn independently and keep up with emerging technologies and industry developments.
• Relevant database certifications, such as Oracle Certified Professional, Google Cloud Professional Cloud Database Engineer, AWS Certified Database certifications, or other related certifications, are an advantage.

We are a rapid-growth and highly innovative IT company based in South Jakarta. We are looking for talented and motivated candidates to be part of our team.Our employees are youthfully enthusiatic and highly passionate about advancement in Information Technology. Thus, we invite you to futher develop your professional expertise and join us in our path to become the chosen software provider in business enterprise application. Contact us immediately.