Ms SQL Server

Resource Waits: Lock Waits: waiting for a shared lock on a table - 'LCK_M_S' IO Waits: waiting for a page to be read from disk. 
 'PAGEIOLATCH_SH' Memory Waits: waiting for a semaphore to be released to access memory 
 'RESOURCE_SEMAPHORE' Queue Waits: CPU Waits: waiting for another process to complete.
 its work - 'CXPACKET' Memory Waits: waiting for an external memory allocation to be released.
 'MEMORY_ALLOCATION_EXT' Wait for Tasks: Backup and Restore Waits: waiting for a backup or restore operation to complete - 'BACKUPIO', 'RESTOREIO'
  External Waits: Waiting for a CLR or extended stored procedure - 'CLR_AUTO_EVENT', 'EXTENSIBLE_HASH_LOAD' Synchronization Waits: Waiting for a semaphore or a latch - 'LATCH_EX', 'ASYNC_IO_COMPLETION' User Waits: Waiting for user input or action - 'WAITFOR', 'SLEEP' Network Waits: Waiting for network resources or connectivity - 'ASYNC_NETWORK_IO', 'NET_WAITFOR_PACKET

One of the MNC looking for following position
Job Title: Product Architect
Location : Kerala Trivandrum
Primary Skill: C#,.Net,WebApi,jQuery,Java,SQL
Year exp : 10+ Years
Shoot your CV: [email protected]

SQL Feathers: Fatal error during installing SSMS or Vsts
https://www.sqlfeathers.com/2021/07/fatal-error-during-installing-ssms-or.html

Multiple positions open for SQL BI (SSAS/SSRS) support Engineer at Microsoft India.
Location Bangalore/Hyd

Candidates having experience 5-12 years can be referred.
Share your resume on
[email protected]

Opportunity with an MNC in Infopark, Cochin

We are Looking for Java Backend Developers having 3-8 Years of experience with Java/J2EE. We provide excellent opportunity to grow, learn and upgrade your skill sets by working with an international team

Job Location: Kochi,Infopark,Kerala,India

Requirement:

Total experience of 3-8 Years with Java/JEE out of which at least 1 year in REST APIs using Spring/ Spring boot.
Experience on working with RDBMS like MS SQLServer.
Experience with GIT or Bitbucket, maven required.
Experience with agile development technologies.
Excellent analytical and problem solving skills.
Able to work independently with minimal supervision and able to take ownership accordingly.
Able to write well designed, testable and efficient code.
Knowledge about tools like Docker, Bamboo will be an added advantage.

Interested candidates please send resume to [email protected]

https://t.me/SQLFeathers

https://www.mssqltips.com/sqlservertip/6993/power-bi-email-reports-power-automate-rls/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211006

https://www.sqlfeathers.com/2014/04/rownumber-rank-denserank-ntile-in-sql.html?m=1

https://www.sqlfeathers.com/2021/07/fatal-error-during-installing-ssms-or.html?m=0

1.DevOps Architect
2.DevOps - Senior Engineer
3.DevOps Engineer
4.DevOps Infrastructure Senior Engineer
5.Linux Platform Architect
6.Android Application Lead
7.ADAS Architect
8.Infotainment Software Lead for Kanzi
9.Infotainment System Platform Architect
10.Python MicroServices Engineer/Lead
11.QT c++/QML
12.ML Engineer
13.Data Architect
14.Java Full Stack / Core Java
15.UI Technologies-Angular / Reacts
16.Cloud Technologies
17.C#.Net/WPF
18.C++ (Windows / Linux)
19.Infotainment Test Engineer (Automotive)
20.NET Full Stack
21.Technical Architect - Python Full Stack (Power Domain)
22..NET Core
23.Data Engineer
24.Data Architect - Hadoop, Cloud Native & NoSQL experience
25.Tech Lead - Data engineering Tableau
26.Senior Data Engineer

Opening in one of the MNC in Kerala if anybody looking for job change share your CV to [email protected],please mention job titile in header.

https://www.sqlfeathers.com/2020/04/finding-blockinglocking-queries-in-sql.html?m=1

https://www.sqlfeathers.com/2018/05/sql-query-optimization-tips.html?m=1

https://www.sqlfeathers.com/2021/04/reduce-null-value-space-in-sql-server.html?m=1

https://www.sqlfeathers.com/2021/02/what-are-basic-data-types.html?m=1

https://www.sqlfeathers.com/2020/11/sql-data-base-in-restoring-mode-after.html?m=1

https://www.sqlfeathers.com/2020/11/how-to-get-next-business-day-after.html?m=1

https://www.sqlfeathers.com/2020/11/different-query-method-in-sql-server.html?m=1

SQL Feathers: Find the SQL server Version
https://www.sqlfeathers.com/2020/10/find-sql-server-version.html?m=1

Hi All,

Excellent opportunity for MS SQlDBA(3--8years) Hyderabad location

Client : Mindtree

Mode : Permanent position with Mindtree

Exp – 3 to 8 yrs

Notice – 0 to 30 days

Work location - Hyderabad
Interview Date :23-August-20(sunday)
Interview mode:webex Discussion

Please find the detailed Job Description - SQL DBA

The person in this position will work in a team environment to support Customers using MS SQL Server.

· 3-8 years of Microsoft SQL Server Database Administration experience in SQL Server 2008R2/2008/2012/2014/2016.

· Installed SQL Server 2005/2008/2008R2/2012/2014/2016/2017 on new 32-bit and x64-bit Operating System.

· Experience in Migrating from SQL Server 2008 to SQL Server 2012 and from SQL Server 2012 to SQL Server 2014/2016.

· Experience in upgrading SQL server software to new versions and applying service packs and patches.

· Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, rescheduling jobs with SQL Server.

· Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks.

· Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.

· Experience with High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering.

· Proficient in implementing different types of Replication models like Snapshot, Transactional and Merge.

· Experience in Implementing Always On in SQL Server 2012, 2014, 2016 and 2017.

· Experience in Implementing Database Mirroring in SQL server 2005/2008/2008R2.

· Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2012 in Active/Passive.

· Auditing database configuration and security configurations.

· Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor.

· Experience with Database Backup and Restore.



Key success factors include:

Customer management and teaming skills, supporting customers on phone and written correspondence regarding technical questions and issues
Logical and Critical thinking skills
Deep technical and troubleshooting skills
Passion for technology and learni
Communicate efficiently both written and verbally with wide variety of the customers

Subject of mail" Ms SQl Dba "Hyderabad
If you know of people who would be a good fit and intersted please ask them to reach out to [email protected]

https://www.sqlfeathers.com/2020/08/where-are-temp-table-and-table-variable.html?m=1