707 Query Optimization Jobs - Page 15

Manage and maintain Microsoft SQL Server databases, ensuring performance, availability, and security. You will perform backups, optimize queries, and troubleshoot database issues. Expertise in SQL Server, T-SQL, and database administration practices is required.

Design, develop, and maintain PL/SQL code for efficient data management and integration with Oracle databases. You will write complex SQL queries, optimize database performance, and ensure data integrity. Experience in PL/SQL development, Oracle databases, and query optimization is essential.

3-5 years of experience in MySQL database development and administration. Strong knowledge of relational database concepts, design, and indexing. Expertise in SQL query optimization and performance tuning. Deep understanding of database security best practices and encryption methods. Experience with ETL processes and tools. Ability to write complex SQL queries, stored procedures, and functions. Strong problem-solving skills, attention to detail, and the ability to work independently or within a team. Excellent communication skills for cross-functional collaboration. Bachelors degree in Computer Science, Information Technology, or a related field. Certification in MySQL administration and knowledge of Oracle or PostgreSQL is a plus! If youre looking to take your career to the next level, apply now and become part of a dynamic and innovative team!

Employee type : CTH Primary Skills - Expert in BI tools like Microstrategy and Tableau with minimum 8 years of experience Secondary Skills Able to lead a team of BI experts and provide technical solution to BI tool reporting requirements Should have Over 6+years of IT experience in Analysis, Design, Development, Implementation, Reporting, Testing and Visualization of Business Intelligence Tools. Extensive Knowledge in creating data visualizations using BI Tools Desktops and regularly publishing and presenting dashboards. Familiar with SQL Concepts SQL tables, Views, indexes, joins, writing stored procedures and query optimization, performance tuning etc. Able to generate reports using BI Tools to analyse data from multiple data sources like Oracle, SQL Server, Excel, Hive and Tera data. Good knowledge on various BI Tools functionalities like Tableau Extracts, Parameters, Trends, Hierarchies, Sets, Groups, Data Blending and joins etc. Able to develop various customized charts. Work extensively with Actions, Calculations, Parameters, Background images, Maps, Trend lines, LOD functions and Table Calculations. Able to generate Context filters, Extract and Data Source filters while handling huge volume of data. Hands on building Groups, hierarchies, Sets and create detail level summary reports and Dashboard using KPIs. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Handling User onboarding activities under BI tools and various servers. Able to manage User groups and access relative activities in BI Tools and tableau server. Ability to handle the data security. experience in SharePoint with min 2+ year experience on office 365 / SharePoint online , Hands on experience 3+ years of relevant experience in SharePoint with minerience on office 365 / SharePoint online , Hands on experience in coding using Angular, HTML, JavaScript, CSS, React JS, SPFx, and RES

Notice Period: Immediate Joiners or within 15 days Employee type : Contract Should have Over 6+years of IT experience in Analysis, Design, Development, Implementation, Reporting, Testing and Visualization of Business Intelligence Tools . Extensive Knowledge in creating data visualizations using BI Tools Desktops and regularly publishing and presenting dashboards. Familiar with SQL Concepts SQL tables, Views, indexes, joins, writing stored procedures and query optimization, performance tuning etc. Able to generate reports using BI Tools to analyse data from multiple data sources like Oracle, SQL Server, Excel, Hive and Tera data. Good knowledge on various BI Tools functionalities like Tableau Extracts, Parameters, Trends, Hierarchies, Sets, Groups, Data Blending and joins etc. Able to develop various customized charts. Work extensively with Actions, Calculations, Parameters, Background images, Maps, Trend lines, LOD functions and Table Calculations. Able to generate Context filters, Extract and Data Source filters while handling huge volume of data. Hands on building Groups, hierarchies, Sets and create detail level summary reports and Dashboard using KPIs. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Handling User onboarding activities under BI tools and various servers. Able to manage User groups and access relative activities in BI Tools and tableau server. Ability to handle the data security. Good knowledge in Banking domain Experience and Expertise in developing Test Harness in J2SE Experience in Continuous Integration Tool Jenkins / Hudson Experience / Knowledge in Version Control systems like Git , CVS, Subversion, etc Experience in writing SQLs / PL-SQL Good knowledge in shell scripting & Unix commands

