Jobs
Interviews

358 Sql Tuning Jobs

Setup a job Alert
JobPe aggregates results for easy application access, but you actually apply on the job portal directly.

9.0 - 14.0 years

22 - 27 Lacs

hyderabad, bengaluru

Work from Office

3+ years of experience in Azure Databricks with PySpark. 2+ years of experience in Databricks workflow & Unity Catalog. 2+ years of experience in ADF (Azure Data Factory), 2+ years of experience in ADLS Gen 2 2+ years of experience in Azure SQL. 3+ years of experience in Azure Cloud platform. 2+ years of experience in Python programming & package builds. Hands-on experience in designing and building scalable data pipelines using Databricks with PySpark , supporting batch and near-real-time ingestion, transformation, and processing. Ability to optimize Spark jobs and manage large-scale data processing using RDD/Data Frame APIs. Demonstrated expertise in partitioning strategies, file format optimization (Parquet/Delta), and Spark SQL tuning. Skilled in governing and managing data access for Azure Data Lakehouse with Unity Catalog. Experience in configuring data permissions, object lineage, and access policies with Unity Catalog. Understanding of integrating Unity Catalog with Azure AD, external megastores, and audit trails. Experience in building efficient orchestration solutions using Azure data factory, Databricks Workflows . Ability to design modular, reusable workflows using tasks, triggers, and dependencies. Skilled in using dynamic expressions, parameterized pipelines, custom activities, and triggers. Familiarity with integration runtime configurations, pipeline performance tuning, and error handling strategies. Good experience in implementing secure, hierarchical namespace-based data lake storage for structured/semi-structured data, aligned to bronze-silver-gold layers with ADLS Gen2 . Hands-on experience with lifecycle policies, access control (RBAC/ACLs), and folder-level security. Understanding of best practices in file partitioning, retention management, and storage performance optimization. Capable of developing T-SQL queries, stored procedures, and managing metadata layers on Azure SQL Comprehensive experience working across the Azure Cloud ecosystem, including networking, security, monitoring, and cost management relevant to data engineering workloads. Experience in writing modular, testable Python code used in data transformations, utility functions, and packaging reusable components. Familiarity with Python environments, dependency management (pip/Poetry/Conda), and packaging libraries. Ability to write unit tests using PyTest/unittest and integrate with CI/CD pipelines. Able to prepare Design documents for development adopting code analyzers and unit testing frameworks.

Posted 1 day ago

Apply

3.0 - 5.0 years

7 - 11 Lacs

bengaluru

Work from Office

PL/SQL Developer - Oracle, SQL Tuning Our Team We work for one of the largest multi-national banks (Client) with presence across the globe. We work on Supply Chain Finance domain and is one of the industry leading solution for the Client. We are responsible for the enhancements to the existing platform to cater to the growing business needs based on industry trends, either functionally or technically. The solution implemented is a global application spanning across 3 regions and 20+ countries with a single code base, with multi-lingual support. Looking for Oracle PL/SQL developers who would be responsible for: Understanding the requirements from the Functional Team Estimating the development efforts Developing the functionalities based on Agile/ Water-Scrum-Fall model Ensuring the queries written are optimized to handle performance and volume. Assisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing. Your Opportunity You will be responsible for applying your extensive hands-on knowledge of Oracle SQL, PL/SQL features to develop functional requirements. You would be responsible for the entire development life cycle viz., development till production implementation. Your Qualifications Any Computer Science based graduation 3+ years in software development Excellent hands-on coding and design skills in Oracle SQL, PL/SQL with exposure to analytical functions and data modelling. Expertise in Query fine-tuning to ensure optimized execution Experience in Banking Domain Knowledge of UNIX is an added advantage Our Ideal Candidate Preferably from Banking domain Hands-on development experience in writing Oracle queries, stored procedures, packages that are fine-tuning to be of good performance and handle high volume. Aspire to learn new tools as per the project need Exposure to Agile methodologies Your Responsibilities As an integral part of the development team you will be responsible for the following Understand the business requirements from the functional team Estimate the development efforts for the assigned functions. Develop the functionalities based on Agile/ Water-Scrum-Fall model Write optimized Queries or Packages that can handle high volume and performance Perform peer-review of code written by other developers Assisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing. Additionally, contribute to the upliftment of existing design/ code for alternates that can help in flexibility and scalability. Filtration criteria: 3-5 years of experience in Oracle SQL, PL/SQL development Pure development experience to be considered (to avoid support expertise where the requirement is more monotonous) Experience in Query fine-tuning (not database tuning) for writing optimized code. Screening Criteria Questionnaire How do you rate yourself in Oracle programming? 6 & above/10 is good Yes Explain Plan Check for the execution where the cost is higher Yes, I have used it. I have good exposure in using and contributing to it. Stored Procedures, Packages, Triggers, Functions, Complex Queries using joins from multiple tables Function can be called within a query whereas Procedure cannot be called within a query. Know the fundamentals of data modelling (tables, views, data types, index, etc.,) Yes Do you have expertise in SQL tuning in your projects? What tool you use for SQL tuning? What do you check for in Explain Plan? Do you have hands-on development experience? What all objects you have created in Oracle? What is the difference between Procedure and Function? Experience in data modelling? Experience in Banking domain Career Level - IC2 Responsibilities Covered under Qualifications

