PostgreSQL Database SME

PostgreSQL Database SME

Posted Today by 1766218170

Apply
Negotiable
Outside
Remote
USA
Apply
Amazon Web Services (AWS) Ansible Application Development Auditing Automation Business Continuity And Disaster Recovery Cloud Computing Cloud Technology Consolidation Continuous Integration and Continuous Delivery Data Access Database Architecture Data Encryption Data Integration Datamodel Data Modeling DevOps Disaster Recovery Elasticsearch Encryption External Auditing Failover File Servers Google Cloud Google Cloud Platform (GCP) Grafana Hardening Indexing Linux Microsoft Azure Microsoft SQL Servers Mobile Application Development MongoDB MySQL NoSQL OLAP Cube Online Transaction Processing Oracle Linux Performance Engineering Performance Tuning PostgreSQL Prometheus (Software) Root Cause Analysis Scalability Software Testing Automation Framework SQL (Programming Language) Storage Systems Terraform

Summary: The PostgreSQL Database Subject Matter Expert (SME) is responsible for providing technical leadership in database architecture, performance engineering, and operations for complex application ecosystems. This role involves supporting multicloud deployments and mission-critical workloads that require high availability and compliance. The SME will lead modernization initiatives and ensure optimal database performance and security. The position is remote and classified as outside IR35.

Key Responsibilities:

  • Design, implement, and optimize PostgreSQL database architectures for OLTP, OLAP, and hybrid workloads.
  • Develop logical and physical data models, indexing strategies, partitioning schemes, and storage optimization plans.
  • Lead database modernization, migration, and consolidation initiatives (on-prem to cloud, cross-version upgrades, Oracle/MySQL to PostgreSQL conversions).
  • Conduct deep-dive performance tuning across queries, indexes, schemas, and system parameters.
  • Analyze execution plans, optimize slow-running SQL, and resolve bottlenecks at the database, OS, and network layers.
  • Implement monitoring, alerting, and capacity planning using tools such as pg_stat_statements, pgBadger, Prometheus, Grafana, or equivalent.
  • Manage installation, configuration, patching, and version upgrades of PostgreSQL clusters.
  • Implement and maintain high availability (HA) and disaster recovery (DR) solutions using replication, failover, and backup strategies (e.g., streaming replication, Patroni, pgBackRest).
  • Ensure database reliability, security hardening, encryption, auditing, and compliance with organizational and regulatory standards.
  • Architect and support PostgreSQL deployments on AWS RDS/Aurora, Azure PostgreSQL, or Google Cloud Platform Cloud SQL.
  • Automate provisioning, scaling, and maintenance using Terraform, Ansible, or CI/CD pipelines.
  • Support containerized and Kubernetes-based PostgreSQL environments (e.g., CrunchyData, CloudNativePG).
  • Serve as the primary PostgreSQL expert for engineering, DevOps, analytics, and application development teams.
  • Provide guidance on SQL best practices, schema design, and data access patterns.
  • Troubleshoot complex production issues and lead root cause analysis (RCA) efforts.

Key Skills:

  • 8-15+ years of hands-on experience with PostgreSQL database engineering and administration.
  • Expert-level knowledge of SQL, PL/pgSQL, indexing, partitioning, replication, and performance tuning.
  • Strong understanding of Linux internals, storage systems, networking, and system performance.
  • Experience with cloud-native PostgreSQL services and automation frameworks.
  • Familiarity with ETL/ELT pipelines, data integration tools, and analytics workloads.
  • Proven ability to support large-scale, high-availability, mission-critical environments.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

The PostgreSQL Database Subject Matter Expert (SME) provides deep technical leadership across database architecture, performance engineering, optimization, security, and enterprisescale operations. This role supports complex application ecosystems, multicloud deployments, modernization initiatives, and missioncritical workloads requiring high availability, scalability, and compliance.

Key Responsibilities

Architecture & Design

  • Design, implement, and optimize PostgreSQL database architectures for OLTP, OLAP, and hybrid workloads.
  • Develop logical and physical data models, indexing strategies, partitioning schemes, and storage optimization plans.
  • Lead database modernization, migration, and consolidation initiatives (onprem to cloud, crossversion upgrades, Oracle/MySQL to PostgreSQL conversions).

Performance Engineering

  • Conduct deepdive performance tuning across queries, indexes, schemas, and system parameters.
  • Analyze execution plans, optimize slow-running SQL, and resolve bottlenecks at the database, OS, and network layers.
  • Implement monitoring, alerting, and capacity planning using tools such as pg_stat_statements, pgBadger, Prometheus, Grafana, or equivalent.

Operations & Administration

  • Manage installation, configuration, patching, and version upgrades of PostgreSQL clusters.
  • Implement and maintain high availability (HA) and disaster recovery (DR) solutions using replication, failover, and backup strategies (e.g., streaming replication, Patroni, pgBackRest).
  • Ensure database reliability, security hardening, encryption, auditing, and compliance with organizational and regulatory standards.

Cloud & Automation

  • Architect and support PostgreSQL deployments on AWS RDS/Aurora, Azure PostgreSQL, or Google Cloud Platform Cloud SQL.
  • Automate provisioning, scaling, and maintenance using Terraform, Ansible, or CI/CD pipelines.
  • Support containerized and Kubernetes-based PostgreSQL environments (e.g., CrunchyData, CloudNativePG).

CrossFunctional Leadership

  • Serve as the primary PostgreSQL expert for engineering, DevOps, analytics, and application development teams.
  • Provide guidance on SQL best practices, schema design, and data access patterns.
  • Troubleshoot complex production issues and lead root cause analysis (RCA) efforts.

Required Skills & Experience

  • 8 15+ years of hands-on experience with PostgreSQL database engineering and administration.
  • Expert-level knowledge of SQL, PL/pgSQL, indexing, partitioning, replication, and performance tuning.
  • Strong understanding of Linux internals, storage systems, networking, and system performance.
  • Experience with cloud-native PostgreSQL services and automation frameworks.
  • Familiarity with ETL/ELT pipelines, data integration tools, and analytics workloads.
  • Proven ability to support large-scale, high-availability, mission-critical environments.

Preferred Qualifications

  • Experience migrating from Oracle, SQL Server, or MySQL to PostgreSQL.
  • Knowledge of NoSQL or complementary data platforms (Redis, MongoDB, Elasticsearch).
  • Certifications in cloud platforms (AWS, Azure, Google Cloud Platform).
  • Experience supporting federal, healthcare, or regulated environments.

Apply
Similar Jobs
Loading data...