| SR. SQL DBA - Remote - CTS at Remote, Remote, USA |
| Email: [email protected] |
| From: Maneesh, Centraprise [email protected] Reply to: [email protected] Job Title: SR. SQL DBA Location: Remote Job Type: Contract Must Have 12+ Years Of Experience Job summary 12+ years of experience working with SQL Server in production environments (at least 3 of those years must be with SQL Server 2017 and higher) \\u2525 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 5+ years of experience working with Distributed Availability Groups Roles & Responsibilities 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 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 team increase code quality by adding to and refining existing standard If interested, please fill the below details and revert with your updated resume. Candidate Full Name Current Location Phone Email ID Skype ID Linked in ID Passport number Total Years of Experience Education Visa Status Willing to relocate Rate Last 4 Digits of SSN#: Availability to start on the project Previously worked with Cognizant (Y/N) If Yes Provide the CTS Emp ID Interview Availability with the time Zone Thanks & Regards Maneesh Sanghi| US IT Recruiter Centraprise Corp Desk/Direct: 848-271-1949 Ext 1039 3 Ethel Rd, #304, Edison, NJ 08817 [email protected] Keywords: active directory information technology golang Idaho New Jersey |
| [email protected] View all |
| Wed Jul 19 01:26:00 UTC 2023 |