Senior SQL DBA
Datacentrix
Job title: Senior SQL DBA
Company: Datacentrix
Job description: 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.
Expected salary:
Location: Midrand, Johannesburg
Job posting date: Sun, 17 Nov 2024 08:47:52 GMT
Apply for the job now!