Intermediate Dba
6 months ago
**We Want You**:
**You Bring**:
- Completed BSc Computer Science or National Diploma in IT.
- Solid time management and communication skills essential.
- Experience in designing/optimising MSSQL Databases.
- 3-5 years’ experience in a commercial environment.
- 3+ 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.
-
**What You’ll Do**:
**Database Design**
- Ensure Database design is robust, scalable, and operating optimally.
- 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**
- Utilise 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 work after hours to ensure that problems are resolved.
- Show 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.
**Living our Spirit**:
- 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.
**The Company We Keep**:
At BET Software, we don't just recruit talent, we cultivate it. Our learning and development programmes, our various opportunities for growth, and our well-deserved incentives are what keep our All-Star Team the best amongst the rest.