We are looking immediatefor SnowflakeDataWarehouse Engineers_ Contract_ Chennai:Snowflake Data Warehouse Engineers5+yearsChennaiPeriodImmediateTypeContractDescription:- We need an experienced, collaborative Snowflake Data Warehouse Engineers with 5+ Yrs of experience in developing Snowflake data models, data ingestion, views, Stored procedures, complex queries Good experience in SQL Experience in Informatica Powercenter / IICS ETL tools Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions Provide production support for Data Warehouse issues such data load problems, transformation translation problems Ability to facilitate and coordinate discussion and to manage expectations of multiple stakeholders Candidate must have good communication and facilitation skills Work in an onsite-offshore model involving daily interactions with Onshore teams to ensure on-time quality deliverables

Roles and Responsibilities Design, develop, test, and deploy complex PL/SQL programs using Oracle SQL. Develop stored procedures, functions, and packages to meet business requirements. Optimize database queries for performance tuning and efficiency. Strong experience in developing applications using Oracle APEX. Perferred : immediate joiner / 15 days of notice period

Project description Luxoft DXC Technology Company is an established company focusing on consulting and implementation of complex projects in the financial industry. At the interface between technology and business, we convince with our know-how, well-founded methodology and pleasure in success. As a reliable partner to our renowned customers, we support them in planning, designing and implementing the desired innovations. Together with the customer, we deliver top performance! For one of our Client in the Insurance Segment, we are searching for a Senior Mainframe Developer. Responsibilities Essential Job Functions: Design and Development Mainframe batch support Resource should be comfortable with On-Call Support and Week-End Release support. Incident & Outage management Develop code for Reporting, Defect & Enhancement Hands on experience with JCL, COBOL, CICS, DB2, VSAM and mainframe utilities are mandatory. Drive the Kanban, Daily Standup, co-ordination meetings with respective stakeholders. Analytical, problem solving, creative thinking and design skills Skills Must have Strong Mainframe skills with minimum 7+ years of experience Experience in developing design, develop, test, debug, and maintain mainframe applications using COBOL programming language 3.Utilize VSAM (Virtual Storage Access Method) for efficient data access and management. 4.Interact with databases using DB2, including SQL query optimization and performance tuning. 5.Utilize tools such as File-AID for data manipulation, browsing, and editing. 6.Write and execute SQL queries using SPUFI for data retrieval and manipulation. 7.Collaborate with cross-functional teams to analyze requirements, design solutions, and implement changes. Nice to have Insurance domain experience. Other Languages EnglishC1 Advanced Seniority Senior

We are seeking a skilled Database Specialist with strong expertise in Time-Series Databases, specifically Loki for logs, InfluxDB, and Splunk for metrics. The ideal candidate will have a solid background in query languages, Grafana, Alert Manager, and Prometheus. This role involves managing and optimizing time-series databases, ensuring efficient data storage, retrieval, and visualization. Key Responsibilities: Design, implement, and maintain time-series databases using Loki, InfluxDB, and Splunk to store and manage high-velocity time-series data. Develop efficient data ingestion pipelines for time-series data from various sources (e.g., IoT devices, application logs, metrics). Optimize database performance for high write and read throughput, ensuring low latency and high availability. Implement and manage retention policies, downsampling, and data compression strategies to optimize storage and query performance. Collaborate with DevOps and infrastructure teams to deploy and scale time-series databases in cloud or on-premise environments. Build and maintain dashboards and visualization tools (e.g., Grafana) for monitoring and analyzing time-series data. Troubleshoot and resolve issues related to data ingestion, storage, and query performance. Work with development teams to integrate time-series databases into applications and services. Ensure data security, backup, and disaster recovery mechanisms are in place for time-series databases. Stay updated with the latest advancements in time-series database technologies and recommend improvements to existing systems. Key Skills: Strong expertise in Time-Series Databases with Loki (for logs), InfluxDB, and Splunk (for metrics).