Posted 1 day ago

Apply

6.0 - 10.0 years

12 - 17 Lacs

mumbai

Work from Office

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 organizations 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 organizations 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 customers IT staff on a regular basis. Either at the clients 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. Responsibilities 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 organizations 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 organizations 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 customers IT staff on a regular basis. Either at the clients 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.

Posted 1 day ago

Apply

5.0 - 10.0 years

8 - 12 Lacs

noida

Work from Office

Minimum of 5 yrs of Software development experience. 5+ Year Oracle PL/SQL experience 5+ Year ETL Experience (AbInitio). Hands on experience in developing complex ETL applications. Along with knowledge of continuous flow. Proficiency with Oracle PL/SQL, SQL tuning, writing packages, triggers, functions and procedures. Experience with data conversion / migration Excellent trouble shooting and debugging skills. Worked in Onsite - offshore model Mandatory Competencies Beh - Communication ETL - ETL - Ab Initio Database - Database Programming - PL/SQL Database - Oracle - Oracle 12c ETL - ETL - Tester.

Posted 1 day ago

Apply

5.0 - 10.0 years

8 - 12 Lacs

noida

Work from Office

Minimum of 5 yrs of Software development experience. 5+ Year Oracle PL/SQL experience 5+ Year ETL Experience (AbInitio). Hands on experience in developing complex ETL applications. Along with knowledge of continuous flow. Proficiency with Oracle PL/SQL, SQL tuning, writing packages, triggers, functions and procedures. Experience with data conversion / migration Excellent trouble shooting and debugging skills. Worked in Onsite - offshore model Mandatory Competencies Beh - Communication ETL - ETL - Ab Initio Database - Database Programming - PL/SQL Database - Oracle - Oracle 12c

Posted 4 days ago

Apply

3.0 - 7.0 years

6 - 10 Lacs

chennai

Work from Office

Mainframe Scheduling, Oracle PL/SQL, SAS ETL, Unix & Shell scripting Snowflake, GitHub, Snowpark, nformatica, SQL Server, SSIS Develop, test, and maintain complex PL/SQL stored procedures, functions, packages, and triggers Write efficient SQL queries for data extraction, transformation, and reporting. Optimize database performance through tuning and indexing. Collaborate with application developers, DBAs, and business analysts to understand requirements. Troubleshoot and resolve database issues and bugs. Ensure data accuracy, integrity, and security. Participate in code reviews and provide recommendations for improvement. Develop and maintain documentation related to database design and code. Assist in database design and schema definition. Support database migration and upgrade activities.

Posted 4 days ago

Apply

5.0 - 10.0 years

5 - 9 Lacs

chennai

Work from Office

Job Summary: We are looking for an experienced Senior Oracle Data Integrator (ODI) Developer to join our dynamic team. You will be responsible for Analysing, Orchestrating, Implementing and Optimizing cutting-edge data integration and analytics solutions. The candidate should be capable of leading a development team and creating a blueprint to help clients achieve their end goal. Knowledge on other ETL tools and databases is an added advantage. Key Responsibilities: Expertise in the Oracle ODI tool and Oracle PL/SQL, ODI knowledge of ODI Master and work repository. Setting up topology, building objects in Designer, Monitoring Operator, different types of Knowledge Modules customisation, ODI Agents, Scenarios and Variables etc. Design and develop complex mappings dynamically, Enhance Process Flows, Review ETL Scripts (Scenarios, Shell Scripts), Error handling, ODI Load Plan customisation, ODI Package Deployment Strategy & performance tuning of ODI mappings. Monitor and troubleshoot data pipelines or Scheduled ODI Jobs. Ensure data quality, accuracy and integrity across integration environment. Experience in Data Migration or ODI Package Migration using SQL Loader, smart import/export. Experience in Database Error handling and creating PL/SQL packages, procedures, Functions, Triggers, Views and Material. Views and exception handling for retrieving, manipulating, checking, and migrating complex datasets in Oracle. Experience in SQL tuning and optimization using explain plan. Partitioning and Indexing strategy for optimal performance. Should have experience in interacting with customers in understanding business requirement documents and translating them into ETL specifications and high-level and Low-level design documents. Experience with scripting languages such as Python or shell scripting. Understanding of data governance and security best practices. Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities. Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents. Qualifications and Skills BTech / MTech / BCA / MCA / BSc-IT / BE in any stream. Must have 5+ years of onsite experience in managing ODI & Data warehouse projects. Preference will be given to candidates who have Banking and Finance Domain Knowledge. Certification in ODI or Oracle Database will be value add.

Posted 4 days ago

Apply

18.0 - 25.0 years

50 - 65 Lacs

hyderabad

Work from Office

