54 Sql Optimization Jobs - Page 2

We are looking for an experienced and results-driven Oracle OBIEE/BIP Developer to join our team. The ideal candidate will have solid experience in Oracle Business Intelligence tools (OBIEE 12c and BIP), strong expertise in SQL and database structures, and hands-on exposure to designing and optimizing reports and dashboards. This role involves end-to-end report development, performance tuning, reconciliation validation, and production support for reporting environments. Key Responsibilities: Design, develop, and unit test OBIEE/BIP reports, dashboards, and ad hoc analyses Perform maintenance of OBIEE RPD, web catalog, and data layer components Schedule and manage reports using OBIEE/BIP tools Optimize and troubleshoot Oracle SQL queries for performance Design reconciliation models and conduct report-to-report comparison/validation Collaborate with ETL and application teams to resolve data/reporting issues Assist with report testing, data validation, and issue resolution Handle production support activities, including bug fixes and data source validation Manage scheduler/admin functions and connection configurations in OBIEE/BIP Communicate effectively with business users and stakeholders Required Skills: Proficiency in Oracle OBIEE 12c : BIP Reports, Dashboards, Analyses, RPD, Web Catalog, Scheduling Strong SQL knowledge: queries, views, functions, procedures Experience in SQL performance tuning and debugging Understanding of reconciliation models and validation techniques Strong communication skills (written and verbal) for end-user and cross-team interaction Secondary/Preferred Skills: Familiarity with OBIEE/BIP scheduler and administration tools Knowledge of connection/session management Exposure to ETL pipelines and data integration processes Work Type: Hybrid Candidate must be currently located in or willing to relocate to Bangalore, Hyderabad, or Noida

SQL Server database administrator, with 3+ years on SQL Server 2005, 2008 and 2008 R2, 2012, 2014, 2016, 2017, 2019 and 2022. Experience in supporting SQL Server IaaS and PaaS, AWS and Azure Clouds. Experience in administrating other database services like SSAS, SSIS and SSRS. Experience in installing different SQL server versions as per customer requirement. Experience in Upgrading and Migrating databases from lower to higher versions. Experience in applying latest patches (SPCUGDRHotfixes) to fix vulnerabilities and strong troubleshooting skills on resolving patching issues. Well versed in database performance tuning, especially SQL tuning. Knowledge on Windows cluster will be plus and Experience in MSSQL cluster environments (Active-Active or Active-Passive). Supported SQL Server on LinuxWindows both migrations and on-going support. Experience in handling HADR environments (Log Shipping, ReplicationCDC, Mirroring and AOAG). Need strong troubleshooting skills on SQL Server Always on Availability Group and Replication issues. Skilled in Backups & Disaster Recovery. Knowledge on Backup tools (Eg: CommVault, Semantic NetBackup, LiteSpeed) will be plus. Strong experience in Automating DB tasks, Health checks, blocking ,disk space ,Maintenance tasks etc. Experience in PowerShell scripting automation will be plus. 24 X 7 production support experience. Knowledge of Windows Server 2003R2 and later editions. Working knowledge in T-SQL, BCP, DTS and SSIS development. Any cloud Architecture certification is preferable. Knowledge and Hands-on expertise on Sybase, Postgre SQL, My SQL and Mongo DB would be additional value addition. Duties and responsibilities: SQL Server Database Administration. Microsoft SQL Server - (Version 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, 2019). Database support, monitoring, troubleshooting, planning, and migration. Transact-SQL (T-SQL). Performance Tuning. SQL Azure. SQL Server Integration Services (SSIS).

Description We are seeking an experienced SQL Developer to join our team in India. The ideal candidate will have a strong background in database design, SQL programming, and performance optimization to support our data-driven projects. Responsibilities Designing and implementing SQL database solutions Developing complex SQL queries and stored procedures Optimizing database performance and scalability Collaborating with developers and stakeholders to define database requirements Performing data analysis and reporting using SQL Ensuring data integrity and security within the database Troubleshooting and resolving database issues Creating and maintaining documentation for database systems Skills and Qualifications 5-15 years of experience in SQL development Strong knowledge of relational database management systems (RDBMS) such as MySQL, SQL Server, or Oracle Proficiency in writing complex SQL queries, stored procedures, and functions Experience with database performance tuning and optimization techniques Understanding of database design principles and normalization Familiarity with data modeling and ETL processes Ability to work with large datasets and perform data analysis Excellent problem-solving skills and attention to detail Strong communication and collaboration skills

