Senior Software Developer

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.