Jobs Career Advice Signup
X

Send this job to a friend

X

Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Sep 14, 2020
    Deadline: Not specified
    • @gmail.com
    • @yahoo.com
    • @outlook.com
  • Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us

    Established in 2010, Betting Entertainment Technologies set its objective to provide quality products through excellence operations while maintaining a strong level of customer intimacy. Focusing on service delivery and meeting the needs of the dynamic gaming industry, Our Software engineers work as a team to develop dependable software systems with a hig...
    Read more about this company

     

    SQL DBA

    Job Description:

    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 maximum positive impact to the operational effectiveness to the systems being supported
    • Ensure negative impact to 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 first attempt
    • Research fit-for-purpose and relevant updates and patches and then ensure all the latest appropriate are installed, and the environment is fully functional without negatively affecting uptime
    • Perform relevant trouble shooting 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 protections 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 for 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

    Security

    • 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 implement and monitored
    • Define, approve and implement plans to manage a security breach or irregularity

    Authentication

    • 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

    Capacity Planning

    • 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 configuration changes which 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 

    Trouble Shooting

    • Remain on call for trouble shooting 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

    Other Duties

    • 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 operational effectiveness of DBA team
    • Perform research and compile 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 

    Qualifications/Certifications:

    Required Qualifications/Certifications:

    • Engineering or Science Degree
    • Microsoft Office - Word, Excel, PowerPoint (Intermediate to Advanced)
    • SQL or related certification

    Preferred Certifications:

    • Windows/Linux
    • C# or Java
    • NO SQL or equivalent

    Advantageous Certifications:

    • .NET
    • Cloud Technology
    • Database Design Skills – OLTP/ Data Warehouse
    • Data Base Management System/s
    • Database Administration / Data ware housing. Data Analytics
    • Certified Information Systems Security Professional  

    Required Experience and Skills:

    • Minimum 5 years’ experience
    • Software Installation and Maintenance
    • Data Extraction, Transformation, and Loading (ETL)
    • Specialised Data Handling
    • Database Backup and Recovery
    • Security
    • Authentication
    • Capacity Planning
    • Performance Monitoring & Database Tuning
    • Trouble Shooting
    • Betting/Gambling 

    Required Attributes and Competences:

    • 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

    Method of Application

    Interested and qualified? Go to Betting Entertainment Technologies on betsoftware.simplify.hr to apply

    Build your CV for free. Download in different templates.

  • Send your application

    View All Vacancies at Betting Entertainment Technolo... Back To Home

Subscribe to Job Alert

 

Join our happy subscribers

 
 
Send your application through

GmailGmail YahoomailYahoomail