| SQL Server DBA @ Remote Visa: USC, GC, GC EAD, H4 EAD at Remote, Remote, USA |
| Email: [email protected] |
| Hello Associate, Hope you are doing well We have the below requirement open. Please send me your genuine candidate on my email ID [email protected] Position: SQL Server DBA Location: Remote Visa: USC, GC, GC EAD, H4 EAD Need 12+ years exp Job description: Skill Highlights- please indicate the # of years on each of the following skills: SQL Server DBA High transaction OLTP instances >50k batch requests/sec Azure SolarWinds Sentry Basic Requirements: 12+ years experience working with SQL Server in production environments (at least 3 of those years must be with SQL Server 2019) 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 Thanks & Regards, KARTHEEK KOLA US IT RECRUITER RITWIK Infotech, Inc Call me +1 248-232-0011 EXT 106 Email: [email protected] http://www.ritwikinfotech.com 38345 W. 10 Mile Rd, Suite 253|| Farmington|| MI 48335|| USA| **We strengthen Oracle EBS/Fusion Cloud, NetSuite Cloud and BI Partners & End Customers by accelerating career development.** Keywords: business intelligence active directory information technology golang green card Idaho Michigan |
| [email protected] View all |
| Thu Jul 27 02:06:00 UTC 2023 |