110 Sql Tuning Jobs - Page 4

Position: Database Administrator II Job Description: Database Administrator II Database Administrator are on the frontline of EBS application support. They are focused on helping to resolve technical issues end users encounter. And responsible for upgrades, migrations and other project related activities. What You ll Be Doing: Will be part of the DBA organization Will work with the Application Development teams to review code and recommend tuning for bad code Will be responsible to coordinate performance related issues and provide a fix or redirect to the appropriate teams Will be responsible to provide tuning recommendations for new projects undertaken by the Application Development team and DBA team What We Are Looking For: Oracle DBA with at least 6-8 years experience At least 2 years experience in tuning code using tools like SQL Profiler, SQLT Explain or any custom performance tools Working knowledge of tools like AWR, ASH SQL Tuning Advisor Good knowledge of Oracle Performance tuning hints Should be able to look at bad SQL code and recommend tuning opportunities Knowledge in Oracle eBusiness Suite is a plus About Arrow Arrow Electronics, Inc. (NYSE: ARW), an award-winning Fortune 110 and one of Fortune Magazine s Most Admired Companies. Arrow guides innovation forward for over 175,000 leading technology manufacturers and service providers. With 2019 sales of USD $29 billion, Arrow develops technology solutions that improve business and daily life. Our broad portfolio that spans the entire technology landscape helps customers create, make and manage forward-thinking products that make the benefits of technology accessible to as many people as possible. Learn more at www.arrow.com. Our strategic direction of guiding innovation forward is expressed as Five Years Out, a way of thinking about the tangible future to bridge the gap between whats possible and the practical technologies to make it happen. Learn more at https://www.fiveyearsout.com/. For more job opportunities, please visit https: / / careers.arrow.com / us / en. Location: IN-KA-Bangalore, India (SKAV Seethalakshmi) GESC Time Type: Full time Job Category: Information Technology

Are you an experienced Oracle DBA looking for a challenging role? We're seeking a highly skilled and proactive Senior Database Engineer to join our team and provide critical Oracle database support. In this role, you'll be responsible for ensuring the health, performance, and stability of our Oracle database environments, including RAC, ASM, Clusterware, and Multitenant architectures and OEM Administration. If you're passionate about database optimization, proactive monitoring, and thrive in a dynamic environment, we encourage you to apply! Primary Responsibilities The Offshore Senior Database Engineer has the primary focus on: Monitoring Database health / performance (RAC, Non-RAC and Data Guard Instance). Review Quarterly Database Patching requirement/steps and execute the patch process. Review Quarterly OEM Patching requirement/steps and execute the patch process. Monitor and take appropriate action proactively on night jobs, i.e., RMAN backups and Data Purging, etc. The overall technical support of the Oracle database, shutdown/startup database, issue troubleshooting, incident, alert and responding to requests from DevOps and other IT teams. Performs Database/Query monitoring, ongoing performance tuning and optimization activities Position Requirements Must have 7+ years of experience focused on Oracle DBA Administration in medium to large corporate environments, 3+ years of Oracle 19c administration (multitenant PDB/CDB, Oracle ASM, Oracle Cluster ware, Data Guard, Oracle Single Instance and Patching process). Installation and configuration for OEM13c for database monitoring and management. At least 5 years experience performance tuning both instance and SQL statement level tuning, good understanding of SQL Profile and query optimization. Ability to identify the culprit with tool (i.e., OEM) and without tool (query from Oracle dictionary). At least 5 years experience with backup and recovery procedures using RMAN. System knowledge and experience with Unix/Linux Operating Systems. Working knowledge of scripting programing (Shell, Python), GitHub, and Automation tools (AWX or Ansible) is a plus but not required. Knowledge, Skills & Abilities Must be a creative problem-solver, flexible, and proactive. Very good people skills, plus written and oral communication skills. Take responsibility, plan and structure all tasks (technical or non-technical) assigned as part of job role to ensure a business efficient service is delivered to customers. Key Performance Indicators Ability to manage multiple assignments (i.e., database/cluster patching, OEM management and troubleshooting) comfortably. Attentive to operational process (i.e. incident management, pickup/resolve/close timely, using SN monitoring tool to proactively monitor database platform, Change Management, etc.). Attentive to Agile process (i.e. story management, pick up/development/implementation and close timely). Onboarding Time: Immediate to 15 days only

Hiring - Sr. SQL DBA Location- Gurugram- Hybrid Fulltime Education - Bachelor or higher degree. 10+ years experience in working in IT services organization. At least 8+ years of SQL DBA experience covering implementation, production support and project work. At least 5+ years of exposure as L3/Lead/ SME support role. Knowledge and Understanding the ITIL process In client facing role(s) globally for at least 5 years. Excellent communication skills On call support for at least 5 years. Excellent Documentations skills in MS SharePoint 2010 /2013 Mandatory skills - SQL Server & Cloud administration required skills • Senior level Microsoft SQL Server DBA with experience in large and critical environments. Excellent knowledge of performance tuning at both server level and query level. Candidate must have knowledge of perfmon, SQL Server dynamic management views. Knowledge of SQL server internals. • Knowledge of SQL partitioning and compression • Hands-on experience on mirroring, replication and Always ON Must have automation experience. Good knowledge of scripting. Ability to write T-Sql scripts, Power Shell or Python. Excellent knowledge of SSIS packages. Hands-on experience on SQL Server Clustering. Hands-on experience on Integration Services, Reporting services and Analysis services • Must have good knowledge in SQL Server permission/security policies • At least 6 months experience with AWS Cloud RDS Good to have skills MySQL knowledge / experience. • Linux Knowledge Experience with Snow Flake Certifications Desired MS certifications on MSSQL latest versions. AWS Certifications

