Role Description:
- Install and configure database software like SQL Server Database engine, SSAS,SSRS and associated database tools for versions 2019/2017/2016 on both stand alone and cluster environment.
- Automation of SQL Server installation along with Service pack through Slip Stream method.
- Should have good experience in deploying AWS Amazon EC2 instance for SQLServer version 2016,2017 & 2019.
- Experience in Microsoft Azure services like BLOB storage, ADF and SQL Instance.
- Should have good experience in migrating the database from on premise to cloud.
- Hands on experience in exporting and importing using data tier.
- Install and configure the new features like Always On in failover cluster environment.
- Experience in troubleshooting and resolving blocking and deadlocking issues replication issues log shipping issues connectivity issues security issues.
- Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler/Extended events/Query store and other related monitoring and troubleshooting tools.
- Automation of SQL Server installation along with Service pack through Slip Stream method using PowerShell, T-sql.
- Monitor database performance by gathering and analyzing database statistics, reviewing database initialization parameters, and performing benchmarks
- Tune database instance/server for maximum performance
- Provide database guidance to application and systems administration teams for database application performance issues.
Job Details
Posted Date: | 2023-06-23 |
Job Location: | Saudi Arabia |
Job Role: | Information Technology |
Company Industry: | Recruitment & Employee Placement Agency |
Preferred Candidate
JobDXB.com, in partnership with the 7 states of the UAE (Abu Dhabi, Dubai, Sharjah, Ajman, Umm Al Quwain, Ras Al Khaimah, and Fujairah), is a leading job portal based in the country, connecting job seekers with opportunities across various industries in the region.
While we strive to provide a platform for employers and candidates to connect, it's essential to note that the content of job postings may vary, and we do not take responsibility for their accuracy or legitimacy. We advise applicants to exercise caution and diligence when applying for positions, ensuring thorough research and verification before proceeding with any application. Your career journey is important to us, and we encourage you to navigate it with care and discernment.