31 Query Tuning Jobs - Page 2

Design scalable and robust PostgreSQL database architectures for enterprise-grade applications. Develop logical and physical data models aligned with business requirements. Create and maintain best practices for database design, coding, performance tuning, and security. Perform capacity planning, data partitioning, and replication strategies. Implement and manage high availability, disaster recovery, and backup strategies. Work closely with software developers, DevOps, and system architects to integrate database solutions with applications. Develop database deployment pipelines and automation scripts using tools such as Ansible, Terraform, or CI/CD. Conduct performance monitoring, query optimization, and troubleshooting for slow-running SQLs. Establish and enforce database access controls, user roles, and data protection protocols. Migrate legacy databases (e.g., Oracle, MySQL) to PostgreSQL when required. Provide mentorship to developers and DBAs on PostgreSQL usage and tuning Preferred candidate profile Proven experience with high-availability architecture (Patroni, Streaming Replication, etc.). Strong expertise in performance tuning, indexing strategies, and complex query analysis. Familiarity with JSONB, GIS data types, full-text search, and PostgreSQL extensions. Experience in Linux-based environments (preferably Ubuntu/CentOS/RHEL). Experience in designing databases for microservices and event-driven architectures. Knowledge of PostgreSQL monitoring tools (pgAdmin, pg_stat_statements, Prometheus, etc.). Hands-on experience with database automation and DevOps pipelines. Experience in database security, encryption, auditing, and compliance. Experience in cloud-native PostgreSQL deployments (e.g., AWS RDS/Aurora, GCP Cloud SQL, Azure Database for PostgreSQL). Certification in PostgreSQL or relevant database technologies. Experience with NoSQL integrations or hybrid data architectures.

Job Title: Senior System Engineer Location: Gurgaon Job Type: Full-Time Experience:2-4 Years Notice Period-Immediate Joiners We are seeking a highly skilled and experienced Senior Systems Engineer to join our dynamic team. The ideal candidate will have a strong background in Java-based enterprise applications , microservices architecture , and business process management systems . This role requires hands-on experience with JBPM , Drools , and modern front-end technologies like Angular , along with a solid understanding of Linux environments and object-oriented design principles . Key Responsibilities: Design, develop, and maintain scalable microservices using Java/J2EE and Spring Boot. Implement business workflows using JBPM and business rules using Drools. Develop and maintain front-end components using Angular. Integrate and optimize database interactions using Hibernate with Oracle/PostgreSQL. Extend JBPM functionality through custom Work Items and other extensions. Collaborate with cross-functional teams to define, design, and ship new features. Ensure the performance, quality, and responsiveness of applications. Troubleshoot and resolve technical issues in development and production environments. Follow best practices in software development, including design patterns and code reviews. Mandatory Skills: Strong experience in Java/J2EE , Spring , Spring Boot , and Hibernate Proficiency in Microservices architecture Hands-on experience with JBPM and Drools Experience with Angular for front-end development Good knowledge of Linux operating systems Experience with Oracle and/or PostgreSQL databases Understanding of Object-Oriented Analysis and Design (OOAD) and common design patterns Experience with JBPM extensions (e.g., Work Items) Desired Skills: Proficiency in SQL and PL/SQL Experience in database modeling and query tuning Familiarity with LOMA Insurance Certifications Prior experience working on insurance administration platforms/products Education: Bachelors or Masters degree in Computer Science, Engineering, or a related field Regards, Infosys BPM Recruitment team

Experience : 6+ Years Location : Bangalore Employment Type : Full-time (Hucon Innovations) Notice Period : Immediate to 15 days Job Description We are seeking a Lead Developer with strong expertise in Oracle Master Data Management (MDM) and Customer Data Hub (CDH) . The ideal candidate should have a solid background in SQL/PL-SQL development , data quality processes, and experience working with Oracle E-Business Suite R12. Key Responsibilities Act as a Lead Developer for Oracle MDM/CDH implementation and support projects. Develop and maintain complex SQL and PL/SQL scripts on Oracle databases. Design, implement, and manage Data Quality Management (DQM) solutions. Work with Oracle Standard APIs and Trading Community Architecture (TCA) . Collaborate with cross-functional teams to analyze and optimize customer data. Perform query tuning and performance optimization . Engage in end-to-end solutioning for Master Data and Integration requirements. Must-Have Skills 6+ years of experience in Oracle MDM, CDH Strong SQL & PL/SQL programming skills Experience in Oracle Applications R12 suite Deep understanding of TCA, DQM, MDM, EDM concepts Experience working with Oracle Standard APIs Good-to-Have / Added Advantage Exposure to Salesforce , Snowflake , or Oracle Data Integrator (ODI) Domain knowledge in ERP systems

---- What the Candidate Will Do ---- Partner with engineers, analysts, and product managers to define technical solutions that support business goals Contribute to the architecture and implementation of distributed data systems and platforms Identify inefficiencies in data processing and proactively drive improvements in performance, reliability, and cost Serve as a thought leader and mentor in data engineering best practices across the organization ---- Basic Qualifications ---- 7+ years of hands-on experience in software engineering with a focus on data engineering Proficiency in at least one programming language such as Python, Java, or Scala Strong SQL skills and experience with large-scale data processing frameworks (e.g., Apache Spark, Flink, MapReduce, Presto) Demonstrated experience designing, implementing, and operating scalable ETL pipelines and data platforms Proven ability to work collaboratively across teams and communicate technical concepts to diverse stakeholders ---- Preferred Qualifications ---- Deep understanding of data warehousing concepts and data modeling best practices Hands-on experience with Hadoop ecosystem tools (e.g., Hive, HDFS, Oozie, Airflow, Spark, Presto) Familiarity with streaming technologies such as Kafka or Samza Expertise in performance optimization, query tuning, and resource-efficient data processing Strong problem-solving skills and a track record of owning systems from design to production

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

6+ yrs of exp in database administration, management, performance engineering with expertise in MS-SQL databases. Strong hands-on experience with MS SQL, PostgreSQL & Azure Cosmos DB. Required Candidate profile Design, implement & manage database architecture for both relational (SQL) & non-relational (NoSQL) databases, with a focus on security. Optimize database performance through query tuning, indexing