ABOUT LINKLY
Linkly is Australia’s leading supplier of payment integration solutions. Annually, our rock-solid middleware processes over 2 billion transactions, across 200,000 terminals, for over 20,000 of Australia’s most iconic merchants.
Linkly has built its strong reputation by providing the seamless integration of payment terminals and POS systems, across multiple decades. Our clients include major banks and iconic Australian retailers such as Woolworths, David Jones, Myer, JB Hi-Fi, and Bunnings.
This is an exciting time to join a rapidly growing company as we build the next generation of best in class in-store payment solutions that seamlessly reduces the touch points within the payment supply-chain. We give our clients the peace of mind to focus on their core business.
Linkly is a founder-led, private company headquartered in Sydney, with offices across Melbourne and Auckland.
From platform to payment, Linkly connects all the dots.
Job Summary
We are seeking a skilled SQL Engineer with a strong focus on PostgreSQL and MS-SQL to join our database engineering team. The ideal candidate will have a deep understanding of database architecture, performance tuning, and data modelling, along with hands-on experience in managing and optimizing SQL databases, including crafting and troubleshooting complex SQL queries and stored procedures.
This role will work closely with software developers, data analysts and other key Linkly stakeholders to address database needs, ensure smooth integration with applications and perform functional analysis.
This position offers an opportunity to:
- Apply your SQL expertise in a high-growth, dynamic environment
- Own new database projects and optimise existing database architecture
- Contribute to the development of Australia’s next generation of payments solutions
Key Responsibilities:
Database Management:
- Design and implement efficient data models that leverage database engine capabilities, including indexes, keys, and storage configurations to enhance performance.
- Monitor and maintain database health, ensuring data integrity and availability.
API Development & Integration:
- Build, store, and maintain APIs efficiently, ensuring seamless integration with relational databases using SQL Server.
- Develop clean, well-documented APIs that adhere to best practices and facilitate data access.
SQL Development:
- Write and optimize complex queries using T/SQL to ensure high performance of database.
- Implement best practices for query performance, data storage, and retrieval, focusing on efficiency and scalability.
Data Compliance:
- Maintaining highest standard of data compliance / hygiene across database infrastructure and operational processes (e.g. user management).
- Maintenance of key compliance artefacts e.g. documentation, audit-trails, processes etc.
Python Programming:
- Develop and maintain scripts for the logic layer of applications, focusing on data handling and automation of processes.
- Collaborate with teams to integrate Python scripts with existing systems and workflows.
Automation & Scripting:
- Create automation scripts using Shell, Python, PowerShell, and Terraform to enhance system efficiency across both Windows and Linux environments.
- Identify opportunities for automation to streamline operations and reduce manual tasks.
CI/CD Pipelines:
- Collaborate on the development and maintenance of continuous integration and continuous deployment pipelines using tools like Jenkins and GitLab CI/CD.
- Ensure reliable and automated deployment processes for database changes and application updates.
Version Management:
- Maintain code and version control using Git and GitLab to manage source code and oversee development workflows.
- Ensure proper documentation and tracking of changes to facilitate collaboration and knowledge sharing within the team.
Experience:
- 5+ years of experience in SQL database engineering, with a focus on PostgreSQL and MS-SQL.
- 2+ years of experience in leading data projects
- Proficiency in writing and optimizing SQL queries.
- Strong knowledge of database architecture, data modelling, and ETL processes.
- Familiarity with database management tools and monitoring software.
- Excellent analytical and troubleshooting skills, with a keen attention to detail.
- Ability to work under pressure and meet tight deadlines.
- Strong communication skills, both verbal and written.
- A collaborative mindset and the ability to work effectively in a team environment.
Behaviours required
At Linkly, we encourage our people to embrace our values, being:
- Act like an owner
- Innovate
- Deepen Trust
- Care and respect