inhousefyi
← Back to listings

DB2 DBA Supporting Application

EncoraSingapore, Singapore · Posted 3 months ago
Full-time
Apply now

Description

DB2 DBA Supporting Applictaion

Important Information

Location: Singapore

Responsibilities:

a) Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards

b) Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements

c) Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns

d) Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments

e) Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools

f) Providing guidance to application developers on DB2 best practices, coding standards, and efficient query writing techniques

g) Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation

Requirements

a) Strong background in IT, Computer Science / Computer Engineering, or related discipline

b) Minimum 5 years of relevant working experience in the above technology is preferred.

c) Relevant experience in the following would be advantageous:
• Working with JCL (Jon Control Language)
• Understanding of VSAM and other mainframe storage concepts
• Familiar with database utilities and tools
• Experience with database backup and recovery procedures

About Encora

Encora is a global company that offers Software and Digital Engineering solutions. Our practices include Cloud Services, Product Engineering & Application Modernization, Data & Analytics, Digital Experience & Design Services, DevSecOps, Cybersecurity, Quality Engineering, AI & LLM Engineering, among others.

At Encora, we hire professionals based solely on their skills and do not discriminate based on age, disability, religion, gender, sexual orientation, socioeconomic status, or nationality

Similar jobs

EncoraSingapore, Singapore

APPLICATION MAINTAINENCE ENGINEER Important Information Location: Singapore Responsibilities: Perform root cause analysis on incidents (application, batch and connectivity) and provide a solution for remediation. Priorit…

Full-time
Systems Engineer3 months ago
EncoraSingapore, Singapore

Systems Engineer Important Information Location: Singapore Job mode: Contract Job Summary: We are looking for a System Engineer to provide technical support, maintenance, and migration support for our mainframe ecosystem…

Full-time
Business Analyst1 month ago
EncoraSingapore, Singapore

BUSINESS ANALYST Important Information Location: Singapore Essential: Business analyst experience in AML Domain (e.g. Name Screening/CDD/Transaction Monitoring) 10 or more years of banking experience Work with business s…

Full-time
EncoraSingapore, Singapore

Linux with Lotus notes Important Information Location: Singapore Responsibilities: A. Manage and Support of Domino Servers i. Support and troubleshoot mail and server issues, such as mail routing, mail agents and other m…

Full-time
EncoraKuala Lumpur, Malaysia

Day-to-Day Responsibilities The Software Engineer will collaborate with business users, business analysts, project managers, and other stakeholders, assuming responsibility for the successful delivery of projects, system…

Full-time
Project Manager1 month ago
EncoraSingapore, Singapore

PROJECT MANAGER Important Information Location: Singapore Responsibilities: Stakeholder Relationship Management Acts as a trusted advisor for business for all new business demands requiring technology or operations enabl…

Full-time
L2 Java Support2 months ago
EncoraSingapore, Singapore

L2 Java support Important Information Location: Singapore 12 months contract Job Summary We’re hiring an L2 Java Support Engineer to support, monitor, and troubleshoot production Java applications. You’ll act as the brid…

Full-time
EncoraKuala Lumpur, Malaysia

Responsibilities Participate in the end-to-end design, development, and deployment of complex software solutions, leveraging deep proficiency in Java. Collaborate closely with cross-functional teams—product managers, des…

Full-time
SQL DBAJul 31, 2023
EncoraChennai, India

Dear Applicant, Greetings from Encora Innovation Labs! A Leading SaaS Technology Product Engineering Company! Please find the below detailed job description and the company profile for your better understanding. Position…

Full-time
EncoraSingapore, Singapore

SYSTEM ANALYST Important Information Location: Singapore Supporting a strategic transformation programme focused on robotics re-wiring, process redesign, and core banking automation initiatives Will bridge business stake…

Full-time
EncoraSingapore, Singapore

Mainframe Backup Administrator Important Information Location: Singapore Job mode: Contract Job Summary: We are hiring a Mainframe Backup Administrator to manage and maintain the integrity of our mainframe backup and rec…

Full-time
DevOps Engineer1 month ago
EncoraSingapore, Singapore

DevOps Engineer Important Information Location: Singapore Support multiple Agile Release Trains (ARTs) and product teams in onboarding to our internal DevOps platform and curated Azure services Drive the re-platforming/m…

Full-time
EncoraSingapore, Singapore

