Job Title: Senior Database Engineer/Admin (Google Cloud SQL/ Postgres/Oracle)
Location Pittsburgh, PA (Onsite)
Duration: Long term contract
Need local candidates and nearby states only
Need a write up from the consultant.
Job Description:
- 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.
- Analyse 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.
- Analyse 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.
Required Technical Skills:
- Strong hands-on experience with PostgreSQL, preferably Google Cloud SQL for PostgreSQL.
- Strong understanding of Oracle databases and Oracle-to-PostgreSQL migration/replication.
- Experience with CDC (Change Data Capture), data streaming, and database replication technologies.
- Strong knowledge of Oracle and PostgreSQL data types and data type conversion/mapping.
- Experience troubleshooting replication lag, synchronization failures, data inconsistencies, and failed CDC events.
- Strong SQL skills across both Oracle and PostgreSQL.
- Experience with database performance tuning, indexing, query optimization, and troubleshooting.
- Understanding transaction management, WAL, replication slots, logical replication, and PostgreSQL replication concepts.
- Experience with cloud database environments, preferably Google Cloud Platform (Google Cloud Platform).
- Ability to analyse logs and troubleshoot issues across source database, replication/streaming layer, and target database.
- Experience with data validation and reconciliation between source and target systems.