System Analyst

Add expected salary to your profile for insights
Scripting and Scheduling:Write SQL scripts to create stored procedures, streamlining various database tasks and processes through automation.
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:Ensure data completeness from multiple sources coming into SFTP.
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 their challenges.
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 and possess own transport.#J-18808-Ljbffr