Mandatory Skills Experience in Grid Installation and Grid Upgradation. Experience in Oracle RAC, Performance Tuning, Dataguard, and knowledge of GoldenGate. Expert-level understanding of Oracle Database Architecture. Technical Expertise Specialized in Oracle RAC with good understanding of the complexity of RAC Architecture across Servers, OS, Network, and Storage Layer. Exposure to Oracle Engineered Systems (Exadata, SSC Box & ExaCM). SQL Tuning skills and experience in refactoring SQL queries to improve performance. Ability to diagnose performance issues across SQL, Application, Database, System, and Storage. Complete understanding of Oracle Database Backup and Recovery options. Expert knowledge of HA features of Oracle Database. Collaboration & Problem-Solving Ability to work with various teams (Development, Storage Administrators, Network Administrators, System Administrators, and Business Users) to resolve performance issues. Excellent problem-solving skills with the ability to transverse across the infrastructure layer to diagnose issues. Work Environment Ability to work under pressure in production environments. Experience working with databases on all flavors of OS. Domain Experience Prior working experience in Telecom or BFSI companies is preferred. Dba, Db Installations, Db Migration, Db Tuning, Rac

Posted 4 days ago

Apply

5.0 - 10.0 years

0 Lacs

noida, uttar pradesh

On-site

Role Overview: You will be a critical member of a fast-paced, entrepreneurial development team responsible for creating custom add-ons for Fiserv's core banking software (DNA) as a Software Developer. The role involves primarily using PL/SQL and SQR programming languages for software development, unit testing, documentation, and UAT processes. You will collaborate with peers in India and the United States to ensure the delivery of high-quality products and services. Key Responsibilities: - Develop, test, and document programs based on customer specifications. - Ensure timely delivery of high-quality finished products. - Communicate effectively with peers and Business Analysts for accurate delivery. - Review software design, code quality, and compliance with defined DNAapp validation rules. Qualification Required: - College/university level degree in software engineering field. - 5-10 years of development experience in PL/SQL, open to learning SQR. - Proficiency in writing Packages, Stored Procedures, Functions, Triggers, Views, PL/SQL debugging, etc. - End-to-end experience across the software development lifecycle. - Ability to work independently and in project teams with excellent communication skills. - Additional desired qualifications include experience in Python development, familiarity with banking principles/banking software, SQR software development, SQL tuning, optimization tools & techniques, troubleshooting performance issues, etc. Thank you for considering employment with Fiserv. Apply using your legal name and complete the step-by-step profile with your resume attached.,

Posted 5 days ago

Apply

2.0 - 6.0 years

0 Lacs

karnataka

On-site

You will be responsible for supporting BIP and OTBI development, including SQL tuning and applying security models to reports. Your role will also involve utilizing HDL experience and demonstrating knowledge of SDLC and JIRA.,

Posted 5 days ago

Apply

4.0 - 8.0 years

6 - 10 Lacs

chennai, bengaluru

Work from Office

Corporate: Light & Wonder s corporate team is comprised of incredible talent that works across the enterprise, defying boundaries to provide essential services in an extraordinary manner to ensure the success of the organization and the well-being of employees. Position Summary SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV. Hands-on experience with SQL Server installations and patching. Perform scheduled maintenance and support release deployment activities. Database Maintenance/ Support tasks and lower-level monitoring using tools like profiler, DMV, Perfmon. Deep understanding of SQL Server performance analysis and tuning / capacity planning / query optimization. Hands-on experience with clustering, Always on / multi node clusters at the time of DR process. SQL Server Replication, Backup/ Restore, maintenance plans and DR strategies. Understanding of system tables, stored procedures, functions, triggers & SQL tuning. General troubleshooting like assisting end users with various issues related to connectivity, permissions, access, distributed queries issues, suggesting solutions, best practices etc. SQL Server Security, adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts. Knowledge of Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices) Experience in working on all the ITIL Processes. Qualifications

Posted 6 days ago

Apply

6.0 - 10.0 years

0 Lacs

haryana

On-site

As a Senior Database Developer at Twinline Business Solutions Pvt Ltd., located in Gurgaon, Haryana, you will be responsible for utilizing your 6-10 years of hands-on coding experience in Oracle/PLSQL development. Your primary focus will be on developing PL/SQL procedures, functions, and packages to support the overall development efforts. You will be involved in designing, developing, testing, releasing, maintaining, and providing technical support for database development projects. Your role will also include reviewing existing PL/SQL packages for performance enhancements, as well as writing complex SQL queries, Views, and Materialized Views. Additionally, you will be expected to possess basic DBA knowledge for tasks such as database installation, management, and tuning. To excel in this role, you must thrive in an Agile development environment and demonstrate a high level of energy, results-driven attitude, and strong interpersonal skills. Your ability to communicate effectively and confidently, along with your problem-solving skills and adaptability to changing environments, will be key to your success. In terms of responsibilities, you will lead a team of database developers, implement new business features based on technical specifications, fix bugs, refactor existing code, and conduct development tests. Moreover, you will collaborate with colleagues across the development team and the entire company, displaying leadership qualities and a proactive approach to problem-solving. The ideal candidate for this position will possess strong analytical and logical problem-solving skills, be open to learning new technologies, and demonstrate a solution-oriented mindset. Additionally, excellent managerial skills, experience in team management, and knowledge of NBFC, Lending System, or MFI domains will be highly valued. If you are a self-directed individual with the ability to work independently, lead a team effectively, and adapt to evolving technologies, we encourage you to apply for this full-time position. A Master's degree is preferred, and proficiency in English is essential for effective communication. Join our dynamic team at Twinline Business Solutions Pvt Ltd. and contribute to our innovative projects in a collaborative work environment. The expected start date for this role is immediate/within 15 days, with compensation as per market standards. We look forward to welcoming you to our team in Gurgaon for this exciting opportunity.,

