Our client helps companies keep their people and operations secure with Micro-Intelligence or street-level threat assessments. Using AI to aggregate public and proprietary information, the product has created the world’s largest dataset of global threat patterns. A visualization platform helps companies conduct geolocation-based analysis for travel safety, threat intelligence, crisis management, and site selection and expansion.
Waverley Software is looking for a database developer to join our project team. If you’ve been dreaming to become a part of a mature, tech-savvy community of domain experts and like-minders, you are on the right way!
The PostgreSQL database developer on this project will play the central role in our team developing the database code and building effective APIs that access and manipulate very large geospatial datasets. This position also involves working with product managers, back-end developers, front-end developers, data analysts, and other team members, if needed. Let’s consider the details below.
- 3+ years working as a database developer working with PostgreSQL.
- Expert Level in SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
- Knowledge of JSON and PostgreSQL support for JSON.
- Ability to efficiently write database code without compromising data quality, privacy, or security.
- Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
- Excellent interpersonal communication skills. At least Intermediate level of English (verbal and written).
- Ability to evaluate alternative solutions and/or workarounds.
- Ability to make recommendations in order to improve processes, technologies, and tools.
Nice to have:
- Experience working with huge, interdependent, complex datasets and data structures.
- Experience with NoSQL databases.
- AWS: ECS, CloudFormation, EKS, Lambda functions, S3, IAM
- PostGIS proficiency and grasp of geospatial concepts.
- GitHub Actions.
- Online geographic mapping (e.g. Google Maps, Mapbox APIs.
- Data processing pipelines.
- Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
- Work with data analysts to implement geospatial processes, queries, and reports.
- Ensure the efficiency of database code, the integrity of data structures, and the quality of data content.
- Implement effective and maintainable database coding practices that form an architectural foundation.
- Collaborate with product managers to ensure that database code meets the requirements.
- Collaborate with data analysts to ensure database code is accurately documented.
- Participate in Agile teams and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in sprint reviews.