SQL Database Administrator

Job description

Referral Programme

• Relevant three-year IT qualification (BSc (Computer Science), BCom (Information Systems) or three year National Diploma in Information Systems)
• MS SQL Certification would be an advantage
• Four to six years’ experience in MS SQL database design and implementation, performance tuning and optimization, administration and support including security components on multiple versions of SQL Server (2012 and later)
• Expert. Level experience proficiency in administration and maintenance of standalone and clustered SQL Server instances
• Experience with SQL Server environments including High-Availability, Replication, Disaster Recovery, and Cluster Environment
• Reporting Service (SSRS), Integration Services (SSIS) and Analyses Services (SSAS), in development, testing, staging and production environments
• Experience with SQL Server and other Microsoft technology stacks, and able to support Enterprise-level SQL Servers and Databases
• Experience with Enterprise monitoring tools, Microsoft Systems Centre Operations Manager (SCOM) preferably
• Good written and verbal communication skills, be able to interact with other teams and coordinate complex efforts
• Team player with a “get-it-done” personality, self-managed and able to juggle multiple tasks to meet deadlines and provide qualitative deliverables with minimal supervision
• Expert level knowledge of developing and supporting complex Data Warehouses
• Strong technical documentation skills

• Owns the strategic direction for the database topography
• Installation, administration and maintenance of SQL Server Clusters and Instances
• Architect and define disaster planning/mitigation/recovery, capacity and scalability planning, and storage management including High Availability and AlwaysOn Failover Cluster Instances
• Provide direction and oversight for architecture and design elements of the full SQL environment, including the Enterprise Data Warehouse
• Proactively monitor and timely maintain the database systems to ensure secure services with minimum downtime and optimum performance. Evaluate / develop and / or use tools to automate the maintenance, monitoring and alert notification of database server
• Perform SQL Server database administration functions, including maintenance of multiple environments (development, testing, and production), patching, troubleshooting, object maintenance (e.g. partition, table, index, users/roles)
• creation/maintenance, space management, SSIS & SSRS deployments, and security management
• Identify required database changes and patches and implement them in line with the system requirements, ensuring that all databases are on the latest applicable changes
• Support on-going projects to ensure that development effort meets standards, including access and change control related procedures
• Automate monitoring with monitoring tools
• Develop, test, implement, document and adhere to standard operating procedures to ensure that the required standards and objectives are met, and ensure adherence within the DBA team
• Interact with the Infrastructure team to ensure the high availability and optimum performance of associated hardware resources allocated to the databases
• Identify and provide meaningful trend analysis and the key measurables that should be monitored to enable informed decision-making regarding resource management
• Draw up, manage and participate in a standby rotation for after-hours support and maintenance
• Formulate and document database standards and best practices, including all aspects of information security, create guiding documentation, make tuning recommendations and report monthly on the Information Security dashboard
• Train and mentor DBAs and Trainee DBAs