Database Administrator

Assuritz Infosec; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

Assuritz Infosec is seeking a skilled Database Administrator to ensure performance, integrity, and security of our databases. You will work with project teams to optimize performance and implement robust data security.

Responsibilities include managing installations, backups, DR procedures, schema design, and high-availability configurations. Experience with SQL Server, Oracle, and MongoDB is valued, with SSRS/SSIS and certifications a plus.

Qualifications

• Bachelor’s degree in computer science, information technology, or related field.
• In-depth knowledge of database management systems (e.g., SQL Server, Oracle).
• Strong data security principles and best practices.
• Effective communication and collaboration abilities.
• Hands-on experience driving performance improvements via schema changes and tuning.
• Experience with failover mechanisms (clustering, mirroring, Availability Groups) and DR drills.
• Experience with MongoDB is a plus; SSRS/SSIS and ETL skills are desirable.

Responsibilities

• Install, configure, and maintain database software and related technologies.
• Monitor and optimize database performance, ensuring high availability.
• Configure backups and disaster recovery procedures.
• Troubleshoot issues and perform root cause analysis.
• Collaborate with developers to design database schemas and optimize design.
• Maintain database documentation and standards.
• Manage users, roles, upgrades, patches, replication, and clustering.
• Analyze queries and indexes to improve performance and mitigate bottlenecks.

Skills

Data security principles

Performance tuning

Team collaboration

Root cause analysis

Documentation

Partitioning

Education

Bachelor’s degree in computer science, Information Technology, or related field

Tools

SQL Server

Oracle

MongoDB

SSRS

SSIS/ETL

Job description

Job Description

We are seeking a skilled and experienced Database Administrator (DBA) to join our team. The ideal candidate will be responsible for the performance, integrity, and security of our databases. As a DBA, you will work closely with our project team member to ensure the availability and functionality of our database systems, optimizing their performance and implementing data security measures.

Key Responsibilities

1. Database Management

• Install, configure, and maintain database software and related technologies.
• Monitor and optimize database performance, ensuring high availability and reliability.
• Configure database backups and disaster recovery procedures.
• Troubleshoot database issues and perform root cause analysis.

2. Data Security

• Implement and maintain data security policies and procedures.
• Ensure compliance with data privacy regulations and standards.
• Configure and maintain database access and permissions, identifying and mitigating security risks.

3. Database Design and Development

• Collaborate with developers to design and implement database schemas.
• Optimize database design for performance and scalability.
• Develop and maintain database documentation and standards.

4. Database Administration

• Create and maintain database users and roles, managing access permissions.
• Perform database upgrades and patches, ensuring system compatibility and stability.
• Configure and maintain database replication and clustering for high availability.

5. Performance Tuning and Optimization

• Analyze and optimize database queries and indexes for improved performance.
• Monitor database performance metrics and implement tuning strategies as needed.
• Identify and resolve performance bottlenecks and resource contention issues.

Qualifications

• Bachelor’s degree in computer science, Information Technology, or related field.
• In-depth knowledge of database management systems (e.g., SQL Server, Oracle…etc)
• Strong understanding of data security principles and best practices.
• Effective communication and collaboration abilities.
• Hands-on experience driving improvements in product performance via changes in database schema, logical and physical data organization (partitioning), tuning and configuration.
• Experience implementing/maintaining database failover mechanism (clustering, mirroring, Availability Group) and perform disaster recovery exercises for mission-critical databases.
• Experience with maintaining and optimizing MongoDB is a plus.
• Strong skills in SSRS report development and SSIS/ETL.
• Relevant certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate) are a plus.