Resource with 3-6 years of experience in SAP Data migration. (B2/B3 Band preferable). ADM (Syniti Tool) knowledge is preferred, Knowledge on other ETL tools is an advantage. Knowledge of SQL & PLSQL queries is mandatory. Good Knowledge of Data migration concept from the requirement to the end of the load in SAP. Sound knowledge in Data analysis, Profiling, Cleaning, Visualization, transformation, Conversion, and implementation. Good functional understanding - SAP Material Master and Finance. Having sound knowledge of the SAP LSMW Program and ABAP. Should be able to debug ABAP programs. Sound knowledge of Loading Methods in SAP and Interface.

We are looking for a talented and experienced PL/SQL Developer to join our team. The ideal candidate should have a strong foundation in Oracle PL/SQL programming , excellent problem-solving skills, and the ability to manage and support applications through their full lifecycle. Key Responsibilities: Design, code, test, and debug Oracle PL/SQL programs including packages, procedures, triggers, and functions Optimize and tune complex SQL queries and PL/SQL blocks for performance Perform code reviews , root cause analysis, and issue resolution in production environments Participate in requirement analysis , technical documentation, and system design Collaborate with cross-functional teams for development and support Maintain and enhance existing PL/SQL applications and scripts Provide L2/L3 application support , manage incidents and changes Work within Agile/Scrum framework and contribute to sprint goals Support deployment, risk mitigation, and project flow coordination Required Qualifications: Bachelor's/Masters degree in Computer Science, IT, or relevant discipline 6–10 years of hands-on experience with PL/SQL and Oracle databases Strong in SQL tuning , debugging, and exception handling Exposure to Unix/Linux environment and shell scripting is a plus Experience in SDLC, Agile methodologies , and version control systems Good communication, documentation, and client interaction skills

Key Responsibilities: Client Engagement Team Management Project Planning and Execution Solution Development Technical Leadership Advanced Database and System Knowledge Documentation and Reporting Requirements Proven experience as a Project Manager, with a strong technical background. Hands-on expertise with Shopify Plus, including APIs, customizations, and integrations. Proficiency in no-code/low-code tools, such as: n8n, Make.com, Glide, Bubble, Airtable, Zapier, Retool, and Appgyver. Strong knowledge of programming languages (e.g., JavaScript, Python, or similar) for troubleshooting and development. Advanced database expertise, including: Designing and managing complex databases. Query optimization and handling large-scale datasets. Familiarity with task management tools (e.g., Trello, Asana, Jira) and agile methodologies.

Req ID: 324434 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Systems Integration Advisor to join our team in Bengaluru, Karn taka (IN-KA), India (IN). Job Title: API Developer (JAVA | Spring Boot| Rest & GraphQL) About the role: We are looking for a passionate and experienced API Developer to join our backend engineering team. In this role, you will play a critical part in designing and implementing robust APIs and microservices. You will work with cutting-edge tech stack including Spring Boot and Java 8+ (Java17 preferred) GraphQL, Docker and Kubernetes. In this role you ll be responsible for building clean, testable and efficient code, contributing to architecture decisions and supporting full lifecycle development from concept to development. Required Skills: Java 8+ (preferred java 17) Strong backend development experience using Spring Boot, specifically building APIs that integrate with relational databases. Proficient in building and consuming RESTful and GraphQL APIs Experience with Junit, SonarQube and test-driven development Knowledge of Docker and Kubernetes for microservice architecture Experience with Rancher for Kubernetes and Jenkins for CI/CD is preferred Hands-on expertise in PostgreSQL/Oracle, including schema design, indexing, query optimization and migration Familiarity with version control (GIT) Strong problem-solving skills and the ability to work collaboratively in Agile teams. Nice to Have: Experience with Apache Kafka Understanding of API security protocols (OAuth2, JWT, etc.)

