Mayisha Umaimath

Experienced in DataStage administration and platform management, bringing strong skills in UNIX, SQL, and automation through Ansible. Skilled in optimizing system performance and implementing compliance measures, with a focus on cost efficiency and vulnerability management. Offering abilities in cross-functional team collaboration and complex problem-solving.

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.

B. Tech in ECE – Canara Engineering College (2018-08)