SQL DBA

Job Description:
Communication & Time Management
• Provide adequate day-to-day feedback and information to teams, management and colleagues
to ensure that all actions taken are planned, understood and implemented with a maximum
positive impact on the operational effectiveness of the systems being supported.
• Ensure negative impacts to the systems being supported are understood, communicated and
mitigated as far as possible.
• Effectively communicate with the relevant teams as to status, progress and time to resolution
when working on systems.
• Ensure you schedule and prioritise your area/task of focus so that your limited-time provides
maximum value.
• Ensure when you are unable to undertake, achieve or complete a task the relevant stakeholders
are 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 to
determine the hardware required to effectively support the databases you intend to administer.
• Verify the relevant operating system, underlying support software and database software is
correctly installed, and the environment is delivered successfully and functionally – provide
feedback as required.
• Collaborate and communicate on the initial installation and configuration of a new system or
database, with infra-structure and the development teams involved to ensure the environment
is delivered successfully and functionally at the first attempt.
• Research fit-for-purpose and relevant updates and patches and then ensure all the latest
appropriate is installed, and the environment is fully functional without negatively affecting
uptime
• Perform relevant troubleshooting and problem-solving to ensure the server is always operating
at peak efficiency and stability.
• Install, test and validate the deployments and maintenance to ensure peak efficiency and
stability.
• Independently and correctly set up and maintain replication and availability groups.
• Maintain appropriate standards in terms of data protection acts, both locally and
internationally.
Data Extraction, Transformation, and Loading (ETL)
• Write/Build robust automated solutions to extract large volumes of data from multiple
sources/systems into a data warehouse environment/s.
• Check the data is extracted correctly, efficiently, timeously and sets the stage for the success of
subsequent processes.
• Ensure data quality and consistency by performing automated data validation, and provide
reporting on errors identified for further analysis.
• Correctly convert or transform the data from one for...