Genasys Logo

SQL Developer

Genasys|Posted 3 days ago

Skills and experience

Role:Data engineer
Other roles:Data architect
Experience in role:3+ years
Language proficiency:English
Must-have skills:
    SQL
    Transact-SQL
    Microsoft SQL Server
    Power BI
    SSIS

Location and salary

Remote policy:Hybrid
Location of job:Rosebank, South Africa or Stellenbosch Local Municipality, South Africa
Visa requirements:Authorised to work in South Africa With status of citizen/passport holder, permanent resident or work permit/visa holder
Visa sponsorship:Unable to sponsor visa
Employment type:Permanent

Role description

Who We Are

The Genasys story began in 1997 with a visionary founder who recognised that software was the key to revolutionising insurance efficiency and delivering exceptional customer experiences. From humble beginnings, we’ve grown into a recognised Insurtech leader, celebrating over 25 years of innovation. We have a strong foothold in South Africa and the UK, and our expansion into international markets is a testament to our continuous growth and impact. Our unwavering mission is to be the preferred software solutions partner to the insurance industry across Europe, Africa, and the rest of the world.

At Genasys, our core values of transparency, honesty, integrity, and personal accountability drive everything we do. We pride ourselves on delivering excellence in insurance technology, building lasting partnerships, and always doing what we say we will. Our comprehensive and dynamic insurance management system is a testament to our commitment to innovation. It’s a modular, cloud-based solution that can be applied to any insurance business, adapting seamlessly regardless of currency, language, or destination. With our platform, clients benefit from faster product launches and an average of 34% reduction in operating costs, enabling them to transact over £3 billion in Gross Written Premium and manage over 1.5 million insurance policies globally. Our system boasts 352 pre-configured product line templates and 486 robust, well-documented API endpoints, offering unparalleled flexibility and speed to market.

Our flagship platform provides end-to-end policy administration, covering the entire insurance policy lifecycle. This includes intuitive, no-code tools for building wholesale and retail quote-and-bind journeys, seamless renewals, mid-term adjustments, and cancellations. It empowers insurers, MGAs, and brokers to create customised, optimised workflows, manage complex currency, taxation, and multiple languages across regions, and support alternative insurance models such as parametric, micro, or embedded products. The platform is truly designed for insurance, tailored to the unique needs of each business.

We believe our people are critical to our success. We are deeply committed to fostering an environment of continuous learning and development, supporting our teams to drive technological expansion and attract top talent. This commitment is exemplified by initiatives like our Genasys Product and Innovation Campus in Cape Town. Join a team passionate about making insurance better for everyone through cutting-edge technology.

Find out more about us at https://www.genasystech.com/careers/

About The Role

The SQL/DB Developer is responsible to design, develop, optimize, and maintain high-performance database solutions for the Genasys Product.

Responsibilities will include:

  • Design, develop, and maintain complex SQL Server databases.
  • Write optimized stored procedures, functions, views, and triggers.
  • Performance tuning of queries and indexing strategies.
  • Troubleshoot blocking, deadlocks, and wait statistics.
  • Design and optimize ETL processes.
  • Implement and maintain data integrity and security.
  • Review and improve existing database architecture.
  • Assist with data migrations and system upgrades.
  • Create and maintain SSRS/PowerBI Reports and SSAS/Semantic Models.
  • Work with developers to improve application data performance.
  • Create and maintain Technical Documentation.

About You

The ideal candidate will have deep expertise in Microsoft SQL Server, strong performance tuning experience, and the ability to work closely with development, BI, and business teams to deliver scalable data solutions.

You are technically strong, analytical, and comfortable taking ownership of complex database environments.

You are detailed orientated with strong problem-solving skills. You have strong time management and multi-tasking skills. You are able to work independently and efficiently under deadlines. You are a continuous learner and enjoy keeping your technology skills up to date.

You have the following experience:

  • At least 3+ years of hands-on SQL Server development experience.
  • Experience with with SQL Server 2016+ (2019/2022 advantageous)
  • Experience with T-SQL, SSIS, SSRS and PowerBI
  • Experience with index optimisation and statistics management
  • Experience with advanced query performance tuning
  • Understanding of database design and normalisation

About Genasys

51-200 employees

Who We Are