Posted 6 days ago

Apply

6.0 - 10.0 years

0 Lacs

kochi, kerala

On-site

As a PLSQL Developer at PracticeSuite, you will be an integral part of our team at a leading SaaS company specializing in cloud-based practice management and medical billing solutions. Your primary focus will be on database development, performance optimization, and ensuring that our data systems effectively meet the business needs of our organization. To excel in this role, you will need to leverage your technical expertise in Oracle databases, specifically PL/SQL. Strong problem-solving and troubleshooting skills are essential, along with the ability to communicate effectively with both technical teams and business stakeholders. Your responsibilities will include designing stable and reliable database programs to meet user needs, tuning and optimizing PL/SQL and SQL for newly developed and existing applications, providing data analysis and validation, and utilizing Oracle 10g/11g features on a large-scale system. You will be tasked with identifying performance issues on production and testing systems, interacting with internal and external clients to understand requirements, explain issues, and prioritize work. Being involved in all stages of the software development life cycle, you will demonstrate your ability to learn both business processes and PL/SQL. Your skills should encompass basic knowledge of Oracle database architecture, advanced database development experience (Oracle SQL/PLSQL), knowledge of software development, strong SQL development and tuning skills, excellent analytical and organizational capabilities, an understanding of front-end user requirements, and a problem-solving attitude. Effective verbal and written communication skills are also crucial in this role. PracticeSuite is a national, fast-growing cloud computing software company with offices in Kochi and Mumbai, offering a cloud-based 360Office Platform to the healthcare industry. We have an agile management team, high employee morale, and exceptional customer satisfaction. Join us in our rapid growth as we establish ourselves as one of the top five cloud-based systems. Learn more about PracticeSuite by visiting our website. Location: Kerala (Kochi) (Work from Office). Apply now to be part of our dynamic team and contribute to the success of PracticeSuite!,

Posted 1 week ago

Apply

5.0 - 9.0 years

0 Lacs

kochi, kerala

On-site

As a PLSQL Developer at PracticeSuite, you will play a crucial role in database development, performance optimization, and ensuring that data systems align with the organizational business needs. Your technical expertise in Oracle databases, specifically PL/SQL, along with strong problem-solving skills will be essential for success in this role. Effective communication with technical teams and business stakeholders is key, as you will be involved in all stages of the software development process. Your responsibilities will include designing stable and effective database programs, tuning and optimizing PL/SQL and SQL, providing data analysis and validation, leveraging Oracle features on a large-scale system, identifying performance issues, and collaborating with clients to understand requirements. You will also be actively involved in the software development life cycle, demonstrating your ability to learn business processes and new technologies. To excel in this role, you should have a basic understanding of Oracle database architecture, advanced experience in Oracle SQL/PLSQL, knowledge of software development, strong SQL development and tuning skills, excellent analytical and organizational abilities, a problem-solving attitude, and effective communication skills. With a minimum of 5 years of experience, you will be based in Kochi and work from the office. PracticeSuite is a fast-growing cloud computing software company based in Tampa, FL, offering a cloud-based 360Office Platform for healthcare facilities. With an agile management team, high employee morale, and exceptional customer satisfaction, PracticeSuite is rapidly expanding and gaining recognition as one of the top cloud-based systems in healthcare.,

Posted 1 week ago

Apply

5.0 - 10.0 years

8 - 12 Lacs

bengaluru

Work from Office

We are looking for an experienced Oracle Database Administrator with a minimum of 5 years of hands-on experience, preferably with a strong background in Linux/Unix environments and development expertise in SQL and PL/SQL. The ideal candidate will be responsible for managing and monitoring Oracle databases, collaborating with development teams to resolve design and support issues, and troubleshooting performance bottlenecks. Key Responsibilities: - Install, patch, and monitor Oracle databases across environments. - Utilize Oracle management tools such as RMAN, Data Pump, and Oracle Enterprise Manager (OEM). - Collaborate with developers to support database design and performance optimization. - Troubleshoot database issues and perform SQL tuning. - Develop and maintain SQL, PL/SQL, and Bash shell scripts for automation and maintenance tasks. - Ensure database integrity, security, and availability. Required Skills: - 5+ years of Oracle DBA hands-on experience. - Proficiency in Oracle database administration and performance tuning. - Experience with backup and recovery tools (RMAN), data export/import (Data Pump), and monitoring tools (OEM). - Strong scripting skills in SQL, PL/SQL, and Bash. - Good understanding of database modeling and table design principles. - Experience in other database technologies like MySQL, Postgres, MS SQL Server is advantageous. - Ability to work independently with a high level of attention to detail. - Strong analytical and problem-solving skills. - Proactive, dependable, and ready to support production environments.

Posted 1 week ago

Apply

3.0 - 5.0 years

4 - 8 Lacs

bengaluru

Work from Office

