Jobs
Interviews

110 Sql Tuning Jobs

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

5.0 - 9.0 years

0 Lacs

hyderabad, telangana

On-site

As an Oracle DBA, you will be responsible for various tasks including Grid Installation and Grid Upgradation, along with expertise in Oracle RAC, Performance Tuning, Dataguard, and knowledge of Golden gate. You should possess an expert level understanding of Oracle database architecture and work effectively with different teams to resolve performance issues. Specializing in Oracle RAC, you must have a good comprehension of the complexity of RAC Architecture across Servers, OS, network, and storage layers. Exposure to working on Oracle Engineered systems such as Exadata, SSC box, and ExaCM is desirable. Additionally, you should have strong SQL tuning skills and experience in refactoring SQL queries for performance improvements. Your role will require you to diagnose performance issues across various levels from SQL to Application to Database to System to Storage. You should have excellent problem-solving skills and the ability to navigate through the infrastructure layer to identify and resolve issues effectively. Expertise in Oracle database's backup recovery options, high availability features, and the ability to work under pressure in a production environment on databases across different operating systems are essential requirements. Strong communication skills and a background in banking would be advantageous in this role.,

Posted 3 days ago

Apply

4.0 - 8.0 years

0 Lacs

hyderabad, telangana

On-site

Genpact is a global professional services and solutions firm that is dedicated to delivering outcomes that shape the future. With a workforce of over 125,000 individuals spread across more than 30 countries, we are fueled by our curiosity, agility, and commitment to creating enduring value for our clients. Our purpose, which revolves around the relentless pursuit of a world that functions better for people, drives us to serve and transform leading enterprises, including the Fortune Global 500. We leverage our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI to achieve this goal. We are currently seeking applications for the position of Consultant - Oracle Apps Technical. In this role, you will be tasked with driving various stages of the application lifecycle, including requirement gathering, fit-gap analysis, solution design, build, CRP, SIT, UAT, cutover/go-live, and post-production support for the aforementioned applications. **Responsibilities:** - Possess knowledge of Oracle Financial Modules such as AP, AR, GL, and CM, along with familiarity with tables, APIs, and interfaces. - Demonstrate a good understanding of Oracle Apps standards, table structure, and architecture. - Showcase experience in performance optimization of PL/SQL packages and SQL tuning. - Proficient in report development, forms development, and functional interfaces. - Ability to work independently, along with strong communication and client interaction skills. - Capable of working autonomously, testing, documenting, and delivering as required. **Minimum Qualifications:** - Proficiency in independently handling functional P2P modules (PO, AP & GL, SLA). - Experience in developing custom interfaces and working with Oracle standard interfaces of multiple Oracle EBS modules, particularly Oracle Inventory (INV). - Thorough understanding of Oracle EBS 12.2.9, Oracle EBS 12.1.3, or Oracle R12 data model of various modules, especially Oracle Inventory (INV), Order Management (OM), Field Services, and CMRO modules. **Preferred Qualifications/ Skills:** - Previous experience in Oracle Applications Technical (EBS R12). - Expertise and experience in any of the following modules: SCM, Discrete Manufacturing, Distribution, OPM, ASCP, or EBS Finance modules like AP, AR, Cash Management. **Job Details:** - **Job Title:** Consultant - **Primary Location:** India-Hyderabad - **Schedule:** Full-time - **Education Level:** Bachelor's / Graduation / Equivalent - **Job Posting:** Oct 8, 2024, 11:58:14 AM - **Unposting Date:** Apr 6, 2025, 7:28:14 AM - **Master Skills List:** Consulting - **Job Category:** Full Time,

Posted 3 days ago

Apply

6.0 - 10.0 years

0 Lacs

hyderabad, telangana

On-site

As a Database Engineer at our company, you will be responsible for designing, developing, and implementing complex database solutions. This includes creating data models, tables, indexes, and constraints to ensure efficient database operations. Your expertise in PL/SQL will be crucial as you develop code for stored procedures, functions, triggers, and packages to automate tasks and enforce business rules effectively. Database performance tuning will be a key aspect of your role, where you will identify bottlenecks and apply optimization strategies to enhance query performance and system efficiency. Monitoring the health of the database to prevent downtime and addressing potential issues promptly will also be part of your responsibilities. You will play a vital role in data integration and ETL processes by designing and implementing solutions that extract, transform, and load data from various sources into the target database. Ensuring data consistency and quality throughout the integration process will be essential for maintaining accurate and reliable information. Implementing robust security measures to safeguard sensitive data, including user access controls, encryption, and data masking, will be a priority. Staying updated on security best practices and industry standards will be crucial to maintaining a secure database environment. Collaboration and communication will be key skills required for this role as you collaborate with development teams, data analysts, and business stakeholders to understand their needs and provide effective solutions. Clear and concise communication of technical concepts to both technical and non-technical audiences will be essential. Required Skills and Experience: - Strong PL/SQL development and Oracle database administration skills - Proficiency in SQL, SQL tuning, and performance optimization methods - Experience with data modeling and database design - Knowledge of data integration and ETL processes - Understanding of database security best practices - Strong troubleshooting and problem-solving abilities - Ability to work independently and collaboratively Preferred Skills: - Experience with data warehousing and business intelligence concepts - Familiarity with cloud-based database systems like AWS RDS and Oracle Cloud Infrastructure - Knowledge of programming languages for automation such as Python and Perl - Certification in Oracle Database Administration or PL/SQL If you are a highly skilled database engineer with a passion for data and a strong understanding of Oracle technologies, we welcome you to apply for this exciting opportunity. Please note that this is a full-time position based in Bangalore, Chennai, Delhi, Hyderabad, Kolkata, Navi Mumbai, Pune, or Vadodara. The work mode is onsite, and the ideal candidate should have 6 to 8 years of experience in the field.,

