SQL Database Administrator

Client PBT Group
Published 12/01/2017
12 Months
Location Sandton, Gauteng, South Africa
Introduction
With over two decades of expert knowledge and experience as information management specialists, PBT is a recognised leader in Business Intelligence and data warehousing and has extended its competency base to cover data quality and advanced analytics.

We pride ourselves to be a company who attracts, recruits and retains consultants of an exceptional calibre, not only within BI, but also within focused areas of Application Development.

We have worked in more than 25 countries around the world and are currently implementing large-scale projects throughout Africa, the Middle East and Australia.
Job Functions Information Technology
Industries Banking / Finance & Investment
Specification
PBT Group requires a strong SQL Database Administrator with 8 years’ relevant experience.

Duties

- Set up/install/configure new environments according to standards and best practice
- Suggest architectural changes in order to lower license costs and improve utilisation of hardware
- Review and maintain standards around databases
- Proactive management and planning of database capacity
- Security on database and users
- Reporting (e.g. table space etc)
- Investigate and resolve slow response issues
- Tune T-SQL queries to improve performance
- React on Alerts generated
- Conduct backups
- Manage and deploy changes to Production
- Clone various test and development environments from Prod, and sometimes across (from one UAT environment to another UAT environment)
- Root cause analysis when databases become corrupted; Resolution
- Create indexes on databases
- Restore from backup
- Morning checks on databases
- Morning checks on backups
- Ensure DR is in sync with Production
- Apply database patches as needed and requested to address specific problems
- Perform database upgrades and migrations
Requirements
- 8+ years of demonstrated experience as a SQL Server DBA
- Demonstrated experience in working with sys admins to size servers, facilitate virtualization and manage storage
- Experience in Microsoft Azure - assessment of enterprise applications for viability for migration to cloud – nice to have
- Application log monitoring and performance tuning experience

Education
- Diploma/Degree/IT certification
Job Closing Date 31/03/2017
Share on