Total 816 Full-time Others database administrator job vacancies

支援銷售團隊並確保高效的銷售流程。

A) 主要職責

• 訂單處理：輸入、核實和管理客戶訂單，確保價格、產品詳情和交貨時間表的準確性。
• 客戶支援：作為客戶諮詢的主要聯絡人，負責處理訂單狀態、交貨和帳單問題。
• 資料庫管理：維護和更新客戶記錄和CRM系統，以確保資料完整性。
• 協調：與物流、財務和行銷等內部部門合作，以確保及時完成訂單和順利營運。
• 文件整理：整理合約、發票、報價單和其他銷售相關文件，以便進行記錄和審計。

B) 必備技能和資格

• 注重細節：確保訂單、報告和客戶記錄的準確性。
• CRM和軟體熟練程度：具備客戶關係管理系統和銷售軟體的使用經驗。
• 問題解決能力：能夠解決與銷售流程或客戶服務相關的問題。
• 團隊合作與適應能力：與銷售團隊有效協作，並適應不斷變化的優先事項。

C) 職業級別

• 初級銷售管理員：主要負責基本訂單輸入、客戶諮詢和記錄維護。
• 高階銷售主管：負責處理複雜的客戶問題、銷售報告，並可能領導流程改善或協調大型專案。

福利待遇

• 附近公共交通
• 醫療保險
• 個人休假
• 有薪培訓和發展

Job Description

• Oversee and coordinate daily activities within the Sales Department, including preparing quotations, tenders, sales agreements/orders, and sales reports.
• Manage pre-sales processing tasks, organize and file important documents, and relay relevant information to sales managers and team members.
• Create and maintain Product IDs for new and existing products in the system
• Update and manage product prices in the database, ensuring accuracy and consistency.
• Manage end-to-end billing and order processing, including preparation of delivery orders, invoices, internal transfers, and rental/loan agreements.
• Take detailed sales meeting minutes, track and follow up on action points discussed during meetings to ensure timely completion of assigned tasks.

Job Requirements

• Bachelor’s degree in Business Administration or equivalent.
• Fresh graduates are encouraged to apply.
• Exposure to tender preparation, pre- and post-sales support will be an added advantage.
• Possession of own transportation (car)
• Working location: Shah Alam, Selangor

Perks & Benefits

• Employee equity
• Free snacks / Happy hours
• Free parking
• Regular team activities
• Company trips
• Medical insurance
• Open culture
• Personal development opportunities

職位描述

• 監督和協調銷售部門的日常活動，包括準備報價、投標、銷售協議/訂單和銷售報告。
• 管理售前處理任務，整理歸檔重要文件，並將相關資訊傳遞給銷售經理和團隊成員。
• 在系統中建立和維護新產品和現有產品的產品 ID。
• 更新和管理資料庫中的產品價格，確保準確性和一致性。
• 管理端到端的計費和訂單處理，包括準備出貨單、發票、內部轉帳和租賃/貸款協議。
• 詳細記錄銷售會議紀錄，追蹤並跟進會議中討論的行動要點，以確保及時完成分配的任務。

職位要求

• 工商管理學士學位或同等學歷。
• 歡迎應屆畢業生申請。
• 具備投標準備、售前和售後支援方面的經驗將是一項優勢。
• 擁有自己的交通工具（汽車）
• 工作地點：雪蘭莪州莎阿南

福利待遇

• 員工權益
• 免費小吃/歡樂時光
• 免費停車
• 定期團隊活動
• 公司旅行
• 醫療保險
• 開放文化
• 個人發展機會

• Position: Warehouse Administrator (Operations).
• Position type:Permanent;Full-time.
• Salary: RM 2000-2800.
• Job location: Westport CFS-2, Pulau Indah;North Port, Port Kelang, Selangor.

The hiring company

