988 karma · joined July 20, 2010
View jobs here: https://technical.ly/company/pinnacle-21/
Here are articles about a couple members of our team:
https://technical.ly/professional-development/pinnacle-21-so...
https://technical.ly/company-culture/pinnacle-21-hiring-saas...
Based in the Philadelphia area, Pinnacle 21 is a leader in clinical trial data software and services. Our vision is a clean data pipeline that ends in a successful regulatory submission. Come help us revolutionize clinical trials and streamline the drug approval process.
View jobs here: https://technical.ly/company/pinnacle-21/
Here are articles about a couple members of our team:
https://technical.ly/professional-development/pinnacle-21-so...
https://technical.ly/company-culture/pinnacle-21-hiring-saas...
https://predictivehealthcare.pennmedicine.org/2020/03/14/acc...
Setting up stuff like Oauth / Okta / etc and handling things like who can access admin screens seems to consume a lot of time on new projects - it'd make for an awesome app platform if some of that was well-supported out of the box.
Senior DevOps / Cloud Engineer (Remote Friendly!) to help us build large scale data pipelines with remote sensing and life sciences data in the cloud.
Job Description + Apply here: https://jobs.smartrecruiters.com/Element84Inc/74399970673121...
Apply above, I'm not the hiring manager available if you have questions - gary @ company name . com.
https://www.element84.com/careers
We're taking on some of the biggest challenges in software: petabyte search, consumer streaming, and Earth science repositories, just to name a few. We are a team of gamers, musicians, artists, pitmasters, pilots, and tinkerers and we think you might have fun helping us solve some big problems.
Element 84 was founded by husband-and-wife engineers and has grown into a skilled group of developers, designers, project managers, and business team that build high performance systems for some of the biggest corporate and government clients in the world. Our main office is located in Alexandria, VA but we support a large remote workforce from Michigan to Texas and Pennsylvania to Colorado.
If you have questions, email me at gary@element84.com and I'll get reply quickly.
Adobe XD is also a free prototyping tool - I would go through a tutorial or watch a few youtube videos of people working to get a feel for it.
One potentially simple option is to have the database temp space stored in RAM, by registering a ramdisk. That also helps large sorts, which implicitly make temp tables.
You can also manually inline everything, but if you have a lot of joins, you may end up tuning queries by changing join order. By default, if there are >8 joins it uses the order you give it. If you set the 8 higher the planning step takes a little longer - fine if it's for ETL but not ideal for a web app.
The content is selected by recommendations - e.g. someone on HN say a speaker was good, so bring in all the conferences they spoke at, then there are some filters to exclude things (e.g. terrible audio).
There are also facets to explore different ways, and my experience has been that this approach works well for researching new technology, in that I can typically find a small number of highly relevant talks on a subject I'm researching.
I'm relying primarily on trusted recommendations - if someone I trust likes a speaker, I'll index channels where they speak. This doesn't scale well, but it has made for a tool that works really well for doing research.
The blog entries let me save time if I return to a problem and tell me at what point I stopped.