Job Description
More than just a recruitment company. At PRTR, we have been a part of our customer's success for 30 years as their total HR solutions partner. With 550 dedicated professionals and over 15,000 outsourced staff, we will continue to carry out our mission to develop a better career, a better life, and a better society, and thrive to become the No.1 people solutions organization in Southeast Asia.
We are looking for an experienced Database Specialist to design, optimize, and maintain our database systems, focusing on MSSQL and PostgreSQL. This role offers the opportunity to drive database performance, security, and innovation in a collaborative environment.
Roles and Responsibilities:
- Designing and managing database structures, including schemas, tables, views, and indexes.
- Optimizing database performance through query tuning and structural improvements.
- Implementing and managing backup, recovery, and high-availability strategies.
- Monitoring database health and resolving performance bottlenecks.
- Developing scripts to automate database tasks and support CI/CD pipelines.
- Ensuring data security and compliance with organizational and regulatory standards.
- Collaborating with teams to support database-related development and operations.
Qualifications:
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 5+ years of experience managing MSSQL and PostgreSQL databases.
- Expertise in SQL development and performance optimization techniques.
- Strong knowledge of database security, backup, and disaster recovery processes.
- Familiarity with high-availability solutions and monitoring tools.
- Experience with cloud-based databases like Azure SQL, AWS RDS, or Google Cloud SQL.
- Proficiency in scripting languages such as Python, PowerShell, or Bash.
- Understanding of containerized environments, including Docker or Kubernetes.
- Relevant certifications in MSSQL or PostgreSQL administration are a plus.