SQL Server DBA

SQL Server DBA
Microvision IT Solutions, United Arab Emirates

Experience
6 Years
Salary
6,000 - 8,000 AED
Job Type
Job Shift
Job Category
Traveling
Yes
Career Level
Telecommute
No
Qualification
Bachelor Degree in Computer Sciences / Information Technology or equivalent.
Total Vacancies
1 Job
Posted on
Feb 17, 2020
Last Date
May 30, 2020
Location(s)

Job Description

Job Description for SQL Server DBA:

  • Strong understanding of SQL database structures, principles, and practices.
  • Working technical experience with designing, building, installing, configuring, and supporting database servers, including Microsoft Clustered SQL Servers.
  • Experience with replication (transactional or log shipping) required.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Manage ETL and reporting environment on SQL server and will develop ETL and reports.
  • Refine and automate regular processes, track issues, and document changes.
  • Assist developers with complex query tuning and schema refinement.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Technical documentation skills.
  • Ability to conduct research into database issues, standards, and products as required.
  • Skilled in working with large volumes of data and loading of data from multiple sources.
  • Knowledge of reporting and query tools and practices.
  • Knowledge of indexes, index management, and statistics.
  • Skilled in deploying database change scripts.
  • Skilled in performance optimization.
  • Proven experiences of large data sets.
  • Experience in BIG Data environments and Big Data tools advantageous.
  • Monitor capacity to prevent unplanned outages, grant permission to servers and databases in conjunction with standards as per security team.
  • Research, assess and implement new features in SQL SERVER where appropriate and beneficial to solution.
  • Work with Security team to manage access and compliance regularly review database and SQL instance permissions to make sure appropriate access is in place.
  • Implement encryption and data masking options where required.
  • Grant permission to servers and databases in conjunction with standards as per Security team.
  • Review SQL SERVER licenses for compliance as well opportunities to reduce costs.
  • Cloud experience helpful.
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
  • Apply service packs/ DB Archive/ Capacity planning.
  • Perform scheduled maintenance and support release deployment activities after working hours.
  • Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
  • Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
  • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
  • Learn relevant business processes and understand the data flow, criticality and dependencies.

Additional Details

The role will be based on a 3 months contract (subject to extention) in the emirates of Dubai

Relevant Visa and travel will be provided by Microvision IT Solutions

Job Specification

Education:

  • Bachelor Degree in Computer Sciences / Information Technology or equivalent.
  • Microsoft SQL Server Certification.
  • MCTS, MCITP, and/or MVP certifications preferred.

Skills:

  • On-call troubleshooting for SQL Server service outages.
  • In depth SQL Server Database Administration experience.
    - Strong self-sufficiency and initiative working on Database projects.
    - Experience Practical experience in monitoring and tuning a database to provide a high availability service.
    - Experience of Transactional SQL, and DTS stored procedures.
    - Practical experience in managing the internal and external MS SQL database security.
  • 5 years of experience as a SQL Server DBA or similar role.
  • 5 years of experience with MY SQL Server Administration experience required.
  • 5 years of experience with Performance Tuning and Optimization (PTO).
  • 5 years of experience with backups, restores and recovery models.
  • 5 years of experience with Windows server, including Active Directory
  • Continuous improvement of processes and practices, automating processes where possible.
  • Sense of ownership and pride in your performance and its impact on company’s success.
  • Critical thinker and problem-solving skills.
  • Great interpersonal and communication skills.

Preferred Experience:

  • Relevant formal education, including BSCS or MSCS in Information Technology.
  • Prefer candidate for Retail Experience.
  • Minimum 5 to 8 year of experience as mentioned above.

Job Rewards and Benefits

Leaves
Transport

Microvision IT Solutions

Computer Software - Dubai, United Arab Emirates
© Copyright 2004-2024 Mustakbil.com All Right Reserved.