184 Complex Queries Jobs - Page 5

We Are Hiring Database Engineer Responsibilities: Administer, maintain and optimize high-availability/always-on and sharded MS SQL Server/PostgreSQL/MongoDB database clusters, ensuring data security, integrity and performance. Develop, maintain and optimize stored procedures, triggers, and other database objects to support efficient data manipulation and retrieval. Implement and oversee backup and recovery strategies to safeguard data against loss or corruption. Monitor database performance, identify and resolve bottlenecks and optimize query performance. Collaborate with developers, system administrators and other stakeholders to ensure efficient and effective use of database resources. Con...

Job Description: - Good hands-on experience on MS-SQL, T SQL, Cursors, Stored procedures, Functions, Joins & SSRS. Sound knowledge of SQL Server 2019 (database concepts, T- SQL and troubleshooting) Good knowledge of Database development including data modelling, developing Stored Procedures. Understanding/Decent knowledge of Database Query Performance tuning & optimization. Good exposure of day-to-day DDL, DML and DCL commands MSSQL SQL Agent SSRS Debugging Good communication skills

Job Role: Senior MS SQL Developer Location: Hyderabad Desired Experience: 2-4 years of experience as an MS SQL Developer or in a similar role Education: Bachelors degree in Computer Science, Information Technology, or a related field. Role Overview We are seeking a highly skilled and experienced Senior MS SQL Developer to join our dynamic team. The ideal candidate will have 2-4 years of relevant experience, with a strong background in database development and management. Prior experience in a SaaS environment is an added advantage. The candidate should possess in-depth knowledge of MS SQL Server and MySQL, including expertise in procedures, functions, triggers, DB backup & restore, temporary...

SQL/PL SQL, Teradata or BigQuery (mandatory), dynamic SQL, cloud database migration, SQL code conversion, debugging, production deployment, scheduler handling (Composer DAGs/Autosys), issue resolution, and end-to-end migration support.

You will be responsible for performing joins such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins of two or more tables. Additionally, you will be expected to work with Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve working with Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER. You should have a good understanding of creating and maintaining Views and Materialized Views, as well as executing Hierarchical queries for data retrieval from tables with hierarchical data structures. Furthermore, you will be required to handle Complex Queries involving Nested queries, inline views, correlated subqueries, and h...

Job Title: SQL Developer (4+ Years) We are looking for a skilled and detail-oriented SQL Developer to join our dynamic team. As a SQL Developer, you will be responsible for designing, developing, and maintaining SQL Server databases. You will work closely with cross-functional teams including application developers, analysts, and business stakeholders to ensure data accuracy, optimize database performance, and deliver reliable database solutions in a fast-paced Agile environment. This role plays a key part in ensuring data integrity and providing support for application development and business intelligence initiatives. Responsibilities: Database Design and Development: Design, implement, an...

4+ yrs of experience in SQL,T-SQL development Strong in writing complex SQL queries, optimizing database performance,CTE, Stored procedure,Joins,Triggers,Views,Functions Passport Mandatory Notice Period - Immediate only Email- sachin@assertivebs.com

About Intellismith Intellismith, is a dynamic HR service and technology startup. Our mission is to tackle India's employability challenges head-on. Currently, we operate two key lines of business: recruiting and outsourcing. With teams based in Noida, Chennai, Mumbai, and Bangalore, we collaborate with top brands in the BFSI and IT sectors. . As a leading outsourcing partners, we are hiring Data Analyst to work on a project for our client, which is the largest provider of telecoms and mobile money services in 14 countries spanning Sub-Saharan, Central, and Western Africa. Job Details Experience Required: 4+ years in SQL, Big Data, Hive, database Qualification: BE/B.Tech/Graduation in a compu...

Contract Duration: 6 months(Extendable) Hybrid Model - 3 days a week Mandatory Skills - SDET Selenium , Complex queries, Database Testing , Sybase, SQL Migration , Selenium , Cucumber , BDD Mandatory background verification checks include:

Hiring for USA based big MNC, Looking for a detail-oriented and experienced SQL Developer to join our team. The ideal candidate will be responsible for developing, maintaining, and optimizing SQL databases and writing complex queries to ensure data accessibility and integrity. You will work closely with data analysts, software engineers, and business teams to support various data-driven projects. Design, create, and maintain scalable databases Write complex SQL queries, stored procedures, triggers, functions, and views Optimize existing queries for performance and maintainability Perform data extraction, transformation, and loading (ETL) Monitor database performance, implement changes, and a...

