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