As an Application Developer, you will lead IBM into the future by translating system requirements into the design and development of customized systems in an agile environment. The success of IBM is in your hands as you transform vital business needs into code and drive innovation. Your work will power IBM and its clients globally, collaborating and integrating code into enterprise systems. You will have access to the latest education, tools and technology, and a limitless career path with the world’s technology leader. Come to IBM and make a global impact! The ability to be a team player The ability and skill to train other people in procedural and technical topics Strong communication and collaboration skills Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Strong knowledge and experience in database design, modelling and development using PL SQL. Minimum of 6 years. Proficiency with Oracle databases and tools, such as SQL Developer and Toad In-depth understanding of SQL tuning and optimization techniques Knowledge of database performance monitoring and troubleshooting Familiarity with ETL processes and data integration techniques and Strong analytical and problem-solving skills Preferred technical and professional experience Ability to work in a fast-paced environment and meet deadlines Knowledge of agile software development practices is a plus Bachelor's degree in computer science or a related field is preferred, but not required

Job Title: Database Engineer Analytics – L Responsibilities As a Database Engineer supporting the bank’s Analytics platforms, you will be a part of a centralized team of database engineers who are responsible for the maintenance and support of Citizens’ most critical databases. A Database Engineer will be responsible for: • Requires conceptual knowledge of database practices and procedures such as DDL, DML and DCL. • Requires how to use basic SQL skills including SELECT, FROM, WHERE and ORDER BY. • Ability to code SQL Joins, subqueries, aggregate functions (AVG, SUM, COUNT), and use data manipulation techniques (UPDATE, DELETE). • Understanding basic data relationships and schemas. • Develop Basic Entity-Relationship diagrams. • Conceptual understanding of cloud computing • Can solves routine problems using existing procedures and standard practices. • Can look up error codes and open tickets with vendors • Ability to execute explains and identify poorly written queries • Review data structures to ensure they adhere to database design best practices. • Develop a comprehensive backup plan. • Understanding the different cloud models (IaaS, PaaS, SaaS), service models, and deployment options (public, private, hybrid). • Solves standard problems by analyzing possible solutions using experience, judgment and precedents. • Troubleshoot database issues, such as integrity issues, blocking/deadlocking issues, log shipping issues, connectivity issues, security issues, memory issues, disk space, etc. • Understanding cloud security concepts, including data protection, access control, and compliance. • Manages risks that are associated with the use of information technology. • Identifies, assesses, and treats risks that might affect the confidentiality, integrity, and availability of the organization's assets. • Ability to design and implement highly performing database using partitioning & indexing that meet or exceed the business requirements. • Documents a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow. • Ability to code complex SQL. • Performs effective backup management and periodic databases restoration testing. • General DB Cloud networking skills – VPCs, SGs, KMS keys, private links. JOB DESCRIPTION • Ability to develop stored procedures and at least one scripting language for reusable code and improved performance. Know how to import and export data into and out of databases using ETL tools, code, migration tools like DMS or scripts • Knowledge of DevOps principles and tools, such as CI/CD. • Attention to detail and demonstrate a customer centric approach. • Solves complex problems by taking a new perspective on existing solutions; exercises judgment based on the analysis of multiple sources of information • Ability to optimize queries for performance and resource efficiency • Review database metrics to identify performance issues. Required Qualifications • 2-10+ years of experience with database management/administration, Redshift, Snowflake or Neo4J • 2-10+ years of experience working with incident, change and problem management processes and procedures. • Experience maintaining and supporting large-scale critical database systems in the cloud. • 2+ years of experience working with AWS cloud hosted databases • An understanding of one programming languages, including at least one front end framework (Angular/React/Vue), such as Python3, Java, JavaScript, Ruby, Golang, C, C++, etc. • Experience with cloud computing, ETL and streaming technologies – OpenShift, DataStage, Kafka • Experience with agile development methodology • Strong SQL performance & tuning skills • Excellent communication and client interfacing skills • Strong team collaboration skills and capacity to prioritize tasks efficiently. Desired Qualifications • Experience working in an agile development environment • Experience working in the banking industry • Experience working in cloud environments such as AWS, Azure or Google • Experience with CI/CD pipeline (Jenkins, Liquibase or equivalent) Education and Certifications • Bachelor’s degree in computer science or related discipline

