US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 1st Nov 2023
REQUIRED SKILLS & QUALIFICATIONS:
• 5+ years of SQL Server Database Administrator experience to join a DBA team supporting more than 100 servers.
• Strong TSQL skills. Able to explain and write TSQL including joins, windowing, CTE's.
• Be entirely comfortable discussing SQL Server at a detailed level.
• Experience installing and configuring SQL Server, especially SQL 2022.
• Must possesses excellent verbal/written communication skills.
• Able to discuss new install options and best practices for securing and standardizing.
• Performance tuning. Able to discuss query plans, missing indexes, use of hints, query store, scans versus seeks.
• Good experience with Availability Groups. Abel to discuss in detail how install, configuration, failover, and read only routing work.
• Practical experience with Log Shipping. Able to explain how to set it up using SQL Server built in functionality, how to failover and fail back, and a good understanding of how it works.
• Comfortable engaging with stakeholders from other teams to discover requirements and pain points.
• Understands patching, including servers using Log Shipping and Availability Groups.