Intermediate DBA

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