563 Query Optimization Jobs - Page 15

Job Description: • Monitor, maintain database systems and troubleshoot problems that may arise. • Maintain data integrity, monitoring and security (manage roles and permissions of database users). • Create and manage constraints and indexes. • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. • Proactive housekeeping/archiving and shrinking of databases. Job Description Senior Database Administrator. • Manage production, QA and development database environments. • Create detailed documentation including diagrams of database infrastructure. • Learn relevant business processes and understand the data flow, criticality and dependencies. • Effectively coordinate and communicate with all the stakeholders (internal teams and clients).

We are seeking a highly skilled PostgreSQL Database Administrator (DBA) to join our team. The ideal candidate will have at least 4 years of hands-on experience managing PostgreSQL databases in production environments. You will be responsible for the installation, configuration, monitoring, performance tuning, backup, and security of PostgreSQL database systems to ensure high availability, reliability, and optimal performance. Key Responsibilities: Database Administration: Install, configure, and maintain PostgreSQL database servers in development, testing, and production environments. Performance Tuning & Optimization: Monitor database performance, identify bottlenecks, and implement tuning strategies to optimize performance. Backup & Recovery: Implement and manage robust backup and disaster recovery solutions, including point-in-time recovery (PITR). High Availability & Replication: Set up and manage replication, failover, and high-availability solutions such as streaming replication, Patroni, etc. Security & Compliance: Ensure database security through access controls, encryption, auditing, and compliance with data protection regulations. Monitoring & Alerts: Implement monitoring tools and alerting mechanisms to proactively manage database health and availability. Upgrades & Patching: Plan and execute version upgrades, patching, and maintenance with minimal downtime. Troubleshooting & Support: Provide expert-level support and troubleshoot database-related issues across environments. Documentation: Maintain comprehensive documentation for configurations, procedures, and policies. Collaboration: Work closely with DevOps, developers, and IT teams to support application requirements and deployment needs. Required Skills & Qualifications: Education: Bachelors degree in Computer Science, Information Technology, or related field. Experience: 3+ years of experience in PostgreSQL database administration Strong hands-on experience with performance tuning, query analysis, and PostgreSQL internals Technical Skills: Expertise in PostgreSQL installation, configuration, and upgrade procedures Proficiency in implementing replication, backup, and disaster recovery strategies Strong knowledge of PostgreSQL security, authentication, and access control Familiarity with Linux/Unix environments and shell scripting Experience with monitoring tools like pgAdmin, pg_stat_statements, Prometheus + Grafana, etc. Preferred Skills (Nice to Have): Experience with cloud-hosted PostgreSQL (AWS RDS, Azure Database for PostgreSQL, etc.) Familiarity with automation tools like Ansible or Terraform Knowledge of containerization and orchestration (e.g., Docker, Kubernetes) Soft Skills: Excellent problem-solving and troubleshooting abilities Strong documentation and communication skills Ability to work independently and collaboratively in a fast-paced environment Proactive and detail-oriented approach to database management

We are looking for a motivated MongoDB Intern to join our engineering team. As a MongoDB Intern, you will assist in designing, developing, and maintaining database systems that ensure the scalability, security, and performance of our applications. This is a great opportunity to get hands-on experience with NoSQL databases and real-world backend systems. Roles and Responsibilities: Support in the design and optimization of MongoDB schemas and collections. Work with backend developers to integrate MongoDB into application architectures. Write and optimize queries for performance and efficiency. Help manage MongoDB deployments including installation, configuration, and backups. Assist in troubleshooting database-related issues. Document database solutions, processes, and architecture. Research best practices and recommend improvements for database operations. Skills Required: Basic understanding of MongoDB and NoSQL database concepts. Familiarity with CRUD operations , aggregation pipeline, and indexing in MongoDB. Working knowledge of JavaScript/Node.js or Python is a plus. Understanding of REST APIs and how they interact with databases. Strong analytical and problem-solving skills. Good communication and documentation abilities. What Youll Gain: Hands-on experience in a production-level NoSQL database environment. Mentorship from experienced developers and DBAs. Opportunity to contribute to live projects. Insight into database performance tuning and real-world data modeling.

