Senior Teradata Database Administrator (DBA)

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.