Educational Requirements BSc,BCA,Master Of Engineering,MSc,MCA,MTech,BTech,Bachelor of Engineering Service Line Application Development and Maintenance Responsibilities Roles and Responsibilities:Development and Implementation:Design, develop, and implement efficient and scalable PL/SQL stored procedures, functions, packages, triggers, and views.Write and optimize complex SQL queries for data retrieval, manipulation, and reporting.Collaborate with business analysts and solution architects to understand requirements and translate them into technical designs.Participate in the full software development lifecycle (SDLC), including requirements analysis, design, coding, testing, and deployment.Code Quality and Standards:Ensure adherence to established coding standards, best practices, and architectural guidelines.Perform thorough unit testing of developed code and assist with integration testing.Identify and debug issues in existing PL/SQL code, providing timely and effective solutions.Performance Tuning and Optimization:Analyze and optimize the performance of existing PL/SQL code and SQL queries.Utilize Oracle performance monitoring tools (e.g., Explain Plan, SQL Trace) to identify and resolve performance bottlenecks.Contribute to discussions on database design improvements and indexing strategies to enhance application performance.Documentation and Support:Create and maintain clear, concise technical documentation for developed modules and features.Provide support for production issues, analyzing and resolving database-related problems.Collaborate with DBAs on schema changes, data migrations, and other database-related activities.Collaboration and Mentorship (Junior Developers):Work effectively within a team environment, actively participating in team meetings and discussions.Potentially mentor junior developers, offering guidance on PL/SQL coding best practices and problem-solving techniques.Communicate technical concepts clearly to both technical and non-technical stakeholders Additional Responsibilities: Additional Information:Education: Bachelor's degree in Computer Science, Information Technology, or a related field.Soft Skills:Excellent analytical and problem-solving skills.Strong attention to detail and commitment to quality.Good communication and interpersonal skills.Ability to work independently and collaboratively in a team environment.Proactive and eager to learn new technologies and concepts.Ability to manage time effectively and handle multiple tasks. Technical and Professional Requirements: Technical Requirements:Must-Have:3-5 years of hands-on experience in Oracle PL/SQL development.Strong proficiency in writing and optimizing complex SQL queries, stored procedures, functions, packages, and triggers.Solid understanding of Oracle database concepts, including data types, indexes, constraints, and views.Experience with SQL tuning and performance optimization techniques.Familiarity with Oracle development tools such as SQL Developer or Toad.Experience with version control systems (e.g., Git, SVN).Good to Have:Basic understanding of data modeling principles.Exposure to Oracle Forms and Reports is a plus.Familiarity with shell scripting (Unix/Linux) for database automation.Knowledge of Agile/Scrum development methodologies.Experience with large-scale transactional systems.Understanding of data warehousing concepts or ETL processes. Preferred Skills: Technology->Oracle Cloud->Oracle Knowledge->Oracle Knowledge

Posted 1 week ago

Apply

5.0 - 9.0 years

0 Lacs

haryana

On-site

Genpact is a global professional services and solutions firm with over 125,000 employees in more than 30 countries. We are driven by curiosity, agility, and a commitment to delivering value to our clients. Our purpose is to create a world that works better for people, and we serve leading enterprises, including the Fortune Global 500, through our deep industry knowledge, digital operations services, and expertise in data, technology, and AI. We are currently seeking applications for the role of Consultant- Oracle EBS Technical. In this position, you will be responsible for driving requirement gathering, solution design, testing, implementation, and post-production support for Oracle Financial Modules AP, AR, GL, and CM. You should have a good understanding of Oracle Apps standards, table structure, architecture, and experience with performance optimization of PL/SQL packages and SQL tuning. Key Responsibilities: - Conduct requirement gathering, fit-gap analysis, and solution design - Build, test, and implement solutions for Oracle Financial Modules - Optimize PL/SQL packages and tune SQL queries for performance - Develop reports, forms, and interfaces - Work independently with strong communication and client interaction skills - Document and deliver work effectively Qualifications: Minimum Qualifications: - Experience working independently on Oracle P2P modules (PO, AP, GL, SLA) - Proficiency in developing custom interfaces and working with Oracle standard interfaces - Understanding of Oracle EBS data models, especially Inventory, Order Management, Field Services, and CMRO modules Preferred Qualifications: - Experience in Oracle Applications Technical (EBS R12) - Expertise in SCM, Discrete Manufacturing, Distribution, OPM, ASCP, or EBS Finance modules like AP, AR, Cash Management Job Details: - Job Title: Consultant - Location: India-Gurugram - Schedule: Full-time - Education Level: Bachelor's / Graduation / Equivalent - Job Posting Date: Jun 24, 2025 - Unposting Date: Dec 22, 2025 If you have the required qualifications and skills, we invite you to apply for this exciting opportunity to join our team at Genpact.,

Posted 1 week ago

Apply

9.0 - 14.0 years

5 - 9 Lacs

hyderabad

Work from Office