So, what’s the role all about? We are looking for a highly driven and technically skilled Software Engineer to lead the integration of various Content Management Systems with AWS Knowledge Hub, enabling advanced Retrieval-Augmented Generation (RAG) search across heterogeneous customer data—without requiring data duplication. This role will also be responsible for expanding the scope of Knowledge Hub to support non-traditional knowledge items and enhance customer self-service capabilities. You will work at the intersection of AI, search infrastructure, and developer experience to make enterprise knowledge instantly accessible, actionable, and AI-ready. How will you make an impact? Integrate CMS with AWS Knowledge Hub to allow seamless RAG-based search across diverse data types—eliminating the need to copy data into Knowledge Hub instances. Extend Knowledge Hub capabilities to ingest and index non-knowledge assets, including structured data, documents, tickets, logs, and other enterprise sources. Build secure, scalable connectors to read directly from customer-maintained indices and data repositories. Enable self-service capabilities for customers to manage content sources using App Flow, Tray.ai, configure ingestion rules, and set up search parameters independently. Collaborate with the NLP/AI team to optimize relevance and performance for RAG search pipelines. Work closely with product and UX teams to design intuitive, powerful experiences around self-service data onboarding and search configuration. Implement data governance, access control, and observability features to ensure enterprise readiness. Have you got what it takes? Proven experience with search infrastructure, RAG pipelines, and LLM-based applications. 2+ Years’ hands-on experience with AWS Knowledge Hub, AppFlow, Tray.ai, or equivalent cloud-based indexing/search platforms. Strong backend development skills (Python, Typescript/NodeJS, .NET/Java) and familiarity with building and consuming REST APIs. Infrastructure as a code (IAAS) service like AWS Cloud formation, CDK knowledge Deep understanding of data ingestion pipelines, index management, and search query optimization. Experience working with unstructured and semi-structured data in real-world enterprise settings. Ability to design for scale, security, and multi-tenant environment. What’s in it for you? Join an ever-growing, market disrupting, global company where the teams – comprised of the best of the best – work in a fast-paced, collaborative, and creative environment! As the market leader, every day at NICE is a chance to learn and grow, and there are endless internal career opportunities across multiple roles, disciplines, domains, and locations. If you are passionate, innovative, and excited to constantly raise the bar, you may just be our next NICEr! Enjoy NICE-FLEX! At NICE, we work according to the NICE-FLEX hybrid model, which enables maximum flexibility: 2 days working from the office and 3 days of remote work, each week. Naturally, office days focus on face-to-face meetings, where teamwork and collaborative thinking generate innovation, new ideas, and a vibrant, interactive atmosphere. Reporting into: Tech Manager, Engineering, CX Role Type: Individual Contributor

What is special about Lighthouse Lighthouse is built on a foundation of unique, compassionate, highly driven individuals. We elevate the strengths and talents of those around us while leveraging opportunities for growth. We offer the experience of solving complex problems while continuing to grow multiple facets of your career. Lighthouse is where innovation meets support and where collaboration is the key ingredient to success. We grow together and are stronger together. What s unique about this role The Senior Software Engineer will be responsible for developing and maintaining software applications that meet the design, and the needs of our customers. Senior Software Engineer will be expected to work independently and collaboratively with other team members to ensure the successful delivery of high-quality software products. What will this person do Maintain and augment software applications and services in operation at Lighthouse Help and mentor a team of software developers, providing technical guidance and support. Adhere to Lighthouse Engineering standards for the overall Software Development Lifecycle and in support of our daily processes around design review and code review Develop competency and mastery of different languages and frameworks used at Lighthouse Collaborate closely with peers and mentors to conceive and build high-quality products and services Author and maintain effective unit tests Review and assess code quality through regular code reviews and provide constructive feedback. Perform manual integration testing and coordinate User Acceptance Testing activities Troubleshoot and resolve challenging technical issues, offering expertise to team members. Design significant/complex software components and communicate said design in an unambiguous way to fellow engineers for execution Drive implementation efforts to completion from design through test automation Stay abreast of emerging technologies and industry trends, guiding the team in adopting relevant innovations. Mentor other engineers on techniques, languages, frameworks and ensure they can complete their job successfully Bring your passion and together we will shine. It would also be great if you have the following: BS in Science/Engineering/Mathematics or equivalent work experience 4 years of professional software development experience Experience within the eDiscovery is preferred Experience with Agile methodologies Strong problem-solving skills Excellent communication and collaboration skills Application development language such as C#, .NET Core. Data Structures Azure Cloud Development Web technologies, frameworks like HTML5, CSS3, JavaScript, JQuery, Angular, REACT. Database development, query optimization, and handling large datasets in a technology like Microsoft SQL Server. Able to work cross-group to negotiate and resolve conflicting situations and priorities. Work Environment and Physical Demands Duties are performed in a typical office environment while at a desk or computer table. Duties require the ability to use a computer, communicate over the telephone, and read printed material, in a quiet and professional setting. Duties may require being on call periodically and working outside normal working hours (evenings and weekends).

FYNXT is a Singapore based Software Product Development company that provides a Software as a Service (SaaS) platform to digitally transform leading brokerage firms and fund management companies and help them grow their market share. Our industry leading Digital Front office platform has transformed several leading financial institutions in the Forex industry to go fully digital to optimize their operations, cut costs and become more profitable. Key Responsibilities: Scalable Backend Development: Architect, design, build, and maintain high-performance backend systems in modern Java capable of handling millions of concurrent users in the multitenant SaaS system. API Design Implementation: Develop clean, well-documented RESTful APIs and high-efficiency gRPC services to expose backend functionality. Distributed Systems: Architect and build microservices and event-driven systems using frameworks like Spring Boot, and Quarkus. Database Management: Work with SQL (PostgreSQL, MySQL) and NoSQL (Cassandra, Redis) databases to ensure efficient data storage and retrieval. Cloud-Native Development: Deploy and manage services on cloud platforms (AWS, GCP, Azure) using Kubernetes, Docker, and serverless technologies. Performance Optimization: Identify bottlenecks, optimize queries, and implement caching strategies (e.g., Redis, Memcached) for low-latency responses. Security Compliance: Implement authentication/authorization (OAuth, JWT), encryption, and data protection best practices. Collaboration: Partner with frontend, DevOps, and product teams to define API contracts, troubleshoot issues, and deliver end-to-end features. Monitoring Observability: Set up logging, metrics (Prometheus, Grafana), and alerts to ensure system health and rapid incident response. Technical Leadership: Drive code reviews, and advocate for engineering best practices (CI/CD, testing, IaC). Qualifications: 8+ years of development experience in Java building large-scale, distributed systems. Expertise in RESTful API design and gRPC implementation (protocol buffers). Hands-on experience with microservices, message brokers (Kafka, RabbitMQ), and API gateways. Strong database skills, including schema design, query optimization, and replication strategies. Familiarity with cloud platforms (AWS, GCP, Azure) and containerization (Docker, K8s). Knowledge of DevOps practices, CI/CD pipelines (Jenkins, GitLab), and IaC tools. Excellent problem-solving skills and a passion for writing clean, maintainable code. Unique experience in Fin-Tech industry, with a leading, fast-growing company. Good atmosphere at work and a comfortable working environment. Additional benefit of Group Health Insurance OPD Health Insurance Coverage for Self + Family (Spouse and up to 2 Children) Attractive Leave benefits like Maternity, Paternity Benefit, Vacation leave Leave Encashment Reward Recognition Monthly, Quarterly, Half yearly yearly.

