| SeniorSQLServer Database Administrator Location: Ohio | mention visa and location at Ohio, New York, USA |
| Email: [email protected] |
| From: Sachin Nayak, Vyze Inc [email protected] Reply to: [email protected] Job Description - Title : Senior SQL Server Database Administrator Location : Ohio(remote) In EST or CST (Preference EST) - NO PST Duration: 6+ months MOI: Skype Team Size: 4 DBA's (Operational support, daily monitoring etc) End of life effort - have to upgrade 60 servers +, powershell, fixing as they go Will Require evening or weekend if needed but work life balance Azure Devops- Track hours within Azure devops SQL 2017, 2019, or 2022 experience is fine Powershell experience needed Splunk query writing just a plus not required and alot of the "extra skills" are bonuses just needs a STRONG SQL DBA Someone who can answer "how things work" Needs Senior + level Top 3 Skills Preferred "SQL Server performance tuning - TSQL using joins, windowing, CTE Seeking a Senior SQL Server Database Administrator with 5+ 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 Keywords: information technology golang |
| [email protected] View all |
| Wed Nov 01 19:07:00 UTC 2023 |