| Hiring!!!- SQL DBA - San Francisco, California (Remote) at San Francisco, California, USA |
| Email: [email protected] |
| Hi , Hope you are doing well. Please take a look at the below position and share me your updated resume to expedite the process.. Role: SQL DBA Location: San Francisco, California (Remote) Duration: 6+Months Job Description:- 12+ years' experience working with SQL Server in production environments (at least 3 of those years must be with SQL Server 2017 and higher) 5+ years must be with high-transaction OLTP instances running > 50k batch requests/sec Expert knowledge of SQL Server Availability Groups with a minimum of 6 years working with them in production environments and a thorough understanding of their use cases, problems, and pitfalls 3+ years of experience working with Distributed Availability Groups 5+ years working with SQL Server on Azure (both PaaS and SaaS offerings) Proven ability to manage databases > 40TB in size containing tables with > 1B rows Experience migrating multi-terabyte SQL Server databases to Azure without downtime Demonstrated understanding of SQL Server wait stats - how they are used and what ones are relevant Knowledge of query options and hints - what ones exist and when you would consider using them High level of knowledge of Windows Server and WSFC with an understanding of things needed to manage HA and DR as well as troubleshoot performance and connectivity Strong experience architecting SQL Server for HA and DR while maintaining performance at scale Extensive experience with PowerShell and creating your own modules for management and automation in SQL Server environments (beyond basic use of community created modules such as DBA Tools) Ability to look at a query and understand where performance problems may reside before looking at a query plan Understand a query plan, whats relevant, what isnt, and how to tune things for performance without just adding another index Able to speak the language of other teams (such as networking, AD, cloud, devops) to facilitate productive communications Knowledge of what breaks in SQL Server at scale and how to mitigate those issues Comprehensive understanding of SQL Server features and the knowledge to know when and when not to use them Be the go to person when theres a SQL Server issue and be able to quickly and efficiently triage issues and recover from them Extensive experience with database design - this goes beyond just understanding 3NF Comfort working with git Bonus Items Experience with SolarWinds SQL Sentry and knowledge to get under the covers and extract more data than provided by the clients Ability to guide and support more junior team members Comfort with helping development 1. Do you have 3 or more years of experience working with SQL Server 2019 2. Have you managed databases larger than 10TB as a DBA If so, for how long 3. Have you configured and troubleshoot High Availability Groups in SQL Server How many time have you configured HA Groups and have you configured HA Groups across more than 2 servers 4. Have you configured read routing using HA Groups If so, how often and have you done this in environments with more than 5 HA Groups 5. Do you have experience performance tuning complex queries and stored procedures using Performance Monitor and analyzing execution plans, index coverage and hints, etc at least 20 or more times If so, how many times and what were the largest and most complex examples Please Share Suitable Resumes to:- [email protected] -- Keywords: active directory information technology golang |
| [email protected] View all |
| Thu Jul 27 21:23:00 UTC 2023 |