75 Ibm Db2 Jobs - Page 3

At least 5+ years of experience in data development and solutions in highly complex data environments with large data volumes. At least 5+ years of experience developing complex ETLs with Informatica PowerCenter. At least 5+ years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis. At least 5+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2. Experience with performance tuning DB2 tables, queries, and stored procedures.

Job Summary We are seeking an experienced Senior Mainframe DBA to join our team and support our main ERP system. The ideal candidate will have extensive experience in IMS database administration as well as experience in DB2 database administration and expertise in migrating IBM Data Propagator to InfoSphere. The ideal candidate will have a deep understanding of mainframe environments, including IBM z/OS, and demonstrate proficiency in database management, performance optimization, and data integration solutions. Responsibilities Database Management Design, implement, and maintain IMS and DB2 databases on IBM mainframe systems. Ensure high availability, performance, and scalability of databases. Develop and execute SQL scripts for database management and automation tasks. Perform database tuning, optimization, and capacity planning. Implement and manage database backup, recovery, and disaster recovery procedures. •Data Migration Plan and execute data migration projects from IBM Data Propagator to IBM InfoSphere. Develop migration strategies, including data mapping, transformation, and validation. Ensure data integrity and minimal downtime during migration processes. Collaborate with cross-functional teams to ensure successful migration and integration with existing systems. System Integration and Support Collaborate with development teams to design and optimize database structures to support ERP applications. Provide technical expertise and support for the ERP system, ensuring seamless integration with EDI, Order Processing, Warehousing, and Financials. Troubleshoot and resolve database-related issues promptly. Data Security and Integrity Ensure data security and compliance with company policies and industry standards. Monitor and manage database access and permissions. Conduct regular audits and implement measures to protect data integrity. Tool and Utility Management Proficiency in IMS DB/DC, DB2, and IMS/DB2 Tools and utilities. Strong knowledge of JCL (Job Control Language) and TSO/ISPF. Familiarity with IBM InfoSphere, including DataStage and Data Replication. Experience with database monitoring and performance tuning tools. Develop and maintain scripts for automation and monitoring purposes. Business Process Integration Apply basic accounting concepts to support business operations. Utilize Microsoft Suite for documentation, reporting, and communication. Support and Maintenance Manage maintenance contracts and provide technical support to ensure continuous operation and timely issue resolution. Collaborate with cross-functional teams to support business needs and project initiatives. Skills and Qualifications: Bachelors degree in technology or related fields. Minimum 8 years of experience with IBM mainframe systems. Extensive experience with IMS database management. Experience with DB2 database management. Proficient in SQL and JCL programming. Strong understanding of database design, optimization, and performance tuning. Proven experience with data migration from IBM Data Propagator to IBM InfoSphere. Understanding of basic accounting concepts. Proficiency with Microsoft Suite. Experience managing maintenance contracts and providing technical support. Preferred Qualifications Experience in a distribution company. Familiarity with EDI, Order Processing, Warehousing, and financial systems. Knowledge of modern development practices such as Agile and DevOps.

More than 5+ years hands-on experience in Mainframe DB2 zOS database administration Hands on experience in DB2 Database Management area ( DB2 Z/OS DBA) with Medium to Advanced knowledge of JCL, VSAM Good analytical skills and ability to troubleshoot Analyzing Database State (both Space and Performance wise) DB2 utility (Load, Unload, Image copy, Reorg etc..) Analyzing tablespaces for space and Performance Writing queries Database Refresh from one system to another Good understanding of Agile Weekly maintenance support and incident handling This position will work on - Small infrastructure type of projects in databases. Ensuring round the clock availability of databases and tables. Work on user requests and tickets. Weekly maintenance process for backup and recovery. DDL and DML Performance tuning.

As Consultant, you are responsible to develop design of application, provide regular support/guidance to project teams on complex coding, issue resolution and execution. Your primary responsibilities include: Lead the design and construction of new mobile solutions using the latest technologies, always looking to add business value and meet user requirements. Strive for continuous improvements by testing the build solution and working under an agile framework. Discover and implement the latest technologies trends to maximize and build creative solutions. Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Mandatory Skills: LUW/Unix DB2 DBA ,Shell Scripting, Linux and AIX knowledge Secondary Skills: Physical DB2 DBA skills, PL/SQL Knowledge and exposure Expert knowledge of IBM DB2 V11.5 installations, configurations administration in Linux /AIX systems. Expert level knowledge in Database restores including redirected restore backup concepts. Excellent understanding of database performance monitoring techniques, fine tuning and able to perform performance checks query optimization Preferred technical and professional experience Good knowledge of utilities like import, load export under high volume conditions. Ability to tune SQLs using db2advisor db2explain. Ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top tec.