Posted 3 days ago

Apply

5.0 - 9.0 years

0 Lacs

karnataka

On-site

Genpact is a global professional services and solutions firm that is committed to delivering outcomes that shape the future. With a workforce of over 125,000 individuals spread across 30+ countries, our team is characterized by innate curiosity, entrepreneurial agility, and a desire to create lasting value for our clients. Driven by our purpose of the relentless pursuit of a world that works better for people, we serve leading enterprises, including the Fortune Global 500, through our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI. We are currently seeking applications for the position of Principal Consultant - Oracle Apps Technical. In this role, you will be tasked with driving requirement gathering, Fit-Gap analysis, Solution Design, Build, CRP, SIT, UAT, Cutover/Go-Live, and post-production support for the aforementioned applications. Responsibilities: - Possess knowledge of Oracle Financial Modules such as AP, AR, GL, CM, including familiarity with tables, APIs, and interfaces. - Demonstrated proficiency in Oracle Apps standards, Table Structure, and Architecture. - Experience in performance optimization of PL/SQL packages and SQL tuning. - Competent in Report development, Forms Development, and Interfaces Functional. - Capable of working independently with excellent communication and client interaction skills. - Ability to independently work on functional P2P modules (PO, AP & GL, SLA). - Hands-on experience in developing custom interfaces and working with Oracle standard interfaces of multiple Oracle EBS modules, particularly Oracle Inventory (INV). - In-depth understanding of Oracle EBS 12.2.9 or Oracle EBS 12.1.3 or Oracle R12 data model of multiple modules, especially Oracle Inventory (INV), Order Management (OM), Field services, and CMRO modules. Qualifications we seek in you: Minimum Qualifications / Skills: - Proficiency in Oracle Applications Technical (EBS R12). - Expertise and experience in modules such as SCM, Discrete Manufacturing, Distribution, OPM, ASCP, or EBS Finance modules like AP, AR, Cash Management. Preferred Qualifications / Skills: - Experience in Oracle Applications Technical (EBS R12). If you are passionate about making a difference and possess the required skills and qualifications, we invite you to join us as a Principal Consultant in Bangalore, India. This is a full-time position requiring a Bachelor's degree or equivalent education level. The job posting is dated August 22, 2024, with an unposting date of March 20, 2025.,

Posted 3 days ago

Apply

10.0 - 15.0 years

12 - 20 Lacs

Pune

Hybrid

Database Developer Company:Kiya.ai Work Location: Pune Work Mode:Hybrid JD: DataStrong knowledge of and hands-on development experience in Oracle PLSQL - Strong knowledge of and hands-on development *** experience SQL analytic functions*** - Experience with *** developing complex, numerically-intense business logic *** - Good knowledge of & experience in database performance tuning - Fluency in UNIX scripting Good-to-have - Knowledge of/experience in any of python, Hadoop/Hive/Impala, horizontally scalable databases, columnar databases - Oracle certifications - Any of DevOps tools/techniques CICD, Jenkins/GitLab, source control/git, deployment automation such Liquibase - Experience with Productions issues/deployments **Interested candidates drop your resume to saarumathi.r@kiya.ai **

Posted 3 days ago

Apply

5.0 - 15.0 years

0 Lacs

karnataka

On-site

As an Oracle Integration Specialist - Oic Consultant with 5-15 years of experience, you will be responsible for integrating Oracle cloud applications and troubleshooting performance-related issues in Oracle Fusion SCM Cloud. Your role will require exceptional diagnostic and troubleshooting abilities, using industry standard tools and techniques to optimize complex applications to meet customer expectations. You should have extensive experience in monitoring, tuning, and changing complex applications, along with a deep understanding of Enterprise Business Applications. Your knowledge should encompass network, database, and server configurations, as well as web server optimization, load balancing hardware, and SQL tuning. Additionally, you will be expected to assist junior team members by providing training on new products and technologies. Your technical and analytical skills should include well-developed troubleshooting abilities, the capacity to analyze details and synthesize the "big picture," and creatively using industry standard tools for diagnostic purposes. A detailed functional and technical knowledge of multiple modules within Oracle Supply Chain Application Suites, such as Oracle EBusiness Suite, Peoplesoft Enterprise SCM, JD Edwards EnterpriseOne, Siebel, and Oracle SCM Cloud, is essential. Desired technical skills include a deep understanding of object-oriented design concepts, experience in supporting/troubleshooting Java applications, proficiency in SQL, reports, forms, packages, and a thorough understanding of at least one database platform (Oracle, SQL Server, DB2). It is expected that you will have knowledge of Object Orientation, Java literacy, development frameworks like Oracle ADF, and proficiency in SQL. Familiarity with Oic integration cloud is also required. In the absence of certain technical skills, you should be willing to develop an understanding of these areas as needed, following post-hire training sessions.,

