Jobs in

SQL DBA - Pretoria

Job Description:Communication & Time Management• Provide adequate day-to-day feedback and information to teams, management and colleaguesto ensure that all actions taken are planned, understood and implemented with a maximumpositive impact on the operational effectiveness of the systems being supported.• Ensure negative impacts to the systems being supported are understood, communicated andmitigated as far as possible.• Effectively communicate with the relevant teams as to status, progress and time to resolutionwhen working on systems.• Ensure you schedule and prioritise your area/task of focus so that your limited-time providesmaximum value.• Ensure when you are unable to undertake, achieve or complete a task the relevant stakeholdersare informed, and you suggest alternative solutions.• Write database documentation, including data standards, procedures and definitions.• Document/map out & maintain conceptual design views for the database.Software Installation and Maintenance• Collaborate and communicate with the System Administrators/Infrastructure/DevOps todetermine the hardware required to effectively support the databases you intend to administer.• Verify the relevant operating system, underlying support software and database software iscorrectly installed, and the environment is delivered successfully and functionally – providefeedback as required.• Collaborate and communicate on the initial installation and configuration of a new system ordatabase, with infra-structure and the development teams involved to ensure the environmentis delivered successfully and functionally at the first attempt.• Research fit-for-purpose and relevant updates and patches and then ensure all the latestappropriate is installed, and the environment is fully functional without negatively affectinguptime• Perform relevant troubleshooting and problem-solving to ensure the server is always operatingat peak efficiency and stability.• Install, test and validate the deployments and maintenance to ensure peak efficiency andstability.• Independently and correctly set up and maintain replication and availability groups.• Maintain appropriate standards in terms of data protection acts, both locally andinternationally.Data Extraction, Transformation, and Loading (ETL)• Write/Build robust automated solutions to extract large volumes of data from multiplesources/systems into a data warehouse environment/s.• Check the data is extracted correctly, efficiently, timeously and sets the stage for the success ofsubsequent processes.• Ensure data quality and consistency by performing automated data validation, and providereporting on errors identified for further analysis.• Correctly convert or transform the data from one for https://protool.gumtree.co.za/external-link-browser.html?urlaHR0cHM6Ly93d3cuZGl0dG8uam9icy9qb2IvZ3VtdHJlZS8xODM2NjAxMDc2P3NvdXJjZT1ndW10cmVl&jid375536&xid1836601076 Apply Now
Share this job with someone you think should apply!
Facebook buttonFacebook   Whatsapp buttonWhatsapp

Want to do another search?

Jobs in