Req ID: 324436 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Software Development Advisor to join our team in Bengaluru, Karn taka (IN-KA), India (IN). About the role: We are looking for a passionate and experienced API Developer to join our backend engineering team. In this role, you will play a critical part in designing and implementing robust APIs and microservices. You will work with cutting-edge tech stack including Spring Boot and Java 8+ (Java17 preferred) GraphQL, Docker and Kubernetes. In this role you ll be responsible for building clean, testable and efficient code, contributing to architecture decisions and supporting full lifecycle development from concept to development. Required Skills: Java 8+ (preferred java 17) Strong backend development experience using Spring Boot, specifically building APIs that integrate with relational databases. Proficient in building and consuming RESTful and GraphQL APIs Experience with Junit, SonarQube and test-driven development Knowledge of Docker and Kubernetes for microservice architecture Experience with Rancher for Kubernetes and Jenkins for CI/CD is preferred Hands-on expertise in PostgreSQL/Oracle, including schema design, indexing, query optimization and migration Familiarity with version control (GIT) Strong problem-solving skills and the ability to work collaboratively in Agile teams. Nice to Have: Experience with Apache Kafka Understanding of API security protocols (OAuth2, JWT, etc.)

Responsibilities: * Design, develop, test & maintain PL/SQL applications using Oracle 11g/12c. * Optimize database performance through query optimization & indexing.

Role: Lead SQL Server Developer Location Bangalore (Ashok Nagar) Experience : 8 - 10 years of prior experience which includes 3+ years of Team Lead experience required. Education : Bachelor's/Masters Degree in Technology. Salary : Negotiable Job Type : Full Time (On Role) Mode of Work : Work from Office Job Description What you will be doing: Working on Microsoft SQL Server 2012 and above server-side development. Designing the schema that can be usable across multiple customers. Design and developing T-SQL (Transact SQL) Stored Procedures, Functions and Triggers and SSIS packages. Develop underlying data models and databases. Develop, manage and maintain data dictionary and or metadata. Doing performance tuning & query optimization. Ensuring compliance of standards and conventions in developing programs. Analyse and resolve complex issues without oversight from other people. Perform quality checks on reports and exports to ensure exceptional quality. Works in Scrum environment. Preferred Skills: Knowledge of tools like Qlik /Qlik sense and/or any other data visual tools. Understanding of .NET code/jQuery experience is a plus. Knowledge in Microsoft Reporting tool (SSRS). Experience in Database Administration activities. Interested candidates kindly share your CV and below details to usha.sundar@adecco.com 1) Present CTC (Fixed + VP) - 2) Expected CTC - 3) No. of years experience - 4) Notice Period - 5) Offer-in hand - 6) Reason of Change - 7) Present Location -

5-7 years of experience in data analytics, business intelligence, or a related field. Proven expertise with Firebase Analytics and GA4, including custom event setup and user journey tracking. Advanced proficiency in BigQuery: SQL scripting, query optimization, partitioning, and clustering. Hands-on experience with Looker or Looker Studio for dashboard development and data modeling. Familiarity with other GCP services such as Cloud Storage, Cloud Functions, Pub/Sub, and Dataflow is a strong plus. Solid understanding of data privacy and governance frameworks (GDPR, CCPA, etc). Strong analytical thinking and problem-solving abilities with attention to detail. Excellent communication skills and the ability to work effectively in cross-functional teams. Preferred Qualifications: Google Cloud certifications (eg, Professional Data Engineer, Looker Business Analyst) Experience with A/B testing frameworks and experimentation platforms Background in product analytics or digital marketing analytics

Key Responsibilities. Architect, build, and optimize Django-based APIs and services. Define and enforce backend best practices, coding standards, and security protocols. Lead integrations with external financial APIs (KYC, banking, payments, etc.). Drive performance improvements in high-load environments. Collaborate with product and engineering leadership on technical decision-making. Must-Have Skills. 47 years of backend development experience in Python and Django/Django Rest Framework. Deep knowledge of relational databases, query optimization, and scaling. Hands-on experience with system design, caching, rate limiting, and error handling. Strong experience working in fintech and Software Development ecosystems is mandatory. Good-to-Have Skills. Familiarity with asynchronous task queues (Celery, RabbitMQ). Containerization and orchestration (Docker/Kubernetes). Experience working with AWS or other cloud platforms. Responsibilities. Collaborate with cross-functional teams to understand project requirements and deliver high-quality Python solutions. Develop and maintain Python-based web applications and APIs using Flask, Django, or FastAPI frameworks. Integrate data storage solutions using MongoDB or other preferred databases. Write efficient, reusable, and reliable code to ensure the overall performance and scalability of applications. Implement security measures and data protection to safeguard sensitive information. Conduct thorough testing to identify and fix bugs and issues promptly. Optimise applications for maximum speed and responsiveness. Deploy and host Python applications or APIs on cloud platforms or servers. (ref:hirist.tech).