Job description: We are looking for Senior / Lead PLSQL Development professionals for our IT services division. who is having experience in below technical stack. Please revert if you are interested with below requested information. Required Skills: Oracle PLSQL / PostgreSQL/ SQL Server Qualification: UG / PG Graduates Experience: 8-13 Years Location: Chennai / Coimbatore / Bangalore Work Time: 2pm to 11pm Work Mode: Hybrid Model (3 Days work from office) Notice Preferred: 0-30 Days. Responsibilities : Ensure performance, security, and availability of databases, Prepare documentations and specifications. Handle common database procedures such as upgrade, backup, recovery, migration, etc. Pro...

Responsibilities: * 3+ Yrs of Exp in SQL Development * Design, develop & optimize complex SQL queries * Manage large databases with efficiency * Collaborate on performance tuning strategies * Ensure data accuracy through rigorous testing Accessible workspace Flexi working Work from home Performance bonus Provident fund

You will be responsible for performing JOIN operations such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins on two or more tables. Additionally, you will handle Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve utilizing Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER for data analysis. You should be adept at working with Views and Materialized Views, understanding the basics of creating and maintaining views. Proficiency in executing Hierarchical queries for data retrieval from tables with hierarchical data is essential. Your expertise in handling Complex Queries like Nested queries, inline views, and co...

You should have a total of 5-6 years of experience in the field. Your skills should include expertise in ASP.NET, MVC, and C# programming. You should be proficient in object-oriented design and development. It is important that you have strong hands-on experience in database development and design using a major DBMS tool, with SQL Server being preferred. Your expertise should extend to the following areas: - Stored Procedures - Triggers - Functions - Writing, fixing, and troubleshooting complex queries - Experience in debugging client-side issues in browsers such as IE, Chrome, and Edge - Hands-on experience in client-side scripting with technologies like Javascript, jQuery, and KendoUI (goo...

Greetings from Aspire Systems!! We would like to give an opportunity again for your super talent. Aspire Systems is a global technology services firm serving as a trusted technology partner for our customers. We work with some of the world's most innovative enterprises and independent software vendors, helping them leverage technology and outsourcing in our specific areas of expertise. Our services include Product Engineering, Enterprise Solutions, Independent Testing Services and IT Infrastructure Support services. (https://www.aspiresys.com/) Our core philosophy of "Attention. Always." communicates our belief in lavishing care and attention on our customers and employees we appreciate your...

Your Impact: We are part of OpenText Cybersecurity Enterprise division specializing in Security Domain. Our product helps security operations teams to efficiently and effectively preempt and respond to threats that matter with proactive threat hunting, real-time threat detection, and response automation using AI/ML. What the role offers: Develops product architectures and methodologies for software applications design and development across multiple platforms and organizations within the Global Business Unit to fulfil product roadmap requirements Identifies and evaluates new technologies, innovations, and outsourced development partner relationships for alignment with technology roadmap and ...

Minimum 8 Years experience in Asp.Net, C# Experience with Angular 14 and .Net core 3+ years experience in SQL server. Minimum 4 years of experience on web API development Strong in writing Stored procedures/Functions/Views/ complex queries Experience with database performance optimization Able to lead the team technically Good communication skills Good in troubleshooting Agile knowledge is a must Good team player Handle multiple project deliverables MS certificate would be preferred Required Skills Job Skills ASP.Net 4.0, ASP.Net 5.0, Angular 4, C++ Programming CSS 3, Dotnet Core 2.0, Entity Framework HTML 5, JDBC, JQuery, Java Script, NUNIT PL/SQL, SQL Server 2014, WCF, Web API Location : -...

Minimum 8 Years experience in Asp.Net, C# Experience with Angular 14 and .Net core 3+ years experience in SQL server. Minimum 4 years of experience on web API development Strong in writing Stored procedures/Functions/Views/ complex queries Experience with database performance optimization Able to lead the team technically Good communication skills Good in troubleshooting Agile knowledge is a must Good team player Handle multiple project deliverables MS certificate would be preferred Required Skills Job Skills ASP.Net 4.0, ASP.Net 5.0, Angular 4, C++ Programming CSS 3, Dotnet Core 2.0, Entity Framework HTML 5, JDBC, JQuery, Java Script, NUNIT PL/SQL, SQL Server 2014, WCF, Web API

