Senior/Lead Database engineer

StartupSoft connects top Ukrainian engineers with world-class startups from Silicon Valley and EU. Our developers work directly on the product as an integral part of the startup team

About project

Delphi is a research group based out of Carnegie Mellon University dedicated to developing the theory and practice of epidemic tracking and forecasting. Pre-pandemic they worked mostly on influenza, dengue and norovirus; they’ve now picked up a focus on COVID. They procure unique data streams that reflect epidemic (or pandemic) activity, extract relevant indicators, and make these publicly and continuously available. They and others then use these indicators for nowcasting (situational awareness) and short-term forecasting

The main goal of Delphi Research Group improving the world’s ability to deal with the next pandemic

Tech stack

MySQL, Python

Team composition

6 full-time engineers (1 DevOps, 1 database, 2 pipeline/statistics/masters, sys admin) + graduate students and professors. The team is mostly in EST

Project stage

Live product

Qualifications and skills

• 5+ years of experience as a software engineer
• Orchestration of billion-row databases and beyond
• Creating and coordinating team-wide plans to test and roll out large-scale designs and changes in a team setting
• Analysis and optimization of database design/performance
• Familiarity with the administration of relational database platforms such as MySQL, Oracle, etc.
• Strengths across data lifecycle (dimensional models, integration, quality, warehouse design, and the best practices)
• Translating logical relations and dimensional models into physical data model implementations
• Experience with cloud technologies such as AWS and Azure
• Ability to problem solve (e.g. working around memory and dusk constraints)
• Participating in the software development life cycle, especially in GitHub
• Data conversations between system and ETL strategies

Nice to have

• Experience with products such as Percona or Percona Server
• Oracle Certified Professional or MySQL Database Administrator certification

Responsibilities

• Supports, participates in, and leads technical projects
• Specifies, designs and implements database specifications and related software systems (often as a small group or small team leader) or modifies existing databases and software packages to meet specific research needs. Responsible for setting and overseeing the development and test schedules for the above in consort with project directors. Documents, new designs, codes, and modifications
• Independently analyzes alternative algorithms, new routines and system changes and suggests program and/or system changes as well as other solutions to problems. Conducts technical assessments, assesses feasibility and compatibility with supported systems and estimates time and resource needs to establish customer agreements and technical roadmaps
• Maintains existing production systems; corrects system bugs; writes system enhancements; performs table/code maintenance; tests system integrations and upgrades; maintains/updates system and user documentation
• Abides by software development guidelines for coding style, version control, unit and/or integration tests, and code review
• Oversees the work of student researchers or lover level programmers and engineers through work distribution and schedule settings
• Supports business user questions/issues regarding applications, systems issues and availability
• Attends required meetings and participates in various seminars and training classes to maintain or upgrade skills needed
• Presents status and performance results at meetings with project managers/directors and attends some meetings with sponsors on and off-site
• Other duties as assigned

Why StartupSoft?

• Work with top entrepreneurs and startups from Silicon Valley and EU
• Become an integral part of the core team — be more than someone who just writes code
• Potential to receive equity in high-growth startups
• Contribute to well-funded products with potential to impact millions
• Beautiful offices in the best locations with high-end amenities
• Tight-knit team with an inclusive and transparent culture
• Only the latest, modern technologies with no legacy code and management bureaucracy
• Above average salary, benefits & medical insurance