Key Responsibilities. Architect, build, and optimize Django-based APIs and services. Define and enforce backend best practices, coding standards, and security protocols. Lead integrations with external financial APIs (KYC, banking, payments, etc.). Drive performance improvements in high-load environments. Collaborate with product and engineering leadership on technical decision-making. Must-Have Skills. 4 to 7 years of backend development experience in Python and Django/Django Rest Framework. Deep knowledge of relational databases, query optimization, and scaling. Hands-on experience with system design, caching, rate limiting, and error handling. Strong experience working in fintech and Software Development ecosystems is mandatory. Good-to-Have Skills. Familiarity with asynchronous task queues (Celery, RabbitMQ). Containerization and orchestration (Docker/Kubernetes). Experience working with AWS or other cloud platforms. Education. Tech/ M. (ref:hirist.tech).

Total Yrs. of Experience* 3 to 4 yrs. Relevant Yrs. of experience* 3 to 4 yrs. Detailed JD *(Roles and Responsibilities) Job Title: Integration Developer Snap Logic & PostgreSQL Relevant Skills for Hiring: Integration Tools: Snap Logic (pipeline creation and modification) Databases: PostgreSQL (script development and query optimization) CRM Platforms: Basic understanding of Salesforce backend Project Management Tools: JIRA (basic usage) Development Methodologies: Agile (basic familiarity) Documentation Tools: Confluence (updating design and assessment documents) Soft Skills: Ability to manage multiple projects, proactive communication, and ownership of deliverables Roles and Responsibilities: Design, develop, and modify Snap Logic pipelines based on business requirements Act as the sole Snap Logic resource for one of the two ongoing projects Prepare assessment and design documents; maintain documentation in Confluence Ensure successful deployment of all pipelines to production Develop scripts in PostgreSQL as needed Collaborate with cross-functional teams to meet project goals Should be capable of handling multiple projects simultaneously when required Mandatory skills* Snap Logic PostgreSQL Basic understanding of Salesforce backend Desired skills* Optional/Additional Skills: Basic knowledge of JIRA Familiarity with Agile methodologies Should be capable of handling multiple projects simultaneously when required

Total Experience 5-8 years Relevant Experience on Mandatory Skills 5 years Design and implement logical and physical data models to support business requirements. Develop, optimize, and maintain database schemas, tables, views, and stored procedures. Collaborate with stakeholders to gather and analyze data requirements. Ensure database performance through query optimization and indexing strategies. Implement and maintain ETL processes for data integration and transformation. Perform data profiling, cleansing, and validation to ensure data quality. Monitor and troubleshoot database performance, availability, and security. Work with development teams to integrate databases with applications. Document database designs, data dictionaries, and processes. Mandatory Skills Strong experience with relational databases (e.g., DB2, PostgreSQL). Proficiency in SQL and database programming (e.g., stored procedures, triggers). Expertise in data modelling tools (e.g., ERwin, PowerDesigner, or similar). Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) is preferrable. Strong understanding of normalization, de-normalization, and database design principles. Experience with performance tuning and query optimization. Knowledge of data warehousing concepts and star/snowflake schemas. Excellent problem-solving and communication skills. Good to Have Skills SQL DB modelling tool

Detailed JD *(Roles and Responsibilities) 8+ years of total IT experience in development projects. 6+ years experience in Python Development Hands on experience in Design, build of data engineering project using Python. Strong hand-on experience in writing complex SQL queries. Able to write complex SQL queries based on different complex scenarios. Good understanding and hands-on experience in AWS/Azure cloud services. Experience in performance tuning including query optimization and have experience in scaling strategies. Address data issues, root cause analysis and production support. Experience working in a Financial Industry. Understanding Agile methodologies Mandatory skills* Python, SQL Lead Role Desired skills* Python, SQL