Must have skills : - Real time experience with CICS is required (not only in Summary & Skills, but also in recent projects). - Analyze and understand existing mainframe systems and applications. - Design, develop, and implement new mainframe applications and enhancements. - Troubleshoot and resolve mainframe application issues. - Optimize mainframe applications for performance and efficiency. - Adhere to coding standards and best practices. - Collaborate with other team members to ensure successful project delivery. - Stay updated on the latest mainframe technologies and trends. Required Skills and Qualifications : - Strong experience in mainframe programming languages such as COBOL, JCL, and Assembler. - Familiarity with mainframe operating systems (e.g., z/OS). - Knowledge of mainframe database management systems (e.g., DB2). - Understanding of mainframe tools and utilities (e.g., ISPF, TSO, SDSF). - Excellent problem-solving and analytical skills. - Ability to work independently and as part of a team. - Strong communication and interpersonal skills. Preferred Skills : - Experience with mainframe modernization projects. - Knowledge of DevOps practices and tools. - Familiarity with cloud-based mainframe solutions. Benefits : - Competitive salary and benefits package. - Opportunities for professional growth and development. - Collaborative and supportive work environment.

As Consultant, you are responsible to develop design of application, provide regular support/guidance to project teams on complex coding, issue resolution and execution. Your primary responsibilities include: Lead the design and construction of new mobile solutions using the latest technologies, always looking to add business value and meet user requirements. Strive for continuous improvements by testing the build solution and working under an agile framework. Discover and implement the latest technologies trends to maximize and build creative solutions Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Mandatory Skills: LUW/Unix DB2 DBA, Shell Scripting, Linux and AIX knowledge Secondary Skills: Physical DB2 DBA skills, PL/SQL Knowledge and exposure Expert knowledge of IBM DB2 V11.5 installations, configurations administration in Linux /AIX systems. Expert level knowledge in Database restores including redirected restore backup concepts. Excellent understanding of database performance monitoring techniques, fine tuning and able to perform performance checks query optimization Preferred technical and professional experience Good knowledge of utilities like import, load export under high volume conditions. Ability to tune SQLs using db2advisor db2explain. Ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top etc

Mandatory to work 5 days from the ODC.(Hinjewadi-Pune) Maintenance and operations (AO) of ETL platform incl. 24/7 on call member. Azure DevOps, Terraform, GitHub. Pending upgrade decisionDataStage vNext (Cloud Pak), Red Hat OpenShift Primary Skill- IBM Information Server, IBM RDM, IBM WebSphere, Azure, RHEL w/Pacemaker, Windows Server, ServiceNow, Dynatrace, Ansible, Redis Secondary Skill- IBM WebSphere, IBM DB2, Perl, Java, C++, Gitlab, Python + Dash, Waitress, Nginx Good communication skill. Must be a team player. Primary Skills Primary Skill- IBM Information Server, IBM RDM, IBM WebSphere, Azure, RHEL w/Pacemaker, Windows Server, ServiceNow, Dynatrace, Ansible, Redis Secondary Skills Secondary Skill- IBM WebSphere, IBM DB2, Perl, Java, C++, Gitlab, Python + Dash, Waitress, Nginx Good communication skill. Must be a team player.

