Sql Database Administrator
Sql Database Administrator
Spectral ConsultantsThis job is no longer accepting applications
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:
Industry:
Employment Type:
About Company
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