Req ID: 325416 We are currently seeking a Systems Integration Advisor to join our team in Bengaluru, Karntaka (IN-KA), India (IN). Job Title: Mainframe DB2DBA (Application DBA) and Systems Administration LocationBangalore (or Remote, as applicable) Experience5+ years in mainframe DB2DBA ,Systems administration and Modernization Job Summary: We are seeking a highly skilled Mainframe DBA Specialist to join our team. The ideal candidate will bring over a decade of experience in managing z/OS environments, mainframe modernization, and database administration (DB2). This role will involve managing complex mainframe systems, and driving system performance, scalability, and security. Key Responsibilities: Oversee the administration and modernization of mainframe systems, including z/OS, DB2, and related tools. Design, configure, and maintain mainframe environments to ensure high availability and optimal performance. Automate routine tasks and streamline processes using REXX, JCL, and other scripting tools. Manage RACF security, conduct audits, and ensure compliance with corporate standards and regulatory requirements. Optimize database performance, including SQL tuning, data recovery, and disaster recovery planning. Collaborate with cross-functional teams to resolve system performance issues, manage incidents, and implement enhancements. Implement and maintain mainframe modernization projects, including migrations and integrations with modern tools.

JOB DESCRIPTION Job Purpose As an individual contributor role, you will be working as a part of data team, responsible of understanding the business requirements, feasibility of data, taking ownership of the tasks and using best practices. He/she will be responsible for designing and implementing the Data solution. Organizational Relationships Key Responsibilities Working with the business to understand processes and capture requirements. Write efficient, clear code and able to articulate what has been implemented and why and along with accompanying test suites. Working with dynamic agile environment. Status reporting both to business and technology management. Provide seamless support to all the business functions. Support the data management activity for doing dashboards Application support as part of team. Functional Responsibilities Develop, design, test and implement complex database programs using Oracle and third-party tools. Designing & creation of table structures Ensure that database programs follow V3 standards. Ability to write & de-bug complex SQL queries Performance tuning of SQL's, application programs and instances. Evaluation of new and upcoming technologies. Providing technical assistance, problem resolution and troubleshooting support. Job Requirements Graduate / Post Graduate. Qualification & Experience Functional Competencies 2-5 years of experience in PL SQL Development Experience in PLSQL Development. Strong experience with oracle functions, procedures, triggers, packages & performance tuning. Hands on development using Oracle SQL & PL/SQL. Experience with Oracle Version 10g, 11g, 12c. Performance tuning of SQL's, application programs and instances. Experience in Query optimization, Experience / Knowledge of Reporting tool Deep Understanding of DB & DWH concepts Strategic and analytical thinking, Problem solving and decision-making skills Behavioral Competencies Strong communication & interpersonal skills People Management & Networking skills

. Complete Understanding of Oracle Apps and E-Business Suite Architecture and underlying table structures and their usage to design efficient program units. 2. Must have strong experience in RICE Components. 3. Develop/maintain oracle custom code and interfaces to oracle forms - based applications in accordance with business requirements. 4. Develop PL/SQL packages, procedures, and functions, and trigger from UI events or database triggers, to implement complex business logic. 5. Proficient in Form Personalization. 6. Work with functional consultants to come out with the appropriate technical design for business requirements. 7. Document all technical designs as well as comment or annotate actual development. 8. Be responsible for complete unit testing and integration testing with other custom components and the larger oracle application. 9. Good knowledge of Shell scripting, Java, SQL tuning, Designing of OAF pages is a plus. 10. Experience in R12 and 11i Series with Modules like AP,AR,GL,FA,INV,OM. 11. Solid Business Process / Requirement Analysis and Re- engineering Required. 12. Proficient in Oracle Forms, Oracle Reports (BI / XML / RDF), Oracle Workflow and Oracle RDBMS. 13. Good Understanding of Performance Tuning. 14. Must be Familiar with APPS Data Model and Oracle Coding Standard. 15. Should have a good communication skill. Rice, Ebs - Apps Technical, R12

As an Application Developer, you will lead IBM into the future by translating system requirements into the design and development of customized systems in an agile environment. The success of IBM is in your hands as you transform vital business needs into code and drive innovation. Your work will power IBM and its clients globally, collaborating and integrating code into enterprise systems. You will have access to the latest education, tools and technology, and a limitless career path with the world’s technology leader. Come to IBM and make a global impact! The ability to be a team player The ability and skill to train other people in procedural and technical topics Strong communication and collaboration skills Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Strong knowledge and experience in database design, modelling and development using PL SQL. Minimum of 6 years. Proficiency with Oracle databases and tools, such as SQL Developer and Toad In-depth understanding of SQL tuning and optimization techniques Knowledge of database performance monitoring and troubleshooting Familiarity with ETL processes and data integration techniques and Strong analytical and problem-solving skills Preferred technical and professional experience Ability to work in a fast-paced environment and meet deadlines Knowledge of agile software development practices is a plus Bachelor's degree in computer science or a related field is preferred, but not required