Sr Data Engineer1 We are looking for a highly skilled Senior Data Engineer with strong expertise in DataWarehousing & Analytics to join our team. The ideal candidate will have extensive experiencein designing and managing data solutions, advanced SQL proficiency, and hands-on expertisein Python.Key ResponsibilitiesDesign, develop, and maintain scalable data warehouse solutions. Write and optimize complex SQL queries for data extraction, transformation, andreporting. Develop and automate data pipelines using Python. Work with AWS cloud services for data storage, processing, and analytics. Collaborate with cross-functional teams to provide data-driven insights and solutions. Ensure data integrity, security, and performance optimization. Work in UK shift hours to align with global stakeholders.Required Skills & Experience8-10 years of experience in Data Warehousing & Analytics. Strong proficiency in writing complex SQL queries with deep understanding of queryoptimization, stored procedures, and indexing. Hands-on experience with Python for data processing and automation. Experience working with AWS cloud services. Ability to work independently and collaborate with teams across different time zones.Good to HaveExperience in the Finance domain and understanding of financial data structures. Hands-on experience with reporting tools like Power BI or Tableau.

SQL Server DBA2 Key Responsibilities : Database Management : Manage, configure, and maintain SQL Server databases in high-availability environments (Active-Active). Ensure optimal database performance, tuning queries, and optimizing resources. Monitor and resolve database performance issues, minimizing downtime. Cluster Setup and Management : Design, implement, and support SQL Server AlwaysOn availability groups and failover clustering . Ensure high availability and disaster recovery across multi-node SQL Server clusters. Monitor and manage cluster health, replication, and failover processes. On-Prem to AWS Migration : Lead and execute migration of on-premise SQL Server databases to AWS cloud, including RDS and EC2 setups. Plan, architect, and execute database migration strategies with minimal downtime and risk. Configure databases in AWS environments, ensuring scalability, performance, and security. Backup, Recovery, and Disaster Recovery : Implement and manage backup and recovery strategies to safeguard critical data. Test and maintain disaster recovery plans to ensure database availability during unforeseen events. Manage database replication between on-premises and cloud infrastructure. Security and Compliance : Ensure databases adhere to security and compliance policies, implementing data encryption , access control , and auditing . Regularly conduct security audits and apply patches and updates to mitigate vulnerabilities. Collaborate with security teams to meet industry compliance standards. Support and Troubleshooting : Provide 24/7 support for production databases, ensuring rapid resolution of any issues. Troubleshoot and resolve complex database issues related to performance, availability, and security. Document procedures, guidelines, and best practices for maintaining and optimizing SQL Server environments. Automation and Scripting : Automate routine database tasks, including backups, monitoring, and performance tuning using tools such as PowerShell , T-SQL , or other automation tools. Continuously improve efficiency and reduce manual intervention in database operations. Collaboration : Work closely with development, infrastructure, and operations teams to ensure smooth database operations across all environments. Provide guidance and best practices for database design, development, and optimization. Required Skills and Qualifications : 5+ years of experience as a SQL Server DBA in enterprise environments. Strong knowledge of SQL Server clustering , AlwaysOn availability groups , and Active-Active setups . Experience with on-premises to AWS migration for SQL Server databases. Expertise in AWS RDS , EC2 , and other AWS database services. Proven experience in performance tuning , query optimization , and database maintenance . Strong understanding of backup, recovery , and disaster recovery strategies . Proficiency in T-SQL , PowerShell , and other automation scripting languages. Excellent troubleshooting, problem-solving, and communication skills.

Key Responsibilities : Application Development : Design, develop, and maintain enterprise-level Java applications using Java EE technologies. Write clean, maintainable, and efficient Java code following coding standards and best practices. Implement RESTful and SOAP web services as part of the application architecture. Work with databases (SQL, NoSQL) to develop data models, query optimization, and integration. JBoss Application Server Management : Configure, deploy, and manage Java applications on JBoss Application Server (or WildFly ). Troubleshoot and resolve issues related to JBoss, including performance bottlenecks, server crashes, and deployment errors. Optimize and fine-tune JBoss configurations to improve system performance. Implement and configure clustering, load balancing, and high-availability setups using JBoss