Senior Database Developer - SQL Server

Mô tả công việc

About Us

As a global player in the SaaS automotive landscape, Titan Dealer Management Solutions (Titan DMS) boasts over 160 staff globally and SaaS representation across more than 26 markets. Titan is now recognised as one of the leading suppliers of technologically driven industry solutions to automotive dealers and manufacturers around the world.

Since 2009, Titan’s flagship product, the Titan Dealer Management System (Titan DMS), has been adopted by Franchised Automotive Dealerships covering over 45 different Automotive Brands throughout Australia, Asia, Pacific Region, Middle East, UK, Africa and Europe, and continues to extend its global reach and reputation as a leading international software provider.

 

The Role

We are looking for a Senior Database Developer – SQL Server to join our Engineering team.

This role is responsible for developing and maintaining database solutions, supporting production environments, resolving complex data issues, and performing data imports, migrations and corrections.

A key focus of the role is the ability to safely investigate and fix production data, develop reliable SQL scripts, and work with tools such as PowerShell and SSIS to import and transform data.

The successful candidate will also have a good understanding of accounting concepts and ERP systems.

 

Key Responsibilities

Database Development

• Participate in solution design and development of database solutions.
• Develop and maintain Stored Procedures, Views, Functions, SQL scripts and database objects.
• Extract, analyse and mine data using SQL.
• Optimise complex SQL queries, Stored Procedures and Views.
• Participate in database code reviews and provide technical guidance to other developers.
• Assess the impact of change requests and develop appropriate database solutions.

Production Data Support & Correction

• Investigate and resolve complex production data issues.
• Identify incorrect, missing, duplicated or inconsistent data and determine the root cause.
• Develop and execute safe data correction scripts in production.
• Assess the impact of data changes before implementation.
• Apply appropriate validation, backup and rollback strategies for production data changes.
• Validate corrected data and ensure the issue has been fully resolved.
• Document data corrections, root causes and preventative actions.
• Work with Development, Support, BA and other teams to resolve data-related production issues.

Data Import, Migration & Conversion

• Develop and execute data import and migration solutions using:
  • SQL scripts
  • SSIS
  • Other appropriate data integration tools.
• Perform data mapping, transformation and validation.
• Develop repeatable and reliable data import processes.

Accounting & ERP Data

• Good understanding of accounting concepts and ERP systems.
• Understand how financial and transactional data is represented within an ERP/DMS.
• Ability to investigate and resolve data discrepancies while considering their business and financial impact.
• Work with BA and other stakeholders to validate data corrections and ensure the expected business outcome.

Database Performance

• Monitor and troubleshoot database performance issues.
• Analyse execution plans and query performance.
• Optimise SQL queries, Stored Procedures and database structures.