- Reporting Solutions Development (Primary Responsibility)
- Design, develop, deploy, and maintain reports using SQL Server Reporting Services (SSRS).
- Convert business requirements into functional and user-friendly reports.
- Develop and optimise report datasets, parameters, subscriptions, and report scheduling.
- Produce operational, management, financial, regulatory, and ad-hoc reports.
- Troubleshoot report performance and optimise data retrieval efficiency.
- Work directly with stakeholders to gather and analyse reporting requirements.
- Ensure report accuracy, consistency, and timely delivery. Database Development & Support
- Develop and maintain Microsoft SQL Server database objects including:
- Stored Procedures, Functions, Views, Triggers.
- Create and optimise T-SQL scripts to support reporting and integration requirements.
- Perform query analysis and performance tuning.
- Support production database troubleshooting and issue resolution.
- Monitor and support SQL Server Agent jobs.
- ETL & Data Integration
- Develop and maintain ETL processes using SQL Server Integration Services (SSIS).
- Support data extraction, transformation, and loading activities.
- Develop and maintain system interfaces and integration processes.
- Perform data validation and reconciliation across source and target systems.
- Troubleshoot integration and data transfer issues. Automation, Secure File Transfer & Encryption
- Develop operational and monitoring scripts using PowerShell.
- Support automated file transfers via SSH/SFTP.
- Support data encryption and decryption processes using PGP/GPG.
- Automate reporting and file processing activities.
Pay: RM7,000.00 - RM9,000.00 per month
Benefits:
- Opportunities for promotion
- Professional development
Work Location: Hybrid remote in Cyberjaya