Design and maintain Azure-based APIs and integration solutions using Logic Apps, Functions, and API Management. Required Candidate profile 5–10 yrs in C#, .NET, REST APIs, Azure Integration. Team collaboration & system design experience.

Overview As a data engineering lead, you will be the key technical expert overseeing PepsiCo's data product build & operations and drive a strong vision for how data engineering can proactively create a positive impact on the business. You'll be empowered to create & lead a strong team of data engineers who build data pipelines into various source systems, rest data on the PepsiCo Data Lake, and enable exploration and access for analytics, visualization, machine learning, and product development efforts across the company. Responsibilities Act as a subject matter expert across different digital projects. Oversee work with internal clients and external partners to structure and store data into unified taxonomies and link them together with standard identifiers. Manage and scale data pipelines from internal and external data sources to support new product launches and drive data quality across data products. Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality and performance. Responsible for implementing best practices around systems integration, security, performance, and data management. Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape. Collaborate with internal clients (data science and product teams) to drive solutioning and POC discussions. Evolve the architectural capabilities and maturity of the data platform by engaging with enterprise architects and strategic internal and external partners. Develop and optimize procedures to productionalize data science models. Define and manage SLAs for data products and processes running in production. Support large-scale experimentation done by data scientists. Prototype new approaches and build solutions at scale. Research in state-of-the-art methodologies. Create documentation for learnings and knowledge transfer. Create and audit reusable packages or libraries. Qualifications 7+ years of overall technology experience that includes at least 5+ years of hands-on software development, data engineering, and systems architecture. 4+ years of experience with Data Lake Infrastructure, Data Warehousing, and Data Analytics tools. 4+ years of experience in SQL optimization and performance tuning, and development experience in programming languages like Python, PySpark, Scala etc.). 2+ years in cloud data engineering experience in Azure. Fluent with Azure cloud services. Azure Certification is a plus. Experience in Azure Log Analytics Experience with integration of multi cloud services with on-premises technologies. Experience with data modelling, data warehousing, and building high-volume ETL/ELT pipelines. Experience with data profiling and data quality tools like Apache Griffin, Deequ, and Great Expectations. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets. Experience with at least one MPP database technology such as Redshift, Synapse or Snowflake. Experience with running and scaling applications on the cloud infrastructure and containerized services like Kubernetes. Experience with version control systems like Github and deployment & CI tools. Experience with Azure Data Factory, Azure Databricks and Azure Machine learning tools. Experience with Statistical/ML techniques is a plus. Experience with building solutions in the retail or in the supply chain space is a plus. Understanding of metadata management, data lineage, and data glossaries is a plus. Working knowledge of agile development, including DevOps and DataOps concepts. Familiarity with business intelligence tools (such as PowerBI). B Tech/BA/BS in Computer Science, Math, Physics, or other technical fields.

Description We are seeking an experienced SQL Developer to join our team in India. The ideal candidate will have 5-15 years of experience in SQL development, with a strong focus on optimizing database performance and ensuring data integrity. Responsibilities Develop and maintain SQL queries and procedures to support business applications. Optimize SQL queries for performance improvements and efficiency. Create and manage database schemas, tables, and relationships. Collaborate with software developers and data analysts to gather requirements and deliver data solutions. Troubleshoot database issues and provide support to end-users as needed. Ensure data integrity and security across all databases. Skills and Qualifications Proficient in SQL and PL/SQL. Strong understanding of database design and normalization principles. Experience with SQL Server, MySQL, or Oracle databases. Ability to write complex queries, stored procedures, and triggers. Knowledge of data warehousing concepts and ETL processes. Familiarity with database performance tuning and optimization techniques. Strong analytical and problem-solving skills. Excellent communication and teamwork abilities.

Core Technical Skills: Design and develop robust backend solutions using Java 11+/17 and Spring Boot. Build, test, and maintain scalable microservices in a cloud environment (AWS). Work with Kafka or other messaging systems for event-driven architecture. Write clean, maintainable code with high test coverage using. Tools & Reporting: Java 11+/17, SpringBoot, AWS, Kafta Soft Skills: Strong communication, coordination with app teams Analytical thinking and problem-solving Ability to work independently or collaboratively Snowflake architecture & performance tuning, Oracle DB, SQL optimization, Data governance, RBAC, Data replication, Time Travel & Cloning, Dynamic data masking, OEM & AWR reports, Apps DBA experience.

