- Candidate much have
- SQL Query Optimization/ Stored Procedure Optimization
- Index Management
- Database Performance Monitoring
- Query Analysis/ Query Cost Reduction
- Database Tables Tuning
- Performance Testing
- Candidate must have Strong Communication.
- Good SQL knowledge and knowledge about DML, DDL etc.
- Strong SQL skills with regards to writing complex SQL joins, SQL window functions etc
- Stored Procedures and Functions strong working knowledge in native SQL store procedures how to read SP, design optimal SP, create/update SP and deploy SP.
- Performance Tuning techniques query optimization, query execution plans, indexes, JOIN operations, subqueries, and best practices for structuring queries
- Good knowledge about indexing indexes (e.g., clustered, nonclustered), when to use them, and how to balance index maintenance with query performance gains
- Database concepts
- Should have some understanding about concepts like buffer pools, query optimization algorithms, and locking mechanisms
- Performance Monitoring familiar with how to capture before and after performance stats, how to capture and read and gain insights on performance metrics, identify resource intensive queries. Knowledge about monitoring tools like SQL profiler etc
- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
- Proven experience as an SQL Developer with a strong focus on performance tuning, preferably on SQL Server platforms.
- Indepth understanding of SQL, relational database concepts, and data manipulation techniques.
- Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
- Expertise in analyzing and optimizing query execution plans to enhance performance.
- Familiarity with Microsoft SQL Server tools including SQL Server Management Studio (SSMS) and QueryPlan (SQL Execution Plans).
- Solid knowledge of database design principles, indexing strategies, and query optimization techniques.
- Experience with data caching mechanisms and strategies.
- Strong problemsolving skills and the ability to troubleshoot and diagnose databaserelated performance issues.
- Excellent communication and collaboration skills to work effectively within crossfunctional teams.
- Attention to detail and a commitment to producing highquality, optimized SQL code.
-
reaas Technology Solutions
6 days ago
KRREAAS Technology Solutions Pvt Ltd Hyderabad, IndiaApplication Security Architect · As an Application Security Architect, you will be responsible for designing, implementing, and maintaining security solutions to protect our organization's applications and data from cyber threats. You will collaborate with cross-functional teams ...
-
Bristol Myers Squibb Hyderabad, IndiaJob Description · Working with Us · Challenging. Meaningful. Life-changing. Those aren't words that are usually associated with a job. But working at Bristol Myers Squibb is anything but usual. Here, uniquely interesting work happens every day, in every department. From optimizin ...
-
Solution Architecture Ic5
2 days ago
Microsoft Hyderabad, IndiaMicrosoft is on a mission to empower every person and every organization on the planet to achieve more. Our culture is centered on embracing a growth mindset, a theme of inspiring excellence, and encouraging teams and leaders to bring their best each day. In doing so, we create l ...
-
Pega Decisioning
2 days ago
Cognizant Technology Solutions Hyderabad, Telangana, India**Sr. Technology Architect** · **Qualification**: · Bachelor's in engineering or equivalent · ** Responsibility**: · **Enterprise Asset Assessment**: · - Understand trends in client requirements and identify opportunities to enhance CTS capabilities across different functional ar ...
-
Security Solutions Architect, Amazon Selling
1 week ago
Amazon Dev Center India - Hyderabad Hyderabad, IndiaBachelor's degree · - Experience in any of the following: Cloud Architecture, Systems Design, Software Development, Infrastructure Architecture, Data Engineering or DevOps · The Solutions Architect role is a unique balance of technical depth and customer-facing experience to work ...
-
Machine Learning 5 to 11 Years Hyderabad and Chennai
20 hours ago
Capgemini Hyderabad, India**Job Description**: · - Identify opportunities where AI and machine learning can be applied to streamline processes, automate tasks, and enhance decision-making. · - Design end-to-end AI architectures that align with business objectives, considering data integration, model selec ...
-
Assoc. Dir. Ddit Dev. Td Ra
20 hours ago
Novartis Hyderabad, Telangana, India394896BR · **Assoc. Dir. DDIT Dev. TD RA**: · India · **About the role** · Role Title: Assoc. Dir. DDIT Dev. TD RA · Location: Hyderabad · Role Purpose: · - Senior Specialist for project delivery and/or operations in the given RA Publishing · - Partner with Business Stakeholders ...
-
Solution Architect
2 days ago
JMS ADVISORY SERVICES PVT Hyderabad, IndiaAround 10+ years of overall experience in developing and testing highly scalable software. · - Expertise in designing and implementing complex solutions which is scalable and maintainable in long · - run · - Sound knowledge in Front end (Angular/React) and Back end (Python/PHP/No ...
-
Mis Executive
1 week ago
MAKRO Hyderabad, India**Company Description**: · DDi is an innovative Technology partner for BioPharma and Medical Device companies. DDi has built its competency with a unique blend of functional / domain expertise to serve the technology needs of this industry. we serve Clinical, Regulatory, and Ente ...
-
Intern-td Mask Generator
1 week ago
Micron Hyderabad, India**Our vision is to transform how the world uses information to enrich life for **_all _**.** · Micron Technology is a world leader in innovating memory and storage solutions that accelerate the transformation of information into intelligence, inspiring the world to learn, communi ...
-
Service Assurance Architect
1 week ago
Cyient Hyderabad, India**Responsibilities**: · Solution Architect for OSS and their transformation, including enhancement to the current systems. · IT business solution partner with the overall responsibility to gather and analyse business, operation or products requirements for the purpose of developm ...
-
Dell Boomi Architect
1 week ago
Dataflix Hyderabad, India**Overview** · As a Dell Boomi Architect, you will be a crucial part of our integration team, responsible for designing, developing, and implementing integration solutions using the Dell Boomi platform. Your expertise in architecture, integration patterns, and best practices will ...
-
Sme Cohesity Backup
20 hours ago
Solugenix Corp Hyderabad, IndiaOverview: · Solugenix is an information technology services firm that has a rich history of providing comprehensive technology services and solutions for five decades.As a pioneer in IT services, we've partnered with some of the biggest global corporations across many industries. ...
-
Princ Engr-sys Architecture
1 week ago
Verizon Hyderabad, India**When you join Verizon**: · Verizon is one of the world's leading providers of technology and communications services, transforming the way we connect across the globe. We're a diverse network of people driven by our shared ambition to shape a better future. Here, we have the ab ...
-
Innova Solutions
5 days ago
ConsultBae Hyderabad, Telangana, India**Role: Software Developer** · **1. Software Developer** - Fullstack · **Mandatory** : Java, Spring Boot, ReactJS, Full-Stack Development · Optional : Data structure, integrations, streaming, microservices, event-driven code, database and UI development, Retail Domain with POS Ex ...
-
Data Architect
3 days ago
Technovert Hyderabad, India**Data Architect**: · **Experience : Years** · **Location : Hyderabad** · **Job Summary**: · The Data Architect will collaborate with stakeholders across departments to define data architecture principles, drive data integration initiatives, and ensure that data assets are utiliz ...
-
Contractor - S/4 Hana Fico
3 days ago
Yash Technologies Hyderabad, India FreelanceDate: Aug 18, 2023- Job Requisition Id: Location: Hyderabad, INYASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business ...
-
Ai Architect
5 days ago
Wipro Limited Hyderabad, Telangana, IndiaHyderabad, India · - Tech Hiring · **Job Description**: · **Role Purpose** · - The purpose of the role is to create exceptional architectural solution design and thought leadership and enable delivery teams to provide exceptional client engagement and satisfaction._ · **Do** · - ...
-
Ai Architect
5 days ago
Wipro Limited Hyderabad, Telangana, IndiaOverview: · **Role Purpose** · - The purpose of the role is to create exceptional architectural solution design and thought leadership and enable delivery teams to provide exceptional client engagement and satisfaction._ · **Do** · - **Develop architectural solutions for the new ...
-
Solution Architect
2 days ago
Novartis Hyderabad, Telangana, India394868BR · **Solution Architect (US&I PEAT)**: · India · **About the role** · Role Title: US&I PEAT Solution Architect · Location: Hyderabad · Role Purpose: · - Define the architecture of a solution elaborated in a program or a project using existing patterns. · - Contribute to t ...
Client Server Technology Solutions - Hyderabad, India - ClientServer Solutions Pvt. Ltd
1 week ago
Description
Job Description :
We are seeking an experienced SQL Developer with a proven track record in performance tuning on SQL Server platforms.
The ideal candidate should be a performance tuning guru, particularly focused on optimizing stored procedures, possessing a deep understanding of SQL, data concepts related to programming, and a keen awareness of performance issues.
Proficiency in utilizing Microsoft tools such as SQL Server Management Studio (SSMS) and QueryPlan (SQL Execution Plans) is crucial to excel in this role.
The SQL Developer will be responsible for enhancing the performance and efficiency of our database systems while collaborating closely with our development and infrastructure teams.
Roles and Responsibilities :