This is a integrated transport and logistics company, providing international freight forwarding and logistics services across Asia, Australia and Europe/America continents. Currently they have several job openings in the operations works at their warehouse facilities at the North Port and West Port in Port Klang area. They are looking for experienced warehouse workers to undertake the warehouse operations functions at their Container Terminal at North Port (NDSB) and West Port in Port Klang.

The vacancies are permanent positions and form part of the warehouse operations team to manage the cargo/shipments that have have been imported or to be exported.

About the job

This role/job will be warehouse based and therefore not in a conventional office environment. This is a full-time permanent position and the role is primarily to help facilitate the smooth running of the warehouse operations activities.

The general duties will involve the following role:

*Perform cargo loading and unloading.

*To perform physical counts, tally and surface inspection of cargo upon receiving/delivery.

*To store cargoes in proper location assigned within the warehouse.

*To perform cargo issuance.

*Picking, packing and dispatch of cargo according to ownership and destinations.

Requirements

*Malaysians in age group 25-40.

*Punctual with positive work ethic.

*Physically fit with ability to lift and carry.

*Minimum qualification: SPM or Diploma in Supply Chain/Logistics Management or Business.

*Forklift license will be ideal, useful and beneficial.

*The ideal candidate for this role should be someone well organized with 2-3 years experience in warehouse operations, picking and packing ,customer services or similar environment preferred, and have the ability to communicate effectively with the team and customers.

*2-3 years of previous warehouse operations, especially in 3PL facility has a huge advantage and will be highly regarded.

*Hands on and hardworking with knowledge of both warehouse and logistics practices.

*Proficient with ability to communicate in Bahasa Malaysia and English.

Candidates who wish to be considered for this role must be willing to be based within warehouse environment and have own means of transport to be accessible to North Port/West Port area.

APPLICATION TO THIS JOB

Interested candidates are hereby invited to apply by forwarding a copy of your resume for our review. You may apply online via JOBSTORE by clicking the apply button to submit your application. Alternatively, candidates may forward their resume directly to us at CHRISJAC via our E-mail at jobs@chrisjac.com.my 

NOTE: Applicants for this job are encouraged to submit resume in Word format stating the essential following information:

*Personal bio-data (Gender/Sex & Age,Marital status,residential address).

*Valid contactable telephone number.

*Employment/Work history.

*Salary; current/last drawn.

[Policy of free job placement for job seekers]

Yes, it is absolutely free to job applicants. Chrisjac does not impose any charges or fees to candidates who apply jobs under our recruitment services. Please do not provide your bank or payment details when apply jobs listed under Chrisjac Recruitment.

Perks & Benefits

• Casual dress code
• Personal leave
• Open culture

• 職位：倉庫管理員（營運）。
• 職位類型：永久；全職。
• 薪資：2000-2800 馬幣。
• 工作地點：西港CFS-2，英達島；北港，巴生港，雪蘭莪。

招募公司

這是一家綜合性運輸物流公司，業務遍及亞洲、澳洲和歐洲/美洲，提供國際貨運代理和物流服務。目前，該公司在巴生港北港和西港的倉庫設施有多個營運職位空缺。他們正在尋找經驗豐富的倉庫工人，負責巴生港北港（NDSB）和西港貨櫃碼頭的倉庫運作工作。

這些空缺職位均為長期職位，隸屬於倉庫營運團隊，負責管理已進口或即將出口的貨物/貨運。

關於這份工作

此職位的工作地點在倉庫，而非傳統的辦公室環境。這是一份全職永久職位，主要職責是協助倉庫營運活動的順利進行。

主要職責包括以下內容：

*進行貨物裝卸作業。

*對收貨/交貨貨物進行實物清點、統計和表面檢查。

*將貨物存放於倉庫內指定的適當位置。

*執行貨物簽發。

*根據所有權和目的地進行貨物揀選、包裝和發貨。

要求

*馬來西亞25-40歲年齡層的人。

*守時，工作態度積極。