Posted 4 days ago

Apply

8.0 - 13.0 years

5 - 9 Lacs

Hyderabad

Work from Office

Project Role : Database Administrator Project Role Description : Design, implement and maintain databases. Install database management systems (DMBS). Develop procedures for day-to-day maintenance and problem resolution. Must have skills : IBM DB2 Database Administration Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time educationJob Summary :We are seeking an experienced DB2 Database Administrator (DBA) with over 8 years of hands-on experience in managing and supporting IBM DB2 databases. The ideal candidate will have a strong background in database performance tuning, backup and recovery, and automation through scripting. This role requires a proactive individual who can manage complex database environments and collaborate with cross-functional teams to ensure optimal database performance and reliability.Key Responsibilities:Install, configure, and maintain IBM DB2 LUW and/or z/OS database environments.Perform database tuning, optimization, and capacity planning.Implement and manage backup, recovery, and high availability strategies.Develop and maintain automation scripts using Shell, Python, or Perl for routine DBA tasks.Monitor database health and performance using tools like IBM Data Studio, Toad, or custom scripts.Troubleshoot and resolve database-related issues in development, test, and production environments.Apply patches, upgrades, and security updates to DB2 environments.Collaborate with application developers and infrastructure teams to support business requirements.Maintain documentation for database configurations, procedures, and standards.Participate in on-call rotation and provide 24x7 support for critical systems.Required Skills: 8+ years of experience in DB2 Database Administration (LUW and/or z/OS).Strong knowledge of DB2 architecture, utilities, and internals.Proficiency in Replication, SQL tuning, query optimization, and index management.Solid experience with Linux/Unix environments.Strong scripting skills in Shell, Python, or Perl for automation and monitoring.Experience with disaster recovery planning and high availability solutions (e.g., HADR, TSA).Familiarity with database security, auditing, and compliance.Preferred Qualifications:Knowledge of DevOps tools and CI/CD pipelines.Exposure to other RDBMS platforms (e.g., Oracle, SQL Server) is a plus.IBM DB2 certification is highly desirable. Additional Information:- This position is based at our Hyderabad office.- A 15 years full time education is required. Qualification 15 years full time education

Posted 4 days ago

Apply

8.0 - 13.0 years

5 - 9 Lacs

Bengaluru

Work from Office

Project Role : Database Administrator Project Role Description : Design, implement and maintain databases. Install database management systems (DMBS). Develop procedures for day-to-day maintenance and problem resolution. Must have skills : IBM DB2 Database Administration Good to have skills : NAMinimum 5 year(s) of experience is required Educational Qualification : 15 years full time educationJob Summary :We are seeking an experienced DB2 Database Administrator (DBA) with over 8 years of hands-on experience in managing and supporting IBM DB2 databases. The ideal candidate will have a strong background in database performance tuning, backup and recovery, and automation through scripting. This role requires a proactive individual who can manage complex database environments and collaborate with cross-functional teams to ensure optimal database performance and reliability.Key Responsibilities:Install, configure, and maintain IBM DB2 LUW and/or z/OS database environments.Perform database tuning, optimization, and capacity planning.Implement and manage backup, recovery, and high availability strategies.Develop and maintain automation scripts using Shell, Python, or Perl for routine DBA tasks.Monitor database health and performance using tools like IBM Data Studio, Toad, or custom scripts.Troubleshoot and resolve database-related issues in development, test, and production environments.Apply patches, upgrades, and security updates to DB2 environments.Collaborate with application developers and infrastructure teams to support business requirements.Maintain documentation for database configurations, procedures, and standards.Participate in on-call rotation and provide 24x7 support for critical systems.Required Skills: 8+ years of experience in DB2 Database Administration (LUW and/or z/OS).Strong knowledge of DB2 architecture, utilities, and internals.Proficiency in Replication, SQL tuning, query optimization, and index management.Solid experience with Linux/Unix environments.Strong scripting skills in Shell, Python, or Perl for automation and monitoring.Experience with disaster recovery planning and high availability solutions (e.g., HADR, TSA).Familiarity with database security, auditing, and compliance.Preferred Qualifications:Knowledge of DevOps tools and CI/CD pipelines.Exposure to other RDBMS platforms (e.g., Oracle, SQL Server) is a plus.IBM DB2 certification is highly desirable. Qualification 15 years full time education

