What are the responsibilities and job description for the Data Engineer - DataStage || Fulltime - Charlotte, NC position at K&K Global Talent Solutions?
Job Title - Data Engineer - DataStage (H1B, OPT andalso Applicable)
Experience - 10 years
Location - Charlotte, NC
Hire Type - Fulltime (Onsite)
Experience - 10 years
Location - Charlotte, NC
Hire Type - Fulltime (Onsite)
Primary skill
Cockroach DB, DataStage, Oracle (PL/SQL), ETL/ELT, SQL, Data Modeling, Performance Tuning, Data Migration, Data Warehousing, Data Governance, Backup & Recovery, Monitoring, Automation, Git, Cloud
Roles & Responsibilities
- Design, implement, and manage CockroachDB distributed database clusters
- Ensure high availability, scalability, and fault tolerance of database systems
- Perform performance tuning, query optimization, and indexing
- Manage data distribution, replication, and consistency models
- Support database migrations from traditional RDBMS (e.g., Oracle) to CockroachDB
- Monitor database health and resolve performance bottlenecks and failures
- Implement backup, recovery, and disaster recovery strategies
- Develop and maintain ETL jobs using IBM DataStage for data extraction, transformation, and loading
- Design data integration workflows to support business and analytics requirements
- Optimize DataStage job performance and scheduling
- Handle data ingestion from multiple sources into target systems
- Perform data validation, transformation, and quality checks
- Troubleshoot ETL failures and ensure data pipeline reliability
- Manage and support Oracle database environments
- Write and optimize complex SQL queries, stored procedures, and PL/SQL scripts
- Perform database performance tuning, indexing, and query optimization
- Support data modeling and schema design · Assist in data migration and integration with CockroachDB and DataStage workflows
- Maintain data integrity, security, and governance standards