Lead Engineer - IT

Job Description:

Qualifications:

The PostgreSQL Database Developer is responsible for developing database code. Will be involved in analyzing existing PL/SQL code and rewriting it PostgreSQL. Will be part of the modernization project and will work closely with Technical Architect and Front end developers.

Responsibilities:

Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Work with front end developers to define simple yet powerful APIs.
Work with DBAs 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 with DBAs and 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:
5 to 8 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
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

Location:

This position can be based in any of the following locations:

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday