Senior Database Administrator(Oracle & SQL)

ENCORA TECHNOLOGIES PTE. LTD.; Singapore; On-site; SGD 45,000 - 65,000; Full time

Job summary

A technology services company located in Singapore seeks a skilled Database Administrator to manage and optimize Oracle and SQL Server databases. The ideal candidate will have a strong foundation in database management, experience with disaster recovery solutions, and proficiency in performance tuning. This role requires excellent troubleshooting abilities, strong communication skills, and the capacity to work in cross-platform environments. A degree in a related field and at least one year of relevant experience are essential.

Qualifications

• Minimum of 1 year experience in installing and configuring relational databases or big data platforms.
• Strong experience with Oracle Data Guard and GoldenGate.
• Hands-on experience with SQL Server AlwaysOn Availability Groups.

Responsibilities

• Install and maintain Oracle and SQL Server databases on different platforms.
• Monitor performance and troubleshoot slow queries.
• Implement database security policies and compliance measures.

Skills

Database installation and configuration

Performance tuning and optimization

Backup and recovery strategies

Security policies and compliance

Scripting for automation

Education

Degree/Diploma in Computer Science, Computing, Electrical Engineering, IT

Tools

Oracle Database 12c/19c/21c

MS SQL Server 2016/2019/2022

RMAN

Oracle Enterprise Manager

Job description

Responsibilities

Database Administration

• Install, configure, and upgrade Oracle (12c/19c/21c) on Windows and Linux servers.
• Install, configure, and maintain Microsoft SQL Server (2016/2019/2022) on Windows platforms.
• Manage database storage structures, users, roles, and access privileges.
• Perform routine database maintenance, patching, and performance tuning.
• Implement and maintain backup and recovery strategies using RMAN (Oracle) and SQL Server native tools.

High Availability & Replication

• Configure, administer, and monitor Oracle Data Guard for disaster recovery and standby database management.
• Implement and support Oracle GoldenGate for real-time data replication and synchronization across heterogeneous environments.
• Configure and maintain SQL Server AlwaysOn Availability Groups for high availability and read-scale solutions.
• Manage SQL Server Failover Cluster Instances (FCI), including cluster setup, node management, and failover testing.

Performance & Optimization

• Analyze and tune SQL queries, indexes, and database performance parameters.
• Troubleshoot slow-running queries and application performance issues.
• Use AWR, ADDM (Oracle) and Query Store, Extended Events (MSSQL) for performance diagnostics.

Security & Compliance

• Enforce database security policies, encryption, and audit mechanisms.
• Ensure compliance with data governance and industry standards (e.g., MAS TRM, ISO 27001).
• Apply regular patches and perform vulnerability remediation activities.

Monitoring & Automation

• Set up proactive database monitoring and alerting using tools such as Oracle Enterprise Manager, SQL Server Management Studio, and third-party monitoring platforms.
• Develop scripts for automation of maintenance, monitoring, and reporting tasks (using Shell, PowerShell, or Python).

Disaster Recovery & Documentation

• Conduct periodic DR drills and validate failover/failback processes.
• Maintain comprehensive documentation for database architecture, configurations, and operational procedures.
• Participate in 24x7 on-call rotation and incident response.

Required skills and qualifications

• Degree/Diploma in Computer Science, Computing, Electrical Engineering, IT or equivalent.
• Good knowledge in one or more of the following platforms and technologies:
  • a. Database (e.g. MS SQL and Oracle)
  • b. Big Data (e.g. Hadoop, NoSQL, Hive, Sqoop, Cloudera)
  • c. Database Activity Monitoring (e.g. Imperva, Guardium, Data Sunrise)
• Good knowledge of Windows platform and Linux platform such as Red Hat and Oracle Linux.
• At least one (1) year experience in installing, configuring or administrating Relational databases, Big data platforms or Database Activity Monitoring tools.
• Strong experience with Oracle Data Guard and Oracle GoldenGate.
• Hands-on experience with SQL Server AlwaysOn Availability Groups and Failover Cluster Instances.
• Proven experience in both Windows and Linux environments.

Technical Skills:

• Oracle Database 12c/19c/21c (RAC, ASM, RMAN, OEM).
• MS SQL Server 2016/2019/2022 (SSMS, SSIS, SSRS, AlwaysOn, FCI).
• Scripting: Shell, PowerShell, Python (for automation).
• Backup tools (NetBackup, CommVault, or equivalent).
• Strong understanding of networking, storage, and OS fundamentals for database performance optimization.

Preferred skills and qualifications

• Oracle and/or MS SQL certifications
• Windows and/or Linux certifications
• ITIL Foundation

Soft Skills

• Strong analytical and troubleshooting skills.
• Excellent communication and documentation ability.
• Team-oriented, with experience working in multi-vendor and cross-platform environments.
• Ability to prioritize and manage multiple tasks under pressure.