Software Engineer – PostgreSQL Optimisation Expertise – Perth, Australia - Fulltime Role

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Job title: Software Engineer – PostgreSQL Optimisation Expertise – Perth, Australia

Live and Work in Paradise

 

Perth, Western Australia could be described as a paradise.  A safe, modern city of 2 million people stretched along an endless white beach on the crystal blue waters of the Indian Ocean.  3 hours’ drive south is the world class wine district and surfing mecca that is Margaret River.  3 hours’ flight north is Bali.  Perth is the home of the world’s biggest mining companies and the regional hub of the world’s largest Oil & Gas companies.  There are few places on the planet that can compare when deciding where to raise a family or advance your career. 

The Company – Manufacturing Intelligence Pty Ltd

Manufacturing Intelligence is a young and energetic software company that is months away from transforming the mining industry forever! We pride ourselves on our ability to innovate to solve real problems, high standards of software engineering, work ethic, accountability and teamwork. Our offices are set up for the job; we have floor-to-ceiling whiteboards throughout which are always filled with an ever-changing canvas of math and design concepts. We are building some very exciting, functionally rich, highly scalable and highly performant software that will deliver significant bottom line benefits for our mining customers.

We are currently executing a world-first – building and trialling a revolutionary software at some of the world’s largest mining companies.  This has been recognized by the Australian government by way of a substantial innovation grant and Australia’s leading research organisation whom have partnered with us to exploit their IP via our software.

The Software

 

The software is a spatiotemporal, real-time, subterranean and above surface tracking solution for materials, equipment and personnel. Basically, an operational digital twin of any operation. We are also developing a highly advanced dynamic physics engine to calculate the effect of events such as blasting, digging, dozing and stockpiling with regards to material behaviour applying fluid dynamics research (amongst others) from the CSIRO (guys who invented WIFI amongst other things).

 

The software is all cloud native, networked storage, horizontally parallelisable, dealing with significant amounts of data and large data files rapidly.  Not only is it a game changer for industry in terms of lowering costs of production but has an added benefit of ensuring the minimal environmental impact is achieved per unit produced.

 

The software is revolutionary for the Mining, Oil & Gas, Pharmaceutical and Manufacturing industries.

The Role

We partition our data over a number of databases, so we are able to scale by adding more PostgreSQL servers to our environment. However, from a cost perspective, we seek to maximise the performance out of each instance independently. By doing so, we reduce the number of PostgreSQL servers we need, and therefore the costs.

We need a top-level innovator with expertise in optimizing performance of PostgreSQL, in terms of designing and building the table structures, indexes, partitions, query/DML statement design, etc. You will be a problem solver and a team player – working with other developers to ensure (where applicable to PostgreSQL performance) that your code, tables, etc. are designed and implemented optimally. 

You will be an expert in engineering high performance, high concurrency, high contention databases, with knowledge of database locking mechanisms, database performance analysis, and the resolution of database performance issues. Ideally you will have experience with high volume/concurrency relational databases (ideally with PostgreSQL).

It is essential to have experience dealing with large data volumes, highly concurrent inserts/updates, be very familiar with database locking/isolation techniques, database performance analysis (e.g. familiar with query execution plans) and database performance issue/bottleneck identification and resolution. In particular, you need to have deep experience with NHibernate (ideally on top of PostgreSQL) in high performance, high concurrency and high contention database environments. 

We need you to be the expert within our company.  This is a critical role and your remuneration will reflect this.

If you are interested in the role, we would like to understand what experience you have in maximising the performance of PostgreSQL in terms of:

  • Transactions per second
  • Row inserts per second
  • MB written per second

 

In your role as a software developer the following skills are required:

 

  • Design patterns and best practices in enterprise application architecture, object oriented design, database design and distributed systems design, including messaging patterns.
  • Experience designing systems with high levels of reliability, robustness, scalability and efficiency.
  • Asynchronous programming.
  • Configuration and performance analysis of relational database management systems.
  • Synchronous and asynchronous messaging between distributed components.
  • Experience with message-oriented-middleware (MOM) such as RabbitMQ.
  • Containerisation and container scheduling using technologies such as Docker and Kubernetes.
  • Experience with cloud environments, ideally AWS.
  • Unit testing.
  • Continuous integration and associated tooling.
  • Strong written and verbal communication skills.
  • Agile software development methodologies.

The job is based in our offices in Perth, Australia.   We offer full relocation and visa costs from anywhere in the world. The remuneration package on offer is world class!  This is a career defining role working with a high calibre team on truly revolutionary software solutions.  So why not take a few minutes and have a quick discussion? 

The Package

Full relocation costs, visas, US$100k to US$125k salary, but with lower cost of living afforded in Australia. Australia also boasts a world leading healthcare system and 4 weeks paid annual leave a year and 9.5%superanuation.

Find out more

 

If you interested in finding out more, please contact me directly – John Kirkman – Co-Founder/Managing Director Manufacturing Intelligence Pty Ltd. John.kirkman@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

The Process

The engagement process will generally be as follows for a successful candidate:

 

  1. Send Resume for Review
  2. Phone Call Interview
  3. Role Negotiation
  4. Face to Face Interview – we will cover all travel costs
  5. Role awarded

 

 

Cheers,

 

id:image001.png@01D38855.AA7246D0

 

John Kirkman

Managing Director

T: +61 (0) 415 188 046

A: Level 10, 172 St Georges Tce, Perth WA 6000

W: www.manufacturingintelligence.com.au

This email and any attachments are proprietary and confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily reflect or represent those of Manufacturing Intelligence. If you have received this email in error, please let us know immediately by reply email and delete it from your system. You may not use, disseminate, distribute or copy this message nor disclose its contents to anyone. Manufacturing Intelligence (73 612 963 112), Perth Western Australia 6000

 


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql Admin]     [PHP Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux