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 a multiple database environments, including resolution of database problems, data backup and restore, and the production of database performance statistics.
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.
