These jobs were popular with other job seekers Negotiable based on quals, exp and earnings Independent Contractor, Self-employed, EE/AA, Non EE/AA, Disabled Easy apply Introduction Time Quantum, in a Joint Venture with Purple Blue Tecnologies, 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 serviced (SSRS) Develop and deploy different types of reported using different 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 SQL Server to new versions like 2000/2005 to 2008 R2 and 2008 R2 TO 2012 up to 2019 Apply APPLIED SP (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, disk space, backup verification Set up jobs and maintenance plans for backups, rebuilding indexes, check server health, alert, notifications Create and manage different types of indexes (cluster/non-cluster) constraints (unique/check) Develop SSIS packages from different sources like SQL Server, flat, file, CSV, excel and many other data sources support ODBC, OLEDB data sources Deploy SSIS packages to move data across server, move logins, load data from different sources Set up jobs from SSIS packages Use Imp/Exp tool to import&export data files from different sources like SQL Server database, flat, file, Excel and many other data sources supports ODBC, OLE DB data sources 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 trouble-shoot SQL server and servers Prepare Change Request Documentation VM-Ware (build virtual machines, allocate resources, install operating system, give rights and permissions, add VM to the domain and manage an AD account. 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 AllwaysOn 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 responsibilituies and send to troskie.neethling@timequantum.co.za . IT&Internet These jobs were popular with other job seekers #J-18808-Ljbffr