Description

You will design, implement, and manage CockroachDB distributed database clusters while supporting Oracle environments and building ETL pipelines with IBM DataStage.

This role is on-site.

Responsibilities

• Design and maintain CockroachDB clusters, ensuring high availability, scalability, and fault tolerance.
• Develop and optimize ETL jobs using IBM DataStage for data extraction, transformation, and loading.
• Manage Oracle database environments, including complex SQL, stored procedures, and PL/SQL scripts.
• Perform performance tuning, query optimization, and indexing for both CockroachDB and Oracle systems.
• Execute data migrations from traditional RDBMS to CockroachDB and support data modeling.

Required Skills

• Minimum 10 years of experience in data engineering or database administration.
• Deep expertise with CockroachDB, including distribution, replication, and consistency models.
• Proficiency in IBM DataStage for designing data integration workflows and optimizing job performance.
• Strong command of Oracle, SQL, and PL/SQL for complex query writing and optimization.
• Experience with ETL/ELT processes, data validation, and quality checks.
• Skills in data modeling, schema design, and backup/recovery strategies.
• Ability to troubleshoot database failures and resolve performance bottlenecks.

Preferred Skills

• Experience migrating data from Oracle to CockroachDB.
• Knowledge of data governance and security standards.

Key Skills

Education

Any Graduate