Hiring - Sr. SQL DBA Location- Gurugram- Hybrid Fulltime Education - Bachelor or higher degree. 10+ years experience in working in IT services organization. At least 8+ years of SQL DBA experience covering implementation, production support and project work. At least 5+ years of exposure as L3/Lead/ SME support role. Knowledge and Understanding the ITIL process In client facing role(s) globally for at least 5 years. Excellent communication skills On call support for at least 5 years. Excellent Documentations skills in MS SharePoint 2010 /2013 Mandatory skills - SQL Server & Cloud administration required skills • Senior level Microsoft SQL Server DBA with experience in large and critical environments. Excellent knowledge of performance tuning at both server level and query level. Candidate must have knowledge of perfmon, SQL Server dynamic management views. Knowledge of SQL server internals. • Knowledge of SQL partitioning and compression • Hands-on experience on mirroring, replication and Always ON Must have automation experience. Good knowledge of scripting. Ability to write T-Sql scripts, Power Shell or Python. Excellent knowledge of SSIS packages. Hands-on experience on SQL Server Clustering. Hands-on experience on Integration Services, Reporting services and Analysis services • Must have good knowledge in SQL Server permission/security policies • At least 6 months experience with AWS Cloud RDS Good to have skills MySQL knowledge / experience. • Linux Knowledge Experience with Snow Flake Certifications Desired MS certifications on MSSQL latest versions. AWS Certifications

What you’ll do: Manage and maintain PostgreSQL databases in development, staging, and production environments. Write and optimize SQL queries, stored procedures, functions, and triggers to support application logic. Design, implement, and maintain logical and physical database schemas. Monitor database performance and implement performance tuning strategies. Ensure data integrity, security, and availability through regular maintenance and backups. Collaborate with application developers to understand requirements and provide efficient database solutions. Handle database migrations, versioning, and deployment as part of CI/CD pipelines. Perform regular database health checks, index analysis, and query optimization. Troubleshoot and resolve database issues, including slow queries, locking, and replication errors. What we seek in you: Proven experience as a PostgreSQL DBA with hands-on SQL development experience. Strong knowledge of PL/SQL and writing efficient stored procedures and functions. Experience with database schema design, normalization, and data modeling. Solid understanding of PostgreSQL internals, indexing strategies, and performance tuning. Experience with backup and recovery tools, pg_dump, pg_restore, replication, and monitoring tools. Proficient in Linux/Unix command-line tools for database management. Familiar with version control systems (e.g., Git) and CI/CD practices. Life at Next: At our core, we're driven by the mission of tailoring growth for our customers by enabling them to transform their aspirations into tangible outcomes. We're dedicated to empowering them to shape their futures and achieve ambitious goals. To fulfil this commitment, we foster a culture defined by agility, innovation, and an unwavering commitment to progress. Our organizational framework is both streamlined and vibrant, characterized by a hands-on leadership style that prioritizes results and fosters growth. Perks of working with us: Clear objectives to ensure alignment with our mission, fostering your meaningful contribution. Abundant opportunities for engagement with customers, product managers, and leadership. You'll be guided by progressive paths while receiving insightful guidance from managers through ongoing feedforward sessions. Cultivate and leverage robust connections within diverse communities of interest. Choose your mentor to navigate your current endeavors and steer your future trajectory. Embrace continuous learning and upskilling opportunities through Nexversity. Enjoy the flexibility to explore various functions, develop new skills, and adapt to emerging technologies. Embrace a hybrid work model promoting work-life balance. Access comprehensive family health insurance coverage, prioritizing the well-being of your loved ones. Embark on accelerated career paths to actualize your professional aspirations. Who we are? We enable high growth enterprises build hyper personalized solutions to transform their vision into reality. With a keen eye for detail, we apply creativity, embrace new technology and harness the power of data and AI to co-create solutions tailored made to meet unique needs for our customers. Join our passionate team and tailor your growth with us!

As a Product Support Engineer specializing in MySQL and PHP , you will provide technical support and troubleshooting for our software products. You will ensure client satisfaction by diagnosing and resolving issues, and collaborating with cross-functional teams to enhance product quality. Job Requirement Key Responsibilities: Technical Support: Address and resolve client inquiries and technical issues via phone, email, or chat. Diagnose and troubleshoot MySQL and PHP-related problems. Provide clear instructions to clients for problem resolution. Issue Escalation and Resolution: Escalate complex issues to senior engineers or development teams. Follow up with clients to ensure issue resolution and document solutions. Product Knowledge: Maintain in-depth knowledge of our products, particularly those using PHP and MySQL. Stay updated on MySQL and PHP developments and best practices Technical Skills: Proficiency in PHP and MySQL, including database design and query optimization. Experience with debugging tools and techniques. Familiarity with version control systems (e.g., Git). MS Excel

