563 Query Optimization Jobs - Page 23

Role & responsibilities Data Analyst working SQL Project. Have developed & analyzed Databases using SQL Should have created Tables & Ad-hoc queries on SQL, Ad-hoc reporting. Strong SQL experience - Advanced level of SQL Excellent data interpretation skills Good knowledge of ETL and a business intelligence, good understanding of range of data manipulation and analysis techniques Working knowledge of large information technology development projects using methodologies and standards Excellent verbal, written and interpersonal communication skills, demonstrating the ability to communicate information technology concepts to non-technology personnel, should be able to interact with business team and share the ideas. Strong analytical, problem solving and decision-making skills, attitude to plan and organize work to deliver as agreed. Hands on experience working with large datasets. Able to manage different stakeholders.

JOB DESCRIPTION Role: Software Development Engineer II Amagi Background Amagi is a dynamic cloud-native SaaS platform that enables content owners to deliver their media seamlessly to consumers across various devices. With a strong emphasis on transforming media consumption, Amagi connects content owners, distribution platforms, consumers, and advertisers to curate exceptional viewing experiences. As a leader in the FAST (Free Ad-supported Streaming TV) space, Amagi supports over 500 media brands across 1500+ endpoints and continues to witness tremendous growth. Amagi Analytics Amagi Analytics is dedicated to providing comprehensive insights via its end-to-end analytics product. This highly scalable platform handles the ingestion of multiple TBs of data daily, offering valuable analytics and predictions to users across channel performance, content efficiency, advertising insights, and billing data. Role reporting into : Senior Engineering Manager, Amagi Analytics Location: Bangalore, India Key Responsibilities Develop, maintain, and enhance scalable backend services and frameworks within the data platform team. Work closely with product managers, designers, and fellow engineers to ensure deliverables and milestones are met. Contribute to the design, development, and implementation of efficient and maintainable code. Involve in code reviews and design discussions to promote best practices. Diagnose performance bottlenecks and scalability challenges, proposing innovative solutions. You will excel at this role, if you have A bachelor s/master s degree in Computer Science or related field with 3+ years of experience in software development. Proficient in either Python or Go, with ha

Performance Tuning , table & data partitioning ORACLE performance tests.Must have worked as application DBA & having proficiency in setting up health & performance check process for day to day monitoring. Having hands on exp. in query optimization. Required Candidate profile Must have exposure/experience in HDFS/HADOOP, HIVE and ICEBERG, Capital Market Exp. preffer

Senior Software Engineer I (MS SQL Server Database Engineer) Job Description Opportunity Summary: We are looking for an enthusiastic and dynamic individual with an overall experience of 6+ years to join Upland India as a Senior Software Engineer in Microsoft SQL Server for our Upland PSA products. What would you do? Develop, test, and maintain the database code Create or modify database objects and/or write SQL code in support of application needs Monitor and improve database performance and capacity Ensure that database systems are safeguarded and implement necessary security measures to ensure data integrity Assist with upgrading database for new version release when needed Syncing data across data sources Conduct research on emerging database and application development software products, languages, and standards in support of development efforts What are we looking for? Technical Skills The following skills are needed for this role. Experience: Must have Expert level (6 + years ) hands-on database development experience and skills and database maintenance experience) in MS SQL Server Primary Skills: The candidate must possess the following primary skills: Excellent (6+ years) hands-on database experience and skills in developing MS SQL Server Stored Procedures, functions, triggers, queries, scripts, etc. Excellent (6+ years) hands-on MS SQL Server database experience in troubleshooting, performance tuning, debugging, and query optimization in MS SQL Server Excellent (6+ years) in indexing, finding and resolving potential for database deadlocks Experience in MS SQL Server database migrations and upgrades. Has experience with analytics and reporting Secondary Skills: It would be advantageous if the candidate also has the following secondary skills: Have a MS SQL Server / Azure SQL certification OR are willing to obtain in a short time frame. Nice to have experience with: ETL, Azure SQL Soft Skills: Strong writing skills are essential, as is the ability to work effectively in a fully remote team without the need for a physical office. The ideal candidate thrives in a collaborative team environment with a diverse range of people and is passionate about delivering an amazing customer experience. They should be adaptable, capable of changing their mind and influencing others Growth Skills: The candidate should have a strong work ethic, be a self-starter with a desire to grow, and consistently seek better ways to accomplish tasks. Qualification Bachelors degree or technical institute degree/certificate in Computer Science, Information Systems, or other related field or equivalent combination of knowledge and experience. This role requires overlap with multiple time zones for planning meetings, status updates etc. on a regular basis. The duration of these overlaps can change depending on the type of meeting. Upland India has the flexibility to manage your working hours accordingly to help in your work-life balance. You can find out more about this during your interview conversation. Upland Software is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or other legally protected status. About [Upland PSA] Upland PSA focuses on planning, execution and financial management of projects. This includes project related business functions such as Timesheet & Leave Request Management, Expense Entry & Approvals, Project Planning & Scheduling, Resource Allocation, and Invoicing.

