Qualifications: Matric and IT Diploma/Degree MCSE - Certified Solutions Expert. Certified Solutions Associate: SQL Server Certified IT Professional: Database Administrator 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. Performance troubleshooting with recommended 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). Disaster recover assessment and best-fit application (AOHA, log shipping, mirroring and replication) 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. Data Maintenance: SQL server configuration for Data Warehousing and capacity planning. Backup and recovery strategies (PIT and PID, Restore point objective and restore time objective). Database hardware requirements (Capacity Planning). Reporting and 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. Troubleshoot integration packages execution failure. Troubleshoot SSAS packages job failure 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. Deploy new/existing code and patches for SQL to running software (C++/C#). Storage management (Log and log files that needs shrinking). Verify SQL backups to disk. Design, architect, and build SQL solutions from determining business requirements. Write and troubleshoot complex stored procedures used to manage SQL environments. Develop innovation, strategies, processes, and best practices. Human Resources Manage and mentor small team of DBAs. Work closely with programming staff on database design changes to meet business requirements. Delegate duties and tasks within the team Review completed tasks to ascertain compliance with standards.
