143 Ibm Db2 Jobs - Page 2

Bachelor's degree in Computer Science, Information Technology, or related field. Proven experience with Oracle WebLogic and AWS cloud services. Strong knowledge of database management systems including Oracle Database, Oracle MySQL Enterprise, Microsoft SQL Server, and IBM DB2. Familiarity with .NET interoperability and middleware integration. Experience with security models and best practices in cloud environments. Excellent problem-solving skills and ability to work under pressure. Strong communication skills and ability to collaborate with clients and team members. Certification in Oracle WebLogic and AWS is a plus.

Dear Candidate, We are seeking a skilled and experienced DBA Data Engineer to join our growing data team. The ideal candidate will play a key role in designing, implementing, and maintaining our databases and data pipeline architecture. You will collaborate with software engineers, data analysts, and DevOps teams to ensure efficient data flow, data integrity, and optimal database performance across all systems. This role requires a strong foundation in database administration, SQL performance tuning, data modeling, and experience with both on-prem and cloud-based environments. Requirements: Bachelors degree in Computer Science, Information Systems, or a related field. 6+ years of experience in database administration and data engineering. Proven expertise in RDBMS ( Oracle , MySQL , and PostgreSQL ) and NoSQL systems (MongoDB, Cassandra). Experience managing databases in cloud environments ( AWS , Azure , or GCP ). Proficiency in ETL processes and tools (e.g., Apache NiFi, Talend, Informatica, AWS Glue). Strong experience with scripting languages such as Python , Bash , or PowerShell . DBA Data Engineer Roles & Responsibilities: Design and maintain scalable and high-performance database architectures. Monitor and optimize database performance using tools like CloudWatch , Oracle Enterprise Manager, pgAdmin , Mongo Compass , or Dynatrace . Develop and manage ETL/ELT pipelines to support business intelligence and analytics. Ensure data integrity and security through best practices in backup, recovery, and encryption. Automate regular database maintenance tasks using scripting and scheduled jobs. Implement high availability, failover, and disaster recovery strategies. Conduct performance tuning of queries, stored procedures, indexes, and table structures. Collaborate with DevOps to automate database deployments using CI/CD and IaC tools (e.g., Terraform, AWS CloudFormation). Design and implement data models, including star/snowflake schemas for data warehousing. Document data flows, data dictionaries, and database configurations. Manage user access and security policies using IAM roles or database-native permissions. Analyze existing data systems and propose modernization or migration plans (on-prem to cloud, SQL to NoSQL , etc.). Use AWS RDS , Amazon Redshift , Azure SQL Database , or Google BigQuery as needed. Stay up-to-date with emerging database technologies and make recommendations. Must-Have Skills: Deep knowledge of SQL and database performance tuning. Hands-on experience with database migrations and replication strategies. Familiarity with data governance, data quality, and compliance frameworks ( GDPR , HIPAA , etc.). Strong problem-solving and troubleshooting skills. Experience with data streaming platforms such as Apache Kafka, AWS Kinesis , or Apache Flink is a plus. Experience with data lake and data warehouse architectures. Excellent communication and documentation skills. Soft Skills: Problem-Solving: Ability to analyze complex problems and develop effective solutions. Communication Skills: Strong verbal and written communication skills to effectively collaborate with cross-functional teams. Analytical Thinking: Ability to think critically and analytically to solve technical challenges. Time Management: Capable of managing multiple tasks and deadlines in a fast-paced environment. Adaptability: Ability to quickly learn and adapt to new technologies and methodologies. Interview Mode : F2F for who are residing in Hyderabad / Zoom for other states Location : 43/A, MLA Colony,Road no 12, Banjara Hills, 500034 Time : 2 - 4pm