*身體健康，能夠舉起和搬運重物。

*最低學歷要求：SPM 或供應鏈/物流管理或商業文憑。

*擁有堆高機駕駛證將是理想、實用且有益的。

*該職位的理想候選人應具備良好的組織能力，有2-3年倉庫營運、揀貨包裝、客戶服務或類似環境的工作經驗者優先，並能夠與團隊和客戶進行有效溝通。

*擁有2-3年倉庫營運經驗，尤其是在第三方物流設施方面，將具有巨大的優勢，並會受到高度重視。

*具備實務精神和勤奮的工作態度，熟悉倉儲和物流運作流程。

*精通馬來語和英語，具備良好的溝通能力。

有意應徵此職位者必須願意在倉庫環境中工作，並擁有自己的交通工具以便前往北港/西港地區。

申請這份工作

有意者請將履歷寄至我司審核。您可透過JOBSTORE線上申請，點選「申請」按鈕提交申請。您也可以將履歷直接寄至我司信箱jobs@chrisjac.com.my。

注意：申請此職位者請提交Word格式的履歷，履歷中需包含以下基本資訊：

*個人履歷（性別/性取向、年齡、婚姻狀況、居住地址）。

*有效的可聯絡電話號碼。

*工作/就業經驗。

*薪資；目前/最近一次領取的薪資。

[提供求職者免費就業安置政策]

是的，求職者完全可以免費使用我們的服務。 Chrisjac 不會向透過我們招募服務申請職位的候選人收取任何費用。請勿在申請 Chrisjac Recruitment 發布的職位時提供您的銀行或付款資訊。

福利待遇

• 休閒著裝要求
• 個人休假
• 開放文化

EssentialR esponsibilities:

·      Responsible for daily business support and 4x capacity guarantee for global and local financial-level storage components (SLA < =99.99%, RTO < = 5mins, RPO = 0, Delay < 100ms), and propose improvement suggestions for high-risk changes and repetitive inefficiencies, and promote implementation

·      Responsible for global and local station financial-level storage components and overall architecture risk identification and hidden danger governance (including but not limited to: effectively blocking big key/showSQL hidden dangers generated by function iteration; identifying and governing scenarios with strong data dependence on Redis, discovering and governing unreasonable architecture design behind abnormal alarms).

·      Responsible for storing component (MySQL/Redis) size version, security patch upgrade (RTO < = 2mins, RPO = 0, efficiency = 3.5person-days/cluster), ensuring smooth business upgrade, and effective emergencyrollback in abnormal scenarios (RTO < = 5mins).

·      Responsible for version planning of storage components(MySQL/Redis/TiDB/Doris/ES/MongoDB), software risk identification (BUG type),architecture risk identification (compatibility with availability zone failures), hardware risk identification (affinity), and promoting cloud vendors and architecture teams to schedule and govern hidden dangers

·      Responsible for continuously iterating storage component (MySQL/Redis/TiDB/Doris/ES/MongoDB) standard construction, cost governance standard construction, and implementing new standards management platform and inspection platform

·      Responsible for the design and development of daily database requirements for the database management platform (Golang)

Job requirements

·      Strong execution ability ensures high-quality and no-delay delivery of business requirements (following the change process and implementing the double check mechanism for program guarantee), and good team collaboration ability

·      Strong stress resistance and open-mindedness, calmly think about the root causes and solutions when facing difficulties or bottlenecks, actively report bottlenecks, give reasonable suggestions, and actively promote problem-solving

·      Master Degree/Degree holder with more than 8 years of full-time DBA work experience in top companies in the financial and internet industries, with practical experience in massive databases (cluster > 800,data > TB level), and experienced large-scale activities and market traffic shocks(at least > 5 times the daily traffic).

·      Proficient in MySQL/Redis system principles and architecture design capabilities, proficient in AWS cloud technology stack(VPC/AuroraRDS/Valkey/OpenSearch) risk identification and standard specification design to ensure business usage storage SLA > 99.99%.