In this role, you will work in one of our IBM Consulting Client Innovation Centers (Delivery Centers), where we deliver deep technical and industry expertise to a wide range of public and private sector clients around the world. Our delivery centers offer our clients locally based skills and technical expertise to drive innovation and adoption of new technology. As a Database Administrator, you'll participate in many aspects of the software development lifecycle, such as design, code implementation, testing, and support. You will create software that enables your clients' hybrid-cloud and AI journeys Your primary responsibilities include: Monitor and analyze database performance (CPU, memory, disk space, etc.). Verify backup integrity and recovery procedures regularly. Work with developers and architects to ensure optimal database design for application requirements. Optimize database schema for performance, scalability, and maintainability. Implement performance tuning strategies (e.g., indexing, query optimization, and partitioning). Identify and resolve database bottlenecks. IBM DB2 Administrator role is to manage and maintaining IBM's DB2 database systems. Educational qualification - Bsc Computer Science Work experience - 6.9 years and 2 years 9 months for UKSC Required education Bachelor's Degree Preferred education Master's Degree Required technical and professional expertise Knowledge on IBM DB2 LUW (DB2 for Linux, Unix, and Windows) Migration of DB2 UDB databases from old to newer versions Apply FIXPACKS to keep DB2 at most recent level. SQL Tuning and benchmarking using db2batch, db2advisdb2explain tools. Working for creating Instances, Databases, Tablespaces and Buffer pools Preferred technical and professional experience Working on IBM DB2 LUW (DB2 for Linux, Unix, and Windows) Expertise in using Movement Utilities like as Export, Import, Load.DB2MOVE under high volume conditions. Expertise on HADR Server Rebuild and Monitoring and HADR failovers and Rolling Upgrades

Posted 1 week ago

Apply

5.0 - 8.0 years

8 - 12 Lacs

bengaluru

Work from Office

Educational Requirements BSc,BCA,Master Of Engineering,MSc,MCA,MTech,BTech,Bachelor of Engineering Service Line Application Development and Maintenance Responsibilities Roles and Responsibilities:Technical Leadership & Mentorship:Lead a team of PL/SQL developers, providing technical guidance, mentorship, and code reviews.Foster a collaborative environment and promote knowledge sharing within the team.Define and enforce PL/SQL coding standards, best practices, and performance optimization techniques.Assist in the professional development of team members.Design & Development:Design, develop, and implement complex PL/SQL packages, procedures, functions, triggers, and views.Create and optimize SQL queries for various database operations and reporting needs.Develop and maintain database schemas, tables, and indexes.Work closely with architects and business analysts to translate business requirements into technical specifications.Participate in all phases of the software development lifecycle (SDLC), including requirements gathering, design, development, testing, deployment, and support.Performance Tuning & Optimization:Identify and resolve performance bottlenecks in existing PL/SQL code and SQL queries.Utilize Oracle performance tuning tools (e.g., AWR, ADDM, Explain Plan, SQL Trace) to analyze and optimize database performance.Implement efficient data loading, transformation, and extraction strategies.Database Management & Support:Collaborate with database administrators (DBAs) for schema design, capacity planning, and database maintenance activities.Provide production support for PL/SQL applications, troubleshooting issues and implementing timely solutions.Ensure data integrity and security within the database environment.Documentation & Reporting:Create and maintain comprehensive technical documentation for PL/SQL code, database designs, and processes.Generate reports and provide insights on database performance and development progress.Collaboration & Communication:Effectively communicate technical concepts to both technical and non-technical stakeholders.Collaborate with cross-functional teams (e.g., Java developers, QA, Business Analysts) to ensure seamless integration and delivery. Additional Responsibilities: Education: Bachelor's degree in Computer Science, Information Technology, or a related field.Certifications: Oracle Certified Professional (OCP) in PL/SQL or Database Administration is a plus. Technical and Professional Requirements: 5-8 years of extensive experience in Oracle PL/SQL development, including strong proficiency in writing complex stored procedures, functions, packages, and triggers.Expertise in SQL tuning and optimization for high-volume, high-performance applications.Solid understanding of Oracle database architecture, data modeling, and relational database concepts.Experience with various Oracle features such as Analytical Functions, Materialized Views, Partitions, and Indexes.Proficiency in using SQL Developer, Toad, or similar Oracle development tools.Experience with version control systems (e.g., Git, SVN). Preferred Skills: Technology->Oracle Cloud->Oracle Knowledge

Posted 1 week ago

Apply

4.0 - 8.0 years

7 - 10 Lacs

thane, navi mumbai

Work from Office

Job Description: • Monitor, maintain database systems and troubleshoot problems that may arise. • Maintain data integrity, monitoring and security (manage roles and permissions of database users). • Create and manage constraints and indexes. • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. • Proactive housekeeping/archiving and shrinking of databases. Job Description Senior Database Administrator. • Manage production, QA and development database environments. • Create detailed documentation including diagrams of database infrastructure. • Learn relevant business processes and understand the data flow, criticality and dependencies. • Effectively coordinate and communicate with all the stakeholders (internal teams and clients).

Posted 1 week ago

Apply

10.0 - 15.0 years

20 - 25 Lacs

pune

Work from Office