Posted 4 days ago

Apply

15.0 - 20.0 years

20 - 30 Lacs

Noida, Hyderabad, Bengaluru

Hybrid

Oracle CSS organization seeking application for a role of Oracle EBS Performance Tuning Expert with attitude to keep customer first. The candidate should have extensive experience on SQL Tuning, Database Performance Tuning As a member of the IT organization you would be responsible to perform following- Manage and Support Oracle Database, Middleware, and E-Business Suite Applications in OCI and On-premise environments • Review, Analyze customer environment and provide recommendation to bring stabilization. • Implement and coordinate changes to Infrastructure, Database, Middleware, and Application layers - at OCI and in On-premise environments • Simplify Server/Service Management and reduce Incidents and Problems with Automation • Create Reusable Frameworks, Standards, and Automation to Manage Database, Middleware, and Application changes • Oracle Database upgrade from 12c to 19c and Multitenant configuration • Oracle E-Business Suite Application upgrade to 12.2.x • Migrate On-Premise E-Business and Middleware systems to OCI • Support & Maintain Oracle EBS Suite High Availability Design Spanning Data Centers - Database Node (RAC, Active Dataguard, Physical Standby, Snapshot Standby, Switchover, Failover). Web Node (Load Balance Web Nodes, DNS/Network Configuration) Forms Node (Load Balance Forms Nodes, Servlets), Parallel Concurrent Processing (Distribute load), Adding an EBS Node in a Shared Application Tier Filesystem • Backup and Recovery using RMAN and Zero Data Loss Recovery Appliance - Monitor, Implement B&R performance improvements • Capacity management, recommendations, and managing implementation • Configure and monitor Database and Application targets using Oracle Enterprise Manager and custom scripts The ideal candidate should have: • Bachelor's degree or masters degree in Engineering or equivalent. • 6+ years of experience in managing and delivering solutions using Oracle Database and Middleware, E-Business site products. • Hands-on experience with Scripting, Automation using high-level languages such as Python with strong Object-Oriented concepts. • Working Knowledge on DevOps, focusing on Infrastructure Automation and Enhancement using any Orchestrator tools • Effective verbal and written communication skills

Posted 1 week ago

Apply

4.0 - 12.0 years

0 Lacs

karnataka

On-site

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired by a collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizations unlock the value of technology and build a more sustainable, more inclusive world. Good experience in Administering; Maintaining DB2 databases. Experience in Install; Upgrade of DB2 UDB and Fix pack on Unix and Windows machine. Taking database Backups and recovering the database using db2 Backup; Restore utilities. Expertise in database upgradations from older to newer version of LUW databases. Experience in Database restores including Redirected restores within production; test and development environment. Experience in scheduling Backup scripts using Cron Jobs in Unix Environment and in DB2 UDB Command Line Utilities. Experience in maintenance of databases; performance testing; archiving and troubleshooting. 4-12 years of experience on DB2 Database Administration. Experience on snapshot/lock wait issues. Preferred to have knowledge on designing Flows; Sub Flows; and Exception handling strategies; Data Weave transformation and Mule Expression Language(MEL). Experience in SQL Tuning using db2advisor and db2explain tools. Knowledge on DB2 UDB DBA and in Mule ESB; Cloud hub; Any point Platform is preferred. Having knowledge on DB2 DPF environment is preferred. Preferable to have knowledge on moving databases from OS platforms and Moving data from database objects to flat files and loading data from flat files to database objects using Data Movement Utilities like Export & Import. Keeping up with the latest DB2 features, best practices, and security updates. Clear career progression paths from L2 support to architecture and consulting roles. Be part of mission-critical projects that secure and optimize networks for Fortune 500 clients. Thrive in a diverse, inclusive, and respectful environment that values your voice and ideas as well work in agile, cross-functional teams with opportunities to lead and mentor.,

Posted 1 week ago

Apply

8.0 - 13.0 years

25 - 30 Lacs

Bengaluru

Work from Office

MariaDB is making a big impact on the world. Whether you re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan or ordering takeout MariaDB is the backbone of applications used everyday. Companies small and large, including 75% of the Fortune 500, run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments and public clouds, MariaDB is uniquely positioned as the leading database for modern application development. The Opportunity 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 Location Hybrid - Bangalore, OR India Remote What s in It for You? Impact the world of technology by pushing the boundaries of technology and business models, working at MariaDB. Be part of a game-changing organization that encourages outside-the-box thinking, values empowerment, and is truly shaping the future of the software industry. You ll be collaborating with high-caliber colleagues around the world, offering unparalleled learning and growth opportunities. We provide a very competitive compensation package, 25 days paid annual leave (plus holidays), a massive degree of flexibility and freedom, and more. Salaries for candidates outside the U.S. will vary based on local compensation structures. How to Apply If you are interested in this position, please submit your application along with your resume/CV. MariaDB does not sponsor work visas or relocation. MariaDB is committed to providing accommodations for individuals with disabilities within our application and interview process. To request an accommodation due to a disability, please inform your recruiter. MariaDB will not accept agency resumes without a prior contractual agreement with HR. Please do not forward resumes to any recruiting alias or employee directly. MariaDB is not responsible for any unsolicited resumes. MariaDB is an equal opportunities employer.

