La credencial Microsoft Certified IT Professional: Database Administrator es la certificación para profesionales que implementan y administran bases de datos de Microsoft SQL Server™.


El perfil del candidato debe contar con experiencia usando SQL Server 2005 o una versión anterior de SQL Server. Asimismo serán estudiantes ó profesionales de TI que tienen empleos en qué la administración de servidores de base de datos es una de sus principales áreas de responsabilidad, e incluso trabajan en entornos en los que las bases de datos son fundamentales para sus áreas de trabajo. Estas funciones de trabajo incluyen:


• Profesionales en entornos en los que SQL Server es parte de una solución global en la empresa. Servidores de Base de Datos, CRM, ERP.
• Profesionales de Administración de Sistemas que deseen implementar ó ya ejecutan SQL Server.
• Profesionales que trabajan con aplicaciones de terceros que están integradas en SQL Server 2008.
• Desarrolladores que crean aplicaciones que utilizan SQL Server 2008.


Desde hoy puede destacar entre la multitud y acreditar el excelente nivel de ésta certificación de la mano de la propia multinacional.

Exam 70-431: TS: Microsoft SQL Server 2005 - Implementation and Maintenance


Installing and Configuring SQL Server 2005
· Install SQL Server 2005.
· Configure SQL Server 2005 instances and databases.
· Configure SQL Server security.
· Configure linked servers by using SQL Server Management Studio (SSMS).


Implementing High Availability and Disaster Recovery
· Implement database mirroring.
· Implement log shipping.
· Manage database snapshots.


Supporting Data Consumers
· Retrieve data to support ad hoc and recurring queries.
· Manipulate relational data.
· Manage XML data.
· Implement an HTTP endpoint.
· Implement Service Broker components.
· Import and export data from a file.
· Manage replication.


Maintaining Databases
· Implement and maintain SQL Server Agent jobs.
· Manage databases by using Transact-SQL.
· Back up a database.
· Back up a database.
· Restore a database.
· Move a database between servers.


Monitoring and Troubleshooting SQL Server Performance
· Gather performance and optimization data by using the SQL Server Profiler.
· Gather performance and optimization data by using the Database Engine Tuning Advisor.
· Monitor and resolve blocks and deadlocks.
· Diagnose and resolve database server errors.
· Monitor SQL Server Agent job history.
· Gather performance and optimization data by using DMVs.


Creating and Implementing Database Objects
· Implement a table.
· Implement a view.
· Implement triggers.
· Implement functions.
· Implement stored procedures.
· Implement constraints.
· Implement indexes.
· Create user-defined types.
· Implement a full-text search.


Exam 70-443: PRO: Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005


Designing a Database Server Infrastructure
· Design for capacity requirements.
· Specify software versions and hardware configurations.
· Design physical storage.
· Design instances.
· Design a database consolidation strategy.


Designing Security for a Database Server Solution
· Analyze business requirements.
· Integrate database security with enterprise-level authentication systems.
· Develop Microsoft Windows server-level security policies.
· Modify the security design based on the impact of network security policies.
· Analyze the risk of attacks to the server environment and specify mitigations.
· Design SQL Server service-level security.
· Design database-level security.
· Design object-level security.


Designing a Physical Database
· Modify an existing database design based on performance and business requirements.
· Design tables.
· Design file groups.
· Design index usage.
· Design views.
· Create database conventions and standards.
· Create database change-control procedures.


Designing a Database Solution for High Availability
· Select high-availability technologies based on business requirements.
· Develop a strategy for migration to a highly available environment.
· Design a highly available database storage solution.
· Design a database-clustering solution.
· Design database mirroring.
· Design a high-availability solution that is based on replication.
· Design log shipping.


Designing a Data Recovery Solution for a Database
· Specify data recovery technologies based on business requirements.
· Design backup strategies.
· Create a disaster recovery plan.


Designing a Strategy for Data Archiving
· Select archiving techniques based on business requirements.
· Design the format of archival data.
· Specify what data to archive.
· Plan for data archival and access.
· Design the topology of replication for archiving data.
· Design the type of replication for archiving data.


Exam 70-444: PRO: Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005


Optimizing the Performance of Database Servers and Databases
· Troubleshoot physical server performance.
· Troubleshoot instance performance.
· Troubleshoot database performance.
· Troubleshoot and maintain query performance.
· Troubleshoot concurrency issues.


Optimizing and Implementing a Data Recovery Plan for a Database
· Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
· Plan for fault-tolerance.
· Recover from a failure of SQL Server 2005.
· Recover from a database disaster.
· Salvage good data from a damaged database by using restoration techniques.


Designing a Strategy to Monitor and Maintain a Database Solution
· Define and implement monitoring standards for a physical server.
· Choose the appropriate information to monitor.
· Create and implement a maintenance strategy for database servers.
· Design a database maintenance plan.
· Design a strategy to manage Reporting Services.


Designing a Database Data Management Strategy
· Design and manage SQL Server Integration Services (SSIS) packages.
· Enforce data quality according to business requirements.
· Design data integrity.
· Design a strategy to manage data across linked servers.
· Design a strategy to manage replication.
· Optimize a database control strategy to meet business requirements.


Designing a Strategy to Manage and Maintain Database Security
· Perform a security audit of the existing security infrastructure based on the security plan.
· Maintain a server-level security strategy.
· Maintain a user-level security strategy.
· Prepare for respond to threats and attacks.