Responsibilities:
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, Work with front end developers to define simple yet powerful APIs.
Work to ensure efficiency of database code, integrity of data structures and quality of data content.
Work with product managers to ensure database code meets requirements.
Work to ensure database code is accurately documented.
Work to maintain Postgraphile environment.
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
Knowledge of SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
Knowledge of JSON and PostgreSQL support for JSON.
Experience with Postgraphile.
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
Familiarity with python/plpython
Able to handle multiple tasks in a fast paced environment
Excellent verbal, written, and interpersonal communication skills
Ability to evaluate alternative solutions and/or workarounds