Introduction
Time Quantum, in a Joint Venture with Purple Blue Technologies, is in need of a specialist SQL DBA for a Pretoria-based Government department.
Duties & Responsibilities
- Install, configure and maintain SQL Server 2019, 2017, 2014, 2012, 2008 and 2005 in development test, and production environments.
- Configure and maintain fall-over clustering using SQL Server 2019.
- Maintain server and database security.
- Install and configure SQL Server reporting services (SSRS).
- Develop and deploy different types of reports using various data sources like SQL Server, Excel, CSV files and Power BI.
- Configure and maintain replications, log shipping for high availability.
- Upgrade/migrate SQL Server instances/databases from older versions to new versions.
- Apply service pack hot fixes on SQL Server instances to address security and upgrade related issues.
- Perform database and SQL/T-SQL performance tuning.
- Schedule jobs to automate different database-related activities including backup, monitoring database health, and disk space.
- Create and manage different types of indexes and constraints.
- Develop SSIS packages from various sources.
- Deploy SSIS packages to move data across servers.
- Set up jobs from SSIS packages.
- Use import/export tools to manage data files.
- Set up manual and on-demand jobs for database backup.
- Design backup strategy.
- Deploy and restore databases.
- Log shipping configuration and database mirroring.
- Monitor server activity, error log, space usage and solve problems as needed.
- Work on SCOM and SCCM to troubleshoot SQL server and servers.
- Prepare Change Request Documentation.
- VM-Ware: build virtual machines, allocate resources, install operating systems, manage AD accounts.
- Set up and configure AlwaysOn High Availability Group.
Desired Experience & Qualification
Applicable SQL Certifications.
More than 5 years' applicable experience in the duties and responsibilities listed for this role.
Experience in AlwaysOn environments.
Package & Remuneration
Comprehensive employment package will be negotiable based on applicable experience, qualifications and prior earnings.
Interested?
If you are interested and capable of doing this job, please edit your CV to address the points listed under duties and responsibilities and send it to
#J-18808-Ljbffr
