Senior Teradata Database Administrator (DBA)

OCBC; Singapore; On-site; SGD 140,000 - 200,000; Full time

Benefits offered by this job

Competitive base salary

Learning & development opportunities

Wellbeing programs

Job summary

OCBC invites an experienced Database Engineer to join our on-prem Teradata data warehouse team. You will optimize performance, ensure security, and support high-availability analytics across the organization.

You should have 10+ years managing Teradata environments on-prem, strong Linux/Unix skills, and a Bachelor’s degree in Computer Science or IT. Banking domain experience is a plus, and you will collaborate with infrastructure, data engineers, and BI analysts.

Qualifications

• 10+ years managing on-prem Teradata production environments.
• Deep understanding of physical Teradata MPP architecture (Nodes, AMPs, BYNET).
• Strong Linux/Unix server administration and shell scripting skills.
• Bachelor’s degree in Computer Science, IT, or related field.

Responsibilities

• Manage, secure, and optimize on-prem Teradata data warehouse for high-performance analytics.
• Collaborate with infrastructure, data engineers, and BI analysts to maintain hardware efficiency and uptime.
• Tune performance using Teradata tools and automate collection of statistics.
• Configure workload management to balance resources and prioritize critical workloads.
• Implement disaster recovery and backup strategies with on-prem storage.
• Manage user access, roles, and auditing using DBQL and ResUsage.

Skills

Teradata administration

SQL tuning

Linux/Unix

Data warehousing

BTEQ/FastLoad tools

Education

Bachelor’s degree in Computer Science/IT

Tools

Teradata Viewpoint

DBQL/ResUsage

BTEQ/FastLoad/MultiLoad/FastExport

NetBackup

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.