Senior SQL DBA

SUMMARY:
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.

POSITION INFO:
Qualifications:

• Matric and IT Diploma/Degree
• MCSE - Certified Solutions Expert.
• Certified Solutions Associate: SQL Server
• Certified IT Professional: Database Administrator

• 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

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

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

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