Role & responsibilities 7+ Yrs experience in DB2 subsystem setup (standalone & data sharing) and ZPARM tuning. Expertise in Monoplex, SYSPLEX, and data-sharing architecture. Strong knowledge of DB2 DRDA architecture, backup & recovery (image copy, FLASH, mirroring). Experience in REXX/CLIST, ISPF programming, and CICS/IMS-DB2 interface. Expertise in SMP/E, DB2 software migration (V12, V13), and maintenance. Familiarity with unsupported/new DB2 z/OS features, compilers, and debugging. Experience handling PMR tickets and DB2 security/health checks. Installation & maintenance of IBM tools (OMEGAMON, DB2 Admin, HPU). Experience with Broadcom (RC Migration, Fast Load/Unload) and BMC tools. Manage DB2 ZPARM settings and optimize system parameters. Use tools like IBM Omegamon, CA Insight, and BMC Mainview for performance monitoring. Strong knowledge of IBM utilities (REORG, RUNSTATS, LOAD, UNLOAD). Troubleshoot DB2 system issues, diagnose performance bottlenecks. Coordinate with vendors for PMR ticket resolution and issue debugging. Support transactional environments like CICS and IMS with DB2 Preferred candidate profile Strong knowledge of IBM utilities (REORG, RUNSTATS, LOAD, UNLOAD). Expertise in DB2 traces, SMF, RMF, WLM, and performance reports. Tuning virtual storage (Buffer Pool, EDM Pool, thread storage). Experience with monitoring tools (IBM Omegamon, CA Insight, BMC Mainview). Experience with DB2 Connect, IBM Data Studio, and DB2 Cloning. SAP/DB2 & PeopleSoft/DB2 architecture knowledge, high availability solutions.

Dear Candidate, We are seeking a skilled and experienced DBA Data Engineer to join our growing data team. The ideal candidate will play a key role in designing, implementing, and maintaining our databases and data pipeline architecture. You will collaborate with software engineers, data analysts, and DevOps teams to ensure efficient data flow, data integrity, and optimal database performance across all systems. This role requires a strong foundation in database administration, SQL performance tuning, data modeling, and experience with both on-prem and cloud-based environments. Requirements: Bachelors degree in Computer Science, Information Systems, or a related field. 5+ years of experience in database administration and data engineering. Proven expertise in RDBMS ( Oracle , MySQL , and PostgreSQL ) and NoSQL systems (MongoDB, Cassandra). Experience managing databases in cloud environments ( AWS , Azure , or GCP ). Proficiency in ETL processes and tools (e.g., Apache NiFi, Talend, Informatica, AWS Glue). Strong experience with scripting languages such as Python , Bash , or PowerShell . DBA Data Engineer Roles & Responsibilities: Design and maintain scalable and high-performance database architectures. Monitor and optimize database performance using tools like CloudWatch , Oracle Enterprise Manager, pgAdmin , Mongo Compass , or Dynatrace . Develop and manage ETL/ELT pipelines to support business intelligence and analytics. Ensure data integrity and security through best practices in backup, recovery, and encryption. Automate regular database maintenance tasks using scripting and scheduled jobs. Implement high availability, failover, and disaster recovery strategies. Conduct performance tuning of queries, stored procedures, indexes, and table structures. Collaborate with DevOps to automate database deployments using CI/CD and IaC tools (e.g., Terraform, AWS CloudFormation). Design and implement data models, including star/snowflake schemas for data warehousing. Document data flows, data dictionaries, and database configurations. Manage user access and security policies using IAM roles or database-native permissions. Analyze existing data systems and propose modernization or migration plans (on-prem to cloud, SQL to NoSQL , etc.). Use AWS RDS , Amazon Redshift , Azure SQL Database , or Google BigQuery as needed. Stay up-to-date with emerging database technologies and make recommendations. Must-Have Skills: Deep knowledge of SQL and database performance tuning. Hands-on experience with database migrations and replication strategies. Familiarity with data governance, data quality, and compliance frameworks ( GDPR , HIPAA , etc.). Strong problem-solving and troubleshooting skills. Experience with data streaming platforms such as Apache Kafka, AWS Kinesis , or Apache Flink is a plus. Experience with data lake and data warehouse architectures. Excellent communication and documentation skills. Soft Skills: Problem-Solving: Ability to analyze complex problems and develop effective solutions. Communication Skills: Strong verbal and written communication skills to effectively collaborate with cross-functional teams. Analytical Thinking: Ability to think critically and analytically to solve technical challenges. Time Management: Capable of managing multiple tasks and deadlines in a fast-paced environment. Adaptability: Ability to quickly learn and adapt to new technologies and methodologies. Interview Mode : F2F for who are residing in Hyderabad / Zoom for other states Location : 43/A, MLA Colony,Road no 12, Banjara Hills, 500034 Time : 2 - 4pm