Job Description Key Responsibilities: Manage and optimize Oracle Exadata and SQL database environments for high availability, scalability, and peak performance. Configure, fine-tune, and secure databases to ensure reliability and efficiency. Monitor, diagnose, and resolve complex database issues in a high-traffic 24x7 production environment. Design and implement backup and disaster recovery solutions to safeguard data integrity. Optimize database queries, indexes, and performance to enhance operational efficiency. Collaborate with application developers to align database structures with business requirements. Plan and execute database upgrades, capacity planning, and storage management. Enforce security best practices, access controls, and compliance standards. Maintain detailed documentation of configurations, policies, and best practices. Stay ahead of industry trends and advancements in database technologies. Required Qualifications: Hands-on experience with database monitoring tools and automation. Expert-level expertise in Oracle Exadata administration, including performance tuning, storage optimization, and security. Strong proficiency in SQL Server, with experience in high availability solutions (Always On, clustering, replication, etc.). Deep understanding of SQL, Database, indexing strategies, query optimization, and transaction management. Strong troubleshooting skills with a focus on reliability, resilience, and scalability. Experience designing and implementing backup/recovery strategies and disaster recovery planning. Ability to work in a fast-paced, high-stakes environment with a proactive and solution-driven mindset. Excellent communication and collaboration skills, with the ability to work across teams. This is an exciting opportunity to work on cutting-edge database technologies and solve complex challenges in a dynamic, mission-critical environment. If you have the technical expertise and problem-solving mindset to drive database excellence, wed love to hear from you! Career Level - IC3 Responsibilities As a Senior Systems Engineer, you will interface with the customer's IT staff on a regular basis. Either at the client's site or from a remote location, you will be responsible for resolution of moderately complex technical problems related to the installation, recommended maintenance and use and repair/workarounds for Oracle products. You should be highly experienced in some Oracle products and several platforms that are being supported. You will be expected to work with only general guidance from management while advising management on progress/status.