·      Proficient in TiDB/Doris/ES (choose one) distributed database principle system (data > 0.5PB), skilled in identifying component hidden dangers and sorting out standard specifications, providing core technical indicators (SLA, PTO, RPO) and pushing component design and planning capabilities for business line use, ensuring that the storage SLA for business use is > 99.90% (for business stability requirements > 99.9%, effective emergency plans need to be aligned as a whole).

·      Experience in Golang backend development is preferred

All Successful candidates can expect a very competitive remuneration package and a comprehensive range of benefits.

Alternatively, you may wish to email your resume in a detailed Word format to debbie@peopleprofilers.com

We regret that only shortlisted candidates will be notified

People Profilers Pte Ltd, 20 Cecil Street, #08-09 PLUS Building, Singapore 049705

 Tel: 69509748

http://www.peopleprofilers.com

debbie@peopleprofilers.com

Consultant in charge: So Boon Shyen, Debbie

EA Licence Number: 02C4944

Registration Number: R1111376

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

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

5+ years of experience as a Database Administrator or database engineer.

• Strong experience with relational databases such as Microsoft SQL Server, PostgreSQL, Oracle, MySQL, or equivalent.

• Good understanding of database design, SQL, indexing, stored procedures, backup, recovery, and performance tuning.

• Experience supporting enterprise applications across multiple environments.

• Experience with data migration, ETL, bulk loading, and data validation is advantageous.

• Good understanding of database security, access control, audit logging, and secure configuration.

• Experience with cloud-based databases or managed database services is advantageous.

• Strong troubleshooting, analytical, and communication skills.

• Able to work with developers, infrastructure teams, data teams, and business stakeholders.

• Degree or Diploma in Information Systems, Computer Science, Engineering, or a related discipline

Responsibilities:

• Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards
• Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements
• Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns
• Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments
• Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools
• Providing guidance to application developers on DB2best practices, coding standards, and efficient query writing techniques 
• Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation

Requirements:

• Strong background in IT, Computer Science /Computer Engineering, or related discipline
• Minimum 8 years of relevant working experience in DB2 database administration is preferred.
• Relevant experience in the following would be advantageous:

1. Working with JCL (Jon Control Language)
2. Understanding of VSAM and other mainframe storage concepts
3. Familiar with database utilities and tools
4. Experience with database backup and recovery procedures

Role Summary

Responsible for design, deployment, and operational management of database platforms across AWS, Microsoft Azure, and on-premises environments, covering both project implementation and day-to-day BAU operations.

Key Responsibilities

• Experience in Design and deploy Microsoft SQL Server solutions on Azure (Azure VM, SQL MI, Azure SQL Database), AWS (EC2, RDS) and on-premises Microsoft SQL Server environments
• Hands on with Database Administration tasks monitoring, patching, upgrades, and configuration management across all platforms
• Manage native Microsoft SQL Server backups (full, differential, transaction log) and cloud-native backup solutions including Azure Backup for Microsoft SQL VMs and Azure SQL MI
• Configure and maintain LTR (Long-Term Retention), PITR (Point-in-Time Restore), and YTR (Yearly Retention) policies aligned to data retention and compliance requirements
• Manage TDE (Transparent Data Encryption) certificate lifecycle — creation, backup, rotation, and secure escrow — across on-premises, EC2/Azure VM, and managed cloud database services
• Conduct regular restore tests and DR drills, maintaining documented RTO/RPO targets
• Manage database security including logins, RBAC, auditing, Azure Key Vault integration for customer-managed keys (CMK), and SQL Server Audit configuration
• Perform query tuning, index management, and performance analysis using Query Store, Extended Events, AWS Performance Insights, and Azure SQL Intelligent Insights
• Automate routine DBA tasks using T-SQL and PowerShell, support database deployments
• Meet Security Compliance with Hardening Baselines, Auditor-General's Office (AGO), IM8 (Instruction Manual 8) and Vulnerability Management
• Provision and manage cloud database infrastructure using Terraform, ARM templates, or Bicep
• Create and maintain technical documentation including architecture design, runbooks, and SOP documents
• Thrives in a fast-paced, rapidly evolving cloud environment, adapting quickly to shifting priorities, new technologies, and changing business requirements
• Effectively manages multiple concurrent workloads balancing implementation projects, BAU operations, and incident response with the ability to context-switch seamlessly across teams and platforms
• Collaborate with various Application Project Managers, development teams, participate in on-call rotation for critical Database incident response, and deliver root cause analysis
• Possesses strong verbal and written communication skills, with the ability to convey complex technical concepts clearly to both technical peers and non-technical stakeholders
• Demonstrates strong self-organisation and the ability to independently plan, prioritise, and execute database engineering tasks with minimal supervision

