137 Ibm Db2 Jobs - Page 6

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