Intermediate DBA

Effective Time Management Effective Communication Skills Query Writing Skills Optimisation and fine tuning all aspects of MSSQL Database management Database Design 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. 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.