Technical Skills Required

• Azure: SQL Server on Azure VM, Azure SQL MI, Azure SQL Database, Elastic Pools, Failover Groups, Geo-Replication, Azure Monitor, Azure Defender for SQL
• AWS: SQL Server on EC2, RDS for SQL Server, Multi-AZ, EBS storage, CloudWatch, IAM, Secrets Manager
• On-Premises: SQL Server 2016–2022, Always On AG, FCI, Log Shipping, SQL Server Agent
• Backup & Recovery: Native SQL backup, Azure Backup, LTR/PITR/YTR, Veeam/Commvault (advantageous)
• Security: TDE certificate management, Azure Key Vault (CMK), Dynamic Data Masking, Always Encrypted, Row-Level Security
• Scripting & Automation: T-SQL, PowerShell (essential); Python, Terraform, ARM/Bicep, Git (advantageous)

Technical Certifications

• Preferred: DP-300 (Administering Relational Databases on Microsoft Azure), DBS-C01 (AWS Certified Database Specialty)
• Advantageous: AZ-104 (Microsoft Azure Administrator), AWS SAA-C03 (AWS Certified Solutions Architect – Associate)

Experience & Education

• 7+ years database administration/engineering experience
• 4+ years managing cloud-hosted databases on AWS or Azure
• Degree in Computer Science, IT, or related field; equivalent experience considered

Key Responsibilities

• Administer and maintain IBM DB2 databases on z/OS platforms, ensuring high availability, performance, and operational stability of business-critical applications.

• Perform database performance monitoring and tuning activities, including SQL optimization, access path analysis, buffer pool tuning, tablespace management, RUNSTATS, REORG, COPY, and other DB2 utility operations.

• Review, analyse, and optimise complex SQL statements developed by application teams to improve query efficiency, reduce resource consumption, and meet performance service levels.

• Design and implement database objects including tablespaces, databases, tables, indexes, views, aliases, and referential integrity structures to support application development and enhancement initiatives.

• Troubleshoot and resolve database-related incidents involving SQLCODE errors, locking and concurrency issues, deadlocks, database object failures, storage constraints, and application performance degradation.

• Support database change implementation activities throughout the Software Development Life Cycle (SDLC), including object creation, schema modifications, migration planning, deployment validation, and production releases.

• Execute database backup, recovery, restoration, and disaster recovery procedures to ensure data protection and business continuity requirements are met.

• Manage database capacity planning activities by monitoring storage utilisation, growth trends, and system resource consumption to support future business demands.

• Collaborate with application development, infrastructure, and support teams to provide technical guidance on DB2 database standards, SQL coding best practices, and performance optimisation methodologies.

• Support testing activities by performing database refreshes, data extraction, data masking, test data preparation, and database validation during SIT, UAT, and production implementation cycles.

• Maintain database security controls, user access management, and audit compliance requirements in accordance with organisational policies and regulatory standards.

