Greetings,
I just came across your requirement for developing an autonomous system to perform certain actions against a DB and an API. I would like to tell you that the biggest challenge I have observed that regular developers struggle with is the concept of proper resource management in such systems. careless development approaches combined with disregard towards best programming practices lead to software that leak memory and resources. the result is a software which crashes frequently and needs to consistently monitored where as it was originally supposed to work interaction-free.
second most overlooked issue is lack of proper logging of all the automated workflows performed behind the scenes and that makes the auditing aspect near to impossible.
I have recently developed a software for a client in New Jersey which runs as windows service, connects with Azure cloud services every 30 seconds and performs a set of operations and workflows. the longest run time for that service was over 8 weeks of continuous operations without any glitch or crashing. every action taken was documented and fully auditable with all the data points.
Next step for you is to discuss your requirements in detail to lock down the scope. if required, I'll revisit the timeline and financials. after our agreement on the technical and financial aspect, we can start working right away.