Job Type: C2H (Long Term) Required Skill Set: Core Technical Skills: Snowflake database design, architecture & performance tuning Strong experience in Oracle DB and SQL query optimization Expertise in DDL/DML operations, data replication, and failover handling Knowledge of Time Travel, Cloning, and RBAC (Role-Based Access Control) Experience with dynamic data masking, secure views, and data governance Tools & Reporting: Familiarity with OEM, Tuning Advisor, AWR reports Soft Skills: Strong communication, coordination with app teams Analytical thinking and problem-solving Ability to work independently or collaboratively Additional Experience: Previous role as Apps DBA or similar Exposure to agile methodologies Hands-on with Snowflake admin best practices, load optimization, and secure data sharing.

We are seeking an experienced Amazon Redshift Developer / Data Engineer to design, develop, and optimize cloud-based data warehousing solutions. The ideal candidate should have expertise in Amazon Redshift, ETL processes, SQL optimization, and cloud-based data lake architectures. This role involves working with large-scale datasets, performance tuning, and building scalable data pipelines. Key Responsibilities: Design, develop, and maintain data models, schemas, and stored procedures in Amazon Redshift. Optimize Redshift performance using distribution styles, sort keys, and compression techniques. Build and maintain ETL/ELT data pipelines using AWS Glue, AWS Lambda, Apache Airflow, and dbt. Develop complex SQL queries, stored procedures, and materialized views for data transformations. Integrate Redshift with AWS services such as S3, Athena, Glue, Kinesis, and DynamoDB. Implement data partitioning, clustering, and query tuning strategies for optimal performance. Ensure data security, governance, and compliance (GDPR, HIPAA, CCPA, etc.). Work with data scientists and analysts to support BI tools like QuickSight, Tableau, and Power BI. Monitor Redshift clusters, troubleshoot performance issues, and implement cost-saving strategies. Automate data ingestion, transformations, and warehouse maintenance tasks. Required Skills & Qualifications: 6+ years of experience in data warehousing, ETL, and data engineering. Strong hands-on experience with Amazon Redshift and AWS data services. Expertise in SQL performance tuning, indexing, and query optimization. Experience with ETL/ELT tools like AWS Glue, Apache Airflow, dbt, or Talend. Knowledge of big data processing frameworks (Spark, EMR, Presto, Athena). Familiarity with data lake architectures and modern data stack. Proficiency in Python, Shell scripting, or PySpark for automation. Experience working in Agile/DevOps environments with CI/CD pipelines.

Overview As a member of the data engineering team, you will be the key technical expert developing and overseeing PepsiCo's data product build & operations and drive a strong vision for how data engineering can proactively create a positive impact on the business. You'll be an empowered member of a team of data engineers who build data pipelines into various source systems, rest data on the PepsiCo Data Lake, and enable exploration and access for analytics, visualization, machine learning, and product development efforts across the company. As a member of the data engineering team, you will help lead the development of very large and complex data applications into public cloud environments directly impacting the design, architecture, and implementation of PepsiCo's flagship data products around topics like revenue management, supply chain, manufacturing, and logistics. You will work closely with process owners, product owners and business users. You'll be working in a hybrid environment with in-house, on-premise data sources as well as cloud and remote systems. Responsibilities Be a founding member of the data engineering team. Help to attract talent to the team by networking with your peers, by representing PepsiCo HBS at conferences and other events, and by discussing our values and best practices when interviewing candidates. Own data pipeline development end-to-end, spanning data modeling, testing, scalability, operability and ongoing metrics. Ensure that we build high quality software by reviewing peer code check-ins. Define best practices for product development, engineering, and coding as part of a world class engineering team. Collaborate in architecture discussions and architectural decision making that is part of continually improving and expanding these platforms. Lead feature development in collaboration with other engineers; validate requirements / stories, assess current system capabilities, and decompose feature requirements into engineering tasks. Focus on delivering high quality data pipelines and tools through careful analysis of system capabilities and feature requests, peer reviews, test automation, and collaboration with other engineers. Develop software in short iterations to quickly add business value. Introduce new tools / practices to improve data and code quality; this includes researching / sourcing 3rd party tools and libraries, as well as developing tools in-house to improve workflow and quality for all data engineers. Support data pipelines developed by your teamthrough good exception handling, monitoring, and when needed by debugging production issues. Qualifications 6-9 years of overall technology experience that includes at least 5+ years of hands-on software development, data engineering, and systems architecture. 4+ years of experience in SQL optimization and performance tuning Experience with data modeling, data warehousing, and building high-volume ETL/ELT pipelines. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets. Experience with data profiling and data quality tools like Apache Griffin, Deequ, or Great Expectations. Current skills in following technologies Python Orchestration platformsAirflow, Luigi, Databricks, or similar Relational databasesPostgres, MySQL, or equivalents MPP data systemsSnowflake, Redshift, Synapse, or similar Cloud platformsAWS, Azure, or similar Version control (e.g., GitHub) and familiarity with deployment, CI/CD tools. Fluent with Agile processes and tools such as Jira or Pivotal Tracker Experience with running and scaling applications on the cloud infrastructure and containerized services like Kubernetes is a plus. Understanding of metadata management, data lineage, and data glossaries is a plus.