Job Description The Tools and Innovation team is a high-performing software development group within Oracle's product development organization. Tasked by executive leadership with creating cutting-edge tools, the team drives Oracle's business forward with solutions that are highly complex, visible, and impactful across the company. These mission-critical innovations empower executives to make key decisions shaping the future of Oracle's SaaS business. We are seeking an experienced full stack developer to join our team in designing and developing innovative tools that empower Oracle's SaaS business. As a full stack developer, you will bring new components to life, working on systems that are highly visible and critical to Oracle's operations. We value team members who strive to understand the business, ensuring that what we deliver aligns closely with organizational goals. With a strong focus on quality, you will ensure that your work provides an accurate and effective interpretation of data, while driving improvements in how we deliver our solutions. You will collaborate across multiple teams, including product, UX, Architects, QA, Data Engineers and DevSecOps, to achieve seamless integration and deliver end-to-end solutions. Our team is dedicated to continuous improvement, always exploring new ways to enhance our processes, systems, and outcomes. Career Level - IC5 Responsibilities The full stack developers responsibilities include : Architect, design, and develop responsive, scalable web applications with advanced, dynamic front-end components and complex back-end systems using modern frameworks and technologies. Develop RESTful APIs and microservices, ensuring seamless integration with databases, third-party services, and internal systems. Architect and oversee the development of complex microservices ecosystems, ensuring high availability, security, and scalability. Ensure comprehensive documentation of APIs and microservices, including endpoint specifications, data models, authentication methods, and integration points, to facilitate ongoing development and collaboration across teams. Design and optimize database schemas, write efficient SQL queries, and implement indexing strategies to ensure high-performance data retrieval. Architect complex data solutions such as replication, partitioning, and tuning for large-scale applications. Collaborate with DevSecOps engineers to drive best practices and ensure automation across the entire software lifecycle. Partner with QA engineers to define and execute comprehensive testing strategies. Take ownership of unit testing, integration testing, and end-to-end testing by integrating appropriate testing frameworks. Ensure identification and resolution of code smells through continuous refactoring efforts, utilizing tools like static code analysis to improve code maintainability and performance. Integrate advanced security measures into the testing pipeline, maintain high coding standards through proactive collaboration with QA and Governance teams. Lead identification, root cause analysis and resolution of performance bottlenecks and defects. Drive advanced optimization efforts, including profiling, query tuning, and high-load testing. Define strategies for scaling solutions effectively. Lead and drive technical discussions and decisions across the team. Mentor and guide junior developers, conduct in-depth code reviews, and establish best practices. Ensure effective collaboration with cross-functional teams for high-quality outcomes. Stay at the forefront of emerging technologies, drive their adoption across the team, and contribute to the continuous improvement of development processes and methodologies. Lead the collaboration with the UX designer, guiding the translation of wireframes and mockups into high-quality, responsive interfaces. Ensure alignment with user experience goals and drive consistency and usability across the application. Job Requirements: Expert proficiency in modern front-end technologies, such as JavaScript, and frameworks/libraries like REACT, Svelte, Angular, or Vue.js Expert proficiency in back-end technologies and frameworks, such as java (Spring Boot), Helidon, Python, Node.js, and ORM tools like JPA and Hibernate. Strong expertise in microservices architecture, including the design and development of RESTful APIs using technologies like Spring Boot (Java), Express (Node.js), or Flask (Python). Experience with API Management, documentation (e.g. Swagger/OpenAPI) and secure API practices (e.g, OAuth, JWT) Advanced expertise in relational databases (PostgreSQL, MySQL, SQL Server) and NoSQL databases (MongoDB, Cassandra). Experience with data modeling, indexing, and query optimization. Extensive experience working with Oracle Cloud Infrastructure (OCI) or similar, particularly in designing and deploying scalable, cloud-native solutions. Expertise in designing and optimizing CI/CD pipelines with tools like Jenkins, GitLab CI, or Graddle. Knowledge of containerization and orchestration technologies such as Docker and Kubernetes. Background in automated testing (unit, integration, and end-to-end) using frameworks like JUnit, Mocha, Jasmine, or Cypress. Expertise in Git, including branching strategies, code reviews, and collaboration tools such as GitHub or GitLab. Qualifications: 10+ years of experience in full-stack development, with a proven track record of architecting and delivering complex applications at scale. Experience leading technical initiatives, mentoring junior engineers, and driving architectural decisions. Strong analytical and problem-solving skills with the ability to resolve complex technical challenges. Bachelors or masters degree in computer science, Engineering, or a related field, or equivalent practical experience.

An experienced consulting professional who has an understanding of solutions, industry best practices, multiple business processes or technology designs within a product/technology family. Operates independently to provide quality work products to an engagement. Performs varied and complex duties and tasks that need independent judgment, in order to implement Oracle products and technology to meet customer needs. Applies Oracle methodology, company procedures, and leading practices. Over 3 to 5+ years of relevant IT experience with 5 + years in Oracle VBCS, OIC, PL/SQL, PCS based implementations as a Technical lead and senior developer Role is an Individual Contributor role. Being Hands-On is a critical requirement. Must Have: Experience Solution design for Customer engagements in the UI and Integration (OIC) space At least 5 project experience in developing SaaS Extensions using VBCS, OIC ORDS. Understanding of Inherent tools and technologies of SaaS Applications (FBDI, BIP, ADFDI, Applications Composer, Page Integration, etc.) Expertise in Oracle Visual Builder Studio, Good experience with Build and Release, Systems Integration, Agile, Estimations/Planning. Experience in configuring SSO PaaS extensions with Fusion SaaS Drive detailed design using customer requirements Good understanding and usage of OCI architecture, serverless functions, APU Gateway, object storage Conduct Design review to provide guidance and Quality assurance around standard methodologies and frameworks Experience in PCS is an added advantage. Good to have SOA/OSB/ODI/BPM skills. Have experience of building at least one project from scratch Experience with rolling out three big project (multiple phased release or country rollouts) to production. #LI-DNI Career Level - IC2 Responsibilities Standard assignments are accomplished without assistance by exercising independent judgment, within defined policies and processes, to deliver functional and technical solutions on moderately complex customer engagements. #LI-DNI

