PostgreSQL Team Data Sheet

DataStrike’s PostgreSQL team is part of our Open-Source Practice, comprised of skilled data management professionals with decades of RDBMS experience.

PostgreSQL DBA Team Resume

Learn more about DataStrike's PostgreSQL DBA services, experience and expertise.

Data Sheet

PostgreSQL Team Data Sheet

Products and Technology

Database Versions and Editions: Versions - 15.x 14.x 13.x 12.x 11.x (supported), Versions - 10.x 9.x 8.x (unsupported)

‍

Advanced Features: Materialized Views, Foreign data wrappers, Module Library, PostgreSQL two-phase commit, Data Definition Language, Advanced Performance Features, XML, JSON and YAML

‍

High Availability and Recovery: , Shared Disk Failover, File System (Block Device) Replication, Write-Ahead Log Shipping, Logical Replication, Trigger-Based Primary-Standby Replication, SQL-Based Replication Middleware, Asynch & Synch Multimaster Replication

‍

Related Products: Administration/development tools, Clustering/replication, Drivers and interfaces, PostgreSQL- derived servers, PostgreSQL extensions, Procedural languages, Reporting tools

Administration and Optimization

Monitoring and Alerting Tools: Logic Monitor, DataStrike custom scripts, Client alerting system, DataDog, Percona

‍

Performance Tuning: Multi-core Scalability, VACUUM and Maintenance, Instance Tuning (Configuration), Performance Tuning (Code), Data Cleansing and Archiving, Reindexing, Defragmentation, Integrity Checks

‍

Management: 24x7 Incident Management, User and Security Admin, Upgrades/Migrations, Patching, ETL Solutions, Problem Management, Root Cause Analysis, Backup/Restore, Disaster Recovery, Regulatory Compliance Support

Cloud Enviroments

Infrastructure as a Service (IaaS): PostgreSQL on AWS, PostgreSQL on Azure, PostgreSQL on OCI

‍

Managed Database as a Service (DBaaS): Azure Database for PostgreSQL, Amazon RDS for PostgreSQL, PostgreSQL on Private Cloud

Strategic Engagements

High Availability Deployments

Cloud Migrations

Oracle to PostgeSQL

Application Migrations

PostgreSQL NoSQL Integration

ADDITIONAL RESOURCES

Video

How do you Modernize Systems Without Putting Uptime and Stability at Risk?

How can organizations modernize systems without risking uptime and stability? Corey Beck, VP of Service Delivery at DataStrike, explains how phased planning, flexible roadmaps, stakeholder alignment, and smart execution can minimize downtime and reduce risk.

View

Video

DataTalks with Rob Brown: SQL Server End of Life and How to Prepare

How should you prepare for SQL Server end of life? Rob Brown, COO of DataStrike, explains how functionality, cost, support requirements, and cloud migration options can help organizations determine the right upgrade strategy.

View

Video

Why DataStrike's SafeSwitch Program Works

Why does DataStrike’s SafeSwitch program work? Rob Brown, President and COO of DataStrike, explains how a proven transition process, decades of managed services experience, and clear SLAs help organizations switch providers with minimal disruption.

View

Video