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