Required Skills

SQL Server DBA

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 :- 2nd Nov 2023

JOB DETAIL

Seeking a Senior SQL Server Database Administrator with 15+ years of current experience in the role to join a DBA team supporting more than 100 servers. Candidates should have the following skills:

- Be entirely comfortable discussing SQL Server at a detailed level.

- Experience installing and configuring SQL Server, especially SQL 2022. Can discuss new install options and best practices for securing and standardizing.

- Performance tuning. Should be able to discuss query plans, missing indexes, use of hints, query store, scans versus seeks

- TSQL skills. Can explain and write TSQL including joins, windowing, CTE's.

- Good experience with Availability Groups. Can discuss in detail how install, configuration, failover, and read only routing work-       Good verbal/written communication skills

- Practical experience with Log Shipping. Can 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

- Located in central/eastern time zone and available to work 8am to 5pm Eastern. Occasional evening or weekend work may be required.

- Must meet the requires of a US Person under ITAR rules

Additional skills that are useful but not required:

- Practical experience and demonstrable skills as far as installing and configuring SQL using Powershell and dbatools, can write Powershell during an interview

- Installing and configuring Reporting Services

- Install and use of Ola Hallengren maintenance scripts

- Monitoring using Solarwinds DPA

- Writing Splunk queries

Company Information