Senior Teradata Database Administrator (DBA)

OCBC Bank; Singapore; On-site; SGD 150,000 - 210,000; Full time

Job summary

OCBC Bank is seeking a seasoned Database Engineer to manage and optimize its on‑premises Teradata data warehouse, ensuring peak performance and robust security. You will partner with infrastructure, data engineers and BI analysts to uphold uptime and efficient resource use.

The role requires deep Teradata architecture knowledge, Linux/Unix administration, and advanced scripting. This position is based in Singapore and offers a challenging, transformation‑driven environment with opportunities to

Qualifications

• 10+ years of dedicated experience managing on-premises Teradata production environments.
• Deep understanding of physical Teradata MPP architecture (Nodes, AMPs, Parsing Engines, BYNET).
• Strong hands-on experience with physical storage, Linux/Unix server administration, and shell scripting.
• Bachelor’s degree in Computer Science, IT, or a related field.

Responsibilities

• Manage, secure, and optimize on-premises Teradata data warehouse for high-performance analytics.
• Collaborate with infrastructure, data engineers, and BI analysts to maintain hardware efficiency and uptime.
• Configure and tune workload management rules to balance server resources.
• Troubleshoot data load scripts and ensure disaster recovery and backup strategies.

Skills

Teradata on‑premises management

Linux/Unix shell scripting

Database performance tuning

Data security & auditing

Infrastructure collaboration

Education

Bachelor’s degree in Computer Science/IT

Tools

Teradata Viewpoint

Visual Explain

TASM

BTEQ

FastLoad

MultiLoad

FastExport

DSA (Data Stream Architecture)

NetBackup

DBQL/ResUsage

Job description

WHO WE ARE: As Singapore’s longest established bank, we have been dedicated to enabling individuals and businesses to achieve their aspirations since 1932. How? By taking the time to truly understand people. From there, we provide support, services, solutions, and career paths that meet their individual needs and desires. Today, we’re on a journey of transformation. Leveraging technology and creativity to become a future-ready learning organisation. But for all that change, our strategic ambition is consistently clear and bold, which is to be Asia’s leading financial services partner for a sustainable future. We invite you to build the bank of the future. Innovate the way we deliver financial services. Work in friendly, supportive teams. Build lasting value in your community. Help people grow their assets, business, and investments. Take your learning as far as you can. Or simply enjoy a vibrant, future-ready career. Your Opportunity Starts Here.

Job Description

Why Join Imagine being part of a team that powers the technology behind one of Singapore's longest established banks. As a Database Engineer at OCBC, you\'ll play a critical role in ensuring our systems and infrastructure are secure, efficient, and always available. You\'ll be part of a team that\'s driving innovation and transformation in the banking industry.

How you succeed

To succeed in this role, you\'ll need to stay ahead of the curve when it comes to technology trends and advancements. You\'ll work closely with our technology teams to design, implement, and maintain our infrastructure, ensuring it\'s aligned with our business goals and objectives. You\'ll need to be proactive, collaborative, and always looking for ways to improve our systems and processes.

What you do

Role Overview

Core Purpose: Manages, secures, and optimizes our on-premises enterprise Teradata data warehouse platform to ensure high-performance data analytics. Collaboration: Partners with infrastructure teams, data engineers, and BI analysts to maintain hardware efficiency and database uptime.

Key Responsibilities

• Hardware & Space Management: Allocates Perm, Spool, and Temp spaces across physical nodes; monitors and resolves data skewing across AMPs.
• Performance Tuning: Uses Teradata Viewpoint and Visual Explain to optimize complex SQL queries and automates database statistics collection.
• Workload Management: Configures TASM (Teradata Active System Management) rules to balance local server resources and prioritize critical business workloads.
• Data Utilities: Troubleshoots infrastructure-level load scripts utilizing BTEQ, FastLoad, MultiLoad, and FastExport.
• Backup & On-Premises Recovery: Implements disaster recovery and backup strategies via Data Stream Architecture (DSA) integrated with on-premises storage systems (e.g., NetBackup).
• Security & Auditing: Manages user access, roles, and profiles, and monitors resource consumption using DBQL and ResUsage.

Who you are

Required Qualifications

• Experience: 10+ years of dedicated experience managing on-premises Teradata production environments.
• Architecture Knowledge: Deep understanding of physical Teradata MPP architecture (Nodes, AMPs, Parsing Engines, BYNET).
• Infrastructure & OS: Strong hands-on experience with physical storage, Linux/Unix server administration, and shell scripting.
• Education: Bachelor’s degree in Computer Science, IT, or a related field.

Preferred Skills

• Teradata Vantage Certified Administrator credential.
• Experience handling hardware upgrades, patches, or storage area network (SAN) integrations.
• Experience in Oracle, SQL Server, Postgres and MongoDB are added advantage
• Self-motivated and driven
• Good interpersonal, analytical and problem-solving skills
• Good communication skills and able to work independently with minimal supervision
• Banking experience is an added advantage

Who we are

As Singapore's longest established bank, we have been dedicated to enabling individuals and businesses to achieve their aspirations since 1932. How? By taking the time to truly understand people. From there, we provide support, services, solutions, and career paths that meet their individual needs and desires. Today, we're on a journey of transformation. Leveraging technology and creativity to become a future-ready learning organisation. But for all that change, our strategic ambition is consistently clear and bold, which is to be Asia's leading financial services partner for a sustainable future. We invite you to build the bank of the future. Innovate the way we deliver financial services. Work in friendly, supportive teams. Build lasting value in your community. Help people grow their assets, business, and investments. Take your learning as far as you can. Or simply enjoy a vibrant, future-ready career. Your Opportunity Starts Here.

What we offer: Competitive base salary. A suite of holistic, flexible benefits to suit every lifestyle. Community initiatives. Industry-leading learning and professional development opportunities. Your wellbeing, growth and aspirations are every bit as cared for as the needs of our customers. Let’s build the bank we need for the future we want. Find the best version of yourself in a friendly, supportive team. Build lasting value in your community. Help people grow their assets, business, and investments. Take your learning as far as you can. Or simply enjoy a vibrant, future-ready career. Your Opportunity Starts Here

Introduce yourself to our recruiters and we\'ll get in touch if there\'s a role that seems like a good match.

As the longest established Singapore bank, formed in 1932 from the merger of three local banks, we have grown from strength to strength to become a regional financial services group. With a deep history in Asia, we offer the most comprehensive coverage across ASEAN and Greater China, complemented with a presence in the leading economies of New York, London and Sydney. We are the second largest financial services group in Southeast Asia by assets with one of the world’s highest credit rating (Aa1 by Moody’s and AA- by both Fitch and S&P). We offer private banking services through our wholly-owned subsidiary, Bank of Singapore, which operates on a unique open-architecture product platform to source for the best-in-class products to meet its clients’ goals. Our insurance subsidiary, Great Eastern Holdings, is the oldest and most established life insurance group in Singapore and Malaysia.