Role & responsibilities Requirements: • Candidate should have minimum of 4 years of relevant exp and below in DB2 • Having good knowledge in Db2 architecture • having good experience to create objects like table and index creation requested by the application team • Good experience in backup strategies like an online and offline backup. • Good experience in restore database and apply logs up to point in time • Good experience to create tablespace management like adding and resizing.. • Good experience in data movement utilities • Granting permissions at the user level • checking DB health check (Monitoring tools) PD, TOP • Good exp in offline reorg/online reorg • creating an instance and install DB2 products • Having HADR knowledge -working • Performance tuning(time issues) • performing redirect restore between different servers • tuning DBM and DB level configuration parameters • knowledge in replication setups (SQL and Q) primary to standby • how to tune queries- explain (current indexes)/advise plan(indexes) • UPGRADING DB Versions / Rollback plan • Perform database maintenance • Troubleshoot the database for log files, rollback segments, table-spaces, database descriptors. • Create definitions of logical data structures, tables, views, indexes, program specification blocks, stored procedures and define their relationships • Follow naming conventions for database objects • Set data storage parameters for storage associated with the physical elements of the database • Estimate and recommend storage requirements • Maintain and monitor the health and performance of RDBMS • Analyze alerts and logs including trace files (including data block corruptions, Enqueue resources, internal errors, and I/O read-write failures), database changes, background job status, operating system logs read-write failures), database changes, background job status, operating system logs • Set up and implement database reorganizations 2 • Test and implement patches and upgrades • Implement and manage security rules and access authority as per security policy • Assist in RDBMS specific command selection (e.g., SQL, DL/I) to optimize performance • Enable Proactive monitoring to ensure Minimal/ Zero system disruptions/performance issues/ outages. • Incorporate takeaways from major incidents into monitoring to prevent repetitions. • Perform any other day-to-day administration and support activities Preferred candidate profile Immediate Joiner

Role & responsibilities Requirements: • Candidate should have minimum of 4 years of relevant exp and below in DB2 • Having good knowledge in Db2 architecture • having good experience to create objects like table and index creation requested by the application team • Good experience in backup strategies like an online and offline backup. • Good experience in restore database and apply logs up to point in time • Good experience to create tablespace management like adding and resizing.. • Good experience in data movement utilities • Granting permissions at the user level • checking DB health check (Monitoring tools) PD, TOP • Good exp in offline reorg/online reorg • creating an instance and install DB2 products • Having HADR knowledge -working • Performance tuning(time issues) • performing redirect restore between different servers • tuning DBM and DB level configuration parameters • knowledge in replication setups (SQL and Q) primary to standby • how to tune queries- explain (current indexes)/advise plan(indexes) • UPGRADING DB Versions / Rollback plan • Perform database maintenance • Troubleshoot the database for log files, rollback segments, table-spaces, database descriptors. • Create definitions of logical data structures, tables, views, indexes, program specification blocks, stored procedures and define their relationships • Follow naming conventions for database objects • Set data storage parameters for storage associated with the physical elements of the database • Estimate and recommend storage requirements • Maintain and monitor the health and performance of RDBMS • Analyze alerts and logs including trace files (including data block corruptions, Enqueue resources, internal errors, and I/O read-write failures), database changes, background job status, operating system logs read-write failures), database changes, background job status, operating system logs • Set up and implement database reorganizations 2 • Test and implement patches and upgrades • Implement and manage security rules and access authority as per security policy • Assist in RDBMS specific command selection (e.g., SQL, DL/I) to optimize performance • Enable Proactive monitoring to ensure Minimal/ Zero system disruptions/performance issues/ outages. • Incorporate takeaways from major incidents into monitoring to prevent repetitions. • Perform any other day-to-day administration and support activities Preferred candidate profile Immediate Joiner

Job Title:Senior-Azure Devops Experience7-14 Years Location:Bangalore : Senior-Azure Devops, Terraform/Terragrunt, Github/Jenkins, HA-DR, AWS services.

Must have skills : - Real time experience with CICS is required (not only in Summary & Skills, but also in recent projects). - Analyze and understand existing mainframe systems and applications. - Design, develop, and implement new mainframe applications and enhancements. - Troubleshoot and resolve mainframe application issues. - Optimize mainframe applications for performance and efficiency. - Adhere to coding standards and best practices. - Collaborate with other team members to ensure successful project delivery. - Stay updated on the latest mainframe technologies and trends. Required Skills and Qualifications : - Strong experience in mainframe programming languages such as COBOL, JCL, and Assembler. - Familiarity with mainframe operating systems (e.g., z/OS). - Knowledge of mainframe database management systems (e.g., DB2). - Understanding of mainframe tools and utilities (e.g., ISPF, TSO, SDSF). - Excellent problem-solving and analytical skills. - Ability to work independently and as part of a team. - Strong communication and interpersonal skills. Preferred Skills : - Experience with mainframe modernization projects. - Knowledge of DevOps practices and tools. - Familiarity with cloud-based mainframe solutions. Benefits : - Competitive salary and benefits package. - Opportunities for professional growth and development. - Collaborative and supportive work environment. Apply Insights Follow-up Save this job for future reference Did you find something suspiciousReport Here! Hide This Job Click here to hide this job for you. You can also choose to hide all the jobs from the recruiter.