• Prepare and maintain operational documentation, database configuration records, recovery procedures, technical runbooks, and support knowledge repositories.

Requirements

• Degree in Computer Science, Information Technology, Computer Engineering, or a related discipline.

• Minimum 8 years of hands-on experience administering IBM DB2 databases in large-scale enterprise or mainframe environments.

• Strong expertise in DB2 for z/OS administration, performance tuning, database monitoring, SQL optimisation, backup and recovery processes.

• Proven experience with DB2 utilities including RUNSTATS, REORG, COPY, LOAD, UNLOAD, CHECK utilities, and database maintenance activities.

• Experience supporting database deployments and migrations across Development, SIT, UAT, and Production environments.

• Strong understanding of IBM Mainframe technologies including JCL (Job Control Language), VSAM datasets, catalog management, and storage concepts.

• Experience with database performance analysis tools, monitoring solutions, and incident management processes.

• Knowledge of disaster recovery planning, database restoration procedures, and business continuity practices.

• Familiarity with change management, release management, and IT service management processes.

• Strong analytical, troubleshooting, and problem-solving skills with the ability to diagnose complex database and application performance issues.

• Excellent communication skills with the ability to collaborate effectively with application development, infrastructure, and business stakeholders.

Job Description & Requirements

Job Responsibilities:

• Address and resolve database incidents promptly to minimize downtime.

• Monitor events, handle alerts, and manage database outages to restore services quickly.

• Process service requests for database changes and enhancements.

• Perform root cause analysis to prevent recurring database issues.

• Support the implementation of standard and custom database builds.

• Provide operational support for HANA and MS-SQL databases.

• Ensure adherence to backup and recovery processes.

• Optimize database performance and manage alert monitoring.

• Decommission systems/servers following proper protocols as needed.

Job Requirements:

• Bachelor’s degree or equivalent in Computer Science or related field

• Strong experience with HANA and MS-SQL databases.

• 2 - 5 years of experience in database administration, with a focus on HANA, MS-SQL and Oracle

• Bachelor's Degree / Diploma in Computer Engineering or any related field.

• Proficiency in RDBMS management and administration.

• Knowledge of backup, recovery, and decommissioning processes.

• Experience in incident management and database performance optimization in a 24x7 environment.

• Experience managing database outages and coordinating effective recovery.

• Familiarity with alert monitoring and performance optimization.

• Strong problem-solving and troubleshooting abilities.

• Ability to work under pressure in a 24x7 support environment.

• Effective communication skills for incident and service request management.

• Prior experience in 24x7 operational support.

• Willing to Learn SAP HANA

Job Scope

You will be providing support for the following areas:

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

d) Possesses good communication and interpersonal skills

e) Have good command of written and oral English

f) Must be able to work beyond business hours including weekend when necessary

Responsibilities:

• Reviewing and optimising SQL queries written by application developers to ensure optimal performance and adherence to database standards
• Assisting in database design activities, including table structures, indexes, and relationships to support new application features or enhancements
• Troubleshooting database-related issues reported by application teams, including SQL error codes, performance problems, and data integrity concerns
• Supporting database changes through the development lifecycle (DEV, TEST, UAT, PROD), including coordinating database object migrations between environments
• Monitoring application database performance and implementing necessary tuning measures like reorganising tablespaces, updating statistics, and adjusting buffer pools
• Providing guidance to application developers on DB2best practices, coding standards, and efficient query writing techniques 
• Supporting application testing activities by helping with data refresh requests, test data preparation, and database-related test case validation

Requirements:

• Strong background in IT, Computer Science /Computer Engineering, or related discipline
• Minimum 8 years of relevant working experience in DB2 database administration is preferred.
• Relevant experience in the following would be advantageous:

1. Working with JCL (Jon Control Language)
2. Understanding of VSAM and other mainframe storage concepts
3. Familiar with database utilities and tools
4. Experience with database backup and recovery procedures