SQL Database Administrator For MNC In spaze IT park Gurgaon

Capital Placement Services

5 - 8 Years
1 Openings
4.0-8.0 Lac/Yr
Faridabad
+3 Gurgaon, Noida, Delhi

Key Skills

Database Administrator SQL Administrator Sql Server Stored Procedures Triggers Views

Apply

Job Description

Good Experience in maintaining the production servers of multiple environments.

Creating new users on SQL server and Managing SQL Server Security.

Experience in Database backup and disaster recovery procedures.

Test backups to ensure we can meet the business Recovery Time Objectives (RTO)Experience in Replication (Mandatory)

Having knowledge of Bulk Data Merging using SQL Server Import or Export.

Wizard or writing queries on SQL Server query window

Creating and maintaining databases.

Monitoring, troubleshooting, and optimizing SQL Server performance.

Having knowledge of SQL Profiler to check the Execution Plan, Performance Monitor.

Monitored server performance, database, and transaction log growth, and error logs.

Help the database query developers on technical issues, ., writing queries like join or subquery, triggers, cursors, store procedures.

Have Experience of indexes.

Review and optimize SQL queries, store procedures, views, and triggers to help developers to achieve maximum efficiency and scalability.

Auditing of DML commands on SQL servers and individual database/s.

Troubleshoot SQL Server service outages as they occur, including after- hours and weekends

Configure SQL Server monitoring utilities to minimize false alarms

Creating the configuration Document for the database environment

Candidate should have good hands-on experience in SQL Data analysis using queries as well as using Microsoft Excel.

AWS RDS (database services)

All High availability concepts like log shipping, Replication, Mirroring, Always ON, Clustering.

Strong knowledge on Performance tuning

Knowledge on .net application projects and connection strings

Profiler and DTA usage and importance

Carry out Defragmentation, Memory management, data migration, server upgrades

Applying patches on existing or new SQL servers

Work from home

Experience : 5 - 8 Years

No. of Openings : 1

Education : Any Bachelor Degree

Role : Database Administrator

Industry Type : IT-Hardware & Networking / IT-Software / Software Services

Gender : [ Male / Female ]

Job Country : India

About Capital Placement Services

Capital Placement Services is a Gurgaon based Placement Consultancy that specializes in providing Placement Services, Manpower Recruitment, HR Consultancy, Placement Consultancy and Staffing Solutions. We have our own large computerized database of candidates across the various functional streams. We can do an exact search based on your requirements and come up with candidates who best meet your job description. We have a team of experienced professionals who do all the preliminary screening. We contact and interview candidates regarding their interest and suitability. Only after we are satisfied we send them for an interview to you. If necessary we also do an informal reference check of the candidate who are shortlisted.