2 Infosphere Datastage Jobs

Installation, migration, configuration, maintenance, technical support and troubleshooting of InfoSphere DataStage Client and Server Responsible for InfoSphere DataStage administration and server maintenance / Upgrades / patches / install Build and Monitor server usage statistics to identify possible performance issues/enhancements for ETL Applications (Administrative Views for InfoSphere DataStage, Server Usage Report) Expertise on AWS and Azure Coud and related technologies Expertise on CI/CD process using Jenkins/UDeploy/Git Expertise on IDE (Integrated Development Environment) Performance tuning and Server management of InfoSphere DataStage server environment (clustering, Load balancing). Work with Business Teams for managing user and group permissions, Workflows and Projects, Database Views, Data Sources and Data Connections Manage and support migration of content from development to production environments. Provide appropriate training and support to business users on the use of InfoSphere DataStage tools, best practices and standards. Assist in the identification and migration of data sources to InfoSphere DataStage server. Document best practices for development and administration of the InfoSphere DataStage platform. Contribute to architecture and capacity planning activities. Required to monitor/Handle InfoSphere DataStage and InfoSphere DataStage services during windows servers maintenance. Configure/Optimize Servers settings. Apply trace logs on servers in case of troubleshooting complex incidents. Troubleshooting dashboards issues, system slowness. Create ODBC, OLE connections for SQL DB servers and Implement Firewall rules on InfoSphere DataStage processing servers. Linux server setup, deployment, and maintenance Provide off-hours and weekend support in an on-call rotation. Required Skills: Expertise on various database drivers (DBX, ODBC, JDBC) Working knowledge on Snowflake, Databricks, SQL Server, etc Expertise on UNIX and Windows scripting Working knowledge on Python and REST API Working knowledge on Okta and other SSO technologies Required Experience & Education: 8 to 11 years of experience Experience with InfoSphere DataStage 11.x or newer bachelors degree or better preferred Desired Experience: Experience with IBMs CloudPak technology / CloudPak for Data

Key Responsibilities: IBM Data Management Administration: Administer and support IBM Db2 and other IBM data management systems (e.g., InfoSphere , IBM Netezza ). Ensure database performance and reliability by optimizing database design, data models , queries , and indexes . Perform installation , configuration , and patching of IBM data management tools and databases. Monitor database health and implement proactive solutions for backup , disaster recovery , and high availability . Database Performance Optimization: Use IBM tools and technologies to tune database performance , focusing on response time, query execution time, and overall system throughput. Identify and resolve database performance bottlenecks through the use of indexing , query optimization , and partitioning strategies. Conduct regular performance assessments and implement improvements based on system load and usage trends. Data Modeling and Data Management: Work closely with business and data teams to design and implement logical and physical data models to meet business requirements. Ensure the integrity and consistency of data across all systems through proper data governance and data quality management practices. Implement and maintain data transformation , integration , and ETL (Extract, Transform, Load) processes using IBM tools like InfoSphere DataStage . Backup and Disaster Recovery: Design and manage backup strategies for IBM data systems, ensuring business continuity. Configure and validate disaster recovery and business continuity processes, minimizing the risk of data loss. Regularly test recovery procedures to ensure quick and efficient restoration of services. Security and Compliance: Implement security best practices within IBM databases, including access control, user permissions, encryption, and audit logging. Ensure compliance with industry-specific data security and privacy regulations (e.g., GDPR , HIPAA ). Perform data masking and data anonymization as part of sensitive data management processes. Automation and Scripting: Develop and maintain scripts for automating routine database management tasks using Shell , Python , PowerShell , or IBM-specific tools. Integrate automation solutions for backup, monitoring, patching, and reporting tasks to improve operational efficiency. Troubleshooting and Support: Provide technical support for issues related to IBM Data Management systems , including performance issues, outages, and system upgrades. Troubleshoot complex database issues related to data access, integrity, and application compatibility. Assist development teams with resolving SQL performance and database-related issues. Documentation and Reporting: Maintain detailed and up-to-date documentation for database configurations, procedures, and IBM Data Management systems . Generate periodic reports on database performance, health, and security compliance. Create and maintain operational guides for end-users, developers, and other stakeholders. Collaboration and Knowledge Sharing: Collaborate with cross-functional teams, including development , data analytics , and operations , to ensure smooth integration and data flow across platforms. Mentor and provide training for junior database administrators and team members on best practices for IBM data management. Share insights and knowledge about new features, best practices, and tools within the IBM data ecosystem. Required Qualifications: Bachelor's degree in Computer Science , Information Technology , Data Engineering , or a related field. 3-5 years of experience in IBM Data Management , including IBM Db2 , InfoSphere , Netezza , or similar IBM data technologies. Strong understanding of database management , including backup/recovery , performance tuning , and high availability concepts. Proficiency in SQL for querying, scripting, and troubleshooting. Experience in data integration and ETL processes using IBM tools (e.g., InfoSphere DataStage ). Familiarity with data governance , data security , and compliance standards in database management. Experience in Linux/Unix and Windows environments for administering databases. Solid understanding of database indexing , query optimization , and partitioning .