HiringCafe
Save Job
Posted 2mo ago

MS SQL Server Consultant / Database Developer

@ Smartera 3S
View All Jobs
Riyadh, Ar Riyad, Saudi Arabia
OnsiteContract
Responsibilities:designing databases, optimizing queries, implementing security
Requirements Summary:2+ years with Microsoft SQL Server; strong T-SQL, SSIS, data modeling; performance tuning; Bachelor in CS/IT; government/public sector experience preferred.
Technical Tools Mentioned:MS SQL Server, T-SQL, SSIS, SSRS, SSAS, Power BI, SAP BusinessObjects, Azure SQL, Data Warehousing
Save
Mark Applied
Hide Job
Report & Hide
Job Description

We are looking for an MS SQL Server Consultant / Database Developer to support a government entity in Riyadh. This is a 5-month assignment with the potential for extension, where the consultant will work closely with development and reporting teams to design, optimize, and maintain the SQL Server environment supporting business intelligence and operational systems.

Key Responsibilities
  • Design, develop, and maintain MS SQL Server databases, schemas, tables, and data models.
  • Write and optimize T-SQL queries, stored procedures, functions, views, and triggers.
  • Monitor and improve database performance through indexing strategies, query tuning, and execution plan analysis.
  • Support ETL processes by developing and maintaining SSIS packages or similar data integration pipelines.
  • Collaborate with BOBJ and application teams to ensure efficient data delivery for reporting.
  • Implement database security, access control, and data governance practices.
  • Perform database backup, recovery planning, and support high-availability configurations.
  • Troubleshoot data-related issues, perform root-cause analysis, and implement fixes.
  • Prepare and maintain technical documentation for database structures and processes.
  • Ensure compliance with government IT security standards and policies.


Requirements

  • Minimum 2 years of hands-on experience with Microsoft SQL Server (2016 /2019 / 2022).
  • Strong proficiency in T-SQL (joins, CTEs, window functions, and query optimization).
  • Experience in database performance tuning and optimization.
  • Experience with SSIS or other ETL/data integration tools.
  • Solid understanding of relational database design and data modeling.
  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • Strong communication skills with the ability to document clearly and present technical information.
Preferred Qualifications:
  • Microsoft certifications (MCSA / MCSE: Data Management) are a plus.
  • Familiarity with SQL Server Reporting Services (SSRS) and/or Analysis Services (SSAS).
  • Experience supporting BI tools such as SAP BusinessObjects or Power BI.
  • Previous experience working with government or public-sector entities.
  • Knowledge of Azure SQL or cloud-based SQL Server environments.
  • Exposure to data warehousing concepts (e.g., Kimball or Inmon methodologies).