Job Description: Intellimind is seeking and PL/SQL Developer with 3-6 years of hands-on experience to join our expanding IT team. The ideal candidate will possess a robust technical knowledge of Oracle databases, be skilled in creating and configuring application pages using Oracle objects, and have actively contributed to both the design and development phases. This role involves collaborating with a team of skilled professionals to drive our database initiatives forward. Key Responsibilities: Participate in the full lifecycle of Oracle PL/SQL development. Develop, Test, and Implement Oracle PL/SQL packages, Table, View, Procedures, Functions and Triggers Create and configure application pages using Oracle or any database objects based on the product training provided by us. Assist in the analysis and gathering of business requirements. Improve query performance and optimize queries using both optimization tools and manual methods. Collaborate with other team members to integrate databases with other applications. Maintain data integrity and security using quality procedures and Oracle features. Follow assigned tasks and resolve issues using ticketing tools. Conduct root-cause analysis of technical and application issues. Create documentation for technical specifications, user manuals. Prepare development time estimates for requirements. Participate in regular team meetings to discuss ongoing projects and potential roadblocks with Project managers and Operations team. Stay updated with the latest Oracle features, technologies, and best practices. Work closely with the Business and Operations team - collaborate effectively to ensure alignment on project goals and priorities. Qualifications & Skills: Bachelors degree in computer science, Information Technology, or a related field. 4-5 years of hands-on experience with Oracle PL/SQL development . Proficient in Oracle Database SQL and PL/SQL with a strong working knowledge of DDL, DML, DQL, DCL, and TCL commands. Strong working knowledge in IDE Tools like Toad for oracle and optimization tools. Working experience in AWS RDS databases, No SQL databases Familiarity with database design principles and normalization. Strong problem-solving abilities and attention to detail. Ability to work both independently and as part of a collaborative team. Effective communication skills, both written and verbal. Knowledge of XML batch configuration and integration with Oracle. Experience with version control tools like GitHub. Ensure close collaboration with the Reporting Manager, Internal teams and the stakeholders. Working Hours : The shift timings for this role are flexible and may vary between 9:00 AM to 6:00 PM and 1:00 PM to 10:00 PM. Candidates should be available for both shifts as required

We are looking for a highly skilled Senior Software Developer with expertise in .NET Core, C#, React.js, and SQL to design, develop, and optimize full-stack applications. The ideal candidate will work closely with cross-functional teams, ensure adherence to best coding practices, and contribute to building scalable, high-performance applications. Key Responsibilities: Develop and maintain .NET Core backend services and React.js front-end applications. Design, implement, and optimize SQL Server databases, including queries, stored procedures, and performance tuning. Build and maintain RESTful APIs and integrate them with front-end applications. Collaborate with product managers, designers, and other developers to deliver high-quality software. Write clean, maintainable, and efficient code while following best practices and design patterns. Conduct code reviews and contribute to architectural decisions. Optimize application performance, scalability, and security. Troubleshoot, debug, and resolve software defects and issues. Stay updated with emerging technologies and propose innovative solutions. Required Skills Qualifications: Experience: 3+ years in software development with a strong background in full-stack development. Technical Expertise: Strong proficiency in .NET Core, C#, ASP.NET Web API . Hands-on experience with React.js, Redux, TypeScript, and front-end development best practices . Expertise in SQL Server , including database design, stored procedures, indexing, and query optimization. Experience with RESTful API development and integration . Knowledge of Azure/AWS cloud services and deployment strategies. Familiarity with CI/CD pipelines, DevOps practices, and containerization (Docker, Kubernetes) is a plus. Soft Skills: Strong analytical and problem-solving skills. Excellent communication and teamwork abilities. Ability to work in an agile development environment and adapt to changing priorities. Preferred Qualifications: Experience in building scalable enterprise applications. Microsoft Azure or AWS certifications.

Position : Database Developer (MS SQL) Position. Total Experience : 2 Years Location : Gandhinagar (Work from office) Shift timings : 2 PM to 11.30 PM Skill Set . Extensive experience designing, writing, and troubleshooting complex queries, stored procedures, functions, tables, and indexes Optimize large complicated SQL statements Diagnose and resolve database performance issues Development and maintenance of all T-SQL objects Ensure all database systems meet business and performance requirements Good to have experience with SSRS, SSIS, and PowerShell Experience in SQL 2008R2/2012/2014/2016 database management and related products from Microsoft Competency Technical documentation skills Ability to work within a team environment Familiar with upgrades, migrations, backup and recovery options Excellent verbal and written English skills Roles & responsibilities Work with the Technology Department to develop and enhance the centralized BI & Reporting Data Structure Collaborate with internal developers and product managers regarding database requirements, data stability, and other matters related to the databases Design, develop, test, and implement databases and database components related to internal and external systems integrated with the Reporting system Generation of complex views /material views for reporting and analytics Identify coding issues and provide fixes where necessary etc. Design and deploy various database components including schemas, queries, functions/stored procedures, views/materialized views, triggers identify opportunities to improve processes and procedures and suggest solutions to the problem Produce and maintain documentation including user guides for all systems developed