As an SAP BASIS Consultant, you will play a crucial role within the Digital Office Enterprise Application SC & ERP Found TA Ops Basis team. You will manage and maintain SAP systems, ensuring their stability, performance, and security while acting as a key interface between SAP applications and the infrastructure. Engage with a diverse range of technologies, from SAP R/3 to SAP S/4 HANA 2020, and perform core Basis activities, including monitoring, patch management, and system upgrades. You will thrive in a collaborative work environment that values initiative, problem-solving, and adherence to ITIL standards. You have: Bachelors/Masters degree with 3-6 years of SAP BASIS experience Core BASIS activitiesMonitoring, Landscape management, Transport Management, Patching Hands-on experience in SAP Kernel maintenance and SAP Patch management Knowledge of SAP Application Security and Single Sign-On technologies It would be nice if you also had: Experience maintaining DB Parameters, SSL, SNC, and SSO configuration Knowledge in SAP Solution Manager configurations Understanding of SoX and Audit Procedures Experience with LAMA and PCA Provide technical management and support for SAP systems from SAP R/3 4.6c to SAP S/4 HANA 2020. Oversee database activities across various platforms including Oracle, IBM DB2 LUW, HANA, and SAP ASE. Ensure compliance with Service Level Agreements (SLAs) for requests and incidents. Analyze issues independently and deliver effective solutions with minimal guidance. Conduct Early Watch Alerts (EWA) assessments and provide actionable recommendations to stakeholders. Implement and maintain SAP Basis activities such as monitoring, transport management, patching, and system upgrades. Configure and administer SAP security and Single Sign-On technologies. Lead and support 24/7 operations, ensuring the stability and performance of the SAP landscape.

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

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

