Data Engineer - DataStage || Fulltime - Charlotte, NC

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