Senior SQL DBA at Betting Entertainment Technologies (Pty) Ltd (Umhlanga, South Africa)
Location: Umhlanga, South Africa
Type: Full Time
Created: 2021-04-08 05:01:21
The Software Development Team of BET delivers betting solutions on a global basis. BET provides reliable, stable, scalable, robust, secure and continually evolving high volume transaction systems using processes that are controlled, effective and efficient. BET’s responsibility is to develop, deliver and support applications, in which data is received from or rapidly made available to users of the system/s with as high a degree of integrity as possible.
The DBA role has a direct impact on the organisational revenue stream, legal standing and reputation. Actions or inaction on your part is critical to organisational success or failure. Your decision making, problem-solving and pro-active attitude, must be enhanced with effective collaboration both with internal and external teams.
Specifically, as a member of BET and administrator of organisational databases, you'll install, upgrade, administer, monitor, maintain, and secure these systems. You will ensure the overall health of the systems assigned to your control. These databases may be hosted on-premise or in a private or public cloud. You are required to take all reasonable steps to ensure data is secure, readily available, protected from loss or corruption and easily accessible as needed by the business
Communication & Time Management
- Provide adequate day-to-day feedback and information to teams, management and colleagues to ensure that all actions taken are planned, understood and implemented with a maximum positive impact on the operational effectiveness of the systems being supported.
- Ensure negative impact on the systems being supported are understood, communicated and mitigated as far as possible.
- Effectively communicate with the relevant teams as to status, progress and time to resolution when working on systems.
- Ensure you schedule and prioritise your area/task of focus so that your limited-time provides maximum value.
- Ensure when you are unable to undertake, achieve or complete a task the relevant stakeholders are informed, and you suggest alternative solutions.
- Write database documentation, including data standards, procedures and definitions.
- Document/map out & maintain conceptual design views for the database.
Software Installation and Maintenance
- Collaborate and communicate with the System Administrators/Infrastructure/DevOps to determine the hardware required to effectively support the databases you intend to administer.
- Verify the relevant operating system, underlying support software and database software is correctly installed, and the environment is delivered successfully and functionally – provide feedback as required.
- Collaborate and communicate on the initial installation and configuration of a new system or database, with infra-structure and the development teams involved to ensure the environment is delivered successfully and functionally at the first attempt.
- Research fit-for-purpose and relevant updates and patches and then ensure all the latest appropriate is installed, and the environment is fully functional without negatively affecting uptime.
- Perform relevant troubleshooting and problem solving to ensure the server is always operating at peak efficiency and stability.
- Install, test and validate the deployments and maintenance to ensure peak efficiency and stability.
- Independently and correctly set-up and maintain replication and availability groups.
- Maintain appropriate standards in terms of data protection acts, both locally and internationally.
Data Extraction, Transformation, and Loading (ETL)
- Write/Build robust automated solutions to extract large volumes of data from multiple sources/systems into a data warehouse environment/s.
- Check the data is extracted correctly, efficiently, timeously and sets the stage for the success of subsequent processes.
- Ensure data quality and consistency by performing automated data validation, and provide reporting on errors identified for further analysis.
- Correctly convert or transform the data from one format or structure to another where needed
- Correctly insert data into the final target data warehouse for the purposes of querying and analysis.
- Ensure the data is appropriately cleansed, and delivered in a proper storage format/structure to facilitate the development team being able to develop applications as quickly as possible.
Specialised Data Handling
- Effectively manage very large databases using advanced monitoring and tuning.
- Develop the solutions required to manage unstructured data types where required.
Database Backup and Recovery
- Create backup and recovery plans and procedures based on industry best practices.
- Focus on cost-effective automated solutions which require minimal support and monitoring.
- Cater to different types of failures with potentially different solutions, so that the most cost and time-effective solution is implemented where required.
- Take preventative actions to reduce the potential of failure is reduced and the number of actual failures is as near zero as possible.
- Ensure these plans are properly reviewed, approved and communicated so that the necessary steps are followed to execute these plans efficiently and effectively.
- Ensure there is limited key-man reliance on yourself if an event occurs.
- Identify potential weaknesses of the database software and overall system.
- Research, plan and implement best practice strategies to mitigate risk.
- Ensure audit logs/trails are implemented and monitored.
- Define, approve and implement plans to manage a security breach or irregularity.
- Establish the needs of users and set up access to the database to ensure appropriate levels of access/security where needed.
- Ensure access to systems is entirely denied where appropriate.
- Perform short-term and long-term capacity analysis and planning across all systems.
- Ensure full understanding of the size of the database/s and estimate growth curves.
- Predict and communicate future capacity needs.
- Ensure preventative measures are taken to mitigate any stability and efficiency issues related to capacity in advance and taking cost into consideration.
Performance Monitoring & Database Tuning
- Perform tracking and on-going monitoring of systems performance ensuring that storage, archiving, backup and recovery processes are functioning effectively.
- Take preventative monitoring steps to ensure systems always have adequate capacity for performance and take steps to prevent future issues.
- Apply your advanced knowledge indexes, index management and statistics to ensure the system is performing optimally.
- Identify any part of the system which is slowing processing, creating instability or negatively affecting response times and then analyse and communicate with development/IT teams (and management where appropriate).
- Apply agreed on configuration changes that improve the systems operational efficiency and effectiveness.
- Optimise the physical configuration of the database to improve performance.
- Perform pro-active, preventative and relevant and appropriate system maintenance.
- Identify, recommend and implement cost-effective monitoring tools which enhance monitoring and thereby improving response times to performance-related issues.
- Monitor and optimise aspects such as indexing and query execution where appropriate.
- Where possible collaborate with the development teams to refine the system design to meet current and future system performance and storage requirements.
- Remain on-call for troubleshooting in case of problems.
- Quickly understand and respond to problems when they occur.
- Restore lost data.
- Correct or eliminate an issue to minimise damage to data, financial or reputational.
- Provide constructive and timely feedback for performance development.
- Assist with recruitment by providing appropriate feedback when required.
- Present performance reports and metrics to management.
- Provide training gap analysis feedback to improve the operational effectiveness of the DBA team.
- Perform research and compile the required reports and papers.
- Collaborate with other divisions and departments to carry out BET’s goals and objectives.
- Draft reports and correspondence to various third parties or outsources contractors.
- Keep updated on emerging technologies and trends in DBA management.
- Identify training needs and ensure training is developed and provided.
- Engineering or Science Degree
- Microsoft Office - Word, Excel, PowerPoint (Intermediate to Advanced)
- SQL or related certification
- C# or Java
- NO SQL or equivalent
- Cloud Technology
- Database Design Skills – OLTP/ Data Warehouse
- DataBase Management System/s
- Database Administration / Data warehousing. Data Analytics
- Certified Information Systems Security Professional
Required Experience and Skills:
- Minimum of 5 years experience
- Software Installation and Maintenance
- Data Extraction, Transformation, and Loading (ETL)
- Specialised Data Handling
- Database Backup and Recovery
- Capacity Planning
- Performance Monitoring & Database Tuning
- Trouble Shooting
Required Attributes and Competencies:
- Good Communication and Time Management Skills
- High Emotional Intelligence
- High Performance
- Strong Business Acumen and Accountability
- Excellent Problem-Solving Skills
- Quality Focused and Results Driven
- Detail Orientated
Apply via [email protected]
Please note that only candidates who meet the stipulated minimum requirements will be contacted.
If you are not contacted within 30 days, please kindly consider your application unsuccessful. Thank you!