Lead Software Engineer - Apache Nifi, Python, PySpark, Hadoop, Cloudera platforms, and Airflow Title and Summary Lead Software Engineer - Apache Nifi, Python, PySpark, Hadoop, Cloudera platforms, and AirflowWho is Mastercard? Mastercard is a global technology company in the payments industry. Our mission is to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments, and businesses realize their greatest potential. Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. With connections across more than 210 countries and territories, we are building a sustainable world that unlocks priceless possibilities for all. Overview Mastercard is looking for a Lead Software Engineer to join the Account Level Management(ALM) team in our Pune office thats focused on building ALM Services with Data warehouse skills. The Mastercard Account Level Management platform empowers real-time card level decisioning. As consumers progress along their life stages as card holders, with increasing disposable income and more refined preferences, ALM provides services to issuers so they can effectively offer more relevant benefits and rewards at each stage, to drive loyalty and spend. Role o Develop high quality, secure and scalable data pipelines using spark, Scala/Python/Java on Hadoop or object storage like MinIO. o Leverage technologies and solutions to innovate with increasingly large data sets. o Drive automation and efficiency in Data ingestion, data movement and data access workflows by innovation and collaboration. o Understand, implement and enforce Software development standards and engineering principles in the Big Data space. o Contribute ideas to help ensure that required standards and processes are in place and actively look for opportunities to enhance standards and improve process efficiency. o Perform assigned tasks and production incident independently. Skill Requirements: MUST Technical 10+ years of experience in Data Warehouse/Data Lake/Lake House related projects in product or service-based organization Solid Experience of building complex data pipelines through PySpark with Scala/Python on Hadoop or Object storage Experience of building Nifi pipelines (Preferred). Proficiency in Cloudera platforms, and Airflow Expertise in Data Engineering and implementing multiple end-to-end DW projects in Big Data environment handling petabyte scale data. Experience of working with Databases like Oracle, Netezza and have strong SQL knowledge. Proficient in working within an Agile/Scrum framework, including creating user stories with well-defined acceptance criteria, participating in sprint planning and reviews Write and maintain Unix shell scripts, Oracle SQL, PL/SQL, and perform SQL tuning. Optimize and troubleshoot Spark applications for performance, scalability, and fault tolerance Use Git-based version control systems and CI/CD pipelines (e.g., Jenkins). Implement and manage HIVE external tables, partitions, and various file formats. Work across on-premises and cloud environments (AWS, Azure, Databricks). Strong experience with Hadoop ecosystem and Cloudera Data Platform (CDP). Optional Technical Strong analytical skills required for debugging production issues, providing root cause and implementing mitigation plan Strong communication skills - both verbal and written Ability to multi-task across multiple projects, interface with external internal resources Proactive, detail-oriented and able to function under pressure in an independent environment along with a high degree of initiative and self-motivation to drive results Willingness to quickly learn and implement new technologies, participate POC to explore best solution for the problem statement Experience working diverse and geographically distributed project teams Education: Bachelors degree in information systems, Information Technology, Computer Science or Engineering or equivalent work experience. Corporate Security Responsibility All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must: Abide by Mastercards security policies and practices; Ensure the confidentiality and integrity of the information being accessed; Report any suspected information security violation or breach, and Complete all periodic mandatory security trainings in accordance with Mastercards guidelines.

Posted 1 week ago

Apply

5.0 - 9.0 years

10 - 15 Lacs

pune

Work from Office

Overview Mastercard is looking for a Senior Software Engineer to join the Account Level Management(ALM) team in our Pune office thats focused on building ALM Services with Data warehouse skills. The Mastercard Account Level Management platform empowers real-time card level decisioning. As consumers progress along their life stages as card holders, with increasing disposable income and more refined preferences, ALM provides services to issuers so they can effectively offer more relevant benefits and rewards at each stage, to drive loyalty and spend. Role o Develop high quality, secure and scalable data pipelines using spark, Scala/Python/Java on Hadoop or object storage like MinIO. o Leverage technologies and solutions to innovate with increasingly large data sets. o Drive automation and efficiency in Data ingestion, data movement and data access workflows by innovation and collaboration. o Understand, implement and enforce Software development standards and engineering principles in the Big Data space. o Contribute ideas to help ensure that required standards and processes are in place and actively look for opportunities to enhance standards and improve process efficiency. o Perform assigned tasks and production incident independently. Skill Requirements: MUST Technical 5-9 years of experience in Data Warehouse/Data Lake/Lake House related projects in product or service-based organization Expertise in Data Engineering and implementing multiple end-to-end DW projects in Big Data environment handling petabyte scale data. Solid Experience of building complex data pipelines through Spark with Scala/Python/Java on Hadoop or Object storage Experience of working with Databases like Oracle, Netezza and have strong SQL knowledge. Proficient in working within an Agile/Scrum framework, including creating user stories with well-defined acceptance criteria, participating in sprint planning and reviews Write and maintain Unix shell scripts, Oracle SQL, PL/SQL, and perform SQL tuning. Optimize and troubleshoot Spark applications for performance, scalability, and fault tolerance Use Git-based version control systems and CI/CD pipelines (e.g., Jenkins). Implement and manage HIVE external tables, partitions, and various file formats. Work across on-premises and cloud environments (AWS, Azure, Databricks). Strong experience with Hadoop ecosystem and Cloudera Data Platform (CDP). Optional Technical Experience of building Nifi pipelines (Preferred) Strong analytical skills required for debugging production issues, providing root cause and implementing mitigation plan Strong communication skills - both verbal and written Ability to multi-task across multiple projects, interface with external internal resources Proactive, detail-oriented and able to function under pressure in an independent environment along with a high degree of initiative and self-motivation to drive results Willingness to quickly learn and implement new technologies, participate POC to explore best solution for the problem statement Experience working diverse and geographically distributed project teams Education: Bachelors degree in information systems, Information Technology, Computer Science or Engineering or equivalent work experience.

