Database Administrator
Full time
at 2P Perfect Presentation
in
Saudi Arabia
Posted on January 7, 2025
Job details
Job Description
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
RequirementsBachelor degree in IT related field+2 years of experience in the same fieldExperience with Microsoft SQL DatabaseProfessional certifications are preferredApply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.
Improve your chance to get this job.
Do an online course on SQL Server starting now.
-
Microsoft SQL Server Bootcamp 2022 Course LineAED 86Duration: Upto 7 Hours
-
Microsoft SQL Server Development Apex LearningAED 86
AED 882Duration: Upto 6 Hours
