Data Base Analyst
Post date: Aug 08, 2011 1:15:6 PM
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.