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

DataStrike PostgreSQL DBA Team Resume

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

Data Sheet

10 Red Flags That Scream It's Time to Go Fractional (Checklist)

Do you really need a full-time DBA on staff? This checklist will help you figure that out fast. We’ve laid out 10 common red flags that scream it's time to go fractional.

View

Data Sheet

eBook

The Future of IT is Fractional eBook

Fractional support is the future. The real question is whether you’re ready to win. Get the guide that shows you how to scale fast and seize the advantage now.

View

eBook

Case Study

Optimizing Data Infrastructure for the Nation’s Largest Independent Mammography Provider

DataStrike delivered a tailored infrastructure strategy for the nation’s largest independent provider of mammography and breast health services, enhancing reliability, streamlining operations, and ensuring business continuity through expert-managed services.

View

Case Study