We are seeking a Senior Migration Consultant with strong expertise in Oracle PL/SQL , MariaDB/MySQL , and/or PostgreSQL to support enterprise-grade database migrations to MariaDB . In this role, you will work with a highly skilled team focused on delivering strategic migration solutions and architecting scalable, high-availability database environments using the MariaDB portfolio. Responsibilities Plan and perform database migrations from Oracle, MySQL, SQL Server, and other platforms to MariaDB Analyse source systems and define appropriate strategies for schema, procedure, and data migration Refactor and convert proprietary or custom database logic into MariaDB-compatible equivalents Design and implement scalable and optimised database solutions Develop and maintain migration tools, scripts, and documentation Lead and contribute to technical scoping and assessment of migration projects Qualifications 8+ years of experience in database development and administration ( Oracle , plus at least one of the following: MariaDB, MySQL or PostgreSQL ) Strong command of SQL , PL/SQL , and other procedural languages Hands-on experience in designing and implementing database architectures Proficient in scripting within a linux environment using any of Perl, Bash, Java , Python or similar languages Understanding of ETL workflows , data modelling , and normalisation Proficiency in query optimisation , execution plans , and SQL tuning Strong analytical and problem-solving skills with a learning mindset Excellent verbal and written communication skills; ability to work directly with clients Preferred Experience and Skills Experience with database migration tools or automation frameworks Familiarity with cloud-native databases and deployment models Exposure to DevOps practices and CI/CD for database pipelines

- Level 2 support on Incident and problem management. - PostgreSQL DB/SQL Performance Analysis and Tuning. - Managing PostgreSQL Database Security Audit violations resolving them. - PostgreSQL Database Installation and Configuration, Database Backup and Recovery, SQL Tuning, User maintenance, Tablespace management, Hot Standby and Replication. - PostgreSQL Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards. - Patch management and highlight teams regarding future enhancements releases. Expertise - Minimum 5 years of DBA (IT) experience. Activities in scope - Installation and Configuration, Perform maintenance activity in database. - PostgreSQL Database upgradations and migration. - PostgreSQL Database reconciliation mechanisms. - PostgreSQL Database Migration, Upgrades to be compliant with organization standards. - Monitoring and optimizing the performance of the PostgreSQL database. - Backup and Recovery, Hot Standby and Replication, PITR and Upgradation. - SQL Tuning, User maintenance, Tablespace management. - Understand the RTO/RPO requirements for the application databases to define the database backup and restore policy. - Experience in Installation and creating Hot Streaming Replication (Master and Slave). - Problem solving and good analytical skills. Communication, teamwork, and negotiation skills. Preferred Skills - Cluster configuration, Master-Slave. - Backup configuration using Veeam and/or by Barman. - PgDump/PgDumpall and PgRestore. - DR Replica, by Barman or other. - Physical streaming replication and Logical replication. - Data masking and encryption.

Job Role Name : Senior Oracle Developer Minimum Qualifying Criteria : B Tech or Equivalent Degree from Reputed Institute Total Oracle Forms experience : Should be greater than 4 years Min 2 years Experience as Senior Forms developer Necessary experience in engineering and software Architecture Excellent technical, analytical skills. This Candidate must be a motivated, innovative Oracle Developer who is prepared to make an immediate impact. Requirements from Candidate Provide on-going support and maintenance of in-house applications using Oracle SQL, PL/SQL and Oracle Forms Working Experience with good command on Oracle Forms 12c and PL/SQL is a must Conduct Code design and development for larger projects using Oracle SQL, PL/ SQL and Oracle Forms Develop PL/SQL database objects, SQL scripts, interfaces, reports and forms using standard tools including Oracle Forms, Report Builder, Oracle Application Framework Should be able to design Solutions , clarify and confirm the design and architecture Oracle performance tuning / Optimization Optimizing SQL ,Tuning Oracle Hands on development of quality Responding in a timely manner to any technical or general questions on Oracle Forms Provide L4 Support to the production team Work as a member of a cross-functional project team contributing to technology-based solutions Accurately estimate development timelines Monitor and debug production issues and get resolutions deployed Engage with the Business Analysts and System Analysts, to understand, clarify and confirm requirements and low level technical design Support functions include problem investigation, development, testing and deployment to Live

