As an Associate IT Officer (Database & ERP), you will be the SQL Server, Azure SQL, and Power BI Administrator is responsible for managing on-premises SQL Server databases, cloud-based Azure SQL (SQL Server PaaS), and Power BI reporting and analytics environments. This role ensures seamless data integration, performance optimization, security, and user access across these platforms to support organizational data management and business intelligence needs.
Install, set-up, manage MS SQLSERVER instances on-premises or in virtualized environments
Manage MS SQL Server security, including user permissions, roles, and encryption
Setup and manage backup/recovery procedures for SQL Server on-premises, MS SQL Server in Azure Virtual Machines (VM) and MS SQL Server PaaS
Provide support to multiple applications which uses MS SQL Server such as Enterprise Project Management server, Forex, Helpdesk, Cafeteria POS, and others
Optimize database performance through indexing, query tuning, and resource monitoring
Apply patches, updates, and upgrades to ensure system reliability and compliance
Deploy and manage Azure SQL Database (SQL Server PaaS) and SQL Server on Azure VMs
Improve Azure SQL Database (SQL Server PaaS) performance using tools like Azure Monitor and SQL Analytics
Administer Power BI service (cloud) and Power BI Report Server (on-premises)
Manage workspaces, datasets, dataflows, and report publishing processes
Configure data gateways for secure connectivity between on-premises SQL Server, Azure SQL and other data sources with Power BI
Monitor usage, performance, and license compliance using Power BI Admin Portal and audit logs
Troubleshoot connectivity issues between data sources and Power BI dashboards/reports
Qualifications:
You will need:
Bachelors degree in Information Systems Management, Computer Science, Mathematics, Engineering or relevant fields. Preferably with advanced training in database administration
At least 5 years of relevant professional experience in MS SQL & Power BI Admin
Experience in the administration, installation, maintenance and tuning of MS SQL Server (2000, 2005, 2008, 2008 R2, 2012, 2014, 2016, 2022)
