• Bachelors degree in computer science or equivalent education and experience.
• 2+ years of experience in administering Microsoft SQL server databases.
• Experience in building databases.
• Ability to deal with different operating systems (Microsoft-Linux)
• Experience in dealing with servers & backup devices.
• Experience in Database Management (SQL)
• Experience in Database Development (SQL)
• Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
• 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 analyze 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.
• Analyze, 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 Modeling.
• Design Data Warehousing (SSAS, Azure Data Factory) and Business Intelligence platform.

Skills

Requirements

• Bachelor degree in IT related field
• +2 years of experience in the same field
• Experience with Microsoft SQL Database
• Professional certifications are preferred