The Customer Success Services (CSS) is a unit within the Oracle s Customer Service Organization that establishes long-term relationships with many of Oracles customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and TM basis. CSS services are typically requested by large Oracle customers that require the utmost attention to real mission critical applications and processes. CSS covers the majority of large-scale Oracle customers. Oracle Customer Success Services provides unmatched, tailored support that ensures organization s Oracle technology investments deliver the cutting-edge innovation and performance your business requires to compete, all while coexisting within your IT environment. CSS is industry-leading expertise with the highest customer satisfaction to support organization s business every step of the way. At least 7 plus years of experience with Oracle Database Administrator / Consultant / Support Engineer Available to work in 24X7 capability . Install, configure, and Administer Oracle Database/RAC 11g,12c,19c. Expert knowledge of Oracle Database Architecture, RAC, and Performance Tuning . Good Database troubleshooting performance tuning skills . Worked on Database upgrades and patching . Knowledge on Performance Tuning of Oracle Instance and SQL Tuning . Good communication and customer management skills. BE/BTech and/or MS in Computer Science or equivalent preferred Oracle Database / Exadata / OCI Certification - Preferred Candidates having optional skills of PL SQL and SQL, Exadata, Goldengate is a Plus! Experience in Oracle Enterprise Manager (OEM) 11g/12c/13c is a plus. Sharp technical troubleshooting skills. Good understanding of support processes. Ability to manage escalated technical situations develop action plans. Ability to spot proactive services that benefit of customer. Ability to facilitate issues with Development and Support. Strong analytical skills. Some travel may be required. Detailed Description and Job Requirements As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues. As an Advanced Support Engineer, you will interface with the customer s IT staff on a regular basis. Either at the client s site or from a remote location, you will be responsible for resolution of moderately complex technical problems related to the installation, recommended maintenance, and use and repair/workarounds for Oracle products. You should be highly experienced in some Oracle products and several platforms that are being supported. You will be expected to work with only general guidance from management while advising management on progress/status. Job duties are varied and complex utilizing independent judgment. May have project lead role. Because of substantial customer interfacing, a demonstrated ability to work with customers on an independent basis with exceptional communication skills, while consistently achieving the highest levels of customer satisfaction is essential. The Customer Success Services (CSS) is a unit within the Oracle s Customer Service Organization that establishes long-term relationships with many of Oracles customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and TM basis. CSS services are typically requested by large Oracle customers that require the utmost attention to real mission critical applications and processes. CSS covers the majority of large-scale Oracle customers. Oracle Customer Success Services provides unmatched, tailored support that ensures organization s Oracle technology investments deliver the cutting-edge innovation and performance your business requires to compete, all while coexisting within your IT environment. CSS is industry-leading expertise with the highest customer satisfaction to support organization s business every step of the way. At least 7 plus years of experience with Oracle Database Administrator / Consultant / Support Engineer Available to work in 24X7 capability . Install, configure, and Administer Oracle Database/RAC 11g,12c,19c. Expert knowledge of Oracle Database Architecture, RAC, and Performance Tuning . Good Database troubleshooting performance tuning skills . Worked on Database upgrades and patching . Knowledge on Performance Tuning of Oracle Instance and SQL Tuning . Good communication and customer management skills. BE/BTech and/or MS in Computer Science or equivalent preferred Oracle Database / Exadata / OCI Certification - Preferred Candidates having optional skills of PL SQL and SQL, Exadata, Goldengate is a Plus! Experience in Oracle Enterprise Manager (OEM) 11g/12c/13c is a plus. Sharp technical troubleshooting skills. Good understanding of support processes. Ability to manage escalated technical situations develop action plans. Ability to spot proactive services that benefit of customer. Ability to facilitate issues with Development and Support. Strong analytical skills. Some travel may be required. Detailed Description and Job Requirements As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues. As an Advanced Support Engineer, you will interface with the customer s IT staff on a regular basis. Either at the client s site or from a remote location, you will be responsible for resolution of moderately complex technical problems related to the installation, recommended maintenance, and use and repair/workarounds for Oracle products. You should be highly experienced in some Oracle products and several platforms that are being supported. You will be expected to work with only general guidance from management while advising management on progress/status. Job duties are varied and complex utilizing independent judgment. May have project lead role. Because of substantial customer interfacing, a demonstrated ability to work with customers on an independent basis with exceptional communication skills, while consistently achieving the highest levels of customer satisfaction is essential.

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : SAP ABAP Development for HANA Good to have skills : SAP ABAP Object Oriented Development, SAP ABAP Proxy Framework, SAP Ariba Cloud Integration Gateway (CIG)Minimum 3 year(s) of experience is required Educational Qualification : 15 years full time educationWe are seeking an experienced SAP S/4HANA Developer specializing in interfaces and integrations to design, develop, and maintain SAP integration solutions. The ideal candidate will have expertise in ABAP, OData, IDocs, RFC, Web Services to enable seamless data exchange between SAP S/4HANA and external systems. This role requires collaboration with functional consultants, middleware teams, and third-party vendors to ensure smooth integration and data consistency.Key Responsibilities:Develop and maintain IDoc-based interfaces (Inbound & Outbound) for seamless integration with third-party systems.Design and implement RFCs (Remote Function Calls) and BAPIs for interfacing with external applications.Create and manage file-based integrations (FTP, SFTP) for batch processing.Develop OData & REST APIs to expose SAP S/4HANA data to Fiori/UI5 applications and external systems.Implement SOAP & REST Web Services for real-time communication between SAP and non-SAP systems.Work with SAP BTP Integration Suite (CPI) for middleware-based integration.Develop batch input (BDC), LSMW, and ABAP programs for data migration.Implement mass data processing using ABAP RAP (Restful Application Programming Model) and parallel processing techniques.Analyze and optimize interface performance using SAP debugging tools and SQL tuning.Monitor and troubleshoot failed IDocs, API calls, and integration logs.Implement error handling, logging, and reprocessing mechanisms for stable interfaces. Qualification 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 : SAP ABAP Development for HANA Good to have skills : SAP ABAP Object Oriented Development, SAP BTP Application DevelopmentMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time educationWe are seeking an experienced SAP S/4HANA Developer specializing in interfaces and integrations to design, develop, and maintain SAP integration solutions. The ideal candidate will have expertise in ABAP, OData, IDocs, RFC, Web Services to enable seamless data exchange between SAP S/4HANA and external systems. This role requires collaboration with functional consultants, middleware teams, and third-party vendors to ensure smooth integration and data consistency.Key Responsibilities:Develop and maintain IDoc-based interfaces (Inbound & Outbound) for seamless integration with third-party systems.Design and implement RFCs (Remote Function Calls) and BAPIs for interfacing with external applications.Create and manage file-based integrations (FTP, SFTP) for batch processing.Develop OData & REST APIs to expose SAP S/4HANA data to Fiori/UI5 applications and external systems.Implement SOAP & REST Web Services for real-time communication between SAP and non-SAP systems.Work with SAP BTP Integration Suite (CPI) for middleware-based integration.Develop batch input (BDC), LSMW, and ABAP programs for data migration.Implement mass data processing using ABAP RAP (Restful Application Programming Model) and parallel processing techniques.Analyze and optimize interface performance using SAP debugging tools and SQL tuning.Monitor and troubleshoot failed IDocs, API calls, and integration logs.Implement error handling, logging, and reprocessing mechanisms for stable interfaces. Qualification 15 years full time education

