108 Complex Queries Jobs - Page 2

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 tables, and indexes. Key Responsibilities Design, develop, and maintain complex database systems using MS SQL Server and MySQL Write and optimize SQL queries, stored procedures, functions, and triggers to support application development and reporting needs Perform database backup, restore, and recovery operations to ensure data integrity and availability Manage database security by developing and implementing access control mechanisms and ensuring data privacy Optimize and tune database performance, including indexing, query optimization, and troubleshooting slow-running queries Develop and implement database change management and version control processes Collaborate with development teams to design and implement database solutions that support application functionality and performance requirements Conduct database testing and validation to ensure data accuracy and consistency Monitor database systems for performance, reliability, and security issues, and take corrective actions as necessary Provide guidance and mentorship to junior database developers and other team members Key Skills Proficiency in MS SQL Server and MySQL Strong knowledge of SQL programming, including stored procedures, functions, and triggers Experience with database backup, restore, and recovery processes. Expertise in designing and managing indexes and temporary tables Proficient in database performance tuning and optimization techniques Solid understanding of database security and access control mechanisms Familiarity with database change management and version control practices Excellent problem-solving skills and attention to detail Strong communication and collaboration skills Ability to work independently and as part of a team in a fast-paced environment Qualifications Bachelors degree in Computer Science, Information Technology, or a related field. 2-4 years of experience as an MS SQL Developer or in a similar role Experience working in a SaaS product-based environment is an added advantage Certification in MS SQL Server or related technologies is a plus Benefits Competitive salary and performance-based bonuses Comprehensive health insurance plans and accidental coverage Opportunities for professional development and career growth A collaborative and inclusive work environment

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 have basic knowledge of Table Partitioning including table and index partitioning. In addition, you must have proficiency in PL/SQL and be able to create and maintain objects like procedures, functions, packages, types, and triggers. Your expertise should also include recursion, loops (FOR, WHILE DO), nested blocks, conditional logic (IF, CASE statements), and managing exceptions effectively. Moreover, you should be familiar with working with Collection & Records in PL/SQL blocks and executing BULK operations efficiently. Requirements: - Minimum of 2 years of relevant experience in posgress SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred certifications: - PL/SQL Developer Certified Associate Preferred Location: - Mumbai: Thane, Mulund, Bhandup, Vikroli, Ghatkopar, Kurla, and Powai Notice Period: - Immediate Joiner required This is a full-time position with a flexible schedule. You will be expected to work day shifts from Monday to Friday with morning shifts and weekend availability. Performance bonuses will be provided based on your contributions. Ability to commute/relocate to Mumbai, Maharashtra is required. Ideally, you should have a total of 1 year of work experience.,

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, and document database schemas, tables, relationships, constraints, and indexes. Create and maintain stored procedures, functions, and triggers based on business and technical requirements. Collaborate with developers and analysts to ensure the database structure supports application requirements and business rules. Database Optimization: Optimize and fine-tune SQL queries for performance and scalability. Conduct regular maintenance tasks, such as indexing, statistics updates, and database cleanup. Monitor server resource usage and proactively resolve performance bottlenecks. Apply best practices to ensure efficient and high-performing database systems. Conduct code reviews for SQL scripts, stored procedures, and database changes to ensure the best practices are followed. Ensure compliance with internal standards, data governance policies, and change management processes. Troubleshooting and Support: Troubleshoot and resolve database-related issues quickly and effectively. Ensure data security, accuracy, and integrity across environments. Implement and maintain appropriate error handling and logging mechanisms. Collaboration and Communication: Work closely with application development teams to embed efficient and scalable database logic. Reporting And Analysis: Develop custom reports and queries to support business intelligence and operational needs. Education and Experience: Bachelor's degree in related fields. 4+ years of experience in SQL Server. proficiency in SQL database designing, writing complex queries, and effective communication abilities. Knowledge and Skills required: Strong expertise in SQL Server and T-SQL/PL-SQL scripting. Skilled in designing and optimizing complex queries and stored procedures. Knowledge of Azure SQL and cloud-based database environments. Familiarity with version control systems such as Azure DevOps and Git. Understanding of NoSQL databases, SSRS, ETL Tools, Power BI is a plus. Effective interpersonal, problem-solving, and communication skills. Experience working within Agile/Scrum frameworks. Benefits: Opportunity to lead dynamic software development projects and teams. Room for career growth and advancement within the organization. Competitive compensation package. Additional Information: This is a full-time position located in Navi Mumbai. Inevia is an equal opportunity employer. We encourage applications from candidates of all backgrounds and experiences.

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 computer-related field Location: Gurugram (WFO) Notice Period: Immediate to 15 days (Candidates with a notice period of less than 30 days are preferred) Primary Skill: RDBMS Structure query language(SQL) Hive tables and query Big Data eco system SQL Developer Responsibilities Designing, developing, and maintaining databases Writing complex SQL queries for data retrieval and manipulation on RDBS and Big Data eco system Optimizing database performance and ensuring data integrity Build appropriate and useful reporting deliverables. Analyze existing SQL queries for performance improvements. Troubleshooting and resolving database-related issues Collaborating with cross-functional teams to gather requirements and implement solutions Creating and maintaining database documentation Implementing and maintaining database security measures SQL Developer Qualifications Strong proficiency in SQL and database concepts Good experience working on hive tables, trio query and big data eco system for data retrieval Experience with database development tools and technologies like Oracle, PostgresSQL, etc. Familiarity with performance tuning and query optimization Knowledge of data modeling and database design principles

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 apply new patches and versions when required Ensure database security, integrity, stability, and system availability Work with application developers to integrate database logic with applications Troubleshoot and resolve data issues in a timely manner Generate reports and data visualizations for stakeholders as needed Strong proficiency in SQL and experience with relational database systems such as MySQL, SQL Server, PostgreSQL, or Oracle Experience in writing and debugging stored procedures, functions, and complex queries Understanding of data warehousing concepts and ETL processes Familiarity with database design, normalization, and indexing Knowledge of performance tuning and query optimization Experience with reporting tools such as SSRS, Power BI, or Tableau is a plus Good understanding of data governance, security, and compliance Excellent analytical and problem-solving skills Strong communication and teamwork abilities

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. Profile server resource usage, and optimize and tweak as necessary Collaborate with other team members and stakeholders Perform Code reviews, Take part in software and architectural development activities. Strong proficiency with SQL and its variation among popular databases MS SQL Server, Oracle, Postgres etc. Activities include but not limited to Advanced database development experience (SQL & PLSQL). Create, Maintain and Optimize Stored Procedures, Functions and Packages. Familiar with database management programs ( SQL Developer, PL/SQL Developer) Knowledge of MSSQL , Oracle , PostgreSQL support for JSON Good Grasp of ETL concepts In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring) Good experience in performance tuning - table partitioning and best practices dealing with the datbases. Capable of troubleshooting database issues Proficient understanding of code versioning tools such as Git / Mercurial / SVN/ GitHub Excellent Analytical Skills Ability to plan resource requirements from high level specifications Carry out Impact Analysis , Estimate the work Be a problem solver, go -getter and self driven

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 correlated subqueries will be crucial. Knowledge of Table Partitioning, including table & index partitioning, is required. You will be expected to work with PL/SQL, creating and maintaining objects such as procedures, functions, packages, types, and triggers. Familiarity with recursion, loops (FOR, WHILE DO), nested blocks, and conditional logic (IF, CASE statements) is necessary. You must possess experience in managing Exception handling for run-time Oracle defined/user-defined errors. Understanding the usage of collections and records in PL/SQL blocks is vital. Proficiency in BULK operations for performing operations on bulk data is a must. Requirements: - Minimum 2 years of relevant experience in PostgreSQL SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: Preferred certifications: - PL/SQL Developer Certified Associate Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred Location: (Mumbai) Thane, Mulund, Bhandup, Vikhroli, Ghatkopar, Kurla, and Powai Notice Period: Immediate Joiner required. Job Types: Full-time Benefits: - Flexible schedule Schedule: - Day shift, Monday to Friday, Morning shift - Weekend availability Performance bonus offered. Ability to commute/relocate: - Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Experience: - Total work: 1 year (Preferred),

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 (good to have) - Familiarity with HTML5 and CSS3 - Preference for experience in mobile application development technologies, and willingness to work in this area - Experience in debugging server-side issues in IIS, C#, ASP.NET WebAPI, and ASP.NET MVC - Intermediate to advanced knowledge in Agile Methodology, with a preference for familiarity with SAFe Agile framework Overall, you should be a well-rounded professional with a strong technical background and a willingness to adapt to new technologies and methodologies as needed.,

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 interest in Aspire Systems. In this regard, please make it convenient to participate in our selection process. Position: MSBI/SSIS Support Job Location: Chennai /Bangalore/ Kochi / Remote Company : Aspire Systems Job Type : Permanent Experience: 5 to 8 Years Work Time: 3 PM to 12 AM Notice Period: 30 Days Job Description: SSIS Support 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 Administration knowledge to handle common database procedures such as upgrade, backup, recovery, migration, etc. Knowledge of best practices when dealing with relational databases. SSRS Basic knowledge in SSRS report development & deployment. Azure Profound expertise in SQL, T-SQL, database design, and data warehousing principles. Strong experience with Microsoft Azure tools including SQL Azure, Azure Data Factory, Azure Databricks, and Azure Data Lake. Proficient in Python, PySpark, and PySQL for data processing and analytics tasks. Performance optimizations in database and query processing. Excellent problem-solving, analytical, and communication skills. Please share the profile if you are interested at Sharmila.Palani@aspiresys.com for immediate response. Cordially Regards Sharmila Palani HR - Talent Acquisition

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 business value. Creates high level, reviews & evaluates designs and project activities for compliance with development guidelines and standards Provides tangible feedback to improve product quality and mitigate failure risk. Troubleshoot production issues within the defined SLAs and respond promptly and professionally to bug reports and customer escalations. Works with Quality Assurance to transfer knowledge and develop the test strategy and validate the test plan Leverages recognized domain expertise, business acumen, and experience to influence decisions of executive business leadership, outsourced development partners, and industry standards groups. Provides guidance and mentoring to less-experienced staff members to set an example of software applications design and development innovation and excellence. Writing and advocating excellent industry best practices for coding and testing What you need to succeed: 12+ years of technical experience with complex technology projects within large, distributed organizations on public clouds platforms like Azure (preferred) or AWS. Experience in overall architecture of software applications (multi-platform) for products and solutions. Expert in frontend technologies (HTML5, CSS3, JavaScript, React.js, Angular, or Vue.js) and advanced state management (Redux, Context API). Extensive backend experience with Node.js, Python, Java (Spring Boot), and building robust, scalable RESTful APIs. In-depth knowledge of SQL (PostgreSQL, MySQL) and NoSQL databases (MongoDB, Cassandra), with expertise in database optimization and complex queries. Advanced experience in version control (Git), CI/CD automation, and leading DevOps practices using Jenkins, GitLab CI, or CircleCI. Proficient in cloud infrastructure and services (AWS, GCP, Azure), with experience in containerization (Docker, Kubernetes) and microservices architecture. Excellent written and verbal communication skills Work experience with global stakeholders and customer interactions Ability to effectively communicate product architectures, design proposals and negotiate options at business unit and executive levels.

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 : - PAN India

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 Administration knowledge to handle common database procedures such as upgrade, backup, recovery, migration, etc. Knowledge of best practices when dealing with relational databases. SSRS Basic knowledge in SSRS report development & deployment. Azure Profound expertise in SQL, T-SQL, database design, and data warehousing principles. Strong experience with Microsoft Azure tools including SQL Azure, Azure Data Factory, Azure Databricks, and Azure Data Lake. Proficient in Python, PySpark, and PySQL for data processing and analytics tasks. Performance optimizations in database and query processing. Excellent problem-solving, analytical, and communication skills. Thanks, Safoora Nausheen Talent Acquisition Mobile: 9384788107 Mail to - safoora.imthiyas@aspiresys.com Website: www.aspiresys.com | Blog: http://blog.aspiresys.com

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 Python or R for data manipulation. Familiarity with cloud platforms like AWS, Azure, or GCP. Knowledge of data warehousing concepts and tools (e.g., Redshift, BigQuery). Exposure to CRM, ERP, or marketing analytics datasets.

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 able to work with peers. Insurance domain knowledge is preferred. Contact No: 86105 69663 Mail Id: sakthi.sankar@extendotech.com

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 plans, and query tuning. Collaborate with business analysts and data engineers to meet data requirements. Required Skills: Strong proficiency in SQL (preferably T-SQL or PL/SQL). Solid experience with joins, subqueries, CTEs, window functions, and aggregations. Deep understanding of GROUP BY, HAVING, ROW_NUMBER(), RANK(), and other analytical functions. Experience with DML (INSERT, UPDATE, DELETE) and DDL (CREATE, ALTER). Experience in debugging and optimizing complex queries. Hands-on experience with large datasets and transactional systems. Collaborate with business analysts and data engineers to meet data requirements. Required Skills:

