Midrand: SQL DBA

Responsibilities: Functional Support – Oversee the maintenance, configuration, and implementation of everything that has to do with databases. – Respond to and resolve database access and performance issues. – Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. – Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. – Monitor, optimize and allocate physical data storage for database systems. – Plan and coordinate data migrations between systems. – Perform database transaction and security audits. – Establish appropriate end-user database access control levels. – Develop routines for end-users to facilitate best practices database use. – Provide solution to any complex IT related challenges in the organization Enterprise Tasks – Benchmark, analyse and test new technologies. – SQL flavour requirements, upgrades and downgrades (Enterprise through to Express). – Data and/or server migrations. – High Availability assessments and best-fit application (AOHA and Failover). – SQL patching and Rollup installations and planning. Facilitate enterprise integrations with SXi and other vendors – Evaluate new software releases and products. – Ensure regular updates, plan future rollouts. Customer experience – Customer SLAs are key Data Maintenance – Data Warehousing setup and capacity planning. – Backup and recovery strategies (PIT and PID). – Database hardware requirements (Capacity Planning). Reporting & Continuous Improvement – Develop, implement, and maintain change control and testing processes for modifications to databases. – Create, or support creation of, required reports in response to business user needs. – Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts. – Keep up with trends in the constantly evolving information technology industry. – Perform regular IT audit to discover areas of weaknesses and fortify them. Administration and Knowledge – High Availability health checks and regular failover tests. – DMV maintenance – Outdated index updates and tuning of existing. – SQL performance monitoring (General, Locks, Buffer) managers. – Review error mails from all integration packages and fix code bugs and/or improvements (SSIS and custom code written). – Ensure SSAS packages executed the previous night. – Review error mails on replication errors and spot check a few instances. – Keep QA and DEV databases up-to-date with PROD for testing. – Ensure IIS on web servers are running and is responsive. – Deploy new/existing code and patches to running software (C++/C#). – Storage management (Log and log files that needs shrinking). Verify SQL backups to disk. – Design, architect, and build databases from determining business requirements. – Write and troubleshoot complex stored procedures. – Develop innovation, strategies, processes, and best practices. Manage Human Resources – Manage and mentor team members. – Work closely with programming staff on database design changes to meet business requirements. – Review completed tasks to ascertain compliance with standards.