Posted 1 week ago

Apply

5.0 - 8.0 years

4 - 8 Lacs

Bengaluru

Work from Office

Educational Requirements Bachelor of Engineering Service Line Information Systems Responsibilities A day in the life of an Infoscion As part of the Infosys delivery team, your primary role would be to interface with the client for quality assurance, issue resolution and ensuring high customer satisfaction. You will understand requirements, create and review designs, validate the architecture and ensure high levels of service offerings to clients in the technology domain. You will participate in project estimation, provide inputs for solution delivery, conduct technical risk planning, perform code reviews and unit test plan reviews. You will lead and guide your teams towards developing optimized high quality code deliverables, continual knowledge management and adherence to the organizational guidelines and processes. You would be a key contributor to building efficient programs/ systems and if you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you!If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! Additional Responsibilities: Knowledge of more than one technology Basics of Architecture and Design fundamentals Knowledge of Testing tools Knowledge of agile methodologies Understanding of Project life cycle activities on development and maintenance projects Understanding of one or more Estimation methodologies, Knowledge of Quality processes Basics of business domain to understand the business requirements Analytical abilities, Strong Technical Skills, Good communication skills Good understanding of the technology and domain Ability to demonstrate a sound understanding of software quality assurance principles, SOLID design principles and modelling methods Awareness of latest technologies and trends Excellent problem solving, analytical and debugging skills Technical and Professional Requirements: Primary skills:Technology-Database-SQL tuning,Technology-Java-Core Java,Technology-Java-Java - ALL,Technology-Java-Spring MVC,Technology-Java-Springboot Preferred Skills: Technology-Java-Core Java Technology-Java-Java - ALL Technology-Database-SQL tuning Technology-Java-Springboot Technology-Java-Spring MVC-Spring MVC

Posted 1 week ago

Apply

3.0 - 6.0 years

4 - 8 Lacs

Kochi

Work from Office

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

Posted 1 week ago

Apply

3.0 - 7.0 years

0 Lacs

noida, uttar pradesh

On-site

You will be responsible for Database Object Creation and Maintenance, including creating and altering various DB2 objects such as Tablespaces, Tables, Stored procedures, Indexes, etc. Additionally, you will need to have knowledge and expertise on DB2 utility execution. Your role will involve Data load and migration tasks, such as understanding the data migration process from VSAM to DB2, unloading data from DB2 tables using UNLOAD utility, loading data from files to Tables using LOAD utility, unloading data from Image copy using UNLOAD or other utilities, and migrating data from one environment to another. Database backup and Recovery will be a crucial part of your responsibilities. This includes setting up and maintaining Image Copy and other DB2 housekeeping jobs, as well as being able to recover data from Image Copy using RECOVER utility. You will also manage Database access and security control by following security and audit control procedures to GRANT/REVOKE permissions on database objects, and providing Group level access on DB2 objects to RACF user groups. Supporting the Application team will be a key aspect of your role, which involves monitoring and troubleshooting batch job failures, handling and resolving all DB2 package related consistency token issues, and assisting the application team in resolving performance issues for the SQLs and/or Stored procedures. As part of Performance monitoring and tuning, you will be required to monitor current active and historical threads using DB2 monitoring tools, identify potential bottlenecks and lock contention in the active or historical threads, troubleshoot them, check overall Mainframe CPU utilization using SYSVIEW online panels, and perform SQL tuning by rewriting the SQLs or designing appropriate indexes. This is a Full-time position with benefits such as Paid time off, Provident Fund, and a Yearly bonus. The work schedule is Day shift, Monday to Friday, with the work location being in person at Noida.,

Posted 1 week ago

Apply

5.0 - 9.0 years

0 Lacs

punjab

On-site

As a Pentaho ETL Developer based in Sydney/Melbourne/Brisbane, your primary responsibilities will include designing, developing, automating, monitoring, and maintaining ETL jobs, batches, processes, and metadata for data transfer to and from various internal and external sources. You will be tasked with troubleshooting data issues, proposing, testing, and implementing solutions, as well as documenting technical requirements and solutions. Additionally, you will participate in design and code reviews, project planning, and ensuring accurate requirements fulfillment within an agile environment. Your qualifications for this role should include demonstrated experience with Pentaho ETL tools, software development, and proficiency in programming languages such as Java (Groovy), JavaScript, SQL, PL/pgSQL, and PL/SQL. Experience with the Pentaho Kettle tool, SQL optimization for platforms like PostgreSQL and Oracle, as well as familiarity with NoSQL databases like Cassandra will be advantageous. Knowledge of Kimball ETL architecture techniques, Unix/Linux operating systems, data integration tools, and scripting languages like bash, Python, or Perl is also required. You should possess excellent communication, analytical, and development skills, along with a strong understanding of real estate information systems standards and practices. Ideally, you will have at least 5 years of experience working in a data warehouse environment handling ETL processing, as well as knowledge of data warehouse and master data management concepts. Effective teamwork, adaptability to changing priorities, and customer-centric approach are key attributes for success in this role.,

