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 SLA’s 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.For more information please contact:Koketso Malete
