Senior Replication / Cloud Data Engineer

Bahwan CyberTek

🇺🇸 United States
On-site
Senior
5 days ago

GCP
SQL
PostgreSQL
Oracle
JSON
Bamboo

5 days ago

Not scoredNo CV on file. Upload one and this job gets a score out of 100.Upload CV

Provide hands-on support for Google Cloud SQL for PostgreSQL environments, including database configuration, performance tuning, troubleshooting, and operational support. Troubleshoot Oracle-to-PostgreSQL data replication and CDC/data streaming issues. Analyze and resolve data type conversion/mapping issues between Oracle and PostgreSQL, including differences in numeric, date/time, timestamp, character, JSON, and other data types. Investigate data synchronization issues, including replication lag, missing records, duplicate records, failed transactions, schema changes, and inconsistent data between source and target. Monitor and troubleshoot data stream/CDC pipelines to ensure reliable and consistent movement of data from Oracle to PostgreSQL. Work closely with application, data engineering, DBA, and reporting teams to identify the root cause of data discrepancies and reporting issues. Perform source-to-target data validation and reconciliation to identify and resolve data mismatches. Analyze replication logs, error messages, database logs, and pipeline metrics to identify recurring issues. Support schema changes and database releases while ensuring replication compatibility and minimal impact to downstream reporting. Optimize PostgreSQL database configuration and queries where performance issues contribute to reporting or synchronization problems. Develop and maintain troubleshooting procedures, monitoring dashboards, and operational documentation for the replication environment. Participate in root-cause analysis and implement permanent fixes for recurring replication and data synchronization issues. Provide technical guidance to the Bamboo Rose team on Oracle/PostgreSQL compatibility, replication architecture, and data integrity. Location:Pittsburgh

Senior Replication / Cloud Data Engineer · Bahwan CyberTek

Auto apply with Likeremote