Cisive India - Database Administrator - SQL/SQL Server (3-5 Yrs) Delhi (Systems/Product Software)

Database Administrator Role Category : Architect/Designer. Essential Criteria : - B.E B.Tech in Computer Science.
-MCA M.Tech candidates can also apply.
-Excellent SQL Server Debugging Techniques.
-Excellent troubleshooting skills.
-Self-motivation and the ability to work under minimal supervision are a must.
-Basic knowledge of database design and data modeling is desired. Key activities will include but not limited to the following : - Install and configure new SQL Servers.
-Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO).
-Ensure that new database code meets company standards for readability, reliability, and performance.
-Test backups to ensure we can meet the business- Recovery Time Objectives (RTO) - Troubleshoot SQL Server service outages as they occur, including after-hours and weekends - Configure SQL Server monitoring utilities to minimize false alarms - As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring - Deploy database change scripts - When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes - Document the companys database environment - Finding DMV queries to answer questions about server-level performance - Ensure that new database code meets company standards for readability, reliability, and performance - Each week, give developers a list of the top rated most resource-intensive queries on the server and suggest ways to improve performance on each - Design indexes for existing applications, choosing when to add or remove indexes - When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes - Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc) - Help developer to work on complex queries/scripts to make it easy.
-Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
-SQL Development - ability to write and troubleshoot SQL Code and design (stored procedure, functions, tables, views, triggers, indexes, constraints). Added Advantage : Any database related certification would be an added advantage.

Required Skills : English