1. Competitive compensation commensurate with role and skill set
2. A fast-paced, growth-oriented environment with the associated rewards
About Our Client
The hiring organization is a reputed entity within the Technology & Telecoms industry, specializing in the Services sector. As a large organization, they are known for offering cutting-edge technological solutions and fostering an environment of innovation and expertise.
Job Description
3. Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
4. Facilitate brainstorming meetings with clients to review, analyse, and assess business systems and needs
5. In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
6. Assists in the selection of a database management system and the maintenance of database performance
7. Participate in continuous process improvement
8. Download and install SQL Server service packs and updates.
9. Configure and maintain SQL Security controls
10. Make recommendations for system architecture per Microsoft SQL Server best practises
11. Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
12. Create, change, and improve SQL Server Agent tasks and maintenance plans
13. Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
14. Troubleshoot application sluggishness and poor performance
15. In charge of T-SQL query tuning
16. In charge of database migrations and server updates
17. Create documentation and training for routine database administration activities, as well as train server operations employees on them
18. In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
19. Integrate SQL Server with corporate applications
20. T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
The Successful Applicant
21. Extensive knowledge of SQL and SQL server tools
22. Experience in Database Performance, Development and Maintenance
23. In-depth understanding of database security, backup and recovery, and performance monitoring requirements
24. Familiarity with relational and dimensional data modelling
25. Extensive knowledge in database design, implementation, and conversion
26. Knowledge of PowerShell and Unix shell scripting
27. Experience with SSAS, SSIS, and SSRS
28. Outstanding writing and verbal communication abilities
29. Meticulous attention to detail
30. Working knowledge of Linux and Windows Server infrastructures
31. Extensive knowledge of database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
32. Prior experience with cloud services (AWS, Microsoft Azure,GCP)