Datacentrix is looking for a certified Senior SQL DBA to be based at our Midrand office. The candidate will be responsible for the provision of day-to-day database administration and support in a large corporation with multiple database environments, including resolution of database problems, data backup and restore, and the production of database performance statistics.Qualifications:Matric and IT Diploma/DegreeMCSE - Certified Solutions Expert.Certified Solutions Associate: SQL ServerCertified IT Professional: Database AdministratorFunctional 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 solutions to any complex IT-related challenges in the organization.Enterprise Tasks:Benchmark, analyze 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 recovery 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 audits 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 need 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 a 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.Datacentrix is a leading, empowered ICT integrator that provides high performing and secure ICT solutions to corporate South Africa and the country's public services sector.Our Footprint:Datacentrix operates from regional branch offices in Pretoria, Samrand, Johannesburg, Cape Town, Port Elizabeth, East London and Durban, with a network of small medium enterprises (SMEs) and service personnel around South Africa that are responsible for servicing remote areas.Our Partners:Datacentrix' global partnerships with its technology partners remain critical to the company's success. The company is accredited by its vendors at the highest possible level both in the technical and sales arenas, which enhances the company's strategic value as a single source service provider.To achieve this, Datacentrix invests in its people through training and education, embracing broad-based black economic empowerment (BBBEE), while actively partnering and representing leading technology partners with distinction.Vision:Datacentrix intends to become the preferred ICT partner to the majority of South Africa's top commercial and public sector organizations over the next five years.
#J-18808-Ljbffr