IT Analyst, Operation Support (Must Have Amazon RDS for PostgreSQL

ITCAN PTE. LIMITED; Singapore; On-site; SGD 45,000 - 78,000; Full time

Job summary

ITCAN PTE. LIMITED is seeking an IT Operations professional in Singapore to monitor batch jobs, perform log analysis, and document root causes for future reference.

You will ensure system stability after patching, execute SQL pipelines, and configure new batch jobs following documented guidelines. The role requires a Diploma in CS/IT and 1–3 years of relevant experience, with strong Unix/Linux, SQL, and Jira skills.

Qualifications

• Diploma in Computer Science, Information Technology, or related discipline.
• 1–3 years of relevant experience in IT operations, system administration, or batch job support.

Responsibilities

• Daily Job Health Checks – monitor batch jobs and system processes to ensure stability.
• Log Analysis & Stakeholder Collaboration – extract logs for failed jobs and coordinate with BSAs.
• Knowledge Base Documentation – document failures, root causes and resolutions.
• Post-Patching Verification – verify system stability after monthly server patching.
• Job Execution Support – run SQL pipelines and ad-hoc jobs as requested by BSAs or developers.
• Job Configuration – create properties files and Quartz scheduler flows per guidelines.
• Unix/Linux – use basic Unix commands for checks and file management.
• Project Reporting Support – assist in monthly operational and performance reports.
• Ticket Management & Follow-Up – monitor Jira and follow up on issues with BSAs/PMs.
• Documentation Support – assist in creating SOPs and technical guides.
• Connectivity & Security Operations – perform CFT testing and encryption/decryption tasks.

Skills

Analytical thinking

Communication skills

Detail-oriented

Independent work

Proactive

Time management

Education

Diploma in Computer Science/IT

Tools

Unix/Linux

SQL

Quartz & Cron

CFT

Jira

MS Office

Job description

Job Description

Key Responsibilities

• Daily Job Health Checks – Conduct daily monitoring of batch jobs and system processes to ensure operational stability
• Log Analysis & Stakeholder Collaboration – Extract relevant logs for failed jobs and collaborate with Business System Analysts (BSAs) to discuss failures and coordinate necessary catch-up activities
• Knowledge Base Documentation – Document job failures, root causes, and resolutions to build a comprehensive knowledge base for future reference
• Post-Patching Verification – Verify system stability and job execution following monthly server patching, and coordinate necessary follow-up actions
• Job Execution Support – Execute SQL pipelines and ad-hoc jobs as requested by BSAs or developers, following provided instructions and procedures
• Job Configuration – Configure new batch jobs by creating properties files and Quartz scheduler flows based on standard documentation and guidelines provided by BSAs
• Unix/Linux – Possess working knowledge of fundamental Unix commands for system checks, file management, and operational tasks
• Project Reporting Support – Assist project teams in preparing monthly operational and performance reports
• Ticket Management & Follow-Up – Monitor Jira tickets and proactively follow up with BSAs and Project Managers (PMs) on outstanding issues and service requests
• Documentation Support – Assist in creating and maintaining operational documentation, standard operating procedures (SOPs), and technical guides etc as required
• Connectivity & Security Operations – Perform Controlled File Transfer (CFT) connectivity testing, execute encryption and decryption processes using tools such as SLIFT and PGP, and support cutover activities for connectivity configurations

Qualifications

Education & Experience

• Diploma in Computer Science, Information Technology, or related discipline
• 1–3 years of relevant experience in IT operations, system administration, or batch job support

Technical Skills

• Operating Systems: Working knowledge of Unix/Linux commands and basic system administration
• Database: Familiarity with SQL and database operations
• Job Scheduling: Understanding of job scheduling tools (e.g., Quartz, Cron)
• File Transfer: Experience with secure file transfer protocols and CFT operations
• Ticketing Systems: Proficiency in Jira or similar incident/request management tools
• MS Office: Competent in Excel, Word, and PowerPoint for reporting and documentation

Soft Skills

• Strong analytical and problem-solving abilities
• Good communication skills (written and verbal) for stakeholder engagement
• Detail-oriented with ability to document processes clearly
• Ability to work independently and collaboratively within a team
• Proactive, resourceful, and result-oriented with a "can-do" attitude
• Good time management skills and ability to handle multiple priorities

Preferred Qualifications

• Knowledge of ITIL processes (Incident, Problem, Change Management)
• Experience with encryption/decryption tools and security protocols
• Familiarity with batch processing frameworks and automation tools
• Understanding of system patching and maintenance procedures