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