UrbanSoft SA
Data Replication Engineer – Stelo/StarQuest
Role Summary: We are seeking a skilled Data Replication Engineer experienced in Stelo/StarQuest’s Data Replication tools (SQDR & SQDR Plus). The role focuses on designing, configuring, maintaining, and optimizing replication pipelines across diverse source and target systems including DB2, Oracle, SQL Server, and cloud data platforms. Key Responsibilities: • Install, configure, and manage SQDR and SQDR Plus environments, including intermediate hosts and control databases. • Implement and monitor Change Data Capture (CDC) using native log APIs or ODBC, depending on source system. • Design and execute replication topologies: one-to-one, hub-and-spoke, or fan-out. • Configure and maintain replication jobs, agents, services, and web consoles. • Ensure replication resilience through failover and load balancing configurations. • Troubleshoot replication errors, log miner failures, ODBC/API connectivity, and performance bottlenecks. • Tune performance by optimizing parallel jobs, core allocations, memory, and thread usage. • Collaborate with DBAs and infrastructure teams for archive log settings, DB triggers, and schema changes. • Define and enforce SLA thresholds, alerts, and monitoring dashboards. • Maintain security posture of replication systems (role-based access, logging, auditing). • Document replication architecture, recovery procedures, and client-specific playbooks. • Participate in disaster recovery and high availability validation testing. Qualifications: • Bachelor's degree in Computer Science, Information Systems, or equivalent experience. • 3+ years experience in data replication or integration engineering roles. • Certification in relevant database technologies or data integration tools is a plus. Technical Skills: • Experience with Stelo/StarQuest SQDR & SQDR Plus, including installation, architecture, and management. • Strong understanding of CDC concepts, including transaction log mining and archive log management. • Knowledge of source databases: DB2 LUW/zOS, Oracle, SQL Server, MySQL. • Familiarity with ODBC/JDBC connectivity, native APIs (e.g., Oracle LogMiner, DB2 capture agents). • Linux and Windows server administration skills. • Experience with cloud data platforms (e.g., Snowflake, Azure Synapse, AWS RDS) a plus. • Scripting experience (Shell, PowerShell, Python) for automation and alerts is advantageous. Originally posted on Himalayas
