DataStage Developer

Envision Technology Solutions; Charlotte (NC); Presencial; USD 170.000 - 210.000; Jornada completa

Descripción de la vacante

Envision Technology Solutions requires a senior-level database and data engineering expert with 15+ years of experience in developing and integrating enterprise data systems. Candidates will design and optimize RDBMS solutions using Oracle, DB2, and SingleStore, while leading data modeling and architecture efforts.

The role emphasizes ETL development with IBM DataStage, data movement at scale, and performance tuning across Linux/Unix environments.

Formación

• 15+ years of industry experience in database development, data engineering, and enterprise data integration.
• Senior-level, hands-on experience designing and developing database applications and data-intensive solutions using RDBMS technologies such as Oracle, DB2, and SingleStore (MemSQL).
• Significant experience with enterprise data modeling, logical and physical data design, and database architecture.
• Extensive experience with Oracle Database, including SQL, PL/SQL, stored procedures, performance tuning, query optimization, indexing, and partitioning strategies.
• Significant experience with IBM DataStage ETL development, data integration, data transformation, and data migration initiatives.
• Strong background in data engineering, ETL design, data movement, and large-scale data processing solutions.
• Extensive experience with stored procedures, SQL, and PL/SQL development, including performance optimization and troubleshooting of complex database workloads.
• Experience with database modernization and migration projects involving large-scale enterprise data platforms.
• Strong understanding of Change Data Capture (CDC), data integration, and data synchronization patterns.
• Experience working in Linux/Unix environments, including shell scripting for automation, deployment, and operational support.
• Experience with Python-based scripting for data processing, automation, and operational tooling.
• Working knowledge of Splunk and Dynatrace for database monitoring, log analysis, troubleshooting, and performance monitoring.
• Knowledge of Oracle GoldenGate, IBM IIDR, or similar data replication technologies is a plus.
• Experience with CockroachDB or other distributed SQL databases is a plus.

Responsabilidades

• Application support and incident management

Conocimientos

Oracle

DB2

SingleStore

SQL

PL/SQL

ETL

Data Modeling

Data Architecture

CDC

Linux/Unix

Shell scripting

Python

Splunk

Dynatrace

Goldengate

IIDR

CockroachDB

Herramientas

Oracle GoldenGate

IBM IIDR

Splunk

Dynatrace

CockroachDB

Descripción del empleo

• Application support and incident management
• BFSI domain knowledge

Required Qualifications

• 15+ years of industry experience in database development, data engineering, and enterprise data integration.
• Senior-level, hands-on experience designing and developing database applications and data-intensive solutions using RDBMS technologies such as Oracle, DB2, and SingleStore (MemSQL).
• Significant experience with enterprise data modeling, logical and physical data design, and database architecture.
• Extensive experience and deep expertise with Oracle Database, including SQL, PL/SQL, stored procedures, performance tuning, query optimization, indexing, and partitioning strategies.
• Significant experience and proficiency with IBM DataStage ETL development, data integration, data transformation, and data migration initiatives.
• Strong background in data engineering, ETL design, data movement, and large-scale data processing solutions.
• Extensive experience with stored procedures, SQL, and PL/SQL development, including performance optimization and troubleshooting of complex database workloads.
• Experience with database modernization and migration projects involving large-scale enterprise data platforms.
• Strong understanding of Change Data Capture (CDC), data integration, and data synchronization patterns.
• Experience working in Linux/Unix environments, including shell scripting for automation, deployment, and operational support.
• Experience with Python-based scripting for data processing, automation, and operational tooling.
• Working knowledge of Splunk and Dynatrace for database monitoring, log analysis, troubleshooting, and performance monitoring.
• Knowledge of Oracle GoldenGate, IBM IIDR, or similar data replication technologies is a plus.
• Experience with CockroachDB or other distributed SQL databases is a plus.