Database Administrator

ASSURITZ INFOSEC (SG) PTE. LTD.; Singapore; On-site; SGD 90,000 - 140,000; Full time

Job summary

ASSURITZ INFOSEC (SG) PTE. LTD. is seeking a skilled Database Administrator to manage performance, integrity, and security of our databases.

You will work with project teams to ensure availability, implement security measures, and optimize DB systems for scalability. Responsibilities include maintenance, backups, DR testing, and collaboration with developers on schema design and performance tuning. Strong SQL Server/Oracle experience and data security expertise are essential; MongoDB experience

Qualifications

• Bachelor's degree in CS/IT or related field.
• In-depth knowledge of database systems (SQL Server, Oracle).
• Strong understanding of data security principles and best practices.
• Excellent communication and collaboration abilities.
• Hands-on experience driving performance improvements via schema design, partitioning, tuning.
• Experience implementing failover mechanisms (clustering, mirroring, Availability Groups) and DR exercises.
• Experience with maintaining and optimizing MongoDB is a plus.
• Strong SSRS and SSIS/ETL skills.
• Certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate) are a plus.

Responsibilities

• 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.
• Implement and maintain data security policies and procedures.
• Collaborate with developers to design and implement database schemas.
• Optimize database design for performance and scalability.
• Create and maintain database users and roles, managing access permissions.
• Perform database upgrades and patches, ensuring system stability and compatibility.
• Configure and maintain database replication and clustering for high availability.

Education

Bachelor's degree in computer science or information technology

Tools

MongoDB

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.