SQL Database Administrator For MNC in Spaze IT Park Gurgaon

Capital Placement Services

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

• Type of Job

  Full Time

• Work Location Type

  Work from Home