Primary responsibility of this role is to provide 24x7 production support to Mongo and Db2 databases. Ideal candidate should have 5+ years of overall experience and expert level knowledge of Mongo DB technology (optionally IBM Db2 LUW), and he/she should be capable enough to handle complex issues independently and provide resolutions within agreed SLA s, also ensure customer delight, and always adhere to HSBC policies and procedures. Candidate having creative thinking and willing to bring innovations and passionate about working on challenging initiatives will be given preference. Requirements Primary responsibility of this role is to provide 24x7 Production Support for MongoDB databases. Perform Root Cause Analysis and troubleshooting majority production issues and provide solutions. Maintain High Availability & Replication setups. Primary responsibility of this role is to provide 24x7 Production Support for Mongo databases. Candidate should be capable to handling production issues independently and provide resolutions within agreed SLA s. Participate in Crisis Calls, MIR, DQR Experience of working in Sharding Environments Knowledge of Replication Experience in various monitoring tools like profiler, Mongo top, Mongostats Experience in MongoDB backup and recovery Experience in OPs Manager. Experience in MongoDB Logging mechanism and Journaling Experience of Handling Crisis Calls. Troubleshoot various type of critical issues in production environments. Candidate ready to work in 247 shifts on rotational basis. Additional Skill Experience in IBM Db2 RDBMS technology. Soft skills / Behavioral Qualities: Efficiently manage all tasks. Taking ownership and accountability of tasks. Proactive approach in taking tasks. Active listening skills Clear, Precise, and Timely communication with Customer/Team Members/Management Ready to work in 365 days / 24 x 7 environment as per Business/Project requirements

Primary Skills DB2 DBA Seconadry Skills ITIL Process Knowledge About The Role DB2 Interactive;IBM DB2;ITIL Good DB2 Architectural knowledge. Databases Administration - DB2 LUWSupport critical production environment. Aware of databases Monitoring & performing health check Monitoring of Ticketing tool.Ready to work in all shifts. Good knowledge inHADRDB Upgrades and Fix Pack implementation . DB backup and recobvery Good on troubleshooting related to database issue Basic knowledge in ( optional)TSAPT

Sr. IBM DB2 Admin Requirements: Candidate should have minimum of 4 years of relevant exp and below in DB2 Having good knowledge in Db2 architecture having good experience to create objects like table and index creation requested by the application team Good experience in backup strategies like an online and offline backup. Good experience in restore database and apply logs up to point in time Good experience to create tablespace management like adding and resizing.. Good experience in data movement utilities Granting permissions at the user level checking DB health check (Monitoring tools) PD, TOP Good exp in offline reorg/online reorg creating an instance and install DB2 products Having HADR knowledge -working Performance tuning(time issues) performing redirect restore between different servers tuning DBM and DB level configuration parameters knowledge in replication setups (SQL and Q) primary to standby how to tune queries- explain (current indexes)/advise plan(indexes) UPGRADING DB Versions / Rollback plan Perform database maintenance Troubleshoot the database for log files, rollback segments, table-spaces, database descriptors. Create definitions of logical data structures, tables, views, indexes, program specification blocks, stored procedures and define their relationships Follow naming conventions for database objects Set data storage parameters for storage associated with the physical elements of the database Estimate and recommend storage requirements Maintain and monitor the health and performance of RDBMS Analyze alerts and logs including trace files (including data block corruptions, Enqueue resources, internal errors, and I/O read-write failures), database changes, background job status, operating system logs read-write failures), database changes, background job status, operating system logs JOB DESCRIPTIONS Set up and implement database reorganizations Test and implement patches and upgrades Implement and manage security rules and access authority as per security policy Assist in RDBMS specific command selection (e.g., SQL, DL/I) to optimize performance Enable Proactive monitoring to ensure Minimal/ Zero system disruptions/performance issues/ outages. Incorporate takeaways from major incidents into monitoring to prevent repetitions. Perform any other day-to-day administration and support activities