Posted 1 week ago

Apply

7.0 - 11.0 years

0 Lacs

haryana

On-site

As a member of the Support organization at Oracle, your primary focus is to deliver post-sales support and solutions to the Oracle customer base, while also acting as an advocate for customer needs. Your responsibilities include resolving post-sales non-technical customer inquiries through various communication channels and addressing technical questions related to the use of and troubleshooting for Oracle's Electronic Support Services. You will serve as a key point of contact for customers, facilitating customer relationships with Support and providing guidance to internal Oracle employees on a wide range of customer situations and escalated issues. Oracle Customer Success Services (CSS) offers tailored support to ensure that organizations" investments in Oracle technology deliver cutting-edge innovation and performance necessary for competitive business environments, while seamlessly integrating within their IT infrastructure. CSS is renowned for its industry-leading expertise and commitment to customer satisfaction, supporting organizations at every step of their journey. To be successful in this role, you should have a minimum of 7 years of experience as an Oracle Database Administrator, Consultant, or Support Engineer. You must be available to work in a 24x7 capacity and possess expertise in installing, configuring, and administering Oracle Database/RAC versions 11g, 12c, and 19c. In addition, you should have in-depth knowledge of Oracle Database Architecture, RAC, and Performance Tuning, along with strong troubleshooting and performance tuning skills. Experience with database upgrades, patching, performance tuning of Oracle instances, and SQL tuning is essential. A degree in BE/BTech and/or MS in Computer Science or equivalent is preferred, and holding Oracle certifications in Database, Exadata, or OCI is a plus. Candidates with additional skills in PL SQL, SQL, Exadata, Goldengate, and Oracle Enterprise Manager (OEM) will be given preference. The role requires sharp technical troubleshooting abilities, a good understanding of support processes, and the capability to manage escalated technical situations, develop action plans, and proactively identify services that benefit customers. Strong analytical skills, effective communication, and customer management capabilities are essential for success in this position. Some travel may be necessary as part of the job responsibilities. As a Senior Systems Engineer, you will engage with customers" IT staff to resolve moderately complex technical issues related to Oracle products, either on-site or remotely. You are expected to work independently with general guidance from management while providing updates on progress and status. Oracle values inclusion and diversity, empowering employees to contribute to innovation and growth. The company offers a supportive work environment with competitive benefits, flexible medical, life insurance, and retirement options, and opportunities for global career development. If you require accessibility assistance or accommodation during the employment process due to a disability, please reach out to us via email at accommodation-request_mb@oracle.com or by calling +1 888 404 2494 in the United States.,

Posted 2 weeks ago

Apply

5.0 - 9.0 years

0 Lacs

chennai, tamil nadu

On-site

As a Mainframe DB2 Database Administrator, you will be responsible for installing, configuring, and upgrading DB2 database software and tools on mainframe systems. Your primary focus will be to ensure compatibility, performance, and security of the databases. You will create and manage DB2 databases, tablespaces, tables, indexes, and other database objects according to organizational standards and best practices. Your role will involve performing ongoing database maintenance activities such as backup and recovery, reorganization, space management, and health checks to uphold data integrity and availability. Monitoring database performance and resource utilization will be crucial, as you will proactively identify and resolve performance issues, tune SQL queries, and optimize database parameters. Database security will also be a key aspect of your responsibilities. You will implement and maintain database security policies, including roles and permissions, to ensure compliance with regulatory and data privacy standards. Planning and executing database migrations, upgrades, and patch installations in alignment with change management processes and business needs will be part of your duties. Collaboration with application developers, system administrators, and other stakeholders is essential to support database-related activities including development, testing, and production deployments. You will also be required to develop and maintain documentation, procedures, and standards for database administration tasks, including disaster recovery plans and high availability configurations. In addition, providing technical support and assistance to internal teams and users by troubleshooting and resolving DB2-related issues will be part of your daily tasks. It is important to stay current with emerging technologies, tools, and best practices in Mainframe DB2 administration, and actively contribute to knowledge sharing within the team. Required Experience: - Minimum of 5+ years of experience as a Mainframe DB2 DBA. Skills: - Mainframe - DB2 DBA - Backup Recovery - Performance and SQL Tuning - High Availability (HA) - Disaster Recovery (DR),

Posted 2 weeks ago

Apply

8.0 - 15.0 years

0 Lacs

karnataka

On-site