Project description The Engineer role provides the technical expertise and dedicated technical focus required to deliver on customer's next generation technology capabilities including data analytics, platform development, specialised application development, systems and processes. This role will operate predominantly in an Agile environment and such will be required to support the technology capabilities to effectively deliver value to customers. Responsibilities Complete the design, development and testing of components that deliver on technology capability with the goal of providing reliable, stable and operationally sound applications, systems and infrastructure that meet business requirements and industry best practices Design, configure and validate new and enhanced Systems needed to improve the flow solutions through our life cycles Specify interfaces and translate logical designs into physical designs taking account target environment, performance & security requirements and existing systems Quick POC development for technical solution feasibility using prototyping tools where necessary Employ a variety of emerging languages and tools to marry systems together. Ensure that applications are developed with consistent maintainable code which supports risk and compliance management Contribute to the continuous improvement of applications throughout lifecycle and provide technical input to the planning of future application and maintenance requirements Develop operational and system documentation to enable effective maintenance and support of applications Employ CI/CD and DevOps practices that are endorsed by Group Technology and ensure maximum leverage of existing platform services. Analyse business requirements and articulate complex technical requirements through collaboration with business users, technology groups and suppliers to ensure business requirements are understood by the technology group. Recommend and justify the functional design to address the business needs to ensure the business understands the proposed design Coordinate and participate in the analysis of Information Technology solutions to ensure effective solutions are delivered to the business. Skills Must have Avaloq Certified Professional (ACP) with 1-4 years' experience in customisation and implementation of Avaloq Banking System. 3+ years of work experience with banking or financial applications. Good understanding of banking operations, trade lifecycle and investment/ superannuation products. Good understanding of relational databases (preferably Oracle and PL/SQL) Subject matter expert of at least one Avaloq module (Functional and Technical) Strong skills with Avaloq development tools ICE and SQL Developer as well as Avaloq change life cycle. Prior Experience working with Avaloq Database Automation and Integration (ADAI) will be advantageous. Strong parameterisation skills in core Avaloq conceptsAvaloq scripts, Cost & Fees, Order Validations & workflow management, Book and Balance engines, Avaloq messaging interface (AMI), Task and Reporting framework. Understanding of Avaloq concepts such as EOD, Pillars and Rule loading. Experience with Avaloq smart client and functional understanding of various modules (Forms, Task and reporting desk, Central Services, Portfolio desk etc.) Ability to write scalable code adhering to Avaloq best practices. Understanding of SQL tuning and performance tuning of Avaloq codes through SQL Trace and PL/SQL Hierarchical Profile (HPROF) Understanding of Avaloq release management processes such as creating streams/releases and creating Avaloq packages for installation. Hands on experience in Avaloq release management processes and Unix scripting will be advantageous for an Avaloq release management role. Strong problem solving and troubleshooting skills of Avaloq banking system. Ability analyse Avaloq installation logs and underlying Oracle schema of ABS. Experience in raising / managing Avaloq kernel issues through Avaloq issue management tool. Nice to have - Other Languages EnglishC1 Advanced Seniority Regular

Proficiency in (COBOL-85/ II or later versions,JCL).Experience in (IBM z/OS, OS/390, or similar). Or Hands on in Unix shell scripting and has the capability to develop shell scripts, perform test run and validate results and deploy to production.

Has 4+ years of experience in database development and support in MS SQL Server environments. hands on experience of Transact SQL utilizing SQL Server 2016,2017. hands on experience in SQL writing hands on experience in Procedure, function, triggers knowledge in SQL tuning and performance tuning, best practices in tuning Strong analytical and problem solving skills Ability to work effectively independently and/or as part of a team. Experience in Agile Scrum Knowledge on Deployments Qualifications: A graduate

