Senior Database Developer - SQL Server
Titan DMS
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.
Yêu cầu công việc
Essential 5+ years of strong SQL Server / SQL development experience. Strong T-SQL skills. Strong experience writing complex Stored Procedures and SQL scripts. Strong hands-on experience fixing and correcting data in production environments. Experience working with large and complex datasets. Good experience with SSIS. Experience with SQL Server Agent Jobs. Strong understanding of database performance tuning and indexing. Strong data analysis and troubleshooting skills. Good knowledge of accounting concepts and ERP systems. Desirable Experience supporting an ERP, DMS, Accounting or Financial system. Experience investigating data discrepancies. Experience working in a SaaS production environment. Experience working with Agile development methodologies. AI & Engineering Productivity Titan is adopting AI-assisted engineering tools to improve productivity. The successful candidate should be comfortable using tools such as ChatGPT, Claude, GitHub Copilot or similar for: SQL analysis and optimisation. Investigating data issues. Generating and reviewing SQL scripts. Analysing complex datasets. Creating data validation scripts. Technical documentation. Troubleshooting and root-cause analysis. Automating repetitive database tasks. Candidates should be able to review and validate AI-generated output, particularly before executing scripts against production data. Personal Attributes We are looking for someone who: Is careful and methodical when working with production data. Takes ownership of problems through to resolution. Has strong analytical and troubleshooting skills. Understands both the technical and business impact of data changes. Can work independently on complex technical problems. Is comfortable dealing with production issues and time-sensitive requests. Communicates clearly with technical and non-technical stakeholders. Has strong attention to detail. Is willing to share knowledge and support other team members. What You Will Gain Work on a global SaaS ERP platform used by automotive dealerships across multiple international markets. Work with Engineering teams across Vietnam and Australia. Solve complex database, performance and production data challenges. Gain exposure to AWS, DevOps, cloud technologies and AI-assisted engineering. Take ownership of important database solutions within a business-critical platform. Develop your technical expertise and mentoring capabilities.
Quyền lợi
We are our people, and whilst as a business we make software, as an organization, we make some of the industry’s best! Joining the team you will work with the engineers around the world from BMW, Mercedes, Honda, Porches, Hyundai … 1 WORKING HOURS Working hours is flexible and the standard guideline is between 8:00 AM to 5:00 PM with 1 hour break for lunch. Staff can start early and finish early to keep in sync with Australia working hours 2 LEAVES 12 days Annual Leave per annum. Annually leave is accumulated up to 2 years. Additional one annual leave day for every five years of service Sick Leave: 5 days paid per annum. Compassionate Leave: 3 days per annum 3 HEALTHCARE Premium Personal Health Insurance package for full-time and permanent staff. Annual health check 4 BONUSES 13th month bonus Loyalty reward Program (Bonus for every 3 years, 5 years of service) Project/ Performance Bonus 5 OTHER BENEFITS, ALLOWANCES AND INCENTIVES 100% salary during Probation Period Fully sponsored onsite trip to Titan international offices (AU, Thailand, UAE, EU etc.) Gifts on special occasions + holidays (Tet, Full-moon festival, Birthday, Christmas etc.) Employee Referral Program Internal events every month (Happy lunch, Milk tea Friday, etc.) Sport Activity Funding (Football every Tuesday & Thursday) Education Funding