Client Server Technology Solutions

2 months ago


Hyderabad, India ClientServer Solutions Pvt. Ltd Full time

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 :

- 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, non-clustered), 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

Requirements :

- 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.

- In-depth 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 problem-solving skills and the ability to troubleshoot and diagnose database-related performance issues.

- Excellent communication and collaboration skills to work effectively within cross-functional teams.

- Attention to detail and a commitment to producing high-quality, optimized SQL code.

(ref:hirist.tech)
  • Dotnet Developer

    4 days ago


    Hyderabad, India Client Server Technology Solutions LLC Full time

    Company OverviewClient Server Technology Solutions LLC is a leading IT consulting company committed to providing innovative and best-in-class consulting, IT solutions, and services. With our customer-centric approach, we help our clients achieve their business objectives and make it a joy for both our clients and employees to work with us. With a team of...

  • Dotnet Developer

    5 days ago


    hyderabad, India Client Server Technology Solutions LLC Full time

    Company Overview Client Server Technology Solutions LLC is a leading IT consulting company committed to providing innovative and best-in-class consulting, IT solutions, and services. With our customer-centric approach, we help our clients achieve their business objectives and make it a joy for both our clients and employees to work with us. With a team of...


  • Hyderabad, Telangana, India ClientServer Solutions Pvt. Ltd Full time

    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...

  • IT Recruiter

    7 days ago


    Hyderabad, India Client server technology solutionS LLC Full time

    **Females only** **Responsibilities and Duties**: Also review and present resumes to hiring managers. Review and understand technical job requirements. Research on new technologies. Ability to build strong relationships. Ability to learn and know the new technologies in the market. Develop and execute recruiting plans Network through industry...

  • IT Recruiter

    2 weeks ago


    Hyderabad, Telangana, India Client server technology solutionS LLC Full time

    Females onlyResponsibilities and Duties:Also review and present resumes to hiring managers.Review and understand technical job requirements.Research on new technologies.Ability to build strong relationships.Ability to learn and know the new technologies in the market.Develop and execute recruiting plansNetwork through industry contacts, association...


  • Hyderabad, Telangana, India ClientServer Solutions Pvt Ltd Full time

    Location: Hyderabad (Uppal)Experience : 6.0 Years - 12YearsShift Timings : 12:30 Pm - 9.30Pm.Job Description :We are seeking a talented Senior .NET Developer to join our team. The ideal candidate will have expertise in .NET desktop and web application development, along with strong knowledge in database management, security/encryption, and DevOps CI/CD...


  • Hyderabad, India ClientServer Solutions Pvt Ltd Full time

    Location: Hyderabad (Uppal)Experience : 6.0 Years - 12YearsShift Timings : 12:30 Pm - 9.30Pm.Job Description :We are seeking a talented Senior .NET Developer to join our team. The ideal candidate will have expertise in .NET desktop and web application development, along with strong knowledge in database management, security/encryption, and DevOps CI/CD...


  • Hyderabad, India ClientServer Solutions Pvt Ltd Full time

    Location: Hyderabad (Uppal)Experience : 6.0 Years - 12YearsShift Timings : 12:30 Pm - 9.30Pm.Job Description : We are seeking a talented Senior .NET Developer to join our team. The ideal candidate will have expertise in .NET desktop and web application development, along with strong knowledge in database management, security/encryption, and DevOps CI/CD...


  • hyderabad, India ClientServer Solutions Pvt Ltd Full time

    Location: Hyderabad (Uppal)Experience : 6.0 Years - 12YearsShift Timings : 12:30 Pm - 9.30Pm.Job Description : We are seeking a talented Senior .NET Developer to join our team. The ideal candidate will have expertise in .NET desktop and web application development, along with strong knowledge in database management, security/encryption, and DevOps CI/CD...

  • Telecalling

    4 weeks ago


    Hyderabad, India Server Basket Full time

    Greeings from **Server Basket** We are hiring **Collection Coordinator** for our company **Location: Secuendrabad** - Roles & Responsiblities: _ - Responsible for acquiring reparations for debts owed to a company or individual. - Follow up calls to clients regarding upcoming Payment dues - Follow up calls to clients regarding Pending Payment dues -...


  • Hyderabad, India Aeries Technology Group Full time

    Job Description : Essential Responsibilities : - Responsible for client's products post implementation- Function as a technical escalation resource for issues with Confluence software solutions.- Resolve client issues with Confluence software solutions.- Communicate progress on issues t internal and external stakeholders.- Educate clients n best...


  • Bangalore/Hyderabad, Karnataka, India Aeries Technology Group Full time

    Job Description : Essential Responsibilities : - Responsible for client's products post implementation- Function as a technical escalation resource for issues with Confluence software solutions.- Resolve client issues with Confluence software solutions.- Communicate progress on issues t internal and external stakeholders.- Educate clients n best...


  • Bangalore/Hyderabad, India Aeries Technology Group Full time

    Job Description : Essential Responsibilities : - Responsible for client's products post implementation- Function as a technical escalation resource for issues with Confluence software solutions.- Resolve client issues with Confluence software solutions.- Communicate progress on issues t internal and external stakeholders.- Educate clients n best...


  • Hyderabad, Telangana, India Cognizant Technology Solutions Full time

    Principal ArchitectQualification:Science / Engineering graduateResponsibility:Innovation and Thought Leadership: ' • Participate in external forums (seminars paper presentation etc) to showcase Cognizant capabilities and insights. • Interact and engage with customers/ partners around new innovative ideas concepts assets. as well as industry trends and...


  • Hyderabad, India Cognizant Technology Solutions Full time

    Principal ArchitectQualification:Science / Engineering graduateResponsibility:Innovation and Thought Leadership: ' •  Participate in external forums (seminars paper presentation etc) to showcase Cognizant capabilities and insights. • Interact and engage with customers/ partners around new innovative ideas concepts assets. as well as...

  • Dba (Ms SQL Server)

    4 weeks ago


    Hyderabad, India Technology Next Full time

    **DBA (MS SQL server)** - **Position**_- Remote - **Experience**_ - 4 - 5 years - **Core Technology**_- SQL Server **Must have basic SQL developer experience as well** - **Required skills**:_ - Database development/administration experience gained in a commercial environment. - A sound knowledge of Microsoft SQL Server including T-SQL, replication, SSIS,...


  • Hyderabad, Telangana, India Cognizant Technology Solutions Full time

    RoleAssociate Director (Solutioning Lead)JOB DESCRIPTION Experience: Minimum 17+ years in technology development or automation, with a significant focus on AI and machine learning, and at least 5-7 years in business development, solutioning or client-facing roles within the technology sector. Role and Responsibilities• Develop and execute a comprehensive...


  • Hyderabad, Telangana, India Cognizant Technology Solutions Full time

    RoleAssociate Director (Solutioning Lead)JOB DESCRIPTION Experience: Minimum 17+ years in technology development or automation, with a significant focus on AI and machine learning, and at least 5-7 years in business development, solutioning or client-facing roles within the technology sector. Role and Responsibilities• Develop and execute a comprehensive...


  • Hyderabad, Telangana, India Cognizant Technology Solutions Full time

    **Principal Architect** **Qualification**: Science / Engineering graduate ** Responsibility**: **Innovation and Thought Leadership**: - ' '¢Â Participate in external forums (seminars paper presentation etc) to showcase Cognizant capabilities and insights. - '¢ Interact and engage with customers/ partners around new innovative ideas concepts assets. -...

  • SQL Server Dba

    1 week ago


    Hyderabad, India aThingz Solutions Private Limited Full time

    1. Strong Experience in Administration of MS SQL Server 2019, 2016, 2012, 2008 R2 and 2008 on standalone and cluster servers. 2. Ability to analyse and provide inputs pertaining to SQL Server DB architecture and Implementation Periodic monitoring of SQL Server jobs and configure Alerts. 3. Experience in creation of logins, users, configuring permissions...