Senior Specialist at HCLTech (2023-02 – Present)
Platform Team Member (Beyond Traditional Admin Scope)
- Led upgrades of IBM DataStage from FP4/SP4 to FP5, ensuring minimal downtime and full compliance.
- Set up a multi-engine architecture to handle high-volume workloads, replacing a standalone environment.
- Standardized the DataStage environment across projects to improve maintainability and performance.
- Created and managed PMRs with IBM, serving as the primary contact for issue resolution.
- Applied IBM fix packs and WebSphere patches to address security vulnerabilities.
- Installed and configured MettleCI for code compliance, unit testing, and version control.
- Automated service restarts, purging, user access provisioning, and process monitoring using Azure.
- Developed Ansible-based pipelines for automated code deployments from GitLab/Bitbucket to DataStage.
- Managed and maintained Oracle databases supporting DataStage ETL workloads across multiple environments (DEV, TEST, ACC, PROD).
- Performed Oracle client upgrades and patch validation (19c/21c) to ensure compatibility with DataStage and improved system stability.
- Managed and validated database connectivity configurations including TNS, wallets, and SSL/TLS setups.
- Monitored database health, sessions, locks, and long-running queries to ensure optimal performance.
- Troubleshot performance issues related to query execution, ETL failures, and database connectivity.
- Coordinated with DBA teams to resolve Oracle RAC / ONS / FAN-related issues impacting application availability.
- Supported schema changes and object validations, including tables, indexes, sequences, and triggers.
- Investigated and resolved database-related job failures, including timeouts, deadlocks, and connection drops.
- Assisted in query tuning and performance optimization for ETL jobs processing high-volume data.
- Supported user management activities, including account verification, role validation, and access troubleshooting.
- Contributed to incident analysis and RCA for database-related production issues.
- Implemented Grafana dashboards to monitor CPU, memory, and I/O metrics.
- Scheduled and managed ETL jobs using UAC (Universal Automation Center).
- Installed Stunnel to meet DORA compliance requirements.
- Participated in penetration testing with IBM, addressing vulnerabilities like XXE, XMQL, and SQL injection.
- Managed password rotations for isadmin and isadmin_xx across all environments.
- Ensured ITRMP compliance, handled NPA creation, and conducted regular vulnerability remediation.
- Contributed to IBM Cloud Pak for Data (CP4D) proof of concept.
- Supported Avro format integration within DataStage pipelines.
- Decommissioned legacy servers and zones as part of infrastructure modernization.
- Created internal knowledge base pages to assist with recurring DataStage issues.
- Provided L2/L3 support for job failures and performance issues.
- Collaborated with server teams, extending responsibilities beyond DataStage to platform-level administration.
- Analyzed system resource usage and implemented CPU/memory reductions to drive cost savings.
- Followed standard change management procedures for all infrastructure and application updates.
Senior Engineer – Cloud & Infra Services at L & T Infotech (2022-05 – 2023-02)
Middleware & DataStage Administrator – Citibank | L2 Support | Environment: IBM InfoSphere DataStage 11.3 to 11.7
- Led the upgrade and installation of IBM DataStage from version 11.3 to 11.7 across multiple environments.
- Set up and configured production support environments, ensuring seamless integration and stability.
- Managed project lifecycle activities including creation, configuration, and deletion of DataStage projects.
- Handled user provisioning, role assignments, and access control across DEV, QA, and PROD tiers.
- Performed import/export of DataStage jobs and datasets using both GUI and command-line tools.
- Monitored system performance and ensured high availability of middleware and ETL services.
- Conducted regular health checks and implemented proactive measures to prevent downtime.
- Configured database connections and managed DataStage for ETL processes.
- Supported integration and file transfers using NDM (Connect:Direct) for secure data exchange.
Software Engineer at Brillio Technologies Pvt. Ltd (2019-07 – 2022-05)
DataStage Administrator – Walmart
- Managed IBM Information Server GRID environments, ensuring optimal performance and uptime across DEV, QA, and PROD tiers.
- Created, configured, and deleted DataStage projects via Administrator client and Linux CLI.
- Performed SSL certificate installations and updated TLS settings on both Service and Engine tiers.
- Set up users, roles, and privileges across multiple environments.
- Configured ETL project parameters and added message handlers at job/project levels.
- Migrated DataStage jobs using Export/Import wizard and istool command for efficient deployment.
- Released job locks and resolved process conflicts to maintain smooth ETL operations.
- Monitored and troubleshot DataStage jobs during production loads and failures.
- Monitored system resources including memory, CPU, and disk space.
- Executed ISA Lite for health checks and maintained APT configuration files.
- Configured database connections using ODBC and TNS entries.
- Updated drivers including ODBC, jdbc.
- Automated daily tasks using shell scripts and scheduled them via crontab.
- Coordinated with DBA and Unix server teams to resolve infrastructure issues.
- Provided continuous support to project teams and documented all troubleshooting activities.
- Assigned and resolved DataStage-related tickets in JIRA and ServiceNow within SLA timelines.
- Worked closely with onsite and offshore L3 teams for escalations and advanced support.