Project Role : Infra Tech Support Practitioner Project Role Description : Provide ongoing technical support and maintenance of production and development systems and software products (both remote and onsite) and for configured services running on various platforms (operating within a defined operating model and processes). Provide hardware/software support and implement technology at the operating system-level across all server and network areas, and for particular software solutions/vendors/brands. Work includes L1 and L2/ basic and intermediate level troubleshooting. Must have skills : IBM DB2 Database Administration Good to have skills : No Function Specialty Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time educationBTech Summary :As an Infra Tech Support Practitioner, you will be responsible for providing ongoing technical support and maintenance of production and development systems and software products, both remote and onsite. You will work on various platforms, implementing technology at the operating system-level and performing basic and intermediate level troubleshooting. Roles & Responsibilities: Expected to perform independently and become an SME. Required active participation/contribution in team discussions. Contribute in providing solutions to work-related problems. Ensure hardware/software support for configured services running on various platforms. Implement technology at the operating system-level across all server and network areas. Provide L1 and L2/ basic and intermediate level troubleshooting. Maintain documentation of technical issues and resolutions. Collaborate with cross-functional teams to resolve technical issues efficiently. Professional & Technical Skills: Must To Have Skills:Proficiency in IBM DB2 Database Administration. Strong understanding of database management principles. Experience in performance tuning and optimization of database systems. Knowledge of backup and recovery procedures for databases. Familiarity with database security best practices. Additional Information: The candidate should have a minimum of 3 years of experience in IBM DB2 Database Administration. This position is based at our Bengaluru office. A BTech degree with 15 years of full-time education is required. Qualifications 15 years full time educationBTech

Project Role : Application Tech Support Practitioner Project Role Description : Act as the ongoing interface between the client and the system or application. Dedicated to quality, using exceptional communication skills to keep our world class systems running. Can accurately define a client issue and can interpret and design a resolution based on deep product knowledge. Must have skills : IBM DB2 Database Administration Good to have skills : NA Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Tech Support Practitioner, you will act as the ongoing interface between the client and the system or application. You will be dedicated to quality, using exceptional communication skills to keep our world-class systems running. With your deep product knowledge, you will accurately define client issues and interpret and design resolutions. Your typical day will involve providing ongoing support to clients, troubleshooting and resolving technical issues, and ensuring the smooth operation of our systems. Roles & Responsibilities: Expected to be an SME, collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams. Ensure timely resolution of client issues and technical problems. Collaborate with clients to understand their needs and provide appropriate solutions. Troubleshoot and resolve technical issues related to the system or application. Ensure the smooth operation of systems by monitoring performance and addressing any issues. Manage and prioritize support tickets to meet client expectations. Document and maintain accurate records of client interactions and issue resolutions. Stay up-to-date with the latest industry trends and technologies to provide effective support. Train and mentor junior team members to enhance their technical skills. Contribute to the continuous improvement of support processes and procedures. Participate in meetings and discussions to provide insights and recommendations. Collaborate with cross-functional teams to address complex technical challenges. Professional & Technical Skills: Must To Have Skills:Proficiency in IBM DB2 Database Administration. Good To Have Skills:Experience with Oracle Database Administration. Strong understanding of database management principles and best practices. Experience in performance tuning and optimization of database systems. Knowledge of backup and recovery procedures for databases. Familiarity with database security and access control. Ability to troubleshoot and resolve database-related issues. Excellent problem-solving and analytical skills. Additional Information: The candidate should have a minimum of 5 years of experience in IBM DB2 Database Administration. This position is based at our Bengaluru office. A 15 years full-time education is required. Qualifications 15 years full time education

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Cobol Mainframe Good to have skills : IBM CICS (Customer Information Control System), IBM DB2 Minimum 6 year(s) of experience is required Educational Qualification : a:minimum 15 years of full-time education br/>Key Responsibilities :A:Discussing requirements with clients, proposing business solutions, performing batch processing and scheduling, providing web services, managing files, and responding to client feedback br/> Technical Experience :A:Must to have skills- COBOL B:Good to have:IBM CICS, mainframe skills in DB2, VSAM, JCl C:Experience in full development life cycle from Requirements Gathering through Design, Development - Implementation; with primary focus on Design and Development br/> Professional Attributes :A:Good communication skill br/> Educational Qualification :a:minimum 15 years of full-time education Qualifications a: minimum 15 years of full-time education

