Description The proposed position will be for a member of a managed services technical team, which is responsible Data Base Administration, functions and services related issues (operations, 3rd & 2nd level support). The engineer will be working in a group of IT experts locally and within multiple projects to cover the required services functionalities and availability.
Role and Responsibilities
Requires travelling based on work needs, when not on site, Engineers will be assisting in the development of project plans, designs and documentation for future sites.
Up to 5 years’ experience in administering Microsoft SQL server databases.
Experience in building databases.
Ability to deal with different operating systems (Microsoft-Linux-HP unix4).
Experience in dealing with servers & backup devices.
Experience in Database Management (SQL, MongoDB, PostgreSQL)
Experience in Database Development (SQL, MongoDB, PostgreSQL)
Extensive experience writing T-SQL and stored procedures and query tuning on high transaction.
Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Experienced in ETL (Extract-Transform-Load) development / data integration.
Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
Experience in SQL server profiler for monitoring and troubleshooting database activity and performance.
Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies.
Knowledge of other databases like MySQL, No SQL databases and In-memory databases.
Monitor and analyse database performance and ensure effective and efficient utilization of database systems/processes.
Organizing and managing the database archiving process.
Ability for planning and implementing Backup and recovery for database.
Ability to specify the required resources such as storage media space and memory size and recommend updating or modifying them based on performance.
Build data infrastructure such as tables and indexes by communicating with the development team.
Impalement security and encryption.
Create shell scripts for task automation.
Analyse, consolidate and tune database for optimal efficiency.
Monitor database performance and solve its issues.
Monitor database users and ensure from efficiency of the permissions.
Develop database utilities and automated reporting.
Design and document database architecture & Data Modelling.
Design Data Warehousing (SSAS, Azure Data Factory) and Business Intelligence platform.
Bachelor’s degree in computer engineering or science