Skill Profile

PostgreSQL

PostgreSQL: SQL, indexes, transactions, JSONB, extensions, replication

Database Management Relational Databases

Roles

69

where this skill appears

Levels

5

structured growth path

Mandatory requirements

122

the other 221 optional

Domain

Database Management

Group

Relational Databases

Last updated

3/17/2026

How to Use

Choose your current level and compare expectations. The items below show what to cover to advance to the next level.

What is Expected at Each Level

The table shows how skill depth grows from Junior to Principal. Click a row to see details.

Role Required Description
1C Developer Understands basic PostgreSQL usage for 1C development: connecting 1C:Enterprise to PostgreSQL databases, basic SQL queries for data extraction from 1C tables, understanding 1C-to-PostgreSQL data type mappings. Follows team conventions for database access patterns in 1C configurations.
AI Product Engineer Understands basic PostgreSQL for AI product work: storing model metadata and experiment results, basic queries for feature retrieval, pgvector extension basics for embedding storage. Follows team conventions for ML data schemas and connection management.
Analytics Engineer Required Writes basic SELECT queries on PostgreSQL for extracting data from staging tables. Understands data types, JOINs, and GROUP BY for simple analytical tasks. Uses pgAdmin or DBeaver for exploring database structure.
Android Developer Understands basic PostgreSQL concepts for Android backend interaction: REST API data flows backed by PostgreSQL, basic understanding of backend database schemas, reading SQL queries for debugging API responses. Follows team conventions for mobile app data layer patterns.
Application Security Engineer Understands basic PostgreSQL security concepts: SQL injection detection and prevention, database access control basics (roles, privileges), connection security (SSL/TLS). Follows team conventions for security assessment of PostgreSQL configurations.
AR/VR Developer Performs basic SQL queries for working with AR/VR application data in PostgreSQL. Understands storing scene metadata, user profiles, and space configurations.
Backend Developer (C#/.NET) Required Works with PostgreSQL via EF Core (Npgsql): entity mapping, LINQ queries, raw SQL via FromSqlRaw. Understands PostgreSQL types: UUID, JSONB, arrays. Uses pgAdmin.
Backend Developer (Elixir) Required Performs basic SQL queries to PostgreSQL through Ecto in Elixir projects. Creates simple schemas with fields, types and associations (has_many, belongs_to). Uses Ecto.Query for selections, filtering and sorting data in Phoenix applications.
Backend Developer (Go) Required Executes basic SQL queries to PostgreSQL from Go services via pgx or database/sql. Understands PostgreSQL data types, writes simple SELECT/INSERT/UPDATE with parameterized queries for SQL injection protection.
Backend Developer (Java/Kotlin) Required Works with PostgreSQL via JPA/Hibernate: entity mapping, JPQL queries, native queries. Uses pgAdmin for data and schema analysis. Understands PostgreSQL data types: UUID, JSONB, arrays.
Backend Developer (Node.js) Required Works with PostgreSQL via Prisma/Knex: CRUD queries, relations, migrations. Understands PostgreSQL types (JSONB, arrays, UUID). Uses Prisma Studio for data inspection.
Backend Developer (PHP) Required Works with PostgreSQL: writes SQL queries, creates tables, understands data types (jsonb, arrays, uuid). Uses pgAdmin or CLI. Understands differences from MySQL in syntax and types.
Backend Developer (Python) Required Writes SQL queries: SELECT, JOIN, WHERE, GROUP BY. Creates tables with proper data types. Uses ORM for CRUD. Understands foreign keys and constraints.
Backend Developer (Rust) Required Performs basic CRUD operations with PostgreSQL from Rust through SQLx or Diesel using type-safe queries with compile-time verification. Understands Rust type mapping to SQL types (String->TEXT, i32->INTEGER) and works with connection pools through sqlx::PgPool.
Backend Developer (Scala) Required Performs basic SQL queries to PostgreSQL from Scala applications through Doobie or Slick: SELECT, INSERT, UPDATE with parameterized queries. Understands PostgreSQL data types, works with migrations through Flyway and can read simple query execution plans.
BI Analyst Required Understands basic PostgreSQL for BI work: writing SELECT queries with JOINs and aggregations, understanding table relationships for report building, basic query optimization with EXPLAIN. Follows team conventions for analytical query patterns and data warehouse schemas.
Blockchain Developer Works with PostgreSQL for blockchain: indexed chain data, transaction history storage.
Cloud Engineer Works with managed PostgreSQL in cloud: RDS/Cloud SQL setup, basic queries, connecting from Lambda/Cloud Functions. Understands connection pooling for serverless.
Compiler Engineer Knows relational database and SQL basics. Can run simple queries against compiler metadata databases: configurations, test results, build information.
Computer Vision Engineer Understands basic PostgreSQL for CV work: storing image metadata and annotation data, basic queries for dataset management, understanding blob storage patterns for image references. Follows team conventions for CV dataset schema design and query patterns.
Data Analyst Required Understands basic PostgreSQL for data analysis: writing analytical queries with window functions, understanding table structures for exploratory analysis, basic CTEs for complex data extraction. Follows team conventions for analytical query organization and data access patterns.
Data Engineer Required Writes SQL queries for data extraction: SELECT with JOIN, GROUP BY, window functions. Works with psycopg2/SQLAlchemy. Understands PostgreSQL types: JSONB, arrays, timestamps with timezone.
Data Scientist Understands basic PostgreSQL for data science: extracting training datasets with SQL queries, understanding schema design for feature stores, basic query optimization for large data retrieval. Follows team conventions for ML data pipeline database interactions.
Database Engineer / DBA Works with PostgreSQL: creating tables with constraints, basic queries, psql CLI. Understands data types (JSONB, arrays), sequences, schemas. Can use EXPLAIN ANALYZE for simple query analysis.
Desktop Developer (.NET WPF/WinUI/MAUI) Uses PostgreSQL through EF Core with Npgsql provider. Performs CRUD through DbContext. Configures connection string and DbContextOptions.
Desktop Developer (Electron/Tauri) Understands basic PostgreSQL concepts for Electron app backends: connecting desktop apps to PostgreSQL through APIs, basic understanding of database schemas for app data, reading queries for debugging data layer issues. Follows team conventions for desktop app database integration patterns.
Desktop Developer (Qt/C++) Uses PostgreSQL through Qt SQL (QSqlDatabase, QSqlQuery) for local data storage. Performs basic CRUD operations. Configures connection through QSqlDatabase::addDatabase.
DevOps Engineer Performs basic SQL queries for analyzing infrastructure logs and metrics. Understands table structure, can do SELECT with JOIN to extract data from monitoring systems. Works with pg_dump/pg_restore for creating backups by instruction.
DevSecOps Engineer Performs basic SQL queries against PostgreSQL for analyzing security logs and audit records. Understands table structures for storing security scanning data and incident records.
Embedded Developer Knows SQL basics and can run simple PostgreSQL queries for storing telemetry from embedded devices. Understands basic data types and can create a table for device logs.
Engineering Manager Understands basic PostgreSQL concepts for engineering management: database performance metrics relevant to SLA monitoring, understanding migration strategies for sprint planning, recognizing scaling bottlenecks in team discussions. Follows team conventions for database-related decision documentation.
Flutter Developer Performs basic SQL queries for working with Flutter app data in PostgreSQL. Understands the server-side table structure and its relationship to Dart code data models.
Frontend Developer (Angular) Understands basic PostgreSQL concepts for Angular full-stack context: how API endpoints map to database queries, basic understanding of relational schemas for form/table UI design, reading query results for frontend debugging. Follows team conventions for data-driven Angular component patterns.
Frontend Developer (React) Understands basic PostgreSQL concepts for React full-stack context: how API data flows from database to React components, basic understanding of relational data for state management design, reading query patterns for debugging data fetching issues. Follows team conventions for data-driven React component architecture.
Frontend Developer (Svelte) Understands basic PostgreSQL concepts for Svelte full-stack context: how SvelteKit server routes interact with databases, basic understanding of data models for reactive store design, reading query results for debugging server-side data loading. Follows team conventions for Svelte data layer patterns.
Frontend Developer (Vue) Understands basic PostgreSQL concepts for Vue full-stack context: how Nuxt/Vue API routes connect to databases, basic understanding of relational schemas for Vuex/Pinia store design, reading query patterns for debugging data flows. Follows team conventions for Vue data layer architecture.
Fullstack Developer Writes basic SQL queries for fullstack applications: CRUD operations, JOINs, filtering. Understands the connection between PostgreSQL schema and backend models (Prisma/TypeORM), can read query plans and create tables for new features.
Game Designer Understands basic PostgreSQL concepts for game design: how game data (items, quests, progression) is stored in relational tables, basic queries for game balance data analysis, understanding data schemas for level and content design. Follows team conventions for game data documentation.
Game QA Engineer Works with PostgreSQL for QA: checks game data integrity, validates database states after tests. Writes SQL for test verification.
Game Server Developer Understands basic PostgreSQL for game servers: storing player profiles and game state, basic queries for leaderboard and inventory systems, understanding connection pooling for game server workloads. Follows team conventions for game database schema design and data access patterns.
Infrastructure Engineer Performs basic PostgreSQL operations as an infrastructure engineer: server installation through package managers, configuring pg_hba.conf for network access, creating users and databases. Can run backups through pg_dump and monitor state through pg_stat_activity.
iOS Developer Studies PostgreSQL and relational database basics for understanding the server side of iOS applications. Understands SQL syntax, data types, and basic CRUD operations for mobile user data.
IoT Engineer Knows SQL basics and relational databases. Can execute simple PostgreSQL queries to retrieve data about registered IoT devices and their configurations.
Language Tooling Engineer Understands basic PostgreSQL for language tooling: storing symbol tables and package registry data, basic queries for dependency resolution, understanding schema design for language server index storage. Follows team conventions for tooling data persistence patterns.
LLM Engineer Understands basic PostgreSQL for LLM work: storing prompt templates and conversation history, pgvector basics for RAG embedding storage, basic queries for retrieval pipeline data management. Follows team conventions for LLM application database schemas.
ML Engineer Writes basic SQL queries for extracting data from PostgreSQL. Loads data into pandas via psycopg2/SQLAlchemy. Understands basic JOIN and GROUP BY.
MLOps Engineer Performs basic SQL queries against PostgreSQL to extract data needed by ML pipelines: selecting training datasets, checking prediction results. Understands table schemas with model and experiment metadata, writes simple JOIN queries for preparing features from relational sources.
Network Engineer Knows SQL basics and can execute basic queries against PostgreSQL to retrieve network infrastructure data — device lists, VLANs, IP addressing from IPAM/CMDB systems.
NLP Engineer Knows PostgreSQL basics: creating tables, basic queries, indexes. Stores NLP data: text corpora, annotations, processing results. Uses full-text search for simple tasks.
Penetration Testing Engineer Understands basic PostgreSQL security testing: identifying SQL injection vectors, enumerating database permissions and roles, basic post-exploitation data extraction techniques. Follows team conventions for documenting database security findings.
Performance Testing Engineer Analyzes PostgreSQL performance: EXPLAIN for query plans, pg_stat_statements for slow queries. Understands connection pooling impact. Collects baseline metrics.
Platform Engineer Works with PostgreSQL in platform context: database provisioning for tenants, basic SQL for platform services. Configures managed PostgreSQL.
QA Automation Engineer Understands basic PostgreSQL for test automation: setting up test databases, writing assertions against database state, basic data seeding and cleanup scripts. Follows team conventions for database test fixtures and test data management.
QA Engineer (Manual) Understands basic PostgreSQL for manual QA: reading database records to verify test results, writing simple SELECT queries for data validation, understanding table relationships for test scenario design. Follows team conventions for database-level test verification.
QA Security Engineer Understands basic PostgreSQL security testing: testing for SQL injection vulnerabilities, verifying database access controls and encryption settings, validating input sanitization in database queries. Follows team conventions for security test coverage of database interactions.
React Native Developer Understands basic PostgreSQL concepts for React Native backend interaction: how mobile API calls map to database operations, basic understanding of backend schemas for mobile data synchronization, reading query patterns for debugging API data issues. Follows team conventions for mobile data layer architecture.
Release Engineer Executes basic SQL queries to monitor release status in PostgreSQL. Understands table structures storing artifact metadata, versions, and deployment statuses.
Security Analyst Performs basic SQL queries for security event analysis in PostgreSQL. Understands schemas for storing logs, vulnerabilities, and scan results in the database.
Site Reliability Engineer (SRE) Writes SQL queries for SRE tasks: incident analysis, metric extraction from operational DB. Works with PostgreSQL for configuration and audit log storage. Understands basic DB monitoring.
Smart Contract Developer Works with PostgreSQL for blockchain: stores indexed chain data, transaction history. Writes basic SQL queries.
Systems Programmer (C/C++) Understands PostgreSQL internals: storage engine basics, shared memory, process architecture.
Technical Lead Works with PostgreSQL: basic SQL queries, understands schema design, indices. Uses ORM for data access and understands generated SQL.
Technical Product Manager Understands basic PostgreSQL concepts for product management: database performance impact on product SLAs, migration planning for feature releases, recognizing data model constraints in feature discussions. Follows team conventions for database-related product decision documentation.
Technical Writer Understands basic PostgreSQL concepts for documentation: documenting database schemas and data models, writing query examples for API documentation, understanding table relationships for data flow diagrams. Follows team conventions for database documentation standards.
Telecom Developer Understands basic PostgreSQL for telecom development: storing CDR (call detail records) and subscriber data, basic queries for call analytics, understanding schemas for telecom billing and provisioning systems. Follows team conventions for telecom database access patterns.
Unity Developer Understands PostgreSQL for Unity: backend data storage, player profiles, game state. Integrates via REST API.
Unreal Engine Developer Understands PostgreSQL for Unreal backend: player data storage, game state persistence. Integrates via API.
XR Unity Developer Knows SQL and PostgreSQL basics for working with XR application data: user profiles, progress, settings. Can write basic SELECT/INSERT queries for XR project backend services.
Role Required Description
1C Developer Independently designs schemas and optimizes queries for 1C-PostgreSQL integration: manages 1C data type mappings in PostgreSQL, optimizes queries for 1C report generation, configures connection pooling for 1C server workloads. Understands trade-offs between 1C built-in data access and direct SQL optimization.
AI Product Engineer Independently designs schemas for AI product data: optimizes queries for feature retrieval and model metadata, implements pgvector indexes for embedding similarity search, configures connection pooling for ML serving workloads. Understands trade-offs between PostgreSQL and specialized vector databases for AI applications.
Analytics Engineer Required Creates complex analytical queries with CTEs, window functions, and subqueries in PostgreSQL. Uses EXPLAIN ANALYZE for profiling queries on large tables. Works with PostgreSQL-specific types: JSONB, ARRAY, INTERVAL.
Android Developer Designs efficient PostgreSQL schemas for Android backend services. Optimizes queries for mobile APIs considering cursor-based pagination, filtering, and delta synchronization.
Application Security Engineer Implements PostgreSQL security hardening: row-level security, data encryption at rest, audit logging configuration. Reviews SQL queries for SQL injection and data leakage vulnerabilities.
AR/VR Developer Designs PostgreSQL schemas for an AR/VR platform — storing spatial data and scenes. Uses PostGIS for working with geolocation in AR applications and spatial queries.
Backend Developer (C#/.NET) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses Entity Framework Core effectively.
Backend Developer (Elixir) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses Ecto effectively.
Backend Developer (Go) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses sqlx/GORM effectively.
Backend Developer (Java/Kotlin) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses Hibernate/JPA effectively.
Backend Developer (Node.js) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses Prisma/TypeORM effectively.
Backend Developer (PHP) Required Uses PostgreSQL features: JSONB for semi-structured data, CTEs for complex queries, window functions for analytics. Works with GIN/GiST indexes. Configures pg_stat_statements for monitoring. Applies LISTEN/NOTIFY for real-time events.
Backend Developer (Python) Required Uses CTEs, window functions, JSONB operations. Configures connection pooling (PgBouncer). Optimizes via EXPLAIN ANALYZE. Works with transactions and isolation levels. Configures pg_stat_statements.
Backend Developer (Rust) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses diesel/sea-orm effectively.
Backend Developer (Scala) Required Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses Slick/Doobie effectively.
BI Analyst Required Independently designs analytical schemas and optimizes complex queries: writes performant multi-table JOINs with window functions, understands query execution plans for optimization, implements materialized views for report acceleration. Understands trade-offs between normalized schemas and analytical denormalization for BI workloads.
Blockchain Developer Designs database: event indexing schema, block data, query optimization for chain data.
Cloud Engineer Administers cloud PostgreSQL: configures RDS parameters, read replicas, automated backups. Optimizes for cloud: connection pooling through RDS Proxy, parameter groups.
Compiler Engineer Uses PostgreSQL for storing compiler metadata: benchmark results, pass statistics, dependency graph. Designs table schemas and writes optimized queries.
Computer Vision Engineer Independently designs database schemas for CV pipelines: optimizes queries for annotation data retrieval, manages large-scale image metadata storage, implements efficient dataset versioning patterns. Understands trade-offs between PostgreSQL and object storage for CV artifact management.
Data Analyst Required Independently designs analytical queries and optimizes data extraction: writes complex CTEs and window functions for analytical workloads, understands execution plans for query tuning, uses EXPLAIN ANALYZE for bottleneck identification. Understands trade-offs between materialized views and live queries for analytical reporting.
Data Engineer Required Optimizes extraction from PostgreSQL: COPY for bulk export, cursor-based pagination, partitioned tables. Configures logical replication for CDC. Designs staging tables for ETL.
Data Scientist Independently designs schemas for ML data pipelines: optimizes queries for large-scale feature extraction, implements efficient data sampling strategies, configures COPY for fast bulk data loading into training pipelines. Understands trade-offs between SQL-based feature engineering and external processing frameworks.
Database Engineer / DBA Administers PostgreSQL: configuring shared_buffers, work_mem, effective_cache_size. Works with pg_stat_statements for load analysis, configures PgBouncer for connection pooling. Performs VACUUM and REINDEX operations.
Desktop Developer (.NET WPF/WinUI/MAUI) Uses EF Core migrations for schema management. Optimizes queries through Include, AsSplitQuery. Implements raw SQL through FromSqlInterpolated. Works with Npgsql bulk operations.
Desktop Developer (Electron/Tauri) Designs data schemas for Electron applications using PostgreSQL as server storage. Implements offline-first pattern with local cache and synchronization with PostgreSQL server.
Desktop Developer (Qt/C++) Uses QSqlTableModel and QSqlRelationalTableModel for Model/View. Optimizes queries through prepared statements. Implements migrations through SQL scripts. Works with transactions (QSqlDatabase::transaction).
DevOps Engineer Manages PostgreSQL in DevOps context: automates backups through cron and scripts, configures replication, deploys PostgreSQL in Docker and Kubernetes. Monitors performance through pg_stat, configures alerts on key database metrics.
DevSecOps Engineer Designs PostgreSQL schemas for storing security scan results, compliance reports and audit trail. Configures row-level security and roles for access control to sensitive data.
Embedded Developer Designs PostgreSQL schemas for time-series sensor data storage with time-based partitioning. Optimizes telemetry aggregation queries and configures indexes for typical access patterns.
Engineering Manager Makes decisions on PostgreSQL usage in team projects, evaluates data schemas and indexes. Manages the migration process and ensures query performance.
Flutter Developer Designs PostgreSQL schemas for Flutter app backends with optimal normalization. Writes migrations for managing data evolution during mobile app updates.
Frontend Developer (Angular) Designs optimal API requests from Angular considering PostgreSQL structure. Understands the impact of pagination, filtering, and sorting on database performance.
Frontend Developer (React) Interacts with PostgreSQL through server APIs in React applications: understands data mapping, pagination, filtering. Designs efficient API queries considering database structure.
Frontend Developer (Svelte) Works with PostgreSQL through SvelteKit server routes, creates efficient queries for server rendering. Uses ORM like Drizzle or Prisma for type-safe data access.
Frontend Developer (Vue) Works with PostgreSQL when developing fullstack features — designs queries for API endpoints, understands JOIN and index impact on data loading speed into Vue components.
Fullstack Developer Independently designs schemas and optimizes queries with PostgreSQL. Understands indexing and query execution plans. Uses Prisma/SQLAlchemy effectively.
Game Designer Designs PostgreSQL schemas for game data: player profiles, economy, leaderboards, statistics. Optimizes queries using indexes and EXPLAIN for high-load game tables. Uses transactions and JSONB for flexible game content and configuration storage.
Game QA Engineer Tests game database: data consistency validation, migration testing, performance queries. Automates database assertions.
Game Server Developer Independently designs game database schemas: optimizes queries for real-time player data access, implements efficient inventory and progression storage patterns, configures connection pooling for concurrent game sessions. Understands trade-offs between PostgreSQL and NoSQL for different game data access patterns.
Infrastructure Engineer Automates PostgreSQL deployment through Ansible roles: configuring postgresql.conf for performance, setting up streaming replication, automatic backups through pgBackRest. Monitors metrics through postgres_exporter in Prometheus, configures alerts on replication lag and connection pool.
iOS Developer Works with PostgreSQL for designing iOS application backend data schema — user profiles, content, and analytics. Writes optimized queries with JOINs, indexes, and pagination for mobile API.
IoT Engineer Uses PostgreSQL for IoT platform: storing device registry, configurations, firmware metadata. Designs schemas considering device hierarchy and group policies.
Language Tooling Engineer Designs efficient PostgreSQL schemas for storing AST data, code indexes, and analysis results. Optimizes queries for fast symbol search and codebase navigation.
LLM Engineer Independently designs schemas for LLM applications: optimizes pgvector queries for RAG retrieval, implements efficient conversation history storage, configures indexing strategies for embedding similarity search. Understands trade-offs between PostgreSQL pgvector and dedicated vector databases for different RAG scales.
ML Engineer Writes complex SQL queries for feature engineering. Uses window functions for time-series features. Optimizes queries with EXPLAIN. Creates materialized views for feature computation.
MLOps Engineer Develops medium-complexity SQL queries for feature engineering from PostgreSQL: window functions for temporal features, aggregations for statistical features. Configures ML pipeline connections to PostgreSQL via SQLAlchemy, optimizes queries for training set extraction, and implements incremental loading for dataset updates.
Network Engineer Designs PostgreSQL schemas for storing network inventory and configurations. Uses inet/cidr data types, creates indexes for fast search by IP ranges and subnets.
NLP Engineer Independently designs PostgreSQL schemas for NLP data: text search configurations, GIN indexes for full-text search, JSONB for NER annotation storage. Optimizes queries.
Penetration Testing Engineer Conducts PostgreSQL installation security audits — checks configuration, privileges, encryption. Uses advanced SQL injection techniques and post-exploitation through databases.
Performance Testing Engineer Profiles PostgreSQL: wait event analysis, lock contention, buffer cache hit ratio. Configures monitoring via pg_stat_activity. Creates database performance dashboards.
Platform Engineer Administers PostgreSQL for the platform: automated provisioning, connection pooling, backup/restore. Designs database-as-a-service for developers.
QA Automation Engineer Independently designs test database strategies: implements efficient test data seeding and state management, writes complex database assertions for integration tests, configures test database isolation with transactions. Understands trade-offs between in-memory test databases and PostgreSQL-based integration testing.
QA Engineer (Manual) Independently uses PostgreSQL for test verification: writes complex queries for data validation across related tables, understands database constraints for test scenario design, verifies data integrity after feature testing. Understands trade-offs between UI-level and database-level test verification approaches.
QA Security Engineer Conducts PostgreSQL security testing: SQL injection verification, privilege auditing, connection encryption testing. Creates test scenarios for row-level security and data masking validation.
React Native Developer Designs efficient PostgreSQL schemas for React Native backend services. Optimizes queries for mobile APIs considering pagination, filtering, and minimizing data transfer.
Release Engineer Manages database migrations as part of the release process. Automates applying and rolling back PostgreSQL migrations, ensuring data consistency during deployments.
Security Analyst Designs PostgreSQL schemas for storing security data — incidents, IOCs, and artifacts. Optimizes queries for fast security event search and correlation.
Site Reliability Engineer (SRE) Administers PostgreSQL for SRE: monitoring through pg_stat_statements, connection pool tuning (PgBouncer), backup verification. Configures alerting on slow queries, connection exhaustion, replication lag.
Smart Contract Developer Designs databases for blockchain: event indexing schema, block data storage, query optimization.
Systems Programmer (C/C++) Works with PostgreSQL at system level: extension development, custom data types, internal APIs.
Technical Lead Designs PostgreSQL schemas: normalization, indexing, constraints. Optimizes queries via EXPLAIN. Manages migrations and data integrity.
Technical Product Manager Works with PostgreSQL for product data analysis — writes queries for analytics, understands database schema impact on feature performance. Considers constraints when designing the product.
Technical Writer Documents project database schemas: tables, relationships, indexes, migrations with ER diagrams. Creates PostgreSQL guides for developers: best practices, conventions, common queries. Describes backup, restore, and maintenance processes in operational documentation.
Telecom Developer Independently designs telecom database schemas: optimizes queries for CDR processing and subscriber data access, implements partitioning for high-volume call record tables, configures connection management for signaling system workloads. Understands trade-offs between normalized and denormalized schemas for telecom data access patterns.
Unity Developer Designs data architecture: game state persistence, leaderboards, player data. Optimizes API queries.
Unreal Engine Developer Designs data architecture: game state persistence, player profiles, analytics data.
XR Unity Developer Designs PostgreSQL schemas for XR application data storage: user progress, spatial data, multiplayer sessions. Optimizes queries using indexes and EXPLAIN.
Role Required Description
1C Developer Required Designs PostgreSQL architecture for high-load 1C systems: optimizes database configuration for 1C server workloads, implements replication for 1C data availability, configures partitioning for large 1C transaction tables. Mentors team on PostgreSQL performance tuning specific to 1C:Enterprise platform.
AI Product Engineer Required Designs PostgreSQL architecture for AI product data infrastructure: optimizes pgvector performance for production embedding workloads, implements hybrid search combining full-text and vector similarity, configures replication for ML serving data availability. Mentors team on PostgreSQL patterns for AI/ML applications.
Analytics Engineer Required Optimizes PostgreSQL as a data source for the analytics platform: configures logical replication for CDC, partitioning for historical data. Designs schemas for efficient data extraction into dbt models.
Android Developer Develops high-performance backend storage on PostgreSQL for Android applications. Designs schemas for conflict resolution during offline synchronization and data versioning.
Application Security Engineer Designs data protection strategy in PostgreSQL: data classification, PII masking policies, access auditing. Implements automated anomaly detection in database access patterns.
AR/VR Developer Optimizes PostgreSQL for high-load AR/VR services with spatial data. Designs sharding and replication strategies for global multiplayer VR platforms.
Backend Developer (C#/.NET) Required Uses advanced PostgreSQL features in .NET: Npgsql bulk copy, JSONB via EF Core value converters, full-text search. Configures connection pooling (PgBouncer). Optimizes EF Core batch operations.
Backend Developer (Elixir) Required Optimizes PostgreSQL usage in Elixir through advanced Ecto capabilities: multi-tenant architecture with prefix, window functions through fragments, CTEs and recursive queries. Configures Ecto.Repo with connection pool through DBConnection for high loads.
Backend Developer (Go) Required Optimizes PostgreSQL usage in Go: uses pgxpool for connection pool management, applies COPY protocol for bulk operations, implements advisory locks. Analyzes EXPLAIN ANALYZE for query optimization and configures monitoring via pg_stat_statements.
Backend Developer (Java/Kotlin) Required Uses advanced PostgreSQL features in Java services: partitioning, materialized views, full-text search via tsvector. Configures connection pooling (PgBouncer + HikariCP). Optimizes ORM: batch operations, query hints, statistics.
Backend Developer (Node.js) Required Designs data access in Node.js: Prisma for type-safe queries, Knex for complex SQL, raw pg for performance-critical. Optimizes connection pooling (pgBouncer). Configures read replicas.
Backend Developer (PHP) Required Uses advanced features: CTEs, window functions, partial indexes, JSONB operators. Configures pg_stat_statements for monitoring. Optimizes via EXPLAIN ANALYZE. Configures logical replication.
Backend Developer (Python) Required Designs schemas for high-load systems. Configures partitioning (range, hash). Uses LISTEN/NOTIFY for real-time. Optimizes pg config for workload. Configures logical replication.
Backend Developer (Rust) Required Develops complex PostgreSQL queries in Rust services using SQLx macros (sqlx::query_as!) for compile-time SQL validation. Configures connection pooling through deadpool-postgres, implements transactions with proper error handling and JSONB operations through serde.
Backend Developer (Scala) Required Optimizes PostgreSQL usage in Scala services: HikariCP connection pool configuration, JSONB fields, window functions and CTEs. Designs schemas with partitioning, implements efficient batch operations through Doobie Transactor and monitors slow queries.
BI Analyst Required Designs PostgreSQL architecture for enterprise BI workloads: optimizes data warehouse schemas for complex analytical queries, implements columnar storage extensions for OLAP performance, configures read replicas for report isolation. Mentors analysts on advanced SQL optimization and data modeling for analytics.
Blockchain Developer Designs data architecture: multi-chain indexing, analytics, historical data.
Cloud Engineer Designs PostgreSQL architecture in cloud: multi-AZ deployment, cross-region replication, Aurora Serverless vs provisioned. Optimizes costs and performance.
Compiler Engineer Designs databases for compiler infrastructure: AST metadata storage, symbol indexing for IDE integration, result table partitioning by version.
Computer Vision Engineer Required Designs PostgreSQL architecture for CV data infrastructure: optimizes database for large-scale annotation management and dataset versioning, implements efficient metadata search across millions of images, configures partitioning for training data lifecycle management. Mentors team on database patterns for computer vision data pipelines.
Data Analyst Required Designs PostgreSQL architecture for analytics teams: optimizes query performance for complex multi-dimensional analysis, implements advanced indexing strategies for analytical workloads, configures materialized view refresh strategies for near-real-time reporting. Mentors analysts on SQL performance optimization and data modeling best practices.
Data Engineer Required Designs PostgreSQL as data pipeline source/sink: CDC through Debezium, materialized views for aggregates, FDW for federation. Optimizes VACUUM for high-write staging tables.
Data Scientist Required Designs PostgreSQL architecture for ML data infrastructure: optimizes database for large-scale feature store operations, implements efficient data versioning and lineage tracking, configures partitioning and archival for training data lifecycle. Mentors team on SQL-based feature engineering patterns and data pipeline optimization.
Database Engineer / DBA Required Designs PostgreSQL HA: streaming replication, Patroni for automated failover, logical replication for zero-downtime migrations. Optimizes: partitioning, partial indexes, parallel queries. Configures PITR via WAL archiving.
Desktop Developer (.NET WPF/WinUI/MAUI) Required Designs data layer with EF Core for desktop. Optimizes PostgreSQL queries through explain analyze. Uses Npgsql NodaTime, NetTopologySuite. Implements connection pooling through NpgsqlDataSource.
Desktop Developer (Electron/Tauri) Develops data architecture for Electron applications with optimal distribution between local storage and PostgreSQL. Introduces conflict resolution and incremental sync for reliable synchronization.
Desktop Developer (Qt/C++) Required Designs data layer for desktop with connection pooling and async queries. Optimizes PostgreSQL for embedded (pgbouncer, connection limits). Implements full-text search through tsvector/tsquery.
DevOps Engineer Required Designs fault-tolerant PostgreSQL clusters: Patroni for automated failover, PgBouncer for connection pooling, WAL archiving to S3. Automates migrations in CI/CD, configures monitoring through PostgreSQL exporter in Prometheus.
DevSecOps Engineer Optimizes PostgreSQL for high-load security systems: audit log partitioning, materialized views for dashboards. Configures pg_audit and logical replication for compliance requirements.
Embedded Developer Develops high-load schemas for storing data from thousands of embedded devices using TimescaleDB. Configures streaming replication and retention policies for managing IoT data volumes.
Engineering Manager Defines PostgreSQL usage strategy across multiple services, including replication, partitioning, and high availability. Plans capacity and scaling.
Flutter Developer Optimizes Flutter app interaction with PostgreSQL for latency minimization. Designs offline data synchronization strategies between local storage and PostgreSQL.
Frontend Developer (Angular) Optimizes Angular application interaction with PostgreSQL through efficient API design. Develops caching and data prefetching strategies to improve UX.
Frontend Developer (React) Designs optimal React frontend interaction with PostgreSQL through APIs: caching strategies, invalidation, optimistic updates. Participates in data schema design for frontend needs.
Frontend Developer (Svelte) Designs the data layer of SvelteKit applications with optimal PostgreSQL queries, including pagination and caching. Implements data loading patterns for optimal SSR/SSG.
Frontend Developer (Vue) Optimizes Vue application interaction with PostgreSQL via API — designs server-side pagination, filtering and sorting, minimizes data volume on the client.
Fullstack Developer Required Designs PostgreSQL schemas for fullstack applications: normalization, indexes for frequent frontend queries, JSONB for flexible structures. Optimizes N+1 queries through DataLoader, configures connection pooling and writes complex queries with CTEs and window functions.
Game Designer Designs high-performance PostgreSQL architectures for game platforms with partitioning and replication. Optimizes storage and queries for massive game data volumes: event logs, analytics, replay. Implements PostgreSQL extensions for specific tasks: PostGIS for geolocation, pg_cron for maintenance.
Game QA Engineer Designs database testing strategy: data integrity automation, performance testing, migration validation pipeline.
Game Server Developer Required Designs PostgreSQL architecture for game server infrastructure: optimizes database for concurrent player session workloads, implements sharding strategies for global game state, configures hot standby for game service availability. Mentors team on database patterns for real-time multiplayer data requirements.
Infrastructure Engineer Required Designs fault-tolerant PostgreSQL infrastructure: Patroni configuration for automatic failover, PgBouncer for connection pooling, WAL archiving to S3. Optimizes OS kernel and filesystem parameters for PostgreSQL, plans capacity for IOPS and storage.
iOS Developer Designs PostgreSQL schemas for high-load iOS backends with partitioning, materialized views, and full-text search. Optimizes queries for mobile access patterns — burst loads, cursor pagination, and offline synchronization.
IoT Engineer Designs databases for IoT: time-based table partitioning for telemetry, TimescaleDB for time-series data, query optimization for large device fleet analytics.
Language Tooling Engineer Develops high-performance PostgreSQL storage for language tools using full-text search and JSONB. Designs schemas for incremental code analysis.
LLM Engineer Required Designs PostgreSQL architecture for LLM application infrastructure: optimizes pgvector for production RAG at scale, implements hybrid retrieval strategies combining semantic and keyword search, configures database architecture for conversation state management. Mentors team on PostgreSQL patterns for production LLM applications.
ML Engineer Designs database schemas for ML metadata and feature storage. Optimizes PostgreSQL for ML workloads. Uses pgvector for embedding storage. Configures partitioning for large tables.
MLOps Engineer Required Designs PostgreSQL schemas for ML platform metadata: tables for model registry, experiment tracking, and feature metadata. Optimizes heavy data extraction queries for model training, configures table partitioning for historical predictions, and implements materialized views for feature pipelines.
Network Engineer Optimizes PostgreSQL for high-load network systems — telemetry storage, flow records, change audit logs. Applies partitioning and materialized views.
NLP Engineer Designs PostgreSQL architecture for production NLP systems: pgvector for embedding storage, partitioning for large corpora, replication for high availability. Optimizes for NLP workloads.
Penetration Testing Engineer Performs deep PostgreSQL audits — privilege escalation, lateral movement via dblink, exfiltration via COPY and large objects. Develops hardening guidelines.
Performance Testing Engineer Required Designs database performance testing: synthetic workload generation, isolation for repeatable tests, production traffic replay. Optimizes: connection pools, query parameters, vacuum.
Platform Engineer Designs PostgreSQL platform service: multi-tenant database management, automated scaling, self-service provisioning. Defines SLA for managed databases.
QA Automation Engineer Required Designs PostgreSQL test infrastructure for QA teams: implements database testing frameworks with snapshot-based assertions, designs test data management strategies for complex schema dependencies, configures parallel test execution with database isolation. Mentors team on advanced database testing patterns and performance test data management.
QA Engineer (Manual) Required Applies deep PostgreSQL knowledge to QA leadership: designs database verification strategies for complex feature testing, implements data integrity validation approaches for regression testing, understands replication lag impact on test results. Mentors junior QA on database-level verification and data-driven test design.
QA Security Engineer Develops comprehensive PostgreSQL security testing strategy: automated configuration auditing, backup security testing, compliance requirement verification.
React Native Developer Develops high-performance PostgreSQL backend storage for mobile applications. Designs schemas for offline-first architecture with conflict resolution and synchronization.
Release Engineer Designs zero-downtime PostgreSQL migration strategies for critical systems. Develops backup and data verification automation as an integral part of the release pipeline.
Security Analyst Develops high-performance PostgreSQL schemas for SIEM data with partitioning. Designs archival and retention strategies for security logs considering compliance requirements.
Site Reliability Engineer (SRE) Required Designs PostgreSQL reliability: streaming replication setup, automated failover (Patroni), point-in-time recovery. Optimizes for operational workloads: vacuum tuning, index maintenance, connection pooling.
Smart Contract Developer Designs data architecture: multi-chain indexing, historical data storage, analytics database.
Solutions Architect Required Designs PostgreSQL architecture for distributed systems: evaluates PostgreSQL vs alternative databases for different service requirements, implements multi-database strategies with PostgreSQL as primary store, configures cross-region replication for global availability. Mentors teams on data architecture patterns and database technology selection.
Systems Programmer (C/C++) Designs database extensions: custom storage engines, FDW implementations, performance plugins.
Technical Lead Defines database architecture: partitioning strategies, replication setup, performance tuning. Designs data access patterns and caching strategies.
Technical Product Manager Makes product data model decisions leveraging PostgreSQL capabilities — JSONB for flexible structures, partitioning for scaling, full-text search for content search.
Technical Writer Designs database documentation standards for the organization: schema docs, migration guides, runbooks. Creates in-depth PostgreSQL optimization guides with performance benchmarks and recommendations. Implements auto-generation of database documentation from DDL and migration scripts.
Telecom Developer Required Designs PostgreSQL architecture for telecom systems: optimizes database for high-volume CDR processing and real-time subscriber lookups, implements partitioning for time-series telecom data, configures replication for telecom service availability requirements. Mentors team on database patterns for telecommunications data workloads.
Unity Developer Designs database architecture: real-time game data, analytics storage, multi-region data access.
Unreal Engine Developer Designs database architecture: real-time game data, analytics, multi-region access.
XR Unity Developer Develops high-performance data schemas for XR platform with partitioning and replication. Uses PostgreSQL-specific features: JSONB for flexible data, PostGIS for spatial queries.
Role Required Description
1C Developer Required Defines PostgreSQL data strategy for 1C products: establishes database standards for 1C-PostgreSQL deployments, designs scaling approaches for high-load 1C environments, drives adoption of PostgreSQL best practices in 1C development teams.
AI Product Engineer Required Defines PostgreSQL data strategy for AI products: establishes standards for ML data storage and pgvector usage, designs database architecture for feature stores and model registries, drives adoption of PostgreSQL best practices for AI/ML data infrastructure.
Analytics Engineer Required Defines the PostgreSQL usage strategy in the analytics stack: read replicas for BI queries, materialized views for intermediate aggregations. Implements naming and schema documentation standards for the data catalog.
Android Developer Defines PostgreSQL usage strategy for all mobile backends. Designs scalable data schemas considering mobile traffic patterns and consistency requirements.
Application Security Engineer Defines database security standards for the organization: encryption policies, credential rotation, backup security. Establishes compliance requirements for storing sensitive data in PostgreSQL.
AR/VR Developer Defines database design standards for the team's AR/VR applications. Trains developers on optimizing spatial queries and managing PostGIS data.
Backend Developer (C#/.NET) Required Defines PostgreSQL standards: extension policy, schema review, monitoring via pg_stat_statements. Chooses between EF Core, Dapper and raw Npgsql for different scenarios.
Backend Developer (Elixir) Required Designs PostgreSQL data architecture for the Elixir platform. Defines partitioning, replication and sharding strategy. Implements Ecto.Multi for transactional integrity of complex operations, configures query monitoring through Ecto.LogEntry and :telemetry.
Backend Developer (Go) Required Designs PostgreSQL architecture for Go microservices: sharding strategies, read replicas, table partitioning. Standardizes migration approach via golang-migrate, configures pgbouncer for infrastructure-level connection pooling.
Backend Developer (Java/Kotlin) Required Defines PostgreSQL standards for the team: extension policy, schema review process, monitoring via pg_stat_statements. Chooses between JPA native queries and jOOQ for complex queries.
Backend Developer (Node.js) Required Defines PostgreSQL standards: Prisma vs Drizzle vs TypeORM choice, migration workflow, query performance budgets. Conducts schema and access pattern reviews.
Backend Developer (PHP) Required Defines PostgreSQL standards for the team: schema design guidelines, migration process, monitoring. Makes decisions about extensions (PostGIS, pg_trgm, TimescaleDB).
Backend Developer (Python) Required Designs database architecture for the platform. Configures HA with Patroni. Designs sharding strategy. Monitors and tunes at cluster level.
Backend Developer (Rust) Required Designs PostgreSQL access layer for Rust platform: choosing between Diesel (compile-time DSL) and SQLx (raw SQL with verification), migration strategies through refinery. Develops repository abstractions with generic trait Repository<T> and optimizes connection pool settings for Tokio runtime.
Backend Developer (Scala) Required Defines PostgreSQL standards for Scala team: choosing between Doobie, Slick and Quill, migration writing rules, table partitioning strategies. Reviews data architecture, implements read replicas for read scaling and configures logical replication for analytical tasks.
BI Analyst Required Defines PostgreSQL data strategy for BI teams: establishes standards for analytical schema design and query optimization, designs data warehouse architecture for enterprise reporting, drives adoption of PostgreSQL best practices for analytical workloads.
Blockchain Developer Defines database standards: indexer schema, performance requirements.
Cloud Engineer Defines managed PostgreSQL standards: Aurora vs RDS selection, backup/recovery SLA, monitoring requirements. Conducts capacity planning and cost optimization.
Compiler Engineer Defines data storage architecture for the compiler platform: replication strategies, backup policies, schema migrations. Optimizes query performance for analytical workloads.
Computer Vision Engineer Required Defines PostgreSQL data strategy for CV teams: establishes standards for image metadata and annotation storage, designs database architecture for dataset management at scale, drives adoption of PostgreSQL best practices for computer vision data pipelines.
Data Analyst Required Defines PostgreSQL data strategy for analytics teams: establishes standards for analytical query patterns and data modeling, designs data access architecture for self-service analytics, drives adoption of PostgreSQL optimization best practices across data teams.
Data Engineer Required Defines PostgreSQL standards for data platform: when PostgreSQL vs analytical databases (ClickHouse/Redshift), connection pooling through PgBouncer for ETL workloads. Conducts extraction pattern reviews.
Data Scientist Required Defines PostgreSQL data strategy for ML teams: establishes standards for feature store design and training data management, designs database architecture for reproducible ML experiments, drives adoption of PostgreSQL best practices for data science workflows.
Database Engineer / DBA Required Defines PostgreSQL standards: configuration templates by tier, monitoring checklists, backup/recovery SLA. Conducts capacity planning, plans major version upgrades. Coordinates PostgreSQL best practices across teams.
Desktop Developer (.NET WPF/WinUI/MAUI) Required Defines database strategy for .NET desktop. Coordinates schema design. Establishes EF Core best practices.
Desktop Developer (Electron/Tauri) Defines data management strategy for the organization's Electron application line with PostgreSQL. Establishes standards for migrations, schemas and query performance for server storage.
Desktop Developer (Qt/C++) Required Defines database strategy for desktop. Coordinates schema design with backend. Establishes performance guidelines for embedded PostgreSQL.
DevOps Engineer Required Defines platform-level PostgreSQL management strategy: deployment standards through Helm charts, backup and restore policies, automated scaling. Designs Database-as-a-Service for internal teams with self-service provisioning.
DevSecOps Engineer Defines PostgreSQL security standards for the organization: encryption, access management, auditing. Designs security data storage architecture considering compliance and retention policies.
Embedded Developer Designs distributed data storage architectures for the embedded ecosystem with PostgreSQL as primary analytics store. Defines sharding and archiving strategies for historical device data.
Engineering Manager Shapes PostgreSQL database management policy for the department, defines schema design standards and operational procedures. Manages licenses and infrastructure.
Flutter Developer Defines database design standards for Flutter app backends. Trains the team on query optimization and proper migration management during app updates.
Frontend Developer (Angular) Defines data layer design standards for Angular applications with PostgreSQL in mind. Trains frontend developers on optimal patterns for working with server data.
Frontend Developer (React) Defines standards for frontend team interaction with PostgreSQL data layer. Coordinates API design between React frontend and server team for optimal performance.
Frontend Developer (Svelte) Defines PostgreSQL standards for the team's frontend projects, selects ORM and data access patterns. Optimizes server component performance.
Frontend Developer (Vue) Coordinates interaction between frontend and backend teams on data schema questions. Ensures optimal API contracts that consider both DB structure and UI needs.
Fullstack Developer Required Defines PostgreSQL architecture for the fullstack platform: partitioning strategy, replication for read-heavy UI scenarios, migration process. Optimizes database performance for frontend and backend access patterns, trains the team.
Game Designer Defines PostgreSQL usage strategy for the game project: sharding, backups, DR. Standardizes database practices for the team: migrations, naming conventions, performance review. Coordinates database scaling for growing game audience.
Game QA Engineer Defines database testing standards: mandatory data tests, migration review, performance requirements.
Game Server Developer Required Defines PostgreSQL data strategy for game server products: establishes standards for game data schema design and player data management, designs database architecture for global multiplayer scaling, drives adoption of PostgreSQL best practices for game server data workloads.
Infrastructure Engineer Required Designs PostgreSQL as a platform service for developers: self-service instance creation through Terraform, configuration standards for different workload profiles, update automation. Defines SLO for database availability and performance, reviews team architectural decisions.
iOS Developer Defines PostgreSQL schema design standards for mobile backends, including migrations and backward compatibility. Leads database performance optimization to ensure mobile API SLA under growing user base.
IoT Engineer Defines IoT platform data storage architecture: replication strategies, sharding by fleet segments, PostgreSQL integration with TSDB and OLAP stores for analytics.
Language Tooling Engineer Defines PostgreSQL usage strategy for all language tools. Designs scalable data schemas and partitioning strategies for large codebases.
LLM Engineer Required Defines PostgreSQL data strategy for LLM products: establishes standards for pgvector usage and RAG data architecture, designs database patterns for conversation management at scale, drives adoption of PostgreSQL best practices for LLM application data infrastructure.
ML Engineer Defines PostgreSQL usage strategy in ML infrastructure. Designs data architecture for ML metadata. Coordinates with DBA on ML workload optimization.
MLOps Engineer Required Defines PostgreSQL usage standards in the MLOps team's infrastructure: schemas for storing experiment results, model metrics, and lineage data. Designs database architecture for MLflow backend store, configures replication for metadata service fault tolerance, and optimizes performance under high-frequency metric writes.
Network Engineer Defines network data storage strategy in PostgreSQL for the team — IPAM data models, CMDB, configuration repositories. Ensures high availability and performance.
NLP Engineer Defines PostgreSQL standards for the NLP team. Establishes guidelines for schema design, indexing strategy for text data, monitoring, and optimization of NLP-specific queries.
Penetration Testing Engineer Defines PostgreSQL audit methodology for the team, creates checklists and automated checks. Coordinates with the DBA team on remediation and hardening measures.
Performance Testing Engineer Required Defines DB performance standards: baseline metrics, regression thresholds, mandatory profiling. Coordinates performance testing with the DBA team.
Platform Engineer Defines database platform standards: provisioning workflow, monitoring requirements, backup policies. Coordinates database-as-a-service development.
QA Automation Engineer Required Defines PostgreSQL testing strategy for QA teams: establishes standards for database test fixtures and test data management, designs test infrastructure architecture for database-dependent testing, drives adoption of database testing best practices across QA teams.
QA Engineer (Manual) Required Defines PostgreSQL testing strategy at the product level. Establishes data validation standards. Conducts database test design reviews and ensures data integrity testing.
QA Security Engineer Defines database security testing standards for the organization. Implements automated PostgreSQL checks in CI/CD and establishes security baselines for all instances.
React Native Developer Defines the PostgreSQL usage strategy for all mobile backends. Architects scalable data schemas considering mobile client specifics and offline modes.
Release Engineer Defines database migration management standards in release processes. Trains teams on safe PostgreSQL schema update practices with minimal production impact.
Security Analyst Defines security data storage standards in PostgreSQL for all team systems. Trains analysts in writing optimal queries for threat hunting and forensic analysis.
Site Reliability Engineer (SRE) Required Defines PostgreSQL standards: HA configurations, backup/recovery SLA, monitoring checklist. Conducts capacity planning and failure mode analysis. Plans PostgreSQL upgrades with zero-downtime.
Smart Contract Developer Defines database standards: indexer schema guidelines, performance requirements.
Solutions Architect Required Defines PostgreSQL data strategy for multi-service architectures: establishes standards for database technology selection per service, designs cross-service data consistency patterns, drives adoption of PostgreSQL architectural best practices across platform and product teams.
Systems Programmer (C/C++) Defines database systems standards: extension development, performance requirements.
Technical Lead Defines team database standards: migration workflows, naming conventions, query performance budgets, review criteria. Coordinates with DBA.
Technical Product Manager Defines data storage strategy for the product team. Coordinates database schema migrations with product roadmap, ensures backward compatibility and downtime planning.
Technical Writer Defines corporate database documentation standards for all organizational projects. Coordinates creation of a unified database knowledge base with automatic updates from schema changes. Implements documentation-driven database management with versioned schema docs.
Telecom Developer Required Defines PostgreSQL data strategy for telecom products: establishes standards for CDR storage and subscriber data management, designs database architecture for telecom platform scaling, drives adoption of PostgreSQL best practices for telecommunications workloads.
Unity Developer Defines data standards: database schema guidelines, API data contracts, performance requirements.
Unreal Engine Developer Defines data standards: schema guidelines, data contracts, performance requirements.
XR Unity Developer Defines data management strategy for XR products: schema selection, migration policies, backup and recovery. Ensures PostgreSQL scalability for growing XR platform user base.
Role Required Description
1C Developer Required Defines organizational data strategy for 1C-PostgreSQL: evaluates enterprise database approaches for large-scale 1C deployments, designs multi-region data architectures for 1C platforms, establishes governance for database technology decisions across 1C development teams.
AI Product Engineer Required Defines organizational data strategy for AI/ML platforms: evaluates PostgreSQL vs specialized databases for enterprise ML infrastructure, designs multi-region data architectures for global AI products, establishes governance for ML data storage and vector database technology decisions.
Analytics Engineer Required Architects PostgreSQL's role in the analytics platform: as an operational datastore, as a metadata backend for tools (Airflow, dbt). Defines the data migration strategy from PostgreSQL to the analytical warehouse.
Android Developer Shapes PostgreSQL usage standards for the organization's mobile platform. Defines data storage patterns ensuring optimal performance for Android services.
Application Security Engineer Shapes database-level data protection strategy for the entire organization. Defines data security architectural principles considering regulatory requirements of GDPR, PCI DSS, and industry standards.
AR/VR Developer Shapes the data storage architecture for the organization's AR/VR ecosystem. Architects scalable PostgreSQL clusters for global multiplayer XR services.
Backend Developer (C#/.NET) Required Designs PostgreSQL platform: logical replication, Citus for distributed queries, TimescaleDB for time-series. Defines migration strategy.
Backend Developer (Elixir) Required Defines PostgreSQL strategy at the entire organizational Elixir ecosystem level. Designs distributed data schemas with Citus, configures logical replication for event sourcing. Develops Ecto usage standards, migration and optimization practices at platform level.
Backend Developer (Go) Required Defines PostgreSQL strategy for the entire Go platform: schema design standards, partitioning and archival policies, multi-region replication. Develops platform abstractions for PostgreSQL including automatic failover and observability.
Backend Developer (Java/Kotlin) Required Designs organizational PostgreSQL platform: logical replication, Citus for distributed queries, TimescaleDB for time-series. Defines migration strategy and backward compatibility.
Backend Developer (Node.js) Required Designs data strategy: database-per-service, shared databases, read replicas routing. Determines when PostgreSQL vs MongoDB vs others for Node.js services.
Backend Developer (PHP) Required Designs PostgreSQL architecture at platform level: clustering, Patroni for HA, logical replication between services. Defines scaling strategy: read replicas, Citus for sharding.
Backend Developer (Python) Required Defines company database strategy. Evaluates PostgreSQL vs NewSQL. Designs multi-region database architecture. Establishes DBA practices.
Backend Developer (Rust) Required Defines PostgreSQL strategy for Rust ecosystem: ORM standards (SeaORM vs Diesel vs SQLx), read-replica and partitioning architecture. Establishes connection management policies, prepared statement caching and monitoring through pg_stat_statements with Prometheus integration.
Backend Developer (Scala) Required Makes strategic data storage architecture decisions: PostgreSQL as primary OLTP database for Scala platform, Citus integration for horizontal scaling, multi-region deployment strategy. Defines backup policies, DR plans and evaluates transition to managed solutions (RDS, Cloud SQL).
BI Analyst Required Defines organizational data strategy for enterprise analytics: evaluates PostgreSQL vs specialized analytical databases for organizational BI, designs multi-region data warehouse architectures, establishes governance for analytical data modeling and query optimization standards.
Blockchain Developer Shapes data strategy: blockchain data platform, governance.
Cloud Engineer Shapes cloud relational database strategy: multi-region PostgreSQL, database-per-service patterns, on-premise → cloud migration strategy. Defines data governance.
Compiler Engineer Shapes data management strategy for the compiler ecosystem: database selection for different workloads, data governance, integration with analytics platforms for decision making.
Computer Vision Engineer Required Defines organizational data strategy for CV/ML: evaluates PostgreSQL and complementary technologies for enterprise-scale image data management, designs multi-region architectures for global CV data pipelines, establishes governance for dataset storage and metadata management standards.
Data Analyst Required Defines organizational data strategy for analytics: evaluates PostgreSQL and analytical database technologies for enterprise data platforms, designs multi-region architectures for global analytical workloads, establishes governance for data access and analytical query standards.
Data Engineer Required Designs PostgreSQL strategy: logical replication for real-time CDC, Citus for distributed analytics, TimescaleDB for time-series pipelines. Defines PostgreSQL boundaries in data architecture.
Data Scientist Required Defines organizational data strategy for ML platforms: evaluates PostgreSQL and complementary technologies for enterprise feature stores, designs multi-region data architectures for global ML training pipelines, establishes governance for training data lifecycle and lineage management.
Database Engineer / DBA Required Shapes organizational PostgreSQL strategy: Patroni vs Stolon vs Citus for different patterns, cross-region DR, RTO/RPO by tier. Defines PostgreSQL platform standards, evaluates managed vs self-hosted approaches.
Desktop Developer (.NET WPF/WinUI/MAUI) Required Shapes enterprise database strategy for .NET desktop. Evaluates EF Core vs Dapper vs raw Npgsql. Defines data architecture.
Desktop Developer (Electron/Tauri) Shapes architectural vision for the Electron product ecosystem data layer with PostgreSQL. Defines long-term data storage strategy considering offline scenarios and scaling.
Desktop Developer (Qt/C++) Required Shapes enterprise database strategy for desktop. Evaluates PostgreSQL vs SQLite vs embedded alternatives. Defines data architecture for the organization.
DevOps Engineer Required Develops organizational database management architecture: multi-regional PostgreSQL clusters, automated DR with RPO/RTO guarantees, DBaaS platform with full lifecycle management. Defines standards for all database systems in infrastructure.
DevSecOps Engineer Shapes PostgreSQL security data management strategy considering GDPR, SOC2 regulatory requirements. Defines data governance architecture for audit trail and forensic analysis at organizational scale.
Embedded Developer Shapes data storage strategy for IoT ecosystem: PostgreSQL vs time-series DB selection, data retention policies, multi-region replication for global device fleets. Defines data governance framework.
Engineering Manager Defines PostgreSQL and other RDBMS usage strategy at the organizational level. Shapes data storage architectural principles and coordinates with the DBA team.
Flutter Developer Shapes data storage architectural strategy for the Flutter app ecosystem. Designs scalable PostgreSQL schemas with multi-platform synchronization support.
Frontend Developer (Angular) Shapes architectural principles for frontend data interaction across the organization. Designs universal data-access layers for Angular with optimal database interaction.
Frontend Developer (React) Shapes data layer strategy for the React product ecosystem considering PostgreSQL backend. Defines architectural patterns for efficient data exchange between frontend and database.
Frontend Developer (Svelte) Shapes data strategy for the organization's Svelte platform, including edge computing and server rendering approaches. Coordinates frontend-database interaction standards.
Frontend Developer (Vue) Shapes data-layer architecture standards for frontend platform. Defines approaches to caching, optimistic updates and client state synchronization with server data.
Fullstack Developer Required Shapes PostgreSQL strategy for fullstack organization: schema design standards, auto-scaling, multi-tenancy. Designs solutions for complex scenarios: full-text search, geo-queries, time-series data. Defines backup and DR policies.
Game Designer Shapes corporate PostgreSQL strategy for the studio's game product lineup. Defines data storage architectural patterns for large-scale online games. Publishes best practices and influences PostgreSQL tool development for gaming workloads.
Game QA Engineer Shapes data quality strategy: platform-wide database testing, data integrity governance.
Game Server Developer Required Defines organizational data strategy for game platforms: evaluates PostgreSQL and complementary databases for enterprise game infrastructure, designs multi-region data architectures for global game services, establishes governance for player data management and game state storage at scale.
Infrastructure Engineer Required Defines organizational PostgreSQL infrastructure strategy: choosing between self-hosted Patroni, managed RDS and Aurora, designing multi-region architecture. Plans major version migrations, makes decisions on sharding (Citus) and horizontal scaling for petabyte-scale data volumes.
iOS Developer Shapes the corporate PostgreSQL data management strategy for the mobile ecosystem with horizontal scaling. Defines data architecture for supporting millions of concurrent enterprise-scale iOS users.
IoT Engineer Shapes data management strategy for IoT ecosystem: hybrid storage (PostgreSQL + InfluxDB + S3), data governance for IoT telemetry, compliance with regulatory requirements.
Language Tooling Engineer Shapes PostgreSQL standards for the organization, defines data storage and indexing patterns for language tools. Optimizes data architecture at the organizational level.
LLM Engineer Required Defines organizational data strategy for LLM infrastructure: evaluates PostgreSQL pgvector vs dedicated vector databases for enterprise RAG platforms, designs multi-region data architectures for global LLM applications, establishes governance for conversation data and embedding storage at organizational scale.
ML Engineer Defines data storage strategy for ML platform. Evaluates PostgreSQL vs specialized ML stores. Designs data architecture for enterprise ML.
MLOps Engineer Required Shapes the PostgreSQL usage strategy at the MLOps platform level: unified standards for metadata store, feature catalog, and audit logging. Makes scaling decisions — Citus for sharding, TimescaleDB for model metric time series, defines migration policies and data governance for ML metadata.
Network Engineer Shapes the organization's network data storage architecture. Researches PostgreSQL integration with TimescaleDB for telemetry and defines standards for working with network data at scale.
NLP Engineer Shapes enterprise PostgreSQL strategy for NLP data. Defines text corpus storage architecture, embedding storage, and vector search at organizational level.
Penetration Testing Engineer Shapes database security strategy for the organization, including PostgreSQL hardening standards. Defines database security policies and regular audit processes.
Performance Testing Engineer Required Designs database performance strategy: automated regression detection, capacity modeling, cross-database benchmarking. Defines DB performance SLA framework.
Platform Engineer Shapes database platform strategy: multi-engine database service, automated management, capacity planning. Defines platform database governance.
QA Automation Engineer Required Defines organizational data testing strategy: evaluates enterprise approaches for database test automation at scale, designs governance for test data management across multiple teams, establishes standards for database testing practices and test infrastructure architecture organization-wide.
QA Engineer (Manual) Required Defines organizational approach to database verification in QA: evaluates enterprise standards for database-level testing practices, designs guidelines for data integrity validation in quality assurance, establishes standards for QA team database skills and verification methodologies across the organization.
QA Security Engineer Shapes data security testing strategy at the organizational level. Defines approaches to continuous database security assessment considering regulatory requirements and scale.
React Native Developer Shapes PostgreSQL usage standards for the organization's mobile infrastructure. Defines data storage patterns ensuring optimal mobile application performance.
Release Engineer Shapes organizational strategy for database lifecycle management during releases. Creates platform solutions for coordinating PostgreSQL migrations in microservice architecture.
Security Analyst Shapes the security data storage architecture for the organization's SIEM platform. Designs scalable PostgreSQL clusters for analyzing petabytes of security logs.
Site Reliability Engineer (SRE) Required Designs database reliability strategy: PostgreSQL HA patterns (Patroni/Stolon), cross-region replication, RTO/RPO by tier. Defines DB platform standards for the organization.
Smart Contract Developer Shapes data strategy: blockchain data platform, multi-chain storage, governance.
Solutions Architect Required Defines organizational data architecture strategy: evaluates PostgreSQL and complementary database technologies for enterprise platform selection, designs multi-region data architecture governance for distributed systems, establishes standards for database technology decisions and data consistency patterns at organizational scale.
Systems Programmer (C/C++) Shapes database systems strategy: custom storage development, kernel optimization.
Technical Lead Shapes the organization's data strategy: polyglot persistence, database technology selection, data governance. Defines architectural principles for the data layer.
Technical Product Manager Shapes data strategy for the product portfolio — choosing between SQL and NoSQL, data lake architecture, migration standards. Ensures data scalability for business growth.
Technical Writer Shapes industry standards for documenting databases and data architecture. Publishes research on the effectiveness of different database documentation approaches. Influences the development of automatic database documentation generation from PostgreSQL metadata.
Telecom Developer Required Defines organizational data strategy for telecom platforms: evaluates PostgreSQL and complementary databases for enterprise telecom data workloads, designs multi-region data architectures for global telecom services, establishes governance for CDR storage and subscriber data management at organizational scale.
Unity Developer Shapes game data strategy for Unity platforms: designs enterprise game data architecture integrating PostgreSQL with specialized stores, establishes analytics infrastructure for player behavior tracking, defines governance for game data lifecycle management across multiple titles.
Unreal Engine Developer Shapes game data strategy for Unreal platforms: designs enterprise game data architecture integrating PostgreSQL with dedicated game stores, establishes analytics infrastructure for game telemetry and player data, defines governance for game data management across Unreal Engine titles.
XR Unity Developer Shapes architectural vision for data storage in XR product ecosystem. Defines PostgreSQL scaling strategy considering growing volumes of spatial and user data.

Community

👁 Watch ✏️ Suggest Change Sign in to suggest changes
📋 Proposals
No proposals yet for PostgreSQL
Loading comments...