Data Base Analyst

Job Title: Data Base Analyst

Company: PIT Solutions Pvt. Ltd.

Last Date: Wednesday, 31 August 2011

Contact Email: careers@pitsolutions.com

Designation: Data Base Analyst

Experience: 3-6 years

Location: Techno park, Trivandrum

Minimum Qualification: BE/BTech, MSc/MCA, PGDCA or any equivalent degree

Technical Skills: MS SQL Server 2005/2008,

Job description:

• • Creating/tuning/optimizing indexes, stored procedures,Views ,Triggers and Functions

  • Implement logical and physical data models at the project level.

  • Coordinating DDL changes; QA support; and the production implementation of all DB changes.

  • Estimation and Capacity Planning for database growth

  • Trace Analysis

  • Query Optimization and Query Execution plan Analysis

  • Database parameters tuning

  • SQL Login, database user creation and granting access

  • Schema creation and granting access

  • Re-Indexing

  • Update Statistics

  • Shrink Database

  • DMV's and DBCC Commands

  • Troubleshooting deadlock and blocking issues.

Proficiency in Transact-SQL (TSQL)

Preferred Skills:

• • Experience with scrum / agile development methodology

  • Strong analytical and problem solving skills

  • Ability to write complex stored procedures & database designing knowledge.

  • Good written and oral communication skills.