Project Role : Technology Architect Project Role Description : Design and deliver technology architecture for a platform, product, or engagement. Define solutions to meet performance, capability, and scalability needs. Must have skills : IBM Db2 Good to have skills : Database Architecture Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Application Tech Support Practitioner Project Role DescriptionAct as the ongoing interface between the client and the system or application. Dedicated to quality, using exceptional communication skills to keep our world class systems running. Can accurately define a client issue and can interpret and design a resolution based on deep product knowledge.Must to have skillsIBM Db2, SSI:NON SSI: Good to have skillsSSI:NON SSI:Job Requirements Job Title:DB2 for Mainframe Database AdministratorJob Summary :We are seeking a skilled DB2 for Mainframe Database Administrator to manage and maintain our enterprise-level DB2 databases on z/OS. The ideal candidate will be responsible for ensuring the performance, availability, and security of DB2 databases while also planning and implementing database solutions for the future.Key Responsibilities:Database Management:Administer and maintain DB2 databases on IBM z/OS mainframe environments, including installation, configuration, upgrades, and patching.Performance Tuning:Monitor and optimize the performance of DB2 databases, identifying bottlenecks, and implementing performance tuning strategies to ensure high availability and responsiveness.Backup & Recovery:Develop, implement, and manage backup and recovery procedures to safeguard critical data. Perform regular backups and ensure that recovery procedures are robust and well-documented.Security Management:Implement and manage database security, including user access controls, encryption, and auditing, ensuring compliance with industry standards and company policies.Problem Resolution:Troubleshoot and resolve issues related to DB2 database operations, including providing support for complex technical problems and developing root cause analysis.Data Integrity & Availability:Ensure data integrity and availability by managing replication, data migration, and data archiving processes.Documentation:Maintain comprehensive documentation of the database environment, including configurations, processes, and procedures.Collaboration:Work closely with application developers, system administrators, and other stakeholders to design and implement database solutions that meet business requirements.Disaster Recovery:Participate in the development and testing of disaster recovery plans to ensure data continuity in the event of a disaster.Compliance & Auditing:Ensure that database systems comply with regulatory requirements and participate in regular audits. Qualifications:Experience:Minimum of 5 years of experience as a DB2 Database Administrator in a mainframe environment.Technical Skills: Technical Proficiency:In-depth knowledge of DB2 for z/OS, SQL,SPUFI, IBM Data Studio, CA Tools For DB2 (RC Query, Migrator, Log Analyzer, etc.), BMC Utilities, CA Utilities, IBM Utilities, File Manager For DB2, InfoSphere CDCStrong knowledge of mainframe technologies and z/OS operating systemMainframe TechnologiesZ/OS, JCL, REXX, CLIST, ESP schedulerPerformance Monitoring ToolsIBM OMEGAMON, CA Thread Terminator, IBM Query Monitor, IBM Tivoli Enterprise Portal, Dynatrace, (other monitoring software is owned but not implemented at the moment ex Detector/Subsystem Analyzer)Version Control Systems.ChangemanSecurity ToolsRACFOperating SystemsZ/OSDB2 System Version:V12M510 & V13M100Scripting LanguagesREXX, JCL, CLISTExperience with database performance tuning and optimizationFamiliarity with backup and recovery tools and processesUnderstanding of database security best practicesExperience with disaster recovery planning and implementationSoft Skills: Strong analytical and problem-solving abilitiesExcellent communication and collaboration skillsAbility to work independently and as part of a teamAttention to detail and strong organizational skillsPreferred Qualifications:IBM Certified Database Administrator DB2 for z/OSExperience with data replication tools (e.g., Q Replication, InfoSphere)Knowledge of automation tools and scripting languages (e.g., REXX, JCL)Additional Information: The candidate should have a minimum of 3 years of experience in DB2 for Mainframe Database Administrator This position is based at our Pune office. A 15 years full-time education is required.

Project Role : Software Development Engineer Project Role Description : Analyze, design, code and test multiple components of application code across one or more clients. Perform maintenance, enhancements and/or development work. Must have skills : IBM DB2 Database Administration Good to have skills : NA Minimum 5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As a Software Development Engineer, you will analyze, design, code, and test multiple components of application code across one or more clients. You will perform maintenance, enhancements, and/or development work, contributing to the overall success of the projects. Roles & Responsibilities: Expected to be an SME, collaborate, and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Provide solutions to problems for their immediate team and across multiple teams. Lead and mentor junior team members. Conduct code reviews to ensure code quality and adherence to best practices. Professional & Technical Skills: Must To Have Skills: Proficiency in IBM DB2 Database Administration. Strong understanding of database performance tuning and optimization. Experience in database backup and recovery procedures. Knowledge of database security best practices. Good To Have Skills: Experience with SQL Server Administration. Additional Information: The candidate should have a minimum of 5 years of experience in IBM DB2 Database Administration. This position is based at our Bengaluru office. A 15 years full-time education is required. Qualification 15 years full time education