So, what’s the role all about? The purpose of this position is to deploy, operate and maintain NiCE’s global customer hosted databases, while also resolving customer issues that require direct access to the database infrastructure, and acting in an appropriate professional working style. The Engineer will report to the Manager, Infrastructure Cloud Operations while acting as part of the Database Team managing the databases in On-Prem data centers and AWS Cloud. How will you make an impact? AWS console administration New deployment tasks for databases & RDS services AWS RDS DB health check & availability checks using tools like CloudWatch and performance Insight. Read & analyse log/error log for Databases Alerts configuration, monitoring alerts and fine-tuning thresholds Perform RDS instance actions and comparison with Terraform code Export/import (Oracle) or backup/restore (SQL Server) specific data Installing/deploying databases, configuring backups, maintenance jobs and other features as needed to support database capacity, performance or product functionality requirements. Performing database administration tasks, including at latest versions of databases. Performing data restores, patchset / service pack installation and deinstallation, edition upgrade and downgrade, troubleshoot locking, corruption issues as well as suggest and implement solutions with minimal downtime Perform operational duties including database backups, application server health, service recycling. Identify and resolve operational issues (e.g. batch failures, network issues, client data feed errors) Experience in Monitor server performance, memory utilization, CPU, file systems, databases, batch jobs, backup and restore concept with best practise. Have a strong skills & experience in Microsoft SQLperformance tuning and queries optimization. Used SQL Profiler, Execution Plan, extended event, Performance Monitor and DBCC Commands. Extensive experience in SQL server high availability solutions- Log shipping, Mirroring, Replication, Clustering and always ON. Prepare, review, test, and execute T-SQL and PowerShell scripts to perform database administrative tasks as assigned. Investigate performance issues, provide and implement tuning solutions Act as part of a global team, creating and extending existing documentation as well as continuously sharing information and assisting on tasks with other team members. Working with monitoring tools Experience providing 24x7 support to production Software as a Service infrastructure, including participating in on-call rota and out of hours/weekend support when needed Have you got what it takes? 12+ Yrs. of experience as DBA in managing multiple DB engines. Hands on experience in multiple versions of Oracle and or MS SQL database is mandatory. Knowledge or experience working in Oracle, Microsoft SQL, Aurora, MySQL, Postgres will be an added advantage. Understand how automated backups are performed by AWS, know how to check the historical backup timings and how to perform ad-hoc snapshot Understanding of ITIL – incidents, service requests, change management Willingness to learn about technologies related to database and backup infrastructure, such as storage, backup, operating system and automation tools, cloud solutions or other database technologies. Demonstrated ability to effectively establish and maintain cooperative working relationships within a global, diverse, multicultural environment. Bachelor or Master’s Degree on Computer science or Information technology streams. You will have an advantage if you also have Basic coding skills in Python, Terraform. NiCE to have knowledge on AWS Cloud, AWS RDS apart from DB technology. What’s in it for you? Join an ever-growing, market disrupting, global company where the teams – comprised of the best of the best – work in a fast-paced, collaborative, and creative environment! As the market leader, every day at NiCE is a chance to learn and grow, and there are endless internal career opportunities across multiple roles, disciplines, domains, and locations. If you are passionate, innovative, and excited to constantly raise the bar, you may just be our next NiCEr! Enjoy NiCE-FLEX! At NiCE, we work according to the NiCE-FLEX hybrid model, which enables maximum flexibility: 2 days working from the office and 3 days of remote work, each week. Naturally, office days focus on face-to-face meetings, where teamwork and collaborative thinking generate innovation, new ideas, and a vibrant, interactive atmosphere. Requisition ID: 7503 Reporting into: Technical Manager. Role Type: Individual Contributor

No of years experience 5-8 years Detailed job description - Skill Set: 6+ years of total IT experience in development projects. 4+ years experience in cloud-based solutions. 4+ years in solid hands on snowflake development. Hands on experience in Design, build data pipelines on cloud-based infrastructure having extensively worked on AWS, snowflake, Having done end to end build from ingestion, transformation, and extract generation in Snowflake. Strong hand-on experience in writing complex SQL queries. Good understanding and experience in Azure cloud services. Optimize and tune snowflake performance 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. Certification on Snowflake and Azure will be added advantage. Mandatory Skills Snowflake, PLSQL, Azure Vendor Billing range (local currency /Day) 7500 INR/DAY Work Location BANGALORE

We are seeking an experienced Senior .NET Full Stack Developer with strong expertise in Microsoft Azure to join our dynamic team. This role involves designing, developing, and implementing scalable web applications and Micro Services while leveraging cloud services. You will be a key contributor to technical development and project execution. Key Responsibilities: Design, develop, and maintain web applications and Micro Services using .NET Core, C#, ASP.NET Core. Implement and manage Azure cloud services such as Azure Functions, Azure SQL, App Services, and Storage . Develop front-end components using React, HTML, CSS , and JavaScript . Write and optimize complex SQL queries, stored procedures, and indexing strategies . Ensure code quality through unit testing with NUnit , integration testing, and code reviews. Collaborate with cross-functional teams to define, design, and develop new features. Optimize application performance, security, and scalability in cloud environments. Manage CI/CD pipelines and automated deployments using Azure DevOps . Ensure code quality through unit testing and integration testing. Qualifications Skills: Experience in full-stack development with .NET technologies . Strong expertise in Azure services and cloud architecture. Proficiency in front-end frameworks like React . Expertise in unit testing with NUnit for test-driven development. Experience with RESTful APIs, Microservices. Extensive experience with SQL Server development, stored procedures, performance tuning, indexing, and query optimization . Experience with DevOps practices, CI/CD pipelines, and version control systems . Excellent problem-solving, communication, and teamwork skills. BE or any other related field.

