Duties & Responsibilities

• Database Automation:
• Write SQL scripts to create stored procedures, streamlining various database tasks and processes through automation
• Scripting and Scheduling:
• Develop SQL, PowerShell, DOS, Python scripts for scheduled tasks, enhancing operational efficiency and task automation. Implement best practices for automation and job scheduling to improve overall database system efficiency
• Report Automation:
• Utilize SQL scripting to automatically generate and distribute reports to end-users, ensuring the punctual and precise delivery of critical data.
• SFTP data integration:
  
• data from multiple sources coming into sftp, and ensuring their data completeness.
• SQL Server Agent Job Management:
• Create, schedule, and manage SQL Server Agent jobs to automate routine database maintenance, backups, and data transformation tasks.
• Monitor job execution, troubleshoot failures, and ensure timely completion of critical database operations
• User Access Management:
• Create, modify, and revoke user access to SQL Server databases using SQL Server Management Studio (SSMS).
• Implement security best practices to ensure data confidentiality and integrity
• User Collaboration:
• Collaborate with users to comprehend their requirements, analyze their needs, and devise effective solutions to address theirchallenges.

Job Requirements

• Bachelor's Degree/Post Graduate Diploma/Professional Degree in Information Technology.
• Minimum of 3 years of working experience in ERP implementation, configuration, system design, or related business experience.
• Strong understanding of ERP software/systems, preferably MS Dynamics.
• Proficient in Excel, PowerPoint, Outlook, and Word.
• Possess excellent English writing and verbal communication skills.
  
• Willing to work in office based at Bukit Jelutong, Shah Alam

Back Apply