Data Engineer _ Cockroach DB, DataStage, Oracle

Must Have Technical/Functional Skills 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 Experience:

Minimum 10 years 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

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage:

Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support:

Maternal & Parental Leaves.

Insurance Options:

Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth:

Commuter Benefits & Certification & Training Reimbursement.

Time Off:

Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance:

Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range:

$110,000-$125,000 a year