DataArchitecture Design: Develop and maintain a comprehensive data architecture strategy that aligns with the business objectives and technology landscape. DataModeling:Createand managelogical, physical, and conceptual data models to support various business applications and analytics. DatabaseDesign: Design and implement database solutions, including data warehouses, data lakes, and operational databases. DataIntegration: Oversee the integration of data from disparate sources into unified, accessible systems using ETL/ELT processes. DataGovernance:Implementand enforce data governance policies and procedures to ensure data quality, consistency, and security. TechnologyEvaluation: Evaluate and recommend data management tools, technologies, and best practices to improve data infrastructure and processes. Collaboration: Work closely with data engineers, data scientists, business analysts, and other stakeholders to understand data requirements and deliver effective solutions. Trusted by the world s leading brands Documentation:Createand maintain documentation related to data architecture, data flows, data dictionaries, and system interfaces. PerformanceTuning: Optimize database performance through tuning, indexing, and query optimization. Security: Ensure data security and privacy by implementing best practices for data encryption, access controls, and compliance with relevant regulations (e.g., GDPR, CCPA) Requirements: Helpingproject teams withsolutions architecture,troubleshooting, and technical implementation assistance. Experiencewithbig data technologies (e.g., Hadoop, Spark, Kafka, Airflow). Expertisewithcloud platforms (e.g., AWS, Azure, Google Cloud) and their data services. Knowledgeofdataintegration tools (e.g., Informatica, Talend, FiveTran, Meltano). Understandingofdatawarehousing concepts and tools (e.g., Snowflake, Redshift, Synapse, BigQuery). Experiencewithdata governanceframeworks and tools.

Role : Mongo Database Developer Senior Location : Offshore/India Who are we looking for? We are looking for 5-10 years of experience in database development, with a strong knowledge of database management systems such as Mongo Database and NoSQL. Technical Skills: 5-10 years of database development experience Strong proficiency in MongoDB and NoSQL database management. Experience with database design, indexing, and query optimization. Knowledge of aggregation frameworks and data modeling. Familiarity with MongoDB Atlas and cloud-based database solutions. Understanding of database security, authentication, and encryption. Strong problem-solving and analytical skills. Familiarity with performance monitoring tools and database tuning techniques. Excellent communication and team collaboration abilities . Roles & Responsibilities Design and implement MongoDB database structures for optimal performance. Develop and optimize queries, indexes, and data aggregation pipelines. Ensure database security, backups, and failover strategies. Implement scalability solutions such as sharding and replication. Work with backend developers to integrate MongoDB with applications. Optimize read and write operations for large-scale databases. Monitor database performance and troubleshoot issues. Ensure data integrity and consistency across multiple environments. Automate database deployment and maintenance tasks. Stay updated with MongoDB best practices and new features. Qualification: Somebody who has at least 5-10 years of Mongo database development experience. Education qualification: Any degree from a reputed college

Job Summary: We are seeking a Database Developer with 4-5 years of hands-on experience in MS-SQL and MySQL. The ideal candidate will be responsible for designing, developing, and maintaining efficient and secure database systems to support business applications and data processes. Role & responsibilities Database Design & Development Design and develop scalable and high-performance MS-SQL databases and schemas. Create and maintain stored procedures, triggers, views, and user-defined functions. Collaborate with application developers to implement database solutions that meet business requirements. Query Optimization Write, review, and optimize complex SQL queries for efficient data access and manipulation. Analyze execution plans and improve query performance through indexing and refactoring. Performance Tuning Monitor and enhance database performance to ensure availability, responsiveness, and scalability. Identify and resolve performance bottlenecks through proactive tuning. Documentation & Reporting Maintain clear and comprehensive documentation for database designs, queries, and processes. Develop and support database reports as required by the business teams. Security & Compliance Implement and manage database security, including roles, permissions, and user access controls. Ensure compliance with internal policies and external data protection regulations. Continuous Improvement Stay updated with the latest trends, features, and best practices in database development. Recommend and support improvements in database architecture and processes. Preferred candidate profile Up to 4 years of experience in MS-SQL Server and MySQL database development. Strong SQL skills, including experience with writing stored procedures, triggers, and functions. Experience with performance tuning, query optimization, and indexing. Familiarity with database security and backup strategies. Strong analytical and problem-solving skills. Preferred Qualifications: Exposure to cloud database platforms like Azure SQL or AWS RDS. Experience in data migration or transformation projects.