Minimum 5+ years of extensive RPG and SQL Experience. Responsibilities Design and implement enterprise solutions based on business needs. Collaborating with IT stakeholders to define requirements and ensure secure cost-effective architectures. Required Candidate profile Lead or support project teams, guide technical decisions, and maintain current knowledge of technologies, standards, and compliance (e.g., PCI).

As Consultant, you are responsible to develop design of application, provide regular support/guidance to project teams on complex coding, issue resolution and execution. Your primary responsibilities include: Lead the design and construction of new mobile solutions using the latest technologies, always looking to add business value and meet user requirements. Strive for continuous improvements by testing the build solution and working under an agile framework. Discover and implement the latest technologies trends to maximize and build creative solutions Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Mandatory Skills: LUW/Unix DB2 DBA ,Shell Scripting, Linux and AIX knowledge Secondary Skills: Physical DB2 DBA skills, PL/SQL Knowledge and exposure Expert knowledge of IBM DB2 V11.5 installations, configurations administration in Linux /AIX systems. Expert level knowledge in Database restores including redirected restore backup concepts. * Excellent understanding of database performance monitoring techniques, fine tuning and able to perform performance checks query optimization Preferred technical and professional experience Good knowledge of utilities like import, load export under high volume conditions. Ability to tune SQLs using db2advisor db2explain. Ability to troubleshoot database issues using db2diag, db2pd, db2dart, db2top tec

Req ID: 318492 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Snowflake, Python, Airflow Engineer to join our team in Bangalore, Karnataka (IN-KA), India (IN). Job DutiesTeam Overview The Controls Engineering, Measurement and Analytics (CEMA) department is responsible for Cyber Risk and Control assessment, management, monitoring, and reporting capabilities across Technology, resulting in risk reduction and better oversight of the technology risk landscape of the firm. Our work is always client focused, our engineers are problem-solvers and innovators. We seek exceptional technologists to help deliver solutions on our user-facing applications, data stores, and reporting and metric platforms while being cloud-centric, leveraging multi-tier architectures and aligned with our DevOps and Agile strategies. We are in the process of modernizing our technology stack across multiple platforms with the goal of building scalable, front-to-back assessment, measurement and monitoring systems using the latest cloud, web, and data technologies. We are looking for someone with a systematic problem-solving approach, coupled with a sense of ownership and drive. The successful candidate will be able to influence and collaborate globally. They should be a strong team-player, have an entrepreneurial approach, push innovative ideas while appropriately considering risk, and adapt in a fast-paced changing environment. Role Summary As an ETL / Data Engineer, you will be a member of the CEDAR / C3 Data Warehouse team, with a focus on sourcing and storing data from various technology platforms across the firm into a centralized data platform used to build various reporting and analytics solutions for the Technology Risk functions within Morgan Stanley. In this role you will be primarily responsible for the development of data pipelines, database views, and stored procedures, in addition to performing technical data analysis, and monitoring and tuning queries and data loads. You will be working closely with data providers, data analysts, data developers, and data analytics teams to facilitate the implementation of client-specific business requirements and requests. KEY RESPONSIBILITIES: To develop ETLs, stored procedures, triggers, and views on our existing DB2-based Data Warehouse and on our new Snowflake-based Data Warehouse. To perform data profiling and technical analysis on source system data to ensure that source system data can be integrated and represented properly in our models. To monitor the performance of queries and data loads and perform tuning as necessary. To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues. Minimum Skills Required Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or related field required. At least 5+ years of experience in data development and solutions in highly complex data environments with large data volumes. At least 5+ years of experience developing complex ETLs with Informatica PowerCenter. At least 5+ years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis. At least 5+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2. Experience with performance tuning DB2 tables, queries, and stored procedures. An understanding of E-R data models (conceptual, logical, and physical). Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ Bi-Temporal models, etc.). Experience with Python a plus. Experience with developing data transformations using DBT a plus. Experience with Snowflake a plus. Experience with Airflow a plus. Experience with using Spark (PySpark) for data loading and complex transformations a plus. Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions. Strong communication skills both verbal and written. Capable of coll About NTT DATA NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies.Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us atus.nttdata.com NTT DATA endeavors to make https://us.nttdata.comaccessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here. Job Segment Cloud, Data Warehouse, Database, Computer Science, Quality Assurance, Technology

