Position: Database Developer
Company: Waverley Software
Experience required: 3y
English level: intermediate

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.

The PostgreSQL Database Developer is responsible for developing database code. This is a central role in our development team that will build effective APIs that access and manipulate very large geospatial datasets, working with product managers, back-end developers, front-end developers, data analysts, and as needed.

**Responsibilities:**
-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
-Work with product managers to ensure database code meets requirements. -Work with data analysts to ensure database code is accurately documented.
-Participate as a member 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.

**Required Skills:**

-3+ years working as a database developer working with PostgreSQL.
-Expert Level 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.

**Desired Skills:**

-Demonstrable 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