Dear Candidate, We are seeking a skilled and experienced DBA Data Engineer to join our growing data team. The ideal candidate will play a key role in designing, implementing, and maintaining our databases and data pipeline architecture. You will collaborate with software engineers, data analysts, and DevOps teams to ensure efficient data flow, data integrity, and optimal database performance across all systems. This role requires a strong foundation in database administration, SQL performance tuning, data modeling, and experience with both on-prem and cloud-based environments. Requirements: Bachelors degree in Computer Science, Information Systems, or a related field. 8+ years of experience in database administration and data engineering. Proven expertise in RDBMS (Oracle, MySQL, and PostgreSQL) and NoSQL systems (MongoDB, Cassandra). Experience managing databases in cloud environments (AWS, Azure, or GCP). Proficiency in ETL processes and tools (e.g., Apache NiFi, Talend, Informatica, AWS Glue). Strong experience with scripting languages such as Python, Bash, or PowerShell. DBA Data Engineer Roles & Responsibilities: Design and maintain scalable and high-performance database architectures. Monitor and optimize database performance using tools like CloudWatch, Oracle Enterprise Manager, pgAdmin, Mongo Compass, or Dynatrace. Develop and manage ETL/ELT pipelines to support business intelligence and analytics. Ensure data integrity and security through best practices in backup, recovery, and encryption. Automate regular database maintenance tasks using scripting and scheduled jobs. Implement high availability, failover, and disaster recovery strategies. Conduct performance tuning of queries, stored procedures, indexes, and table structures. Collaborate with DevOps to automate database deployments using CI/CD and IaC tools (e.g., Terraform, AWS CloudFormation). Design and implement data models, including star/snowflake schemas for data warehousing. Document data flows, data dictionaries, and database configurations. Manage user access and security policies using IAM roles or database-native permissions. Analyze existing data systems and propose modernization or migration plans (on-prem to cloud, SQL to NoSQL, etc.). Use AWS RDS, Amazon Redshift, Azure SQL Database, or Google BigQuery as needed. Stay up-to-date with emerging database technologies and make recommendations. Must-Have Skills: Deep knowledge of SQL and database performance tuning. Hands-on experience with database migrations and replication strategies. Familiarity with data governance, data quality, and compliance frameworks (GDPR, HIPAA, etc.). Strong problem-solving and troubleshooting skills. Experience with data streaming platforms such as Apache Kafka, AWS Kinesis, or Apache Flink is a plus. Experience with data lake and data warehouse architectures. Excellent communication and documentation skills. Soft Skills: Problem-Solving: Ability to analyze complex problems and develop effective solutions. Communication Skills: Strong verbal and written communication skills to effectively collaborate with cross-functional teams. Analytical Thinking: Ability to think critically and analytically to solve technical challenges. Time Management: Capable of managing multiple tasks and deadlines in a fast-paced environment. Adaptability: Ability to quickly learn and adapt to new technologies and methodologies. Interview Mode : F2F for who are residing in Hyderabad / Zoom for other states Location : 43/A, MLA Colony,Road no 12, Banjara Hills, 500034 Time : 2 - 4pm

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 : NAMinimum 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

Project Role : Application Lead Project Role Description : Lead the effort to design, build and configure applications, acting as the primary point of contact. Must have skills : Finastra Fusion Loan IQ Good to have skills : Java, Spring BootMinimum 7.5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Lead, you will lead the effort to design, build, and configure applications, acting as the primary point of contact. Your day will involve overseeing the application development process and ensuring seamless communication within the team and stakeholders. 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 the application development process effectively- Ensure seamless communication within the team and stakeholders Professional & Technical Skills: - Must have Skills :Finastra Fusion Loan IQ - Good to Have Skills :Spring Application Framework, Microservices and Light Weight Architecture - Integrate Loan IQ with Market data applications and clients proprietary software applications using Spring related frameworks - Perform Analysis, design, code, unit test and deployment in Loan IQ SDK, and ensure that interfaces are working fine - Develop and maintain batch report files from Loan IQ for Loan Operations, Treasury etc, - Assess the impact of changes on existing business and technology processes, as well as other interfacing systems Technical Experience :- 5+ years of sound experience in Loan IQ SDK, Loan IQ functionality, Java, Spring related frameworks Good to know Spring Boot and Microservices - Expertise in designing and developing the interface programs for different integrating applications Batch, Web Services, JMS etc, - Must have good Knowledge on Loan IQ Data Model - Good to have Interface Mapping documentation designing experience - At least, 1 RDBMS experience is required Oracle/MS-SQL/IBM DB2 - Good communication skills - Good analytical skills Additional Information:- The candidate should have a minimum of 7.5 years of experience in Finastra Fusion Loan IQ- This position is based at our Bengaluru office- A 15 years full-time education is required Qualification 15 years full time education

