IBM Optim Specialist
- Hiring from
- Philippines
- Work type
- Remote
- Posted
627,506 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Avensys is a reputed global IT professional services company headquartered in Singapore. Our service spectrum includes enterprise solution consulting, business intelligence, business process automation and managed services. Given our decade of success we have evolved to become one of the top trusted providers in Singapore and service a client base across banking and financial services, insurance, information technology, healthcare, retail and supply chain.
We are seeking for IBM Optim Specialist Position
Position Details:
Job Type: 3 Months extendable contract with our client (payroll Avensys)
Location: Remote, Philippines
Timings : Regular working hours
Yrs of Exp: 10+ years of relevant experience
Job Description
Responsibilities:
- Source analysis: review the Optim Directory (DB2) and archive file registrations; produce the inventory of archive files, applications, schemas and tables, including empty and same-named tables.
- Convert set-up: configure Optim 11.3 Convert Requests for CSV output: delimiters, string delimiter, null marker, escape character, header row, file-size limit, LOB and XML columns as separate files, and archive metadata columns.
- Automation: script Convert runs from the command line (PR0CMND) on the Linux Optim server, in batches by archive file or table group, with process reports captured for every run.
- Data fidelity: confirm code page and special-character handling, timestamp precision (milliseconds and finer), decimal scale, and CLOB, BLOB and XML output.
- Large files: split and tune Convert runs for large archive files (up to 46 GB) and LOB-heavy tables, within the memory and disk limits of the Optim server and off-hours windows.
Requirements:
- Experience: around 10 years in data management, archiving or data migration, with at least 5 years hands-on with IBM InfoSphere Optim Archive (distributed platforms, preferably version 11.x).
- Optim Convert: proven delivery exporting Optim archive (.AF) files to CSV at scale, across hundreds of files and thousands of tables, including LOB and XML columns.
- Optim administration: Optim Directory, Access Definitions, archive file registration and maintenance, Convert and Extract Requests, process reports and audit records.
- Command line: running and scheduling Optim processes with PR0CMND, parameter and override files.
- SQL: DB2 SQL against the Optim Directory; working knowledge of SQL Server and DB2 data types.
- Linux: shell scripting, file handling and monitoring of long-running batch jobs.
- Reconciliation: experience proving completeness of an extraction with row counts, file inventories and exception logs.
- Independence: able to resolve Optim issues without relying on IBM support; clear written and spoken English.
WHAT’S ON OFFER:
You will be remunerated with an excellent base salary and entitled to attractive company benefits. Additionally, you will get the opportunity to enjoy a fun and collaborative work environment, alongside a strong career progression.
To submit your application, please apply online or email your UPDATED CV in Microsoft Word format to uma@aven-sys.com. Your interest will be treated with strict confidentiality.
CONSULTANT DETAILS:
Consultant Name : Uma
AvensysConsultingPteLtd
Privacy Statement: Data collected will be used for recruitment purposes only. Personal data provided will be used strictly in accordance with the relevant data protection law and Avensys' privacy policy.