IMPORTANT: This is not just a classic DBA position but it is a Application DBA(database developer + DBA) position. Please do not apply if you're a core DBA or BI developer. ***** This is not a remote position. If you're not in Hyderabad and can't come to office, please don't apply. ***** ***** Apply only who resides in greater Hyderabad and Secunderabad. ***** ***** Apply only your expected CTC is in the given range. ***** ***** Apply only who are willing to work in dynamic, fast-paced startup environment, would take on multiple roles and your passion for the company's mission. ***** Novaya is engaged in providing turnkey software solutions and service to our global clients. We specialize in web and mobile healthcare solutions for Acute and ambulatory clinics. Our client is a US based Health Tech solution provider and theyre on a mission to transform behavioral health through cutting-edge technology. The cloud-based platform helps care providers improve outcomes, streamline operations, and deliver better care. We're looking for a Senior SQL Server Developer to join our Hyderabad team. This role is ideal for someone who thrives in a collaborative environment, enjoys solving real-world problems, and has hands-on experience in working with SQL Server on Azure . Responsibilities: Design scalable database schema for high-transaction and high-volume applications. Build complex queries, views, stored procedures, functions and triggers, optimized for high performance. Analyze and improve slow running SQL queries. Excellent hands-on database experience and skills in developing complex MS SQL Server Stored Procedures, functions, triggers, complex T-SQL queries, views, T-SQL scripts etc. Excellent hands-on MS SQL Server database experience in troubleshooting, debugging, performance tuning, and query optimization in MS SQL Server. Strong in performance tuning and query optimization using Profiler, Execution Plans, Query Store and Wait Stats. Collaborate with development and systems teams on performance tuning and query optimization. Manages mission-critical databases, resolving incidents in collaboration with application teams. Proactively monitor and troubleshoot SSIS packages to ensure successful execution and resolve failures promptly. Experience in setting up the SQL servers in Azure IaaS Virtual machines. Experience in PaaS Databases like Azure SQL single database, elastic pools and Managed instances Monitored Azure SQL performance using Azure Monitor and Log Analytics; developed custom dashboards and real-time diagnostics with Kusto Query Language (KQL). Provided 24/7 support for production environments and actively monitored performance using SQL Sentry. Performs routine maintenance, health checks, and capacity planning to ensure optimal server performance. Created alerts, monitored activity logs, and troubleshot issues using Azure Portal and Log Analytics. Set up Azure Automation for scheduled maintenance tasks and point-in-time restores. Implement database changes and rollback strategies using CI/CD pipelines in Azure DevOps, integrated with Git projects for automated deployment and version control. Design scalable database schema for high-transaction and high-volume applications. Build complex queries, views, stored procedures, functions and triggers, optimized for high performance. Analyze and improve slow running SQL queries. Resolve database-related issues and provide solutions in a timely manner. Ensure performance, security, and availability of databases. Develop procedures and scripts for data migration. Build scripts for data archiving and purging. Build nightly jobs to handle batch activities. Support data encryption, masking and compliance and implement access controls to safeguard data. Work closely with backend engineers, DBAs, DevOps Engineers and BI analytics. Required Skills & Experience Must have Expert level hands-on database development experience and skills and database maintenance experience in Azure MS SQL Server. 8+ years of experience working with any relational and NoSQL databases and applying it in various applications, including within the Microsoft Azure platform. 8+ years of experience in Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and functions. Deep knowledge of T-SQL, performance tuning, and query optimization. Excellent in indexing, finding and resolving potential for database deadlocks. Proficiency with SQL Server security models, backups, restores, and HA/DR strategies. Experience using Azure Monitor, Log Analytics, and SQL Insights. Expertise in packaging and deploying SQL changes across 100s of databases as part of product releases. Experience with Data archiving and data purging. Hands on experience with NoSQL databases. Nice to Have Knowledge of SQL Server licensing and cost optimization strategies in Azure. Exposure to Redis Cache and MongoDB. Familiarity with Agile/Scrum development environments. What We Offer Opportunity to work on a meaningful product in the behavioral health space Competitive salary and performance-based incentives Flexible work culture with hybrid options Professional growth through mentorship, learning budgets, and collaborative culture Apply now and become a part of a mission-driven team creating tech that makes a real impact.