As a member of the Support organization, your focus is to deliver SaaS support and solutions to the Oracle customer in Customer Success Services while serving as an advocate for customer needs. This involves resolving SaaS Ap-plications technical/non-technical customer incidents via Incident Management System and electronic means, as well as, technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues. You would be expected to be a hands-on lead with Oracle Fusion Supply Chain Management Functional/Technical skills. Career Level - IC4 Responsibilities As a Supply Chain Management Lead, you will offer strategic functional/technical support to assure the highest level of customer satisfaction. A primary focus is to create/utilize automated technology and instrumentation to diagnose, document, and resolve/avoid customer issues. You are expected to be an expert member of the technical problem solving/problem avoidance team, routinely sought after to address extremely complex, critical customer issues. Services may be frequently provided by on-site customer visits.

Job Description Oracle Financial Services Global Business Unit (FSGBU) is a world leader in providing IT solutions to the Financial Services industry. Oracles customers include ten of the top ten Global Banks, ten of the top ten Insurance companies, ten of the top ten Securities firms, five of the top five Mutual Fund companies and four of the top five World Stock Exchanges. Banking Consulting NACA which is a part of Americas Region under FSGBU - Consulting delivers Oracle Technology and Applications solutions for clientele in the North America and Caribbean region. The service offerings include Application Implementation, Managed Services and Customization development services for Oracle Financial Services Software Banking products. Career Level - IC2 Responsibilities Mandatory Skills: 4 6 years of Oracle PL/SQL, PL/SQL and Oracle Database experience. Knowledge and skills in software programming in Oracle PL/SQL Experience in procedures, triggers and functions Should have design and coding experience of enterprise applications Should have experience in Code review tools like Sonar. Should have experience in writing unit testing using utPLSQL etc. Should be able to understand complex SQL queries and query optimization. Exposure to any cloud environment is preferable. Moderate experience on Unix, shell scripting Basic understanding of webservices and RESTful API Job Responsibilities Activities in Development or Implementation or Managed Service activity streams as a Technical Consultant. Your responsibilities include: Perform analysis and development of application components in Oracle PL/SQL Ensure quality code delivery Perform unit testing for the developed code. Participate in design discussion and perform module design. Support SIT, UAT during testing Develop programs as per specifications/requirements given by Oracle / Client within planned schedule. Use defined standards/tools/processes to achieve deliverables that meet quality expectations of Oracle / Client. Document all work in accordance with agreed standards/processes applicable for Oracle / Client. Adhere to defined Change Control Process of Oracle / Client. Comply with Oracle / Client audit / Compliance requirements. Good to have Exposure to Banking Domain Experience in Core Java, J2EE, Webservices (Rest services) You are aware of latest technologies in Banking Customer facing experience w.r.to technical discussions Experience Experience of 4 to 6 years Experience in development and / or implementation and / or support of core banking applications. Job Location: - Bangalore

Role & responsibilities Strong hands-on Experience in SQL Development Writing & Optimizing Database Queries Database Design & Maintenance Performance Tuning Troubleshooting & Debugging Documentation & Continuous Learning Experience applying an automation-first approach using configuration management tools and scripting (e.g., PowerShell & Python). Experience with configuration management and orchestration tools (e.g., Ansible, Jenkins). Proficiency in database management, including Oracle or Microsoft SQL Server administration. Experience supporting large-scale enterprise applications and systems on public cloud infrastructure (AWS preferred). Familiarity with continuous integration tools (e.g., GitHub, Azure DevOps). Hands-on experience with AWS services such as Lambda, Secrets Manager, Parameter Store, DynamoDB, and CLI. Experience implementing infrastructure-as-code, self-healing systems, and security automation. Work Timing: 5:30 PM 2:30 AM IST