Project Role : Application Lead Project Role Description : Lead the effort to design, build and configure applications, acting as the primary point of contact. Must have skills : Finastra Fusion Loan IQ Good to have skills : Java, Spring BootMinimum 12 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Lead, you will lead the effort to design, build, and configure applications, acting as the primary point of contact. Your day will involve overseeing the application development process and ensuring seamless communication within the team and stakeholders. 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- Expected to provide solutions to problems that apply across multiple teams- Lead the application development process effectively- Ensure seamless communication within the team and stakeholders- Provide guidance and mentorship to team members Professional & Technical Skills: - Must have Skills :Finastra Fusion Loan IQ - Good to Have Skills :Spring Application Framework, Microservices and Light Weight Architecture - Integrate Loan IQ with Market data applications and clients proprietary software applications using Spring related frameworks - Perform Analysis, design, code, unit test and deployment in Loan IQ SDK, and ensure that interfaces are working fine - Develop and maintain batch report files from Loan IQ for Loan Operations, Treasury etc, - Assess the impact of changes on existing business and technology processes, as well as other interfacing systems Technical Experience :- 8+ years of sound experience in Loan IQ SDK, Loan IQ functionality, Java, Spring related frameworks Good to know Spring Boot and Microservices - Expertise in designing and developing the interface programs for different integrating applications Batch, Web Services, JMS etc, - Must have good Knowledge on Loan IQ Data Model - Good to have Interface Mapping documentation designing experience - At least, 1 RDBMS experience is required Oracle/MS-SQL/IBM DB2 - Good communication skills - Good analytical skills Additional Information:- The candidate should have a minimum of 12 years of experience in Finastra Fusion Loan IQ- This position is based at our Bengaluru office- A 15 years full-time education is required Qualification 15 years full time education

Project Role : Application Lead Project Role Description : Lead the effort to design, build and configure applications, acting as the primary point of contact. Must have skills : Finastra Fusion Loan IQ Good to have skills : NAMinimum 7.5 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Lead, you will lead the effort to design, build, and configure applications, acting as the primary point of contact. Your day will involve overseeing the application development process and ensuring seamless communication within the team and stakeholders. 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 the application development process effectively- Ensure seamless communication within the team and stakeholders Professional & Technical Skills: - Must have Skills :Finastra Fusion Loan IQ - Good to Have Skills :Spring Application Framework, Microservices and Light Weight Architecture - Integrate Loan IQ with Market data applications and clients proprietary software applications using Spring related frameworks - Perform Analysis, design, code, unit test and deployment in Loan IQ SDK, and ensure that interfaces are working fine - Develop and maintain batch report files from Loan IQ for Loan Operations, Treasury etc, - Assess the impact of changes on existing business and technology processes, as well as other interfacing systems Technical Experience :- 5+ years of sound experience in Loan IQ SDK, Loan IQ functionality, Java, Spring related frameworks Good to know Spring Boot and Microservices - Expertise in designing and developing the interface programs for different integrating applications Batch, Web Services, JMS etc, - Must have good Knowledge on Loan IQ Data Model - Good to have Interface Mapping documentation designing experience - At least, 1 RDBMS experience is required Oracle/MS-SQL/IBM DB2 - Good communication skills - Good analytical skills Additional Information:- The candidate should have a minimum of 7.5 years of experience in Finastra Fusion Loan IQ- This position is based at our Bengaluru office- A 15 years full-time education is required Qualification 15 years full time education