PMO /Project Admin Important Information Location: Singapore Responsibilities: Manage small changes (CRs) and budget for Innovation Group ring fenced resources. Serve as single point of contact for all of business needs…

Full-time
EncoraSingapore, Singapore

Lead Data & Integration Engineer Important Information Location: Singapore Key Responsibilities1. System Analysis & Design Analyse business/technical requirements and translate them into data flows and integratio…

Full-time
EncoraSingapore, Singapore

Technical Delivery Manager Important Information Location: Singapore Responsibilities: Drive and support the delivery of Private Banking (PB) technology projects, ensuring alignment with business objectives and delivery…

Full-time
EncoraSingapore, Singapore

Senior Backend Developer Important Information Location: Singapore Key Responsibilities Design, develop, and enhance backend services supporting payment processing and transaction switching platforms. Develop and maintai…

Full-time
Test Lead1 month ago
EncoraSingapore, Singapore

Test Lead Important Information Location: Singapore 6 months contract Job Summary We are seeking a skilled and detail-oriented QA Automation Engineer to join our Quality Assurance team. The ideal candidate will have stro…

Full-time
EncoraSingapore, Singapore

Senior Network Engineer – L3 Important Information Location: Singapore 12 months contract Job Summary As a Senior Network Engineer, you will be responsible in providing Tier-3 support for enterprise networks including Ci…

Full-time
EncoraSingapore, Singapore

Data Project Manager (Data PM) Important Information Location: Singapore 12 months contract Job Summary We are seeking an experienced Data Project Manager (Data PM) to lead the successful delivery of data and analytics i…

Full-time
EncoraKuala Lumpur, Malaysia

About the Role We are looking for an experienced AS400 RPG Developer to support and enhance enterprise applications running on IBM i (AS400) platforms. This role involves maintaining legacy systems, developing new featur…

Full-time
EncoraSão Paulo, Brazil

Job Title: L2 Application Support EngineerKey Skills: Java, C, ETL, Shell script.Location: São PauloMode: In-personWe at Coforge are hiring L2 Application Support Engineer with the following skill set.Key Responsibilitie…

Full-time
Cobol Developer5 months ago
EncoraKuala Lumpur, Malaysia

About the Role We are seeking an experienced COBOL Developer to support and enhance legacy systems within a critical enterprise environment. The ideal candidate will have strong experience in mainframe technologies and b…

Full-time
EncoraKuala Lumpur, Malaysia

Key Responsibilities Design, develop, and maintain complex Oracle database applications using PL/SQL. Develop and enhance Stored Procedures, Functions, Packages, Triggers, Collections, Dynamic SQL, Analytical Functions,…

Full-time
EncoraPhilippines

Backend Developer (Node JS) Experience: 3 to 5 years / 5 years & up Job Mode: Contract Work Mode: Hybrid Job Summary As a Software Engineer, you will play a critical role in developing and implementing secure softwar…

Full-time
Developer(317)4 months ago
EncoraKuala Lumpur, Malaysia

Overview:We are looking for an experienced Mainframe Developer (L3) with strong COBOL-based development skills to support banking projects, particularly in cards domain. The role will involve integration work between bac…

Full-time
EncoraSingapore, Singapore

HashiCorp Vault Senior Engineer Important Information Location: Singapore 12 months contract Job Summary We’re hiring a Senior DevOps Engineer with deep expertise in HashiCorp Vault to secure and scale our cloud infrastr…

Full-time
Point72Bengaluru, India

A CAREER WITH POINT72’S TECHNOLOGY TEAM As Point72 reimagines the future of investing, our Technology group is constantly improving our company’s IT infrastructure, positioning us at the forefront of a rapidly evolving t…

Full-time
EncoraBangalore, India

Dear Applicant, Greetings from Encora Innovation Labs! A Leading SaaS Technology Product Engineering Company! Please find the below detailed job description and the company profile for your better understanding. Position…

Full-time
Hyphen Connect LimitedSingapore, Singapore

Est. 65,000 USD

ResponsibilitiesDevelop and optimize backend logic for the company's internal systems.Build efficiency engineering platforms to improve business quality and efficiency through tools and process enhancements.Collaborate w…

Full-time
Senior DBA (SQL)5 months ago
BOLDNoida, Uttar Pradesh, India

BOLD seeks a senior professional to provide support for various MS SQL databases. This person will perform database structure and software maintenance and implementations, support database tuning and consultation, and as…

Full-time