Candidates for this exam should have five or more years of hands-on SQL Server experience planning complex mission critical environments. Competencies include designing and implementing high-performance, scalable, secure enterprise environments and identifying and resolving issues.
The candidate may include senior-level consultants, support engineers, technology architects, senior database engineers, developers or administrators. The MQC uses knowledge of the organization’s environment to deliver timely and high-quality solutions to customer problems.
The candidate is able to manage multiple instances of SQL Server, and is able to use a variety of features and automation tasks using a thorough understanding of SQL Server design and architecture.
The candidate is able to set comprehensive, enterprise-wide standards and associated policies related to a database solution.
The candidate is able to mentor and guide database administrators and database developers. The MQC is the final point of escalation within an organization’s mission critical environment and is able to take charge of situations with confidence.
The candidate performs in a technical leadership role and typically influences senior leadership. The MQC has a thorough understanding of SQL Server core engine components and dependencies, such as OLTP, high availability, disaster recovery, performance-tuning and optimization, SQLOS, storage engine, relational engine, security, manageability, and distributed data technologies.
What can this person do without assistance?
Meet complex and conflicting business requirements based on recovery point/time objectives
Identify and determine a strategy to recover from a corruption scenario
Design and implement a strategy to prevent data corruption
Create compliance solutions based on business-specific requirements
Choose the right features to meet business requirements for high availability
Manage multiple features for a single solution (such as combining replication and mirroring)
Enforce varying standards and policies across the enterprise via automation
Use features such as Central Management Server, partitioning, Utility Control Point, etc.
Troubleshoot poorly-performing highly-complex queries
Establish best practices based on performance scalability based on patterns and anti-patterns
Identify and remediate external factors that affect performance issues
Identify root-cause for performance issues
Define appropriate baselining and benchmarking methodology and associated tools
SQLOS and storage engine internals
Analyze the operation of a SQL Server instance by using Dynamic Management Views, catalog views and Extended Events
Design and implement highly-scalable OLTP- centric database design and associated T-SQL access methods
Evaluate operational implications of developers’ technology and feature choice
Scale Up and Out design and approach based on application and business requirements
Identify and resolve instance level issues
Diagnose root cause of a SQL Server instance not starting
Diagnose connection failure issues
In what environments?
Mid to large sized (Enterprise) environments.
Using what tools?
Microsoft SQL Server core tools (for example, SQL Server Management Studio, sqlcmd, SQL Profiler, SQL Server Configuration Manager), PowerShell