ECMS Req # /Demand ID 529251 PU DNA Role Technology Lead Number of Openings 1 Duration of project 1-2 years No of years experience 5-8 years Detailed job description - Skill Set: 6+ years of total IT experience in development projects. 4+ years experience in cloud-based solutions. 4+ years in solid hands on snowflake development. Hands on experience in Design, build data pipelines on cloud-based infrastructure having extensively worked on AWS, snowflake, Having done end to end build from ingestion, transformation, and extract generation in Snowflake. Strong hand-on experience in writing complex SQL queries. Good understanding and experience in Azure cloud services. Optimize and tune snowflake performance 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. Certification on Snowflake and Azure will be added advantage. Mandatory Skills Snowflake, PLSQL, Azure Vendor Billing range (local currency /Day) 7500 INR/DAY Work Location BANGALORE BGV Pre/Post onboarding Pre Onboarding If its pre-onboarding, Interim or final BG report NA Hybrid Model 4-5 days in office Shift Timings NA

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 : NAMinimum 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

Project Role : Application Developer Project Role Description : Design, build and configure applications to meet business process and application requirements. Must have skills : Lucidworks Fusion Good to have skills : NAMinimum 3 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. You will collaborate with teams to ensure seamless integration and functionality of applications. Roles & Responsibilities:- Expected to perform independently and become an SME.- Required active participation/contribution in team discussions.- Contribute in providing solutions to work-related problems.- Develop and implement software solutions to meet business requirements.- Collaborate with cross-functional teams to ensure application integration.- Conduct code reviews and provide feedback for continuous improvement.- Stay updated with industry trends and technologies for enhancing applications.- Assist in troubleshooting and resolving application issues. Professional & Technical Skills: - Must To Have Skills: Proficiency in Lucidworks Fusion.- Strong understanding of search technologies and information retrieval.- Experience with search relevance tuning and query optimization.- Hands-on experience in developing and deploying search applications.- Knowledge of RESTful APIs and web services. Additional Information:- The candidate should have a minimum of 3 years of experience in Lucidworks Fusion.- This position is based at our Bengaluru office.- A 15 years full-time education is required. Qualification 15 years full time education

Job Summary: We are seeking a skilled Database Developer (SQL) to design, develop, and maintain efficient database solutions. The ideal candidate will have expertise in SQL development, database optimization, and data integrity management. This role involves working closely with cross-functional teams to develop and support database applications, ensuring performance, security, and scalability. Location: Bangalore Mode of Work: Work from office (5 days) Key Responsibilities: Design, develop, and optimize SQL databases to support business applications. Write complex SQL queries, stored procedures, functions, and triggers for efficient data retrieval and processing. Ensure database performance tuning, indexing, and optimization techniques. Maintain database integrity, security, and compliance with industry standards. Collaborate with software developers and analysts to understand database requirements. Develop and maintain ETL processes for data extraction, transformation, and loading. Troubleshoot database-related issues and provide timely resolutions. Monitor database performance and conduct regular maintenance tasks. Document database designs, processes, and best practices. Preferred Skills & Qualifications: Strong proficiency in SQL and relational database management systems (RDBMS) such as Microsoft SQL Server, MySQL, or PostgreSQL. Experience in writing and optimizing complex SQL queries and stored procedures. Knowledge of database indexing, normalization, and performance tuning techniques. Understanding of database security best practices. Familiarity with ETL tools and processes. Experience in data modeling and database design principles. Ability to work with large datasets and optimize query performance. Strong problem-solving and analytical skills. Desired Skills: Experience with cloud-based database solutions (Azure SQL, AWS RDS, or Google Cloud SQL). Knowledge of NoSQL databases such as MongoDB or Cassandra. Exposure to database automation and DevOps practices. Experience with reporting and BI tools like Power BI, Tableau, or SSRS. Strong communication and collaboration skills to work effectively with development teams. Ability to adapt to fast-paced environments and manage multiple database projects.

Primary mandate skills: Postgre SQL DBA Admin Secondary mandate skill: Mongo DB Flexible to hire in any location – If not, please mention job location: ONLY MUMBAI Postgre DBA Admin JD :- Job Requirements : - Engineering Degree in CS OR Equivalent majors - In-depth knowledge of PostgreSQL architecture version 12 to 16 - 3-8 years of NoSQL OR PostgreSQL DBA experience in a High Volume, heavy transaction database always up service. - Experience with PostgreSQL technologies including Streaming Replication, High Availability, Backup and Recovery . - Have proven experience in Query optimization and DB tuning for different production applications and use-cases - Hands on with Administration Tools and Maintenance Utilities such as Vacuum and Reindex - Be able to setup fine-grained and proactive monitoring & alerting - Experience in doing multi-site real-time - Expert level knowledge in at least one scripting language like shell or python and a strong understanding of Linux - Ability to communicate your vision to project stakeholders and upper management.