As a Database Performance Optimization Expert at Oracle Customer Success Services (CSS), you will play a crucial role in enabling customers to thrive with Oracle's world-class technology. Your primary responsibility will be to provide deep technical expertise to address complex database performance issues, particularly focusing on critical workloads. You will engage directly with enterprise customers, acting as a trusted advisor and technical point of contact during Hyper Care engagements. Your day-to-day tasks will involve identifying performance bottlenecks by leveraging tools such as AWR, SQL Plan analysis, and indexing strategies. You will be expected to optimize query performance, address I/O issues, and resolve resource contention scenarios. Collaboration with product teams will be essential to drive long-term database health and ensure high levels of customer satisfaction. To excel in this role, you must possess a strong command of Oracle Database, PL/SQL, and SQL Tuning. Additionally, a deep understanding of Exadata architecture and optimization techniques is crucial. Hands-on experience with performance tools like AWR, SQL Plans, and Index tuning is a must. Excellent communication skills and the ability to work autonomously in critical project phases are also key requirements. While not mandatory, experience with Oracle Cloud Infrastructure (OCI) and familiarity with the Oracle Product Development lifecycle and Customer Success model would be advantageous. Exposure to emerging trends in database optimization and cloud performance is also considered a plus. Joining Oracle CSS offers you the opportunity to work on the most critical workloads for Oracle's top-tier customers. You will collaborate with global teams and cutting-edge tech stacks while being closely integrated with Oracle Product Engineering. By excelling in this role, you will make a visible impact on customer satisfaction and retention. If you are passionate about database performance optimization and want to be part of a team that is shaping the future of data performance, we encourage you to apply now or refer someone in your network who would be a great fit for this position. Join us in building the future of data performance together at Oracle CSS. #OracleCareers #DatabaseJobs #PerformanceTuning #OracleSQL #Exadata #OCI #CustomerSuccess #SQLTuning #HiringNow #IndiaJobs,

Posted 2 weeks ago

Apply

3.0 - 7.0 years

0 Lacs

noida, uttar pradesh

On-site

As a PL/SQL Developer at our organization, you will have the opportunity to work for one of the largest multi-national banks, focusing on the Supply Chain Finance domain. Our team is dedicated to enhancing the existing platform to meet the evolving business requirements in alignment with industry trends. The application you will be working on is a global solution spanning across multiple regions and countries, emphasizing the importance of functionality and technical expertise. Your primary responsibilities will include understanding requirements from the Functional Team, estimating development efforts, and developing functionalities based on the Agile/Water-Scrum-Fall model. Additionally, you will play a crucial role in optimizing queries for performance and volume handling, as well as assisting in defect fixes during various testing phases. To excel in this role, you should possess a Computer Science-based graduation, along with at least 3 years of experience in software development. Your proficiency in Oracle SQL, PL/SQL, analytical functions, and data modeling will be essential. Experience in the Banking Domain and knowledge of UNIX will be advantageous for this position. As an ideal candidate, you should have hands-on experience in writing Oracle queries, stored procedures, and packages, ensuring they are performance-oriented and capable of handling high volumes. Your willingness to learn new tools as per project requirements and exposure to Agile methodologies will further enhance your suitability for this role. Joining our development team, you will be responsible for understanding business requirements, estimating development efforts, developing functionalities, writing optimized queries, and contributing to code reviews. Your role will also involve assisting in defect fixes across various testing phases and suggesting enhancements for flexibility and scalability in the existing design/code. If you meet the filtration criteria of having 3+ years of experience in Oracle SQL, PL/SQL development, and a focus on pure development experience with expertise in query fine-tuning, we encourage you to apply for this position and be part of our innovative and inclusive workforce.,

Posted 2 weeks ago

Apply

3.0 - 8.0 years

0 Lacs

karnataka

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. EY-Consulting Advanced PL/SQL - Technical Consultant The opportunity We're looking for a PLSQL Technical Consultant to join the leadership group of our Consulting Team. This is a fantastic opportunity to be part of a leading firm while being instrumental in the growth of a new service offering. Your Key Responsibilities - Support client needs in Oracle application development/support using Advanced PL/SQL - Proactive with a solution-oriented mindset, ready to learn new technologies for client requirements - Working knowledge of a source code control system - Interact with senior leaders, understand their business goals, and contribute to the delivery of the workstreams Skills And Attributes For Success - SQL Concepts: Group By / Joins / Surrogate Keys / Constraints / Datatypes / Indexes - Experience in designing and developing Oracle objects such as Experience with SQL queries (Scalar subqueries, inline views, outer joins, hints, and analytic functions) - Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views, Collections, and Exception handling for retrieving, manipulating, checking, and migrating complex datasets in Oracle - Experience in SQL tuning and optimization using explain plan and SQL trace files - Partitioning, Hints, and Indexing strategy for optimal performance - Experience in Direct Load & Conventional Load using SQL Loader - Should have a good understanding of Oracle Database Architecture - Prior consulting experience preferred To qualify for the role, you must have - Computer Science degree or equivalent - 3 to 8 years of development experience - Strong analytical and debugging skills - Good understanding of advanced PL/SQL and performance tuning - Should have a positive and learning attitude, Good Communication, Strong Analytical skills What Working At EY Offers At EY, we're dedicated to helping our clients, from startups to Fortune 500 companies, and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer: - Support, coaching, and feedback from some of the most engaging colleagues around - Opportunities to develop new skills and progress your career - The freedom and flexibility to handle your role in a way that's right for you EY | Building a better working world EY exists to build a better working world, helping to create long-term value for clients, people, and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help 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 2 weeks ago