What PepsiCo Data Management and Operations does: Maintain a predictable, transparent, global operating rhythm that ensures always-on access to high-quality data for stakeholders across the company. Responsible for day-to-day data collection, transportation, maintenance/curation, and access to the PepsiCo corporate data asset Work cross-functionally across the enterprise to centralize data and standardize it for use by business, data science or other stakeholders. Increase awareness about available data and democratize access to it across the company. As a Data Engineering Associate Manager, you will be the key technical expert overseeing PepsiCo's data product build & operations and drive a strong vision for how data engineering can proactively create a positive impact on the business. You'll be empowered to create & lead a strong team of data engineers who build data pipelines into various source systems, rest data on the PepsiCo Data Lake, and enable exploration and access for analytics, visualization, machine learning, and product development efforts across the company. As a member of the data engineering team, you will help lead the development of very large and complex data applications into public cloud environments directly impacting the design, architecture, and implementation of PepsiCo's flagship data products around topics like revenue management, supply chain, manufacturing, and logistics. You will work closely with process owners, product owners and business users. You'll be working in a hybrid environment with in-house, on-premises data sources as well as cloud and remote systems. Responsibilities Provide leadership and management to a team of data engineers, managing processes and their flow of work, vetting their designs, and mentoring them to realize their full potential. Act as a subject matter expert across different digital projects. Overseework with internal clients and external partners to structure and store data into unified taxonomies and link them together with standard identifiers. Manage and scale data pipelines from internal and external data sources to support new product launches and drive data quality across data products. Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality and performance. Responsible for implementing best practices around systems integration, security, performance, and data management. Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape. Collaborate with internal clients (data science and product teams) to drive solutioning and POC discussions. Evolve the architectural capabilities and maturity of the data platform by engaging with enterprise architects and strategic internal and external partners. Develop and optimize procedures to productionalize data science models. Define and manage SLAs for data products and processes running in production. Support large-scale experimentation done by data scientists. Prototype new approaches and build solutions at scale. Research in state-of-the-art methodologies. Create documentation for learnings and knowledge transfer. Create and audit reusable packages or libraries. Qualifications B.Tech in Computer Science, Math, Physics, or other technical fields. 11+ years of overall technology experience that includes at least 5+ years of hands-on software development, data engineering, and systems architecture. 4+ years of experience with Data Lake Infrastructure, Data Warehousing, and Data Analytics tools. 4+ years of experience in SQL optimization and performance tuning, and development experience in programming languages like Python, PySpark, Scala etc.). 2+ years in cloud data engineering experience in Azure. Fluent with Azure cloud services. Azure Certification is a plus. Experience in Azure Log Analytics Experience with integration of multi cloud services with on-premises technologies. Experience with data modelling, data warehousing, and building high-volume ETL/ELT pipelines. Experience with data profiling and data quality tools like Apache Griffin, Deequ, and Great Expectations. Experience building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets. Experience with at least one MPP database technology such as Redshift, Synapse or Snowflake. Experience with running and scaling applications on the cloud infrastructure and containerized services like Kubernetes. Experience with version control systems like Github and deployment & CI tools. Experience with Azure Data Factory, Azure Databricks and Azure Machine learning tools. Experience with Statistical/ML techniques is a plus. Experience with building solutions in the retail or in the supply chain space is a plus. Understanding of metadata management, data lineage, and data glossaries is a plus. Working knowledge of agile development, including DevOps and DataOps concepts. Familiarity with business intelligence tools (such as PowerBI).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).

SQL Query T SQL - functions and package SQL Optimization and Performance improvement Knowledge of data warehousing concepts (Star Schema, Fact and dimension tables) Experience in SQL Server, SSIS SSIS Development Experience on data loads SQL Servers Total experience. SSIS Package configuration and optimization. ETL xfr, error handling, data flow components, script components, debugging. Input files : XML, CSV, flat, json Installation, backup, db setting, configurations Strong SQL Skills (Joins, subqueries, Aggregations, Window functions).