Project Role : Application Lead Project Role Description : Lead the effort to design, build and configure applications, acting as the primary point of contact. Must have skills : IBM DB2 Database Administration Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time educationJob Title:DB2 Database AdministratorJob Type:[Full-time]Position Overview:The DB2 Database Administrator will be responsible for the installation, configuration, maintenance, and performance tuning of DB2 databases. The ideal candidate will have a strong background in database administration and a deep understanding of DB2 technologies. This role involves ensuring the reliability, availability, and security of our database systems to support business operations. Working experience on SAP systemsKey Responsibilities:Database Installation and Configuration:oInstall and configure DB2 database servers and clients.oImplement database instances, databases, and table spaces.Database Maintenance:oPerform routine maintenance tasks, including database backups, recovery, and data integrity checks.oApply patches, updates, and upgrades to DB2 software.Performance Tuning:oMonitor and optimize database performance, including query optimization, indexing, and resource allocation.oAnalyze and resolve performance issues to ensure efficient operation.Security Management:oImplement and manage database security measures, including user access controls and data encryption.oEnsure compliance with organizational and regulatory security requirements.Troubleshooting and Support:oProvide technical support and troubleshooting for database-related issues.oCollaborate with other IT teams and stakeholders to resolve complex problems.Backup and Recovery:oDevelop and execute backup and recovery strategies to protect data.oTest and validate backup procedures to ensure data recoverability.Documentation and Reporting:oMaintain accurate and up-to-date documentation for database configurations, procedures, and policies.oGenerate and analyze reports on database performance, usage, and security.Capacity Planning:oMonitor database growth and usage trends.oPlan for future database capacity requirements and scalability.Compliance and Best Practices:oEnsure databases adhere to industry best practices and organizational standards.oStay current with emerging DB2 technologies and industry trends.Migration and UpgradesoDatabase upgrades (Version Upgrades)oDatabase Migration Qualifications:Education:oBachelors degree in Computer Science, Information Technology, or a related field. Equivalent work experience may be considered.Experience:oMinimum 6+ years of experience as a DB2 Database Administrator or similar role.oHands-on experience with DB2 for [z/OS/Linux/Unix/Windows], including version [specific versions if applicable]. Skills: oProficiency in DB2 installation, configuration, and administration.oStrong understanding of database performance tuning and optimization.oExperience with SQL and database query optimization.oKnowledge of backup and recovery techniques.oUpgrade and migration knowledgeoFamiliarity with scripting languages (e.g., Shell, Python) for automation.oExcellent problem-solving and analytical skills.oStrong communication and interpersonal skills.Certifications:oRelevant DB2 certifications (e.g., IBM Certified Database Administrator DB2) are a plus.Preferred Qualifications:Experience with other database management systems (e.g., Informix, Oracle, SQL Server).Knowledge of cloud-based database solutions.Familiarity with DevOps practices SAP systems and tools.Good to have knowledge on Informix Qualification 15 years full time education