Apply

5.0 - 9.0 years

0 Lacs

chennai, tamil nadu

On-site

At EY, you 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 yourself. Your unique voice and perspective are essential to help EY become even better. Join us to build an exceptional experience for yourself and contribute to creating a better working world for all. As a Senior Aera Developer, you will be a part of the Supply Chain Tech group of EY GDS consulting Team. Your role involves translating business needs into technical specifications, performing data analysis and manipulation, and simplifying business concepts through data modeling. You will be responsible for developing reporting systems, writing/customizing code in various Aera modules, and evaluating and improving Aera Skills. Additionally, you will generate quality reports, develop data visualizations, and work with clients throughout the implementation lifecycle. To succeed in this role, you must have experience as an Aera Skill Builder, expertise in BI reporting and data warehouse concepts, strong data modeling skills, and proficiency in Aera skill builder modules. You should be skilled in creating dynamic visualizations, configuring Aera skills, applying security concepts, and handling report performance and administration. Aera Skill Builder and Aera Architect certification is required. Ideal candidates will have a strong knowledge of Aera Skill Build concepts, expertise in data handling, experience in SQL tuning and optimization, and the ability to interact with customers to understand business requirements. Good communication skills, problem-solving abilities, and a proactive approach to learning new technologies are also important. In this role, you will drive Aera Skill Development tasks and have the opportunity to work with a market-leading, multi-disciplinary team. EY offers a supportive environment, coaching, and feedback from engaging colleagues, opportunities for skills development and career progression, and the freedom to handle your role in a way that suits you. EY is committed to building a better working world by creating long-term value for clients, people, and society, and by fostering trust in the capital markets. Through the expertise of diverse teams worldwide, EY provides trust, assurance, and support for clients to grow, transform, and operate effectively across various industries.,

Posted 2 weeks ago

Apply

5.0 - 9.0 years

0 Lacs

karnataka

On-site

You are a passionate and experienced Oracle ERP Techno-Functional Consultant/Architect who will be responsible for driving the implementation and optimization of critical Oracle ERP solutions in financials, supply chain, and HCM. You will lead complex Oracle Cloud and EBS initiatives contributing to the digital transformation of a dynamic global enterprise. Your key responsibilities will include leading technical delivery for Oracle ERP implementations, designing and implementing scalable solutions across modules, developing integrations using Oracle Integration Cloud and various technologies, delivering reporting solutions, handling technical upgrades and data migrations, collaborating with stakeholders to translate requirements into technical designs, and managing customization and performance tuning. To excel in this role, you should have at least 5 years of hands-on experience with Oracle ERP, expertise in Oracle Cloud Integration, PL/SQL, SQL Tuning, BI/OTBI, ADF, VBCS, SOAP/REST APIs, Oracle Workflow & Personalization, and proven experience leading full-cycle ERP implementations. You should also possess a strong technical architecture background, stakeholder management skills, and familiarity with relevant tools. Additional qualifications such as Oracle Certifications, experience in industries like healthcare, manufacturing, or retail, exposure to Taleo integrations and HCM Extracts would be a bonus. By joining our team, you will be at the forefront of enterprise-wide ERP transformation initiatives, working with seasoned professionals and solution architects, leading global projects, mentoring teams, and benefiting from competitive salary, upskilling programs, and long-term growth opportunities. If you are ready to shape the future of ERP solutions and build smarter, faster, and future-ready systems in Bangalore, apply now and be part of our exciting journey.,

Posted 2 weeks ago

Apply

3.0 - 8.0 years

14 - 16 Lacs

Kolkata, Mumbai, New Delhi

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+ 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. Career Level - IC2 Covered under Job Description

Posted 2 weeks ago

Apply

3.0 - 8.0 years

14 - 16 Lacs

Kolkata, Mumbai, New Delhi

Work from Office

Junior consulting position for those who are continuing to develop their expertise. Receives general instruction on routine work and detailed instruction on new projects or assignments. Career Level - IC1 Career Level - IC1 As a member of a project team, follows standard practices and procedures to analyze situations/data and provide quality work products to deliver functional and technical solutions on applications and technology installations. Work involves some problem solving with assistance and guidance in understanding and applying relevant Oracle methodologies and practices. Implements Oracle products and technology in various industries to meet customer specifications.

Posted 2 weeks 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 2 weeks ago

Apply
Page 1 of 5
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