Microsoft SQL Development

I am proficient in a wide range of responsibilities with Microsoft SQL Server from designing, building, loading, testing, optimizing and troubleshooting databases and data warehouses. Installation considerations ought to go beyond just whether to perform a clean install, upgrade or migrate. Other consideration such as clustering and other resource requirements, default collation, file locations, growth strategy, and service accounts must be taken into account. Resolving database issues also requires detailed attention. Below is a list of some sample tasks I am capable of with regard to SQL.

• Design and build multiple database systems for specific functions such as Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP).
  
  
• Design and create the logical data model.
  
  
• Design and define entities. Considerations include entity composition, normalization and constraints.
  
  
• Design and build parameters for data validation constraints and processes with regard to business rules.
  
  
• Design and enforce attribute domain integrity.
  
  
• Implement, troubleshoot and optimize database transactions to ensure data consistency and recoverability.
  
  
• Manage appropriate locking strategies to ensure data integrity.
  
  
• Design and implement indexing strategies.
  
  
• Design and build XML schema structures.
  
  
• Retrieve, filter, group, summarize and modify data by using Transact-SQL.
  
  
• Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions and views.
  
  
• Troubleshoot and optimize programming objects.
  
  
• Optimize overall database performance.
  
  
• Design, implement and enforce security.
  
  
• Administrative tasks like backup and restore strategies and system monitoring.
  
  
• Extracting and transforming data
  
  
• Develop and manage DTS packages.
  
  
• Configure, maintain, and troubleshoot replication services.
  
  
• Create, manage, and troubleshoot SQL Server Agent jobs.
  
  
• Monitor and report on hardware resource usage.
  
  
• Resolve system bottlenecks.
  
  
• Design and build data warehouses.
  
  
• Program and enforce business logic by managing data manipulation, controlling data access, and implement error handling.
  
  

Contact me with the details of your specific situation and goals.