The Genasys story began in 1997 with a visionary founder who recognised that software was the key to revolutionising insurance efficiency and delivering exceptional customer experiences. From humble beginnings, we’ve grown into a recognised Insurtech leader, celebrating over 25 years of innovation. We have a strong foothold in South Africa and the UK, and our expansion into international markets is a testament to our continuous growth and impact. Our unwavering mission is to be the preferred software solutions partner to the insurance industry across Europe, Africa, and the rest of the world.

At Genasys, our core values of transparency, honesty, integrity, and personal accountability drive everything we do. We pride ourselves on delivering excellence in insurance technology, building lasting partnerships, and always doing what we say we will. Our comprehensive and dynamic insurance management system is a testament to our commitment to innovation. It’s a modular, cloud-based solution that can be applied to any insurance business, adapting seamlessly regardless of currency, language, or destination. With our platform, clients benefit from faster product launches and an average of 34% reduction in operating costs, enabling them to transact over £3 billion in Gross Written Premium and manage over 1.5 million insurance policies globally. Our system boasts 352 pre-configured product line templates and 486 robust, well-documented API endpoints, offering unparalleled flexibility and speed to market.

Our flagship platform provides end-to-end policy administration, covering the entire insurance policy lifecycle. This includes intuitive, no-code tools for building wholesale and retail quote-and-bind journeys, seamless renewals, mid-term adjustments, and cancellations. It empowers insurers, MGAs, and brokers to create customised, optimised workflows, manage complex currency, taxation, and multiple languages across regions, and support alternative insurance models such as parametric, micro, or embedded products. The platform is truly designed for insurance, tailored to the unique needs of each business.

We believe our people are critical to our success. We are deeply committed to fostering an environment of continuous learning and development, supporting our teams to drive technological expansion and attract top talent. This commitment is exemplified by initiatives like our Genasys Product and Innovation Campus in Cape Town. Join a team passionate about making insurance better for everyone through cutting-edge technology.

Find out more about us at https://www.genasystech.com/careers/

Why Work For Us

Would you like to work for a company that believes in its staff and its product? A company that instills, "Never forget to have Fun"? Do you have what it takes to be one step ahead of the others? Would you like to be one of the highly valued professional staff members in our team?

If you have answered yes to any one of the above questions, then Genasys Technologies is the right place for you.

Our key differentiator is that we pride ourselves on the outstanding quality of our products, our harmonious relationships with our clients and our commitment to becoming the leading software provider to the South African insurance industry, and we pride ourselves in the caliber of staff we hire. If you can relate to these same qualities and values, we need you to help us grow and obtain our goals through a mutually beneficial relationship. Your success will be our success and vice versa.

Our Culture

Genasys promotes hard work and productivity, without ever forgetting to have fun. We see our team as people with unique and diverse needs and therefore always encourage participation in social and sporting events with teambuilding and also personal enjoyment and satisfaction as the main objectives. "We work hard, and we play hard."

Our Genasys Processes

Genasys makes use of an Agile development process adapted from the Scrum framework in order to ensure that the clients’ expectations are always met or exceeded. Daily stand-ups and an emphasis on client collaboration ensure alignment across all stakeholders every step of the way, while exhaustive Quality Assurance, strict Code Standards, and best practices ensure the delivered product is of the finest quality.

Perks at Genasys

Group of dynamic individuals to work with
Hybrid working model
Ongoing Training, Mentoring and Coaching
Financial benefits include medical aid allowance, group life and pension
Collaborative and supportive culture
Training Academy

Tech Stack

dev ops

Git
Git
Docker
Docker
Selenium
Selenium
Bitbucket
Bitbucket
Kubernetes
Kubernetes

application and data

Javascript
Javascript
MySQL
MySQL
HTML5
HTML5
C#
C#
Microsoft Azure
Microsoft Azure
nginx
nginx
ASP.NET
ASP.NET
MS SQL
MS SQL
.Net Core 2.0
.Net Core 2.0
TypeScript
TypeScript
VB.Net
VB.Net
Angular
Angular
RxJS
RxJS

business tool

JIRA
JIRA
Microsoft Sharepoint
Microsoft Sharepoint
Microsoft Teams
Microsoft Teams
Confluence
Confluence
HubSpot
HubSpot
Miro
Miro

utilities

Power BI
Power BI

Office Photos

Supporting the Pink Drive for Women's Day
GG our Genasys Giraffe Mascot
Monthly Shout outs
Loving our product

Similar jobs on OfferZen: