Sql Database Administrator

Spectral Consultants

Gurugram

4-8 Years

This job is no longer accepting applications

Posted 2 months ago
Over 200 applicants

Job Description

SQL Server DBA (2012, 2014, 2016) in Production, Development and Staging Environments
24/7 on Call Support for Production Database.
Experience in Upgrades, Patches, Configuration and Administration for SQL Server.
Experience in Setting up (HA) High Availability solutions like Availability group.
Experience in Troubleshooting, Backup and Restore of Databases.
Refreshing the DB from Prod to staging/Development environment.
Experience in upgrading SQL Server software to new versions, applying Service packs & hotfixes.
Experience in scheduling Backups and Restore, Maintenance plans using SSMS.
Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Standards.
Strong Communication & Management skills and Excellent Team player.
Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Index tuning, Update Statistics.
Experience in Migrating the SQL server from lower versions (2008R2,2012,2014) to the higher version (2016).
Experience in fetching the Bak files of RDS by Creating IMA role and option groups.
Experience in troubleshooting the high CPU usage.
Having little knowledge of Azure SQL managed Instances.
Experience in migrating on-prem data from to Azure cloud & azure data factory.

More Info

Job Type:

Permanent Job

Industry:

Consulting

Role:

Database Administrator

Function:

IT/Software Development - DBA/Datawarehousing

Employment Type:

Full time

Open to candidates from:

Indian

About Company

Spectral Consultants

Spectral Management Consultants is one of the professionally managed, talent search and human resource consulting firm in Delhi (N.C.R.) since 2001. We have multi-tiered portfolio of services.We have in-depth industry and functional expertise knowledge in our team.We have primarily deep domain enterprise & syndicated knowledge for the Outsourcing and Offshoring Industry, ITES, KPO, LPO, IT, BFSI, FRSC, Investment Banking

Job ID: 104491603

Jobs by Skill - IT