Intermediate DBA - DBN at BETSoftware

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