Job Summary Synechron is seeking a highly skilled Senior Data Engineer specializing in T-SQL and SSIS to lead and advance our data integration and warehousing initiatives. In this role, you will design, develop, and optimize complex ETL processes and database solutions to support enterprise data needs. Your expertise will enable efficient data flow, ensure data integrity, and facilitate actionable insights, contributing to our organizations commitment to data-driven decision-making and operational excellence. Software Requirements Required Skills: Proficiency in SQL Server, advanced T-SQL querying, stored procedures, functions, and scripting Expertise in SQL Server Integration Services (SSIS), including design, deployment, and troubleshooting Deep understanding of data warehousing concepts, schema design, and ETL best practices Experience in performance tuning, query optimization, and troubleshooting SQL and SSIS packages Hands-on experience with database security, compliance, and data masking standards Familiarity with source system analysis and complex data migration Preferred Skills: Experience with cloud platforms (Azure Data Factory, AWS Glue) Knowledge of Azure SQL, Amazon RDS or other cloud-based data services Experience with scripting languages like PowerShell or Python for automation Overall Responsibilities Design, develop, and maintain robust ETL workflows using SSIS to meet diverse data integration requirements Write optimized, scalable T-SQL queries, stored procedures, and functions aligned with data quality standards Develop and manage data warehouse schemas, tables, and relationships to support reporting and analytics Ensure data accuracy, security, and compliance across all data processes Collaborate closely with business analysts and other stakeholders to understand data requirements and translate them into technical solutions Troubleshoot and resolve performance issues in SQL Server and SSIS packages Document data workflows, schemas, and data mappings to support ongoing maintenance and audits Participate in code reviews, performance tuning, and implementing best practices for ETL and database management Support data migration projects and facilitate seamless data transfers between systems Technical Skills (By Category) Programming Languages: Essential: T-SQL, SQL Preferred: PowerShell, Python, or similar scripting languages for automation and scripting Databases & Data Management: Essential: SQL Server (2016 or higher), relational data modeling, ETL processes Preferred: Azure SQL, Amazon RDS, or other cloud-based databases Frameworks & Libraries: Essential: SSIS (SQL Server Integration Services) packages and components Preferred: Data analysis libraries (e.g., Pandas, Power BI integrations) Development Tools & Methodologies: Essential: SQL Server Management Studio (SSMS), Visual Studio, SQL Server Data Tools (SSDT), version control (Git) Preferred: Azure Data Factory, DevOps pipelines, automated deployment tools Design & Architecture: Data warehouse schema design (star schema, snowflake) Data flow and process automation best practices Security & Compliance: Basic understanding of database security, access control, and data masking standards Experience Requirements Minimum of 5+ years working in database development, data warehousing, or ETL processing Proven experience designing and optimizing large-scale ETL workflows in enterprise environments Demonstrated proficiency in writing complex T-SQL queries, stored procedures, and functions Experience with SSIS, including package development, deployment, and troubleshooting Background in data migration and data governance is preferred Industry experience in financial services, banking, or large enterprise environments is advantageous Alternative pathways include extensive hands-on experience or relevant professional training in ETL and database management Day-to-Day Activities Develop, test, and deploy robust ETL workflows using SSIS to meet business needs Build and optimize T-SQL queries, stored procedures, and functions for performance and reliability Analyze source system data structures, identify best-fit schemas, and design data warehouse models Monitor and troubleshoot ETL processes, resolving performance bottlenecks and errors Collaborate with stakeholders to gather requirements and translate them into technical designs Review and optimize database performance and security configurations Document data models, mappings, and processes for operational clarity Engage in regular team meetings, code reviews, and process improvement initiatives Qualifications Bachelors degree or higher in Computer Science, Information Technology, or related field Relevant certifications such as Microsoft Certified: Data Engineer or SQL Server certifications (preferred) Proven track record of designing and maintaining enterprise data warehouses and ETL processes Professional Competencies Critical thinking and analytical skills to troubleshoot complex data issues Strong communication skills for effective stakeholder engagement and documentation Ability to work independently and collaboratively in a fast-paced environment Adaptability to evolving data technologies and requirements Results-oriented with excellent time and priority management Commitment to continuous improvement and learning new data management techniques.

We are an escalations team in Operations that primarily works on databases, performance, infrastructure, scalability & innovate solutions Diagnose and resolve complex database performance issues across PostgreSQL and MySQL and provide RCAs Perform query optimization, indexing, and database configuration adjustments to ensure optimal response times and resource utilization. Proactively monitor and analyze database workloads, identify bottlenecks, and recommend improvements to developers and other teams. Perform MariaDB/MySQL to Postgres migrations. Provide on-call support during weekends on rotational basis. you'll get an opportunity of leading individual projects, including driving project outcomes & delivering technical solutions for complex business needs. Work with cross functional teams, pursue to the resolution of bugs identified. Proactive monitoring of customer infrastructure to avoid any P1/P2 escalations. Ensure that MTTR (Mean Time To Resolve) of any issues stays within SLA Deep dive on Database and ServiceNow Platform performance bottlenecks by utilizing performance engineering tools To be successful in this role you have: 5+ years of hands-on experience as a Database Administrator or Database Operations Engineer, with a strong focus on PostgreSQL and MySQL in production or business critical environments. Expertise in database architecture, indexing, query tuning, performance optimization, high-availability solutions and regular DB administration activities such as schema, tablespace and backup/recovery management. 3+ years of experience providing support on a SaaS, PaaS, or Cloud Infrastructure product/solution Proven experience with concurrency, multithreading, and distributed system architectures Hands-on experience with database monitoring tools and setting up effective alerts. Experience in data mining tool such as Splunk, Grafana or ELK stack tool. Unix skills: including development, navigation, file manipulation, permissions, searching/finding files and text contents, and administrative actions Develop and implement automation scripts (e.g., Python, Bash) for routine operational tasks, deployments, and health checks. Strong experience with application/database performance engineering tools (pgbench, sysbech, mysqlslap, jmeter, flamegraph) is highly preferred. Experience with ServiceNow platform, scripting, tuning, troubleshooting is highly preferred. Formal experience on a DevOps, support or Operational team is desired. Experience in supporting large scale web-based distributed application running on JVM/Apache/Tomcat is preferred