Database Analyst
Добавлено: 13 июл 2006, 11:31
[trn]Vot rekruter prislal, mozhet komu-to nado[/trn]
Database Analyst
We are looking for a Database Analyst to join our Development team. This role will appeal to a person who enjoys designing and developing efficient database solutions for large scale web-based applications.
Position Duties & Responsibilities:
• Data modeling and database design: plan, design, and construct logical and physical models
• Collect and develop metadata describing data elements; conduct data analysis to determine where and how the data is stored, business rules to be built into it, and how the data can be reused for various business needs
• Develop database solutions such as indexes, partitions, views, stored procedures, etc.
• Support application development team in understanding the data model
• Prepare database components and execute database modifications for Production release
• Perform database performance tuning and efficient utilization activities
• Production support and problem resolution when required; conduct root-cause analysis on problems as they may occur
Qualifications:
• Strong background in relational technology fundamentals, modeling and design; familiar with data modeling methodologies, tools and techniques.
• Minimum of 3 years experience with MS SQL Server architecture and design
• Minimum of 5 years experience with database programming including triggers, stored procedures, and complex SQL
• Post secondary degree in Computer Science or related field of study
• Strong knowledge of SQL Server 2000, and T-SQL
• Strong data analysis and database solution design skills
• Demonstrated experience in developing, maintaining, and supporting SQL databases in a MS SQL Server 2000 environment
• Proven experience with large scale databases (over 100 million rows) and deriving reporting cubes
• Service oriented with a focus on database reliability, service-level delivery, and quality of deliverables
• Good knowledge of OLAP
• COM+, .NET technologies, Perl, VB, ETL, Tools are asset.
• Sybase Power Designer or Erwin, XML is an asset
If you possess the aforementioned background requirements & skills, outstanding communication & interpersonal skills, a confident attitude, and the ability to work to deadlines then forward your resume in .doc format to: malexander@hays.ca, quoting reference #DBA962
We regret that we can only respond to candidates chosen for an interview.
Hays Information Technology has offices in Vancouver, Victoria, Ottawa, Kitchener-Waterloo and the GTA. We place our candidates with industry leaders on a permanent or contract/temporary basis and are a division of Hays Specialist Recruitment. Listed on the London Stock Exchange, the company operates in 22 countries and is the largest specialist recruitment firm in the world. We opened our first office in Canada in 2001.
To create your personal job alert, see other career opportunities, read up on best practices in job hunting or use our career map, go to:
http://www.hays.ca