SQL Database Developer: The primary purposes of this role include data migration, application development and assisting other developers in database development. In the role you will develop new code, models, structures and processes to support our current and new products. You may also assist in the administration of the databases. The role is to help ensure performance, capacity, functionality, tuning, deployment and that best practices are followed at all times.

The current databases are MS SQL Server. You will work with a small but skilled team in a highly complex international solution environment and collaborate with developers and product management to understand our domain and deliver out products, with security at the heart of everything we do.

Key activities

Write and support SQL queries and stored procedures in a SaaS based environment

Assist and provide leadership in migrating data between different generations of applications

Assist in data acquisition for an online product

Assist developers with complex query tuning and schema refinement

Work with the application development team to implement new data products

Title

SQL Database Developer

Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.

Communicate regularly with other technical, applications and operational staff to ensure database integrity and security

Manage the disaster recovery aspects of a database

Research and implement new related database technologies as necessary

Maintains quality service by establishing and enforcing best practices

Implement and maintain automated database maintenance plans and backs up routines using standard methodologies

Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.

Maintain professional competence by complying at all times with the training and competence procedures of the company

To undertake any other reasonable duties as deemed appropriate by management, commensurate with the level of the post so as to ensure the smooth running of Acupay

Required skills and experience

5+ years of database development with significant MS SQL Server Experience

Ability to write and troubleshoot SQL code, design stored procedures, create functions, tables, views, triggers, and indexes

Experience with ETL processing and ETL tools like SSIS

Any experience in data migration between different generations of an online product

Strong knowledge of MS SQL Server 2016 or later

Thorough understanding of database structures, theories, principles, & best practices

Technical knowledge of MS SQL Server internals with emphasis on query performance.

Degree in Computer Science, Engineering or a related subject preferred, or the equivalent work experience

Excellent written and verbal communication skills

Enthusiastic, self-driven, willing to go the extra mile and work at own initiative

Ability to work under pressure, to work independently as well as to be a team player, particularly across different sites and time zones

DESIRABLE

Any experience with a scripting language such a Python

Experience in a cloud-environments with an emphasis on AWS

Data modelling experience

DBA experience with any relational databases technologies

3

Deliverables

High-quality database source code, in compliance with Acupay's coding standards for readability, maintainability, and efficiency.

Database availability, performant, and resilient

Clear and comprehensive technical documentation.