clipped from www.bestjobsca.com
In order to apply for this job please copy and paste the below link in address bar of you browser
• Assume a technical leadership role for SQL server 2000 and 2005. This is a highly visible position and a person with strong knowledge of SQL Server 2000/2005 administration and support would be a right fit.
• This role will help to define internal release and testing process and be proactively involved in the future changes made to database, hardware, availability, replication and backup strategies.
• This person would be leading the SQL server replication and backup and on-going maintenance.
• Optimize and review existing schemas and stored procedures and recommend optimizations for enhancing performance of existing platform.
• Take leadership role in monitoring available disk space and plan for the future.
• Monitor all SQL jobs and DTS package execution.
• Create and Run scripts in production environments.
• Create Reports using Reporting Services and Crystal Reports
• Monitor and support a data warehouse application running on Analysis Server.
• Manage all aspects of incident response related to internal threats
• Design, document, and promote security "best practices", policies, standards and protocols
• Provide guidance and consultation on database related questions from management, technical teams or users as required
• Maintain and increase knowledge and skills pertaining to field through training and study
Experience:
• 5+ years of SQL server DBA experience preferred with at least 1 year on SQL server 2005.
• Ability to develop and modify SQL Server DTS/SSIS packages to extract, transform and load data from various sources on an on-going basis.
• Expert knowledge of Analysis server, Reporting Services, replication, log shipping, backups (local and off-site).
• Solid understanding of SQL server security administration.
• Expert performance tuning/MS SQL server development skills - SQL Profiler and Performance Monitor, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indices and statistics (Query Optimizer).
• Comfortable working in multiple simultaneous implementations.
• Requires strong communication skills, both verbal and written, and organizational skills.
• Demonstrated aptitude towards problem root cause identification and resolutions.
• Knowledge of .NET development, XML, T-SQL Development is desirable.
• Knowledge of Microsoft SharePoint Office 2007 Administration is desirable.