Database Design Collaborate with application developers to design and optimize SQL databases that meet application requirements, scalability, and performance needs Database Implementation Install, configure, and set up SQL Server instances, creating and configuring databases, tables, and stored procedures Performance Tuning Monitor and optimize database performance, identifying and resolving performance bottlenecks, query optimization, and index maintenance Backup and Recovery Develop and implement database backup and recovery strategies to ensure data availability and integrity Security Manage database security by configuring user roles, permissions, encryption, and auditing to protect sensitive data Maintenance Perform routine maintenance tasks, such as patching, upgrading, and applying service packs to keep SQL Server instances up to date High Availability Implement high availability and disaster recovery solutions, such as clustering, replication, and Always On availability groups Monitoring and Alerting Set up monitoring tools to track database health and performance, configuring alerts for proactive issue resolution Documentation Maintain detailed documentation of database configurations, procedures, and incidents Query and Performance Analysis Analyze and optimize SQL queries for efficient data retrieval and manipulation

Job Title : Snowflake Developer (4+ years' experience) Location : F, 384, Sector 91 Rd, Phase 8B, Industrial Area, Sector 91, Sahibzada Ajit Singh Nagar, Punjab 160055. Job Type : Fulltime (In-house) Job Overview : We are looking for an experienced Snowflake Developer with 4+ years of hands-on experience in Snowflake Data Warehouse and related tools. You will be responsible for building, managing, and optimizing Snowflake data pipelines, assisting in data integration, and contributing to overall data architecture. The ideal candidate should have a strong understanding of data modeling, ETL processes, and experience working with cloud-based data platforms. Responsibilities : Design, develop, and maintain Snowflake Data Warehouses. Create and manage Snowflake schema, tables, views, and materialized views. Implement ETL processes to integrate data from various sources into Snowflake. Optimize query performance and data storage in Snowflake. Work with stakeholders to define data requirements and provide technical solutions. Collaborate with Data Engineers, Data Scientists, and Analysts to build efficient data pipelines. Monitor and troubleshoot performance issues in Snowflake environments. Automate repetitive data processes and report generation tasks. Ensure data integrity, security, and compliance with data governance policies. Assist in data migration and platform upgrades. Required Skills : 4+ years of experience working with Snowflake Data Warehouse . Proficient in SQL , SnowSQL , and ETL processes . Strong experience in data modeling and schema design in Snowflake. Experience with cloud platforms (AWS, Azure, or GCP). Familiarity with data pipelines , data lakes, and data integration tools. Experience in query optimization and performance tuning in Snowflake. Understanding of data governance and best practices. Strong knowledge of data security and privacy policies in a cloud environment. Experience in using tools like dbt , Airflow , or similar orchestration tools is a plus. #Salary: No bar for deserving candidates. Location: - Mohali Punjab (Work from office) Shift:- Night Shift Other Benefits: 5 Days working US based work culture and environment Indoor and Outdoor events Paid Leaves Health Insurance Employee engagement activities like month end & festival celebration, team outing, birthday celebrations. Gaming and sports area Please comment/DM to know more. You may also e-mail your resume to me at priyankaaggarwal@sourcemash.com

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Google BigQuery Good to have skills : NA Minimum 12 year(s) of experience is required Educational Qualification : 15 years full time education Summary :As an Application Developer, you will design, build, and configure applications to meet business process and application requirements. Your typical day will involve collaborating with teams to develop innovative solutions and contribute to key decisions. Roles & Responsibilities: Expected to be an SME. Collaborate and manage the team to perform. Responsible for team decisions. Engage with multiple teams and contribute on key decisions. Expected to provide solutions to problems that apply across multiple teams. Lead the development and implementation of new features. Conduct code reviews and ensure coding standards are met. Troubleshoot and resolve complex technical issues. Professional & Technical Skills: Must To Have Skills: Proficiency in Google BigQuery. Strong understanding of data modeling and database design. Experience with cloud platforms like Google Cloud Platform. Knowledge of SQL and query optimization techniques. Hands-on experience in developing scalable applications. Good To Have Skills: Experience with data warehousing solutions. Additional Information: The candidate should have a minimum of 12 years of experience in Google BigQuery. This position is based at our Bengaluru office. A 15 years full-time education is required. Qualification 15 years full time education