PostgreSQL developers

Create and maintain database tables, views, indexes, and triggers.

Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.

Develop and maintain high-quality stored procedures.

Write low cost, high-quality database queries and code while maintaining data quality, privacy, and security

Profile databases, measure database performance and troubleshoot complex database issues, and IO bottlenecks.

Optimize database queries and ensure table locking/deadlocks happen in production.

Optimize large, complicated SQL statements & Stored Procedures.

Cost optimization of Amazon instances using databases.

Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels

Knowledge of message queuing, indexing, and high-performance data concept

Knowledge of JSON and PostgreSQL support for JSON.

Good Grasp of ETL concepts

Work with front-end developers to define simple yet powerful APIs

Work with DBAs to ensure the efficiency of database code, integrity of data structures and quality of data content.

Coordinate with product managers and leadership teams to build effective database objects

Excellent verbal and written communication skills

Good attitude towards work and flexibility

Ability and willingness to handle multiple tasks in a fast-paced environment

Ability to evaluate alternative solutions and/or workarounds