Intermediate DBA

BETSoftware

Job Description

  • Effective Time Management
  • Effective Communication Skills
  • Query Writing Skills
  • Optimisation and fine tuning all aspects of MSSQL
  • Database management
  • Database Design

Responsibilities

Job Responsibilities

Database Design

  • Ensure Database design is robust, scalable, and operating optimally.
  • Work with other DBAs to make sure that the solutions meet application requirements and performance goals.
  • Actively contribute to planning meetings, documentations, and testing.

Database Performance

  • Ensure Store Procedures are optimised.
  • Rollback and Disaster recovery management.
  • Ensure high DB availability as this has a public facing web front end.
  • Work towards a long-term Data warehousing solution based on SQL server 2016 Enterprise.
  • Support and update existing products.

Monitoring

  • Monitor database performance, implement changes and apply new patches and versions when required.
  • Utilize tools and scrips to monitor all aspects of database performance including the underlaying compute, storage, and networking.
  • Drive the adoption of processes within the team which consider and meet the expectations of technical throughput rates and responses; processing times; effective resource utilization during operation and where the system or solution ensures maximum operational capacity requirements are met.
  • Good Understanding of big data manipulation methodology.
  • Use high-speed transaction recovery techniques and backup data.
  • Diagnose and troubleshoot database errors.
  • Create and manage database reports, visualizations, and dashboards.

Initiative and Innovation

  • Recommend and implement emerging database technologies.
  • Take an active involvement in problem resolution and where necessary works after hours to ensure that problems are resolved.
  • Shows foresight to prevent errors or delays in projects.
  • Demonstrate initiative by understanding, acquiring, and implementing new knowledge and skills both within team and to the wider group.
  • Incorporates the new abilities into the day-to-day operational activities to improve performance of products and systems.
  • Ensure techniques, technologies, tools, and processes used are in line with industry best practices.

Knowledge Share

  • Identify team members requiring a specific knowledge, skill or understanding and seek ways to impart or upskill the team members through coaching and mentorship.
  • Verify the knowledge has been imparted successfully and if not, take steps to rectify gaps in transfer of the knowledge.
  • Provide technical guidance to the team through collaboration sessions and knowledge sharing initiatives.
  • Openness to changes and improvements in the data base systems by embracing new technologies and methodologies that will enhance the performance and security of the data base.
  • Prompt responses to requests and issues relating to Database management and therefore enhancing teams’ effectiveness.
  • Willingness to share knowledge on the system on configurations, process, and procedures with other team members so they have a clear understanding of how the database works in a way that is easy to understand.
  • Maintain a positive and can-do attitude, which can inspire and motivate yourself and other team members in all situations.
  • Support and coach fellow junior team members and assisting them to develop their skills and grow in the team.
  • Ability to work seamlessly with colleagues and in a collaborative approach to improve database solutions and outcomes.

Qualifications

  • Completed BSc Computer Science or National Diploma in IT.
  • Solid time management and communication skills essential.
  • Experience in designing/optimizing MSSQL Databases.
  • 3-5 years’ experience in a commercial environment.
  • 3-5 years’ experience in MSSQL-all aspects.
  • Advanced SQL skills and query writing skills.
  • Optimisation and fine tuning all aspects of MSSQL.
  • Ensuring high data base availability Yes Competencies.
  • Microsoft Certified: Azure Database Administrator Associate advantageous.