MS Database Administrator at Nambiti Technologies (Pty) Ltd

Job Description

• Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
• Review, analyze, and evaluate business systems 
• Highly skilled at database design, installations, conversions Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management
• Participates in Database Management System selection and maintains database performance
• Engage in ongoing process improvement
• Experienced in Database Performance, Maintenance and Development to perform the following:
• Database management including backups, recovery and maintenance
• Database management for export, import and mass data loads
• Analyzes and generation of all tables and index statistics
• Monitoring and resolving data lock issues
• Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions and background processes
• On-Line Transaction Processing (OLTP) to capture, validate and store large amounts of transactions
• Create indexes to achieve critical dataset response time for time sensitive reports.
• Install SQL Server service packs and updates.
• Configure and manage SQL Security settings.
• Make system design recommendations according to Microsoft SQL Server best practices