• DBASQL Developer Jobs in Gurgaon,India - 25310357

  • Save Job
  • 3 - 4 Years
  • Posted : above 1 month

Job Description:


- 3-4 years of experience in Microsoft SQL Server 2005 and higher & SQL

- 2 implementing and managing multi-node clusters

- Advanced knowledge of MS SQL, Server Integration Services (SSIS), SQL Server Always On Availability, SQLReplication, Azure cloud, and Microsoft Clustering

- Working knowledge of SQL 2005, 2008, 2012, 2016
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security

Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics

Resolving Space management issues like Database and log file space issues

Database consistency check using DBCC utilities

Troubleshooting transaction logs and Tempdb when full

Experience in using DMV and dynamic management functions for finding out long running queries

Experience in implementing different types of Replication models like snapshot replication and Transactional replication

Experience in supporting and managing multiple Production, Staging, Development instances

Experience in Database shrinking and analyse growth patterns in detail

Should have knowledge of Database Archiving and Table Partitioning

Configure SMS and mail alerts in SQL Server for Jobs and schedules

Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end

Refine and automate regular processes, track issues, and document changes

Assist developers with complex query tuning and schema refinement using SQL Server Profiler, Database Tuning Adviser

Provide 24x7 support for critical production systems

Perform scheduled maintenance and support release deployment activities after hours

Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members

- Working experience of High Availability (HA), mirroring and Disaster Recovery (DR), Clustering, AlwaysOn options for MS SQL Server Multi-node clustering is required

- Qualified to troubleshoot and resolve database integrity, performance issues, blocking and deadlocking, replication, connectivity, indexes and security issues

- Configure / Manage /Optimize Azure Cloud with multi tenancy independently

- VLDB experience is required

- Analysis Services and Reporting Services a plus

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : IT-Software
Functional Area : IT Software : Software Products & Services
Role : Database Administration (DBA)
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status