Database Administrator - Microsoft SQL
Retail & Distribution
Job Summary
Location : Nairobi Kenya
Total View :1578
Job type : Full Time
This job has already expired
Industry
Retail & DistributionJob Description
Roles & Responsibilities;
- Install and configure new Microsoft SQL Server instances
- Ensure high availability including Always On availability groups, Replication mirroring and failover clustering.
- Maintain secure access and database integrity.
- Management, design and planning of physical data storage
- Database administration activities including but not limited to;
- Database management including backups recovery and maintenance.
- Restoration of databases in different environments.
- Monitoring and resolving blocking sessions and data lock issues
- Check all statistics related to memory locks, I/O database response time, wait events top sessions and background processes
- Create indexes to achieve critical dataset response time for time sensitive activities.
- Install SQL Server service packs and updates.
- Archiving and partitioning
- Updating statistics
- Proactively monitor and maintain SQL Server jobs troubleshoot failed jobs and resolve issues in a timely manner.
- Provide technical guidance for design, development, integration, and testing of production
- Perform database performance analysis, tuning, capacity planning, system sizing and ongoing maintenance to ensure maximum performance.
- Communicate and coordinate with other IT teams to successfully resolve support and maintenance Issues.
- Create, document and lead in the compliance of policies, procedures, and standards for business continuity
- Risk management of the database administration function.
- Build and maintain a network of support structures (like the: vendors, employees, user groups etc) for consultation purposes and best practice adoption.
Minimum Qualifications:
- Bachelors degree in IT, Computer Science and related field.
- Microsoft Certified Solutions Associate Certification.
- 5 Years experience in DBA roles- Microsoft SQL databases a MUST
- Experience managing Multiple databases in a large enterprise with many branches