Database Administrator

APAR TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

APAR TECHNOLOGIES PTE. LTD. is seeking a database administrator to install, configure, and optimize SQL Server and Oracle environments. You will monitor performance, enforce security, and implement backup, disaster recovery, and high-availability solutions.

The role involves collaboration with developers on database design, performance improvements, and data migration tasks. Experience with SSRS/SSIS is highly valued, with MongoDB knowledge a plus.

Qualifications

• Bachelor's degree or higher in CS/IT or related field.
• Strong knowledge of SQL Server and/or Oracle database administration.
• Experience with database security and access management.
• Hands-on experience with performance tuning and optimization.
• Experience with disaster recovery planning and high availability solutions.

Responsibilities

• Install, configure, maintain and upgrade database management systems.
• Monitor database performance, availability and reliability.
• Perform performance tuning, query optimization and index management.
• Configure and maintain backup and disaster recovery procedures.
• Troubleshoot issues and perform root cause analysis.
• Manage users, roles, access permissions and security controls.
• Implement security policies and data privacy requirements.
• Design and optimize schemas for performance and scalability.
• Configure replication, clustering and high availability solutions.
• Perform upgrades, patches and compatibility assessments.
• Support failover mechanisms including clustering and mirroring.
• Conduct disaster recovery exercises for critical databases.
• Collaborate with developers on database design and performance.

Education

Bachelor's degree in Computer Science, Information Technology or a related field

Tools

SQL Server

Oracle

SSRS

SSIS/ETL

MongoDB

Job description

Job Details

• Install, configure, maintain and upgrade database management systems.
• Monitor database performance, availability and reliability.
• Perform database performance tuning, query optimization and index management.
• Configure and maintain database backup and disaster recovery procedures.
• Troubleshoot database issues and perform root cause analysis.
• Manage database users, roles, access permissions and security controls.
• Implement database security policies and support data privacy requirements.
• Design and optimize database schemas for performance and scalability.
• Configure and maintain database replication, clustering and high-availability solutions.
• Perform database upgrades, patches and compatibility assessments.
• Support failover mechanisms including clustering, mirroring and Availability Groups.
• Conduct disaster recovery exercises for mission-critical databases.
• Work with developers and project teams on database design and performance improvements.
• Support SSRS reporting and SSIS/ETL activities.
• Maintain database documentation, standards and operational procedures.
• Support MongoDB administration and optimization where required.

Requirements

• Bachelor's degree in Computer Science, Information Technology or a related field.
• Relevant experience in database administration.
• Strong knowledge of SQL Server and/or Oracle database administration.
• Strong understanding of database security and access management.
• Hands-on experience with database performance tuning and optimization.
• Experience with database schema design, partitioning and physical data organization.
• Experience implementing and maintaining database high-availability and failover solutions.
• Experience with disaster recovery planning and exercises for critical databases.
• Strong experience with SSRS and SSIS/ETL.
• Experience with MongoDB is an advantage.

EA Number: 11C4879