Posted 1 week ago

Apply

3.0 - 8.0 years

7 - 12 Lacs

hyderabad

Work from Office

Position Description: Shift Timings: 1:00 pm to 10:00 pm Skill: ETL (IBM Datastage), SQL, UNIX/Linux scripting, and Big Data distributed system,Python Teradata (Vantage), SQL Server, Greenplum, Hive Notice Period: 0-30 Days Your future duties and responsibilities: Core Skills Secondary Skills Requires a Bachelor's in Computer Science, Computer Engineering, or related field. 5+ years of experience as a Data Engineer. Experience with Data Warehousing, Operational Data Store, Data technologies and ETL solutions. 4+ years of experience in ETL (IBM Datastage), SQL, UNIX/Linux scripting, and Big Data distributed systems. 4+ years of experience working with Teradata (Vantage), SQL Server, Greenplum, Hive and delimited text files would be helpful. 3+ years of experience in programming languages like Python, orchestration tools and processes. Experience in building ETL pipelines using Python pandas. Extensive experience in data migration, data analysis, data transformations, conversion, interface, large volume data loading (ETL techniques), database modeling, and performance SQL tuning. Experience in leveraging database tools to develop DDL scripts, stored procedures, and functions to create and alter database objects. Hands-on experience with Git version control processes, and other release processes Exposure in RDD s with Python/Scala using Spark framework. Delivering all aspects of the software development lifecycle, including design, coding, integration testing, deployment, operations support, and documentation using Agile methodologies. Also, able to work independently, collaborate with cross-functional teams on technical understanding, handle multiple concurrent projects, with an ability to prioritize and manage projects effectively with changing priorities.delivering all aspects of the software development lifecycle, including design, coding, integration testing, deployment, operations support, and documentation using Agile methodologies. Also, able to work independently, collaborate with cross-functional teams on technical understanding, handle multiple concurrent projects, with an ability to prioritize and manage projects effectively with changing priorities. Skills: English Python SQLite.

Posted 1 week ago

Apply

3.0 - 7.0 years

0 Lacs

haryana

On-site

As a skilled Oracle RAC Database Administrator, you will be responsible for installing, configuring, and managing Oracle RAC nodes on the cluster. Your role will involve monitoring the cluster health and resource utilization across all nodes, as well as managing inter-node communication and network configuration. Additionally, you will play a key part in implementing failover and disaster recovery strategies for the RAC environment. Your day-to-day responsibilities will include performing standard DBA tasks such as creating users, tablespaces, indexes, views, and managing database objects. You will be expected to optimize database performance by analyzing query plans, tuning SQL statements, and managing cache sizes. Ensuring database security by implementing security policies and managing user privileges will also be part of your core duties. In the event of issues related to RAC specific features like Global Enqueue, node failures, and cluster synchronization, you will be the go-to person for diagnosing and resolving them. Your expertise in analyzing Oracle Alert logs and tracing files will be crucial in pinpointing problems and ensuring smooth operations. Moreover, setting up monitoring tools to track database performance, resource utilization, and cluster status will fall under your purview. You will configure alerts for critical events such as node failures, database errors, and performance thresholds to ensure proactive management of the RAC environment.,

Posted 1 week ago

Apply

3.0 - 7.0 years

0 Lacs

kochi, kerala

On-site

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. The Supply Chain Technical Associate position at EY offers a fantastic opportunity for Staff Level Consultants with good communication skills to join the Supply Chain Technology group of our GDS consulting Team. This role is essential in the growth of a new service offering and being part of a leading firm. This role requires a technical blend of mind, the right attitude to learn and grow with our EY Partners, working with external clients to develop new business, and driving other initiatives based on various business needs. The ideal candidate for this position must have a good understanding of Supply Chain management. To qualify for this role, you must have a B Tech/BCA/MCA/MBA with excellent written and oral communication skills, exposure to ETL Mappings, Data Warehouse concepts, thorough knowledge in Structured Query Language (SQL), experience working on SQL Server, SQL tuning, and optimization using explain plan and SQL trace files, as well as exposure to Multiple Cloud databases. The incumbent should be able to drive data integration and analysis related developments on the project. Additional knowledge of source system data structures, preferably in Supply Chain services industry, and reporting-related developments will be advantageous. You will have the opportunity to be part of a market-leading, multi-disciplinary team of 10,000+ professionals globally, working with leading businesses across various industries. Working at EY offers a diverse and inspiring environment, dedicated to helping clients from startups to Fortune 500 companies. You will work on varied and meaningful projects, focusing on education, coaching, and personal development. You will have the freedom to control your own development with an individual progression plan, quickly growing into responsible roles with challenging assignments. Additionally, you will benefit from support, coaching, and feedback from engaging colleagues, opportunities for skills development and career progression, and the freedom and flexibility to handle your role in a way that suits you. EY exists to build a better working world, creating long-term value for clients, people, and society while building trust in the capital markets. With diverse teams in over 150 countries leveraging data and technology, EY provides trust through assurance and helps clients grow, transform, and operate. Working across assurance, consulting, law, strategy, tax, and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.,

Posted 1 week ago

Apply
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Featured Companies