Required Skills

install configuration failover

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 1st Nov 2023

JOB DETAIL

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.

Company Information