Req ID: 318488 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Snowflake, Python, Airflow Engineer to join our team in Bangalore, Karnataka (IN-KA), India (IN). Job DutiesTeam Overview The Controls Engineering, Measurement and Analytics (CEMA) department is responsible for Cyber Risk and Control assessment, management, monitoring, and reporting capabilities across Technology, resulting in risk reduction and better oversight of the technology risk landscape of the firm. Our work is always client focused, our engineers are problem-solvers and innovators. We seek exceptional technologists to help deliver solutions on our user-facing applications, data stores, and reporting and metric platforms while being cloud-centric, leveraging multi-tier architectures and aligned with our DevOps and Agile strategies. We are in the process of modernizing our technology stack across multiple platforms with the goal of building scalable, front-to-back assessment, measurement and monitoring systems using the latest cloud, web, and data technologies. We are looking for someone with a systematic problem-solving approach, coupled with a sense of ownership and drive. The successful candidate will be able to influence and collaborate globally. They should be a strong team-player, have an entrepreneurial approach, push innovative ideas while appropriately considering risk, and adapt in a fast-paced changing environment. Role Summary As an ETL / Data Engineer, you will be a member of the CEDAR / C3 Data Warehouse team, with a focus on sourcing and storing data from various technology platforms across the firm into a centralized data platform used to build various reporting and analytics solutions for the Technology Risk functions within Morgan Stanley. In this role you will be primarily responsible for the development of data pipelines, database views, and stored procedures, in addition to performing technical data analysis, and monitoring and tuning queries and data loads. You will be working closely with data providers, data analysts, data developers, and data analytics teams to facilitate the implementation of client-specific business requirements and requests. KEY RESPONSIBILITIES: To develop ETLs, stored procedures, triggers, and views on our existing DB2-based Data Warehouse and on our new Snowflake-based Data Warehouse. To perform data profiling and technical analysis on source system data to ensure that source system data can be integrated and represented properly in our models. To monitor the performance of queries and data loads and perform tuning as necessary. To provide assistance and guidance during the QA & UAT phases to quickly confirm the validity of potential issues and to determine the root cause and best resolution of verified issues. Minimum Skills Required Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or related field required. At least 5+ years of experience in data development and solutions in highly complex data environments with large data volumes. At least 5+ years of experience developing complex ETLs with Informatica PowerCenter. At least 5+ years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries to perform data analysis. At least 5+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2. Experience with performance tuning DB2 tables, queries, and stored procedures. An understanding of E-R data models (conceptual, logical, and physical). Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal \ Bi-Temporal models, etc.). Experience with Python a plus. Experience with developing data transformations using DBT a plus. Experience with Snowflake a plus. Experience with Airflow a plus. Experience with using Spark (PySpark) for data loading and complex transformations a plus. Strong analytical skills, including a thorough understanding of how to interpret customer business requirements and translate them into technical designs and solutions. Strong communication skills both verbal and written. Capable of coll About NTT DATA NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies.Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us atus.nttdata.com NTT DATA endeavors to make https://us.nttdata.comaccessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us. This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here. Job Segment Cloud, Data Warehouse, Computer Science, Database, SQL, Technology

Warm Greetings from SP Staffing Services Pvt Ltd!!!! Experience:6-10yrs Work Location :Chennai Job Description: Experience in Mainframe Db2 DBA 1. Should be stronghold on Mainframe & Database Architecture. 2. Should be expertise in Mainframe Database concepts 3. Should be dealing with various vendors & application team and troubleshoot the application Issues. 4. Should hold the hands-on knowledge in Mainframe Database offline & online Utilities. Hands-on experience in ISV tools like BMC and CA products Interested candidates, Kindly share your updated resume to gokul.priya@spstaffing.in or contact number (Whatsapp:9360311230) to proceed further.

Job Description DB2 Architecture & Administration : Expertise in designing, implementing, and managing IBM DB2 LUW environments across multiple OS platforms. Performance Tuning & Optimization : Proficiency in database performance tuning, query optimization and troubleshooting complex issues. Security & Auditing : Experience in implementing database security, audits, and compliance measures. Upgrades & Patching : Skilled in planning and executing DB2 upgrades, patch management, and applying fixes. Replication & CDC : Nice to have experience in DB2 replication process (including IBM CDC) across diverse environments and platforms. Scripting & Automation : Proficient in automation using shell scripts, Python, or other scripting languages. Change Management & Communication : Strong knowledge of ITIL change management processes, with excellent communication skills and experience working in MNC environments. Role & responsibilities Preferred candidate profile