Bachelors Degree in Computer Science or Information
5 of relevant working experience; Years
A minimum of Bachelor Degree in Computer Science or Information Technology with at least 5 years of relevant working experience; With a formal certification in Microsoft products database administration and development; Experience of working with Structured Query Language (SQL) & coding; Experience in Data Warehouse development and SQL Server Integration Services development (SSIS) and SQL Server Reporting Services development (SSRS) is highly preferred; Deep understanding of MS SQL RDBMS and Reporting functions; Experience in database design; Knowledge of structured query language (SQL), e.g. SQL/PSM or Transact-SQL General understanding of distributed computing architectures, e.g. Client-server model, multi-tier models in addition to Windows; Knowledge of storage technologies and networking; Knowledge of routine maintenance, recovery, and handling failover of a database; Possesses exceptional communication skills, including being able to explain key technical information to non-technical staff; Knowledge in designing, developing, and implementing data warehouse and business intelligence solutions with Microsoft SQL Server and Reporting Services (ETL-Extract, Transform and Load), SSIS - SQL Server Integration Services, Data warehousing, OLAP Cubes); Development experience with languages such as VB.Net, .NET 4.0, C#, and reporting tools, such as Microsoft SQL reporting Services (SSRS) including stored procedures/functions; Strong knowledge of T-SQL and database programming; and Strong organization and interpersonal skills
This position reports to the IFMS Director.
Duties & Responsibilities
The Sr. DBA and Data Warehousing Specialist will work under the direct supervision of the IFMS Director, and the overall guidance of the Synergy International Systems and SHAHAR Management. The incumbent will be assigned to contribute to the development of IFMS application, as well as the implementation in the targeted municipalities (14 municipalities) and Deputy Ministry of Municipalities (DMM).
Objective and Duties:
The Sr. DBA and Data Warehousing Specialist will be responsible for the IFMS database design and integration analysis, requirements gathering, design of reporting tools, design of new modules, communication system design, ensuring database performance, data security, integrity, backup and recovery, verifying accuracy of data, and maintaining and supporting the data warehouse. His/her responsibility will include:
System architecture design and system analysis of IFMS current modules;
Participation in the development of IFMS new modules;
Develop & integrate MS SQL databases for IFMS current modules;
Enhance and further development of the IFMS reporting interface;
Developing technical documents as required;
Ensuring the system is designed and developed according to accepted international standards;
Propose system design based on the Software Requirement Specifications (SRS);
Develop Use Cases and other UML diagrams;
Ensure the integration of the systems is reflected in the design.
Error and issue troubleshooting;
Ensure database performance across the distributed system implementing new releases and completing required maintenance;
Identifying database requirements by interviewing beneficiaries, analyzing applications, current programming and operations;
Recommending solutions by defining database structure and functional capabilities, database security, data back-up, and recovery specifications;
Designing, implementing and supporting data warehousing;
Implementing business rules via stored procedures, middleware, or other technologies.
Responsible for verifying accuracy of data, and maintaining and supporting the data warehouse;
Creating best practices for data loading and extraction;
Developing data architecture, data modeling, and mapping solutions within structured data warehouse environment;
Develop reporting applications and data warehouse consistency;
Develop and implement ETL routines according to the DWH design and architecture;.
Support the development and validation required through the lifecycle of the DWH and, and provide adequate security for data warehouse;
Monitoring of the DWH system performance and integrity provide corrective and preventative maintenance as required.
To apply: please send your updated CV & cover letter to the below mentioned email address and include Sr. DBA and Data warehousing Specialist in the subject line. application without subject line will not be considered.