Some careers shine brighter than others. If you re looking for a career that will help you stand out, join HSBC and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new direction, HSBC offers opportunities, support and rewards that will take you further. HSBC is one of the largest banking and financial services organisations in the world, with operations in 64 countries and territories. We aim to be where the growth is, enabling businesses to thrive and economies to prosper, and, ultimately, helping people to fulfil their hopes and realise their ambitions. We are currently seeking an experienced professional to join our team in the role of Consultant Specialist. In this role, you will: Work directly with DCM/ Technical Lead in China/Pune, London Canada to implement functional and data requirements. Implement solution to meet user requirements within the parameters of the application. Test Driven Development / Behaviour Driven Development Document functionality for further use in global IT systems. Provide knowledge transfer and guidance for the development team. Provide 3rd line support when necessary. Occasional weekend support for Releases. Requirements To be successful in this role, you should meet the following requirements: Working experience of all layers/tiers of the project from Front End development through Back End database design i. e. , full stack developer. Experience in all phases in the Development Life Cycle Very good understanding of architecture and design patterns used for Web Application Framework Experience with formal release procedures and source control Excellent communication and interpersonal skills (written and spoken) comfortable with detail. Experience of working within multi-site teams Cultivates a collaborative and cooperative attitude across different work cultures. Ability to work under pressure and manage own time. Ability to work on own or as part of a team. Ownership of tasks assigned to ultimate resolution. Working knowledge of Source code repository tool GitHub Very strong working experience and expertise of Java, Microservices React Very strong expertise on Java based framework like Vert. x, Spring, Hibernate etc. Have working experience of micro services supported framework like Spring Boot. Excellent Understanding of Single Page architecture application and its optimal implementation Experience of writing complex SQL queries with knowledge do SQL tuning. Good understanding of Behaviour Driven Development and Test-Driven Development approach Have fair understanding of Architecture and Design requirements for building micro-service based applications. You ll achieve more when you join HSBC. .

Consultant - Systems Responsible for ensuring all database system operational processes are managed according to established service level agreements. Specifically; DB2 UDB V 9 , 10, 11 Installations, Configurations and Administration . Should have strong experience on High availability (HA) and disaster recovery (DR) experience with DB2 HADR with TSA (tivoli system automation ) Should have strong experience in Database restores including Redirected restores and backup concepts Good understanding in performance monitoring techniques and conduct performance checks to ensure the databases, and their associated applications, are continuing to support the existing Service Levels Hands on experience in Table range partition , Multi dimension clustering , Materialized query tables data movement utilities like IMPORT, LOAD, and EXPORT under high volume conditions. SQL Tuning using db2advisor and db2explain tools. Troubleshooting database issues using db2diag, db2pd, db2dart, db2support, db2top. Database performance tuning by configuring database and instance Parameters. Should have good knowledge on DB2 V10 and DB2 V11 new features Administration of database objects such as indexes, tables, views, constraints, stored procedures Administration of database users Capacity Management and storage management Design, test, and optimize/tune RDBMS components Contribute to design, maintenance, and documentation of integrated database security and components in relation to SOX and SAS70 compliance Review and assess new features or upgrades to existing RDBMS components as well as application database changes For databases that may be supported in the future, reviews product literature to assess RDBMS differences and unique features. When possible, test new technologies and report results Good knowledge of ITIL processes with special attention to incident, change, problem management, Database growth & capacity management for shared environment Troubleshooting hardware using tools like Netbackup, Avamar, Arago, Ansible

- Database migration experience - Oracle to PostgreSQL, MongoDB, Cosmos DB - Migrate workloads from AWS to Azure - Automate schema/data migration - Tune performance and support cloud-native Database solutions Required Candidate profile - Database admin and migration with hands-on experience in Oracle to PostgreSQL, MongoDB, Cosmos DB, Azure, and AWS. - Strong skills in schema conversion, automation, and cloud-native databases.

Primary Skills Expertise in tools SAP Data services, ETL and Data warehouse concepts. SQL writing, Advance SQL tuning preferably Oracle Knowledge in SAP BO, Informatica are added advantages Batch and real-time data processing of large-scale data sets Optimal use case data structure design, build & performance tuning Ingestion, transformation and cleansing of structured & unstructured data across a heterogeneous landscape Secondary Skills Excellent problem solving and analytical skills Experience of working in traditional waterfall and agile methodologies, working both independently and in project/product teams under pressure and to deadlines Excellent Stakeholder Management skills (supporting use cases and data consumers)