Shift timings: 3:00 pm to 12:00 am Work mode: Hybrid Location: Pune Job Summary: This individual contributor is responsible for the design, configuration, build, implementation, maintenance, and performance of critical database systems, to ensure the availability and consistent performance of our corporate applications. This role will specialize in DB2 UDB as its primary platform of accountability. In additional, they are responsible for ensuring adherence to IT policies and standards including security practices. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills. This position requires the individual to be able to handle large databases with high degree of complexity and non-uniformity at an enterprise corporate level. Essential Responsibilities: List primary and specific job duties performed daily in order of importance. Performs physical database management system design and build to support application development teams with application database needs in their development lifecycle. This person will translate logical data model designs into physical designs and assist with deployment and security configuration. This individual will be the primary development database point of contact. They will serve as a liaison to database administration production support teams and serve as an escalation point for incident management for databases assigned. Completes work assignments and supports business-specific projects by applying expertise in subject area; supporting the development of work plans to meet business priorities and deadlines; ensuring team follows all procedures and policies; coordinating and assigning resources to accomplish priorities and deadlines; collaborating cross-functionally to make effective business decisions; solving complex problems; escalating high priority issues or risks, as appropriate; and recognizing and capitalizing on improvement opportunities. Practices self-development and promotes learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others and managers; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback. As part of the IT Engineering job family, this position is responsible for leveraging DEVOPS, and both Waterfall and Agile practices, to design, develop, and deliver resilient, secure, multi-channel, high-volume, high-transaction, on/off-premise, cloud-based solutions. Supports the review of team deliverables. Provides some recommendations and input on options, risks, costs, and benefits for systems designs. Collaborates with team members to develop project support plans, schedules, and assignments. Translates business and functional requirements into technical specifications that support integrated and sustainable designs for designated infrastructure systems by partnering with Business Analysts to understand business needs and functional specifications. Serves as a liaison with business partners, Solutions, and enterprise architects to define and understand target strategies. Collaborates with counterparts in various IT Teams (e.g., database, operations, technical support) throughout system development and implementation. Develops and modifies solutions by identifying technical solutions to business problems Provides consultation and technical advice on IT infrastructure planning, engineering, and architecture for assigned systems by assessing the implications of IT strategies on infrastructure capabilities. Reviews and makes changes to technical specifications and documentation. Collaborates with IT teams and key business partners to troubleshoot complex systems and provides solutions, as appropriate. Evaluates existing systems to make recommendations on resources required to maintain service levels. Evaluates new service options, identifies issues and impacts, and provides recommendations on feasibility and ROI. Collaborates with architects and software engineers to ensure functional specifications are converted into flexible, scalable, and maintainable designs. Verifies system designs adhere to company architecture standards. Drives physical database architecture design for new initiatives. Leads the implementation of assigned enterprise infrastructure systems to ensure successful deployment and operation by developing and documenting detailed standards (e.g., guidelines, processes, procedures) for the introduction and maintenance of services. Job Qualifications: Bachelor's degree in Computer Science, CIS, or related field OR Minimum Six (6) years experience in an IT operations environment with technical experience in distributed technologies, systems development, and/or networking. Six (6) years of overall IT experience in managing various database technologies. Four (4) years of experience with DB2 UDB database, DB2 UDB High Availability and Disaster Recovery (HA/DR) solutions such as Clustering, Log shipping and Replication, etc. Two (2) years experience with database performance tuning and troubleshooting Three (3) years experience using SQL or similar query language. Two (2) years experience with Database configurations for high performance (database and query tuning) Two (2) years experience with database monitoring solutions like Foglight or other monitoring tools Two (2) years experience in supporting complex Development/projects Two (2) years experience in storage engineering and/or data backup engineering, including experience with data replication. Three (3) years experience in database administration. Preferred Qualifications Two (2) years experience working with an IT Infrastructure Library (ITIL) framework Two (2) years experience with other database technology such as DB2 LUW, Sybase, Teradata, Datacom, Oracle, Postgres Two (2) years experience using PostgreSQL (versions 9.x through current), High Availability, Clustering and Replication features - Streaming Replication, Patroni, pgBouncer, pgPool Two (2) years experience working with cloud environments (AWS, Azure, Google Cloud) and database services. Two (2) years scripting experience using UNIX/Linux scripting languages. Two (2) years scripting experience using PowerShell scripting languages. Two (2) years experience writing technical documentation in an infrastructure development environment. Two (2) years coding experience with one or more programming languages. Two (2) years of work experience in a role requiring interaction with senior leadership (e.g., Director level and above) Three (3) years experience with Database Design, Engineering, Implementation and Operations Three (3) years experience with job design, Controlling and scheduling & Automation Two (2) years experience IT Service Management Process (Incidents, Change Management etc.) Two (2) years experience with Microsoft Office tools Two (2) years experience working with operating system and client/server utilities. Two (2) years experience working with configuration management software. Two (2) years experience in the design and implementation of complex middleware infrastructure solutions. Two (2) years experience working with load balancing technologies. Two (2) years of experience building technology solutions to meet corporate or industry IT Policies and regulatory requirements. Two (2) years experience in the design and implementation of complex data infrastructure solutions. Two (2) years experience working on cross-functional project teams Three (3) years experience working in a large matrixed organization.

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Broadcom CA Gen, Policy Good to have skills : IBM CICS (Customer Information Control System) Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Roles & Responsibilities: Collaborate with cross-functional teams to analyze business requirements and develop solutions to meet those requirements using COBOL. Design, build, and configure applications to meet business process and application requirements. Develop and maintain technical documentation related to application development. Participate in code reviews and ensure that all solutions are aligned with industry best practices and standards. Provide technical support and troubleshooting for applications developed using COBOL. Professional & Technical Skills: Must To Have Skills in either:Proficiency in mainframe CA Gen,IBM CICS,IBM DB2 for z/OS,IBM Enterprise Good To Have Skills:Experience with other programming languages such as IMS, PL/I COBOL Strong understanding of software development life cycle (SDLC) and software engineering principles. Experience with relational databases such as DB2 and SQL Additional Information: The candidate should have a minimum of 3 years of experience in mainframe CAGen The ideal candidate will possess a strong educational background in computer science or a related field, along with a proven track record of delivering impactful solutions.This position is based at our Pune office. 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 : IBM Db2 Good to have skills : NA Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will be responsible for designing, building, and configuring applications to meet business process and application requirements. You will work on developing solutions to enhance business operations and streamline processes. 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. Collaborate with cross-functional teams to analyze business requirements and translate them into technical solutions. Develop and implement software solutions to meet business needs. Conduct code reviews and ensure code quality. Provide technical guidance and support to team members. Stay updated on industry trends and best practices to enhance technical skills. Professional & Technical Skills: Must To Have Skills:Proficiency in IBM Db2. Strong understanding of database management systems. Experience in SQL programming and database design. Knowledge of data modeling and optimization techniques. Hands-on experience in troubleshooting and performance tuning of databases. Additional Information: The candidate should have a minimum of 3 years of experience in IBM Db2. This position is based at our Pune office. A 15 years full time education is required. Qualifications 15 years full time education

