MCITP: Database Administrator 2008

Candidates for this exam work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidates should also have experience with the following:

• Defining high-availability solutions
• Data distribution
• Automating administrative tasks (for example, checking db stats, backups)
• Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
• Defining security solutions
• Monitoring and troubleshooting the database server
• Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
• Designing and executing deployments
• Deployments and migration
• Defining the infrastructure (for example, storage, hardware, and number of servers or instances)