What We Offer: So what does an Associate Database Administrator do? Think of yourself as someone who will be performing administrative tasks and day to day Database Management duties for our Core Apps tools and solutions. Responsibilities Oversee administration and maintenance of different database engines, both On-Prem and in AWS. This also includes Data Warehouses in the Cloud (Redshift experience is a plus). Perform health checks and performance tuning to ensure databases are available and healthy. Place and Test disaster recovery plans for all databases. Ensure protocols for DB security and data privacy are in place. Maintain compliance of all databases to various InfoSec and Audit bodies Automate tasks as deemed necessary. Handle Database service request tickets in a timely manner Audit accounts on periodic review Collaborate with Various IT groups for support needed on Infrastructure requests and dependencies Qualifications Bachelors Degree or equivalent experience in Computer Science, Technology, or a related field of study. Advanced Experience (minimum of 2 years) in handling DBA tasks for MySQL and SQL Servers including installation, upgrades, patching, and deployments. Experience in administration of Data Warehouses (Redshift is a plus). Experience in handling Amazon Aurora (fully managed relational database engine compatible with MySQL and PostgreSQL). Proficient with high availability tools like AWS DMS, Always On, FCI, Replication, etc. Experience in Database monitoring tools such as SQL Server Profiler Proficient in SQL (Structured Query Language) for managing relational databases, primarily T-SQL extension. Hands on experience implementing Disaster Recovery for different platforms. Experience or knowledge of handling PCI-DSS, Data Privacy, and DB audits DB hardening based on CIS Knowledge of DB performance tuning and SQL tuning Work Location / Work Schedule / Travel: Hybrid Rotational Shifts Five Working Days How We Partner To Protect You: TaskUs will neither solicit money from you during your application process nor require any form of payment in order to proceed with your application. Kindly ensure that you are always in communication with only authorized recruiters of TaskUs. DEI: In TaskUs we believe that innovation and higher performance are brought by people from all walks of life. We welcome applicants of different backgrounds, demographics, and circumstances. Inclusive and equitable practices are our responsibility as a business. TaskUs is committed to providing equal access to opportunities. If you need reasonable accommodations in any part of the hiring process, please let us know. We invite you to explore all TaskUs career opportunities and apply through the provided URL https://www.taskus.com/careers/ .

Work Requirements Minimum Bachelors Degree required with 6-8 years experience in Oracle EBS R12 1. 6+ years of experience with Oracle applications e-business suite (11i or R12) as a Techno Functional Consultant. 2. 6+ years of experience with SQL and PL/SQL and SQL tuning including SQL and PL/SQL development tools 3. 5+ years of experience with Oracle Forms and Oracle Reports 4. 5+ years of experience with XML/BI publisher 5. 2+ years of experience with Oracle Workflow Builder 6. 2+ years of experience with a Unix Shell scripting. Specific Work Preferences 1. Knowledge of general business operating principles. 2. Advanced troubleshooting skills 3. Ability to multitask and maintain composure when working with the business users. 4. Good Techno Functional knowledge of Order to Cash Process (O2C) and Procure to Pay process (P2P). 5. Technical expertise with solid understanding of underlying data flow and functionality in Oracle modules likes Inventory, Shipping Execution, Order Management, Purchasing, iProcurement, WIP and BOM. 6. Good technical and functional knowledge in Supply Chain modules. 7. Expertise in Forms Personalization and customization. 8. Knowledge of Oracle Application Framework (OAF) and ADF a plus. 9. Knowledge of Oracle Mobile Forms development is a plus 10. Knowledge of Application Object Library 11. Excellent analytical and problem-solving skills 12. Excellent verbal and written communication skills

Oracle DBA Performance Tunning About Oracle - CSS The Customer Success Services (CSS) is a unit within the Oracles Customer Service Organization that establishes long-term relationships with many of Oracle's customers through annuity-based service contracts and project based one-time services. CSS services team sells from a broad IT-services portfolio both in fixed price and T&M basis. CSS services are typically requested by large Oracle customers that require the utmost attention to real mission critical applications and processes. CSS covers the majority of large-scale Oracle customers. Oracle Customer Success Services provides unmatched, tailored support that ensures organization’s Oracle technology investments deliver the cutting-edge innovation and performance your business requires to compete, all while coexisting within your IT environment. CSS is industry-leading expertise with the highest customer satisfaction to support organization’s business every step of the way. Job Responsibilities: Provide post-sales technical support and solutions to Oracle customers. Act as the primary point of contact for customer inquiries, troubleshooting, and issue resolution. Install, configure, and administer Oracle Database/RAC 11g, 12c, and 19c. Perform database upgrades, patching, and performance tuning. Diagnose and resolve moderately complex technical issues related to Oracle products. Interface with customers’ IT teams regularly, either on-site or remotely. Manage escalations, develop action plans, and facilitate issue resolution with Development and Support teams. Ensure high customer satisfaction through proactive service recommendations and support. Utilize Oracle Enterprise Manager (OEM) for database monitoring and management. Work independently with minimal supervision while advising management on progress. May take on project lead responsibilities and provide guidance to team members. Mandatory Skills: Minimum 7 years of experience as an Oracle Database Administrator/Consultant/Support Engineer. Availability to work in a 24x7 support environment. Expertise in Oracle Database Architecture, RAC, and Performance Tuning. Strong troubleshooting skills for database performance and SQL tuning. Experience in database upgrades, patching, and maintenance. Good understanding of support processes and ability to manage escalations. Strong analytical skills with independent problem-solving capabilities. Excellent communication and customer management skills. BE/BTech/MS in Computer Science or equivalent preferred. Oracle Database / Exadata / OCI certification preferred. If you have the above skills, take up the below list of self-test questions to know if you qualify to apply. Self-Test Questions: Can I explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output? Do I know the fastest query method for a table? Can I fix the contention for library caches? Do I know row chaining, how does it happen? How can I reduce it? How do I correct it?