ENVIRONMENT: A large national betting company seeks a strong SQL DBA/ developer to maintain and enhance a MSSQL based database offering to ensure scalability/reliability/functionality of a database at the core of a new national software solution. As the effective owner of the databases across the organization the role offers career growth and the use the latest Microsoft SQL technology. The position is based in Umhlanga. DUTIES:
- Ensure Database design is robust, scalable and operating optimally.
- Ensure Store Procedures are optimised.
- Write stored procedures/views etc.
- Rollback and Disaster recovery management
- Ensure high DB availability as this has a public facing web front end
- Be involved with planning meetings, documentations and testing
- Work towards a long-term Data warehousing solution based on SQL server 2016 Enterprise
- Support and Update existing products
- Good Understanding of big data manipulation methodology
- Manage the design, delivery and continuous improvement of IT solutions across the organization in support of increasing the organization’s levels of automation and innovation.
- Partner with individual operational departments to provide technical solutions to business requirement, manage expectation and ensure the delivered solution is fit for purpose and is delivered on time based on provided deadlines.
- Utilize a variety of the Technical tools that are provided to ensure maximum effectiveness of IT solutions. These tools will be based on industry best practices.
- Must be a leader that sets the standard and expectations through example in his/her conduct, work ethic, integrity and character. Must be an inspiration to others and set a level of coding standards that need to be a benchmark for others to follow.
- Demonstrated ability to successfully develop, adapt and deliver Software solutions utilizing skills in software design, program design & development using the latest software development methodologies. Effectively document these solutions for maintenance and hand these over for support.
- Take full responsibility of tasks and projects assigned and make the necessary corrections to bring these projects into alignment with business expectation.
- Lead discussions in the adoption of new technologies and be part of a committee dedicated to the continuous improvement of internal coding standards.
- Ensure that the stakeholders are completely aware of the effectiveness of the solution and are trained in the correct use of the delivered software.
- Create and maintain a positive and professional environment conducive to software development and mentoring
- Report on Software project deliverables to ensure all stakeholders are kept up to date on progress and ensure that deadlines are met.
- Demonstrate strong communication skills, both verbal and written. Willingness to work overtime to ensure the delivery of projects assigned and communicate effectively when timelines are in danger of not being met.
- Mentor Junior and intermediate developers by periodically reviewing checked in code to ensure that the standards expected are met and the logic within the code base is sound.
REQUIREMENTS:
- Advanced SQL skills and query writing skills
- Optimisation and fine tuning all aspects of MSSQL
- Ensuring high db. availability.
- Experience in designing/optimising MSSQL Databases.
- 5 – 7 years’ experience in a commercial environment
- 5+ years’ experience in MSSQL – all aspects
- Matric with a good Maths Grade
- A completed BSc Computer Science or National Diploma in IT
- Solid time management and communication skills essential
- Driver’s license and own transport essential
- Willing to work extended hours
- Ability to work under pressure
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful. COMMENTS: When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to bethany@datafin.com and mention the reference numbers of the jobs.
To apply for this vacancy please access this job advert on a desktop computer.
Apply for other Jobs on Job Mail.