SQL DBA

SUMMARY:
We are currently looking for an 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 environment, including resolution of database problems, data backup and restore, and the production of database performance statistics.

POSITION INFO:
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 vendorsEvaluate new software releases and products.

• Ensure regular updates, plan future rollouts.

• 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).

• 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.

• 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.

NB! This job is now closed. You can apply for other jobs by uploading your CV.