 |
|
 |
|
|
|
|
|
Company Name : Zenith Monitoring Services Pvt. Ltd Skills Required : (UG - Any Graduate) OR (PG - Any PG Course) Experience Required : 1 - 5 Year(s) Job Location : Mumbai Walkin Date : 03 February 2012 - 04 February 2012 Walkin Time : 10:00 a.m - 01:00 p.m Job Description : For SQL Database Developer:- 1) Strong SQL, Transact-SQL Programming. 2) Create and manage databases and their related components. 3) Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers. 4) Plan for the use of indexes. 5) Create and maintain indexes. 6) Create, use, and maintain data views. 7) Design, create, and use stored procedures. 8) Implement user-defined functions. 9) Create and implement triggers. 10) Program across multiple servers by using distributed queries, distributed transactions, and partitioned views. 11) Optimize query performance and tuning. 12) Analyze queries. 13) Manage transactions and locks to ensure data concurrency and recoverability For SQL Database Administrator:- 1) Must have solid understanding of relational data modeling concepts 2) Experience supporting development of web applications in a SQL/Server-application Environment 3) Able to write stored procedures / functions and parameterized queries (Mandatory) 4) Strong performance tuning skills at both the database and individual SQL levels, Performance Monitoring tools like SQL Server Profiler/System Monitor/ Activity Monitor (Mandatory) 5) Query optimization and performance tuning (Mandatory) 6) Solid experience writing and debugging queries/stored procedures, Able to write / test / 7) Update code and design to develop database objects and queries 8) Good working knowledge of Windows operating system 9) PERFORMANCE TUNING AND CONFIGURING SQL SERVER • Reconfiguring Memory/AWE options • Disk resources • Running Perfmon utility to Monitor Performance • Running Index Tuning Wizard • Managing Tempdb 10) Strong experience with database backup and recovery methods in a production environment • Backup and Restore Databases/Logs • Recovery of master database and device using buildmaster • Recovery of msdb database • Recovery of user database Walkin Venue : Zenith Infotech Ltd. Zenith Grande Plot No. 30 MIDC Central Road Nr. Hotel Tunga Paradise Andheri East Mumbai 400093 Contact Person: - Alpesh Email Address:alpesh.master@noc.continuum.net Telephone:91-22-28377300 Posted Date : 02/02/2012 Posted By : WalkinsIndia.com Support Team Print / Share this Walkin : Tweet
More Jobs : |
|
||||
Copyright © 2011 WalkinsIndia.com. All Rights Reserved.