All applicants have to mandatorily apply on BNP Career Site- https://bwelcome.hr.bnpparibas/su/5885fffe248c5637 Job ID - 12358121 Applicants can directly search the JOB ID - 12358121 on https://bwelcome.hr.bnpparibas/su/5885fffe248c5637 and Apply on the same. Position Purpose Realize second level support activities: Analyze application problems in production, debug processes, correct defects and anomalies, improve processes resilience, applies lean methodology to make continuous improvement of the Run activities, update documentation (PDD, Design document) Effective management of maintenance tickets within SLA defined Apply classification of maintenance tickets to address actions for the continuous improvement of the automated processes (LEAN methodology) Analyze business needs to evolve existing applications and processes Designs and develops new applications or parts of them when required, collaborates in the analysis of new technological solutions Support the production of reports of Run activities Support the continuous dialogue and exchange of information with the other IT maintenance teams to improve the maintenance activities Responsibilities Direct Responsibilities Problem solving on run activities, manage maintenance tickets respecting business SLA, support reporting on run activities to the management classifying tickets to address improvement actions (Lean methodology) taking in charge of new/modified application and check the quality of code and documentation, debug the code with problems and develop corrections, analysis, design and development of evolutions of application, test the software created or modified, Interact with other IT maintenance teams to speed up the solution of problems Contributing Responsibilities Support BNL teams in analyzing and resolving application problems. Collaborate on the design and development of new applications or parts of them. Actively participate in the ceremonies of analysis and sharing of the Tribe's activities. Technical & Behavioral Competencies Fundamental skill: Deep knowledge of the technology: MS Power BI, : IBM DataStage Deep knowledge of relational databases MS SQL Server technology Important skill - knowledge of at least one of these technologies: Oracle DB, IBM DB2 Have basic knowledge of: some of these technologies: Jenkins, Maven, Nexus, SonarQube abstract classes, interfaces, mastery of the object paradigm CRM, web architectures, application client/server, API services knowledge of how systems are monitored and maintained General knowledge of: cloud architectures, microservices and containers testing Nice to have: knowledge of Requirements Collection, Analysis, Design, Development and Test activity knowledge of the reference architectures and main integration issues continuous improvement approaches (Lean methodology) Specific Qualifications (if required) Has at least five years of analysis and development experience, with five years of experience in developments with Power BI - Has experience in functional analysis and design of IT solutions - Excellent knowledge of the Office package - Problem Solving techniques - Knows the SQL language for querying databases - Has knowledge of open technologies/architectures and Microsoft products

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