Data Base Analyst in PIT Solutions

Data Base Analyst in PIT Solutions

Job Title: Data Base Analyst
Company PIT Solutions Pvt. Ltd.
Closing On: Sunday, 15 July 2012
Contact Email: careers@pitsolutions.com ,
Job Description: Experience: 3-6 yearsLocation: Techno park, Trivandrum

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

Technical Skills: MS SQL Server 2005/2008

  • 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.

Comments

comments