-3+ yrs of exp into MS SQL Development -Exp in writing complex SQL Queries -Normalizations -Differnt types of DB schema's ( like fact and dimention table, snowflake schema) -Table joins, Case statements, CTE , Window Functions in SQL. We are looking for immediate joiners only. Plz apply if you are available to join within 2 weeks of time .

Experience with Java Angular Experience developing java Rest API's using Springboot Experience with Cloud Technologies (GCP) Experience with key development and deployment tools (ex. GitHub, & Jenkins) SQL/database experience involving multiple, complex queries Analytical experience of complex applications and data relationships Team oriented with strong interpersonal skills and able to work as part of a product team Strong written/oral communication skills * Java Angular Experience developing java Rest API's using Springboot Experience with Cloud Technologies (GCP) 5+ years of IT experience in below Java Experience Strong Data and ETL experience Experience with APIs

Experience with Java Angular Experience developing java Rest API's using Springboot Experience with Cloud Technologies (GCP) Experience with key development and deployment tools (ex. GitHub, & Jenkins) SQL/database experience involving multiple, complex queries Analytical experience of complex applications and data relationships Team oriented with strong interpersonal skills and able to work as part of a product team Strong written/oral communication skills Java Angular Experience developing java Rest API's using Springboot Experience with Cloud Technologies (GCP) 5+ years of IT experience in below Java Experience Strong Data and ETL experience Experience with APIs.

Greetings! Currently hiring MSBI Developer & Support Role : MSBI Developer - Production Support Shift : Night Shift Exp : 6 to 8 Years Notice : Immediate to 20 Days Remote option available. JD: Work Type : Night Shift SSIS Highly proficient in SSIS with Strong knowledge of working in ETL development, Performance tuning, data profiling. Proficient in Data Migration from different sources using SSIS. Ability to walk through independently and logically understand existing SSIS Packages, Scheduling Jobs, and Debugging. SQL Well-versed in T-SQL Programming Highly proficient in SQL DB Complex Queries, indexing, stored procedures, functions, and joins. • Performance tuning & optimizations Basic DB ...

Required Skills & Qualifications : 5+ years of hands-on experience in data analysis roles. Expertise in Advanced SQL including window functions, CTEs, subqueries, and performance tuning. Strong understanding of data structures, ETL processes , and relational databases (e.g., MySQL, PostgreSQL, SQL Server, Snowflake). Experience with BI tools like Power BI, Tableau, Looker, or similar. Proficiency in Excel (PivotTables, advanced formulas, charts). Ability to interpret business problems into analytical solutions. Strong attention to detail, critical thinking, and problem-solving skills. Excellent verbal and written communication skills. Good to Have : Experience with scripting languages like P...

ORACLE PL/SQL Developer NO OF POSITIONS 2 REQUIREMENT STATUS IMMEDIATE WORK LOCATION – CHENNAI / MADURAI Job Type: Full-time Senior Software Engineer 5 – 8 years Technical Lead 8 – 12 years DESIRED SKILLS: 7+ years of hands-on experience in PL/SQL program development Strong knowledge on Oracle SQL & PLSQL (12C / 19C) Hands on experience in development projects Ability to code for complex requirements and debug them. Ability to lead developers. Ability to work independently on Procedure, Packages, Functions and triggers. Performance Tuning knowledge Analyze the Business Requirements and prepare technical documentation. Strong Analytical & programmatic skills Strong interpersonal skills and ab...

Key Responsibilities: Develop, test, and maintain complex SQL queries and stored procedures. Design and optimize data models, tables, and relationships. Write efficient SQL for data extraction, transformation, and loading (ETL) purposes. Create and manage Common Table Expressions (CTEs), temporary tables, and subqueries. Perform advanced data analysis using aggregate functions, window functions, and joins. Detect and eliminate duplicate records using techniques such as ROW_NUMBER() and RANK(). Write queries to support business reporting, analytics, and dashboards. Ensure data accuracy and integrity across multiple systems. Troubleshoot and resolve performance issues using indexing, execution...