![](https://cdn.nolocation.io/companies/1719212416065166333.png)
Job Description
Service DetailsService Scope of Work (SOW) - (NSSIMSIMG-MSSQL) Administration
l MSSQL User Account Managementn Create /drop/alter application accountsn Create/ drop/alter/Lock user accountsn Grant Access Rightsn Manage user profiles / Policiesl Database Administrationn Manage Initialization parametersn Naming conventionsn Datafile managementn Batch jobs management ( Root/MS SQL/Application accounts)n Maintain instance parameters and system settingsn Manage Database Linksn Maintain application objectsl Management of space on serverl Application specific administration Change & Configuration Management l Data Definition Scripts/ Schema Changes executionl Creation of servicesl Database / Instance creationl Create Application Objectsl Patch testing and applicationl Security Patches Fault Management l Response to alerts generated by monitoring systems or problems reported by customer/end-userl Troubleshooting, root cause analysis and identification of problem areal Resolution of problems through configuration changes/ re-installations / replacements within the given Architecture and design. (Any change in design will be treated as a separate scope).l Restart /shutdown instancel Connectivity issuesl Kill sessionsl Fix Broken jobs / queues Performance Management l 24 X 7 monitoring of performance parameters (Parameters as per “Monitored Parameters & Threshold” document) through best in class “NTT Companies in India” monitoring tool ‘NGmon’.l Auto alerts and notification to performance degradation / threshold violationl Generate and Analyze schema statisticsl Re-Indexingl Inter-database interaction managementl Generate, parse statisticsl Tuning pools / cachesl Tuning and Reducing Database CPU / IO Read/Writel Index performance Optimizationl Object Validity Checksl Disk & Datafiles Fragmentation Tuningl Execution of Dynamic Troubleshooting & Performance Views and Scriptsl Conduct Trouble shooting, root cause analysis and identify the bottlenecksl Suggest de-bottlenecking solutions. Operation Support
l Backup process execution1l Restoration of files and configuration when required2l Trouble ticket logging, update, and closurel Replication setup checks3l Backup and resize log filesl Version upgrades4 Version Support
l Standard, Enterprise, DC & Web editionl 2008, 2008 R2 and 2012, 2014, 2016
Key Skills
Related Jobs
![Canonical - Jobs](https://cdn.nolocation.io/companies/1660042917895383454.png)
Security Engineer Ubuntu
![LimeSurvey](https://cdn.nolocation.io/companies/1660423335339479365.png)
Senior Software Engineer
![Covariant](https://cdn.nolocation.io/companies/1662068976948151470.png)
Test Automation Engineer
![Plenty of Fish](https://cdn.nolocation.io/companies/1661544872112376170.png)
Senior Android Engineer
![LeadSimple](https://cdn.nolocation.io/companies/1661544812266350309.png)
Lead Software Engineer
![Iterative](https://cdn.nolocation.io/companies/1660423210424072051.png)
Senior Frontend Engineer
![Wander](https://cdn.nolocation.io/companies/1660231993025589187.png)
Data Engineer
![Covariant](https://cdn.nolocation.io/companies/1662068976948151470.png)
Production Engineer
![Commit](https://cdn.nolocation.io/companies/1660155122581611122.png)
Senior Back End Developer
![AON3D](https://cdn.nolocation.io/companies/1662069060345636558.png)
Senior Frontend Engineer Platform
![Philo](https://cdn.nolocation.io/companies/1660474887673216995.png)
IT Engineer
![Canonical - Jobs](https://cdn.nolocation.io/companies/1660042917895383454.png)
Senior Software Engineer Cloud Images
![Levity AI](https://cdn.nolocation.io/companies/1660642670139425624.png)
Senior Product Designer
![Clevertech](https://cdn.nolocation.io/companies/1660147397267007086.png)
Hands On Engineering Manager
![SOCi](https://cdn.nolocation.io/companies/1661544362311902003.png)
Full Stack Software Engineer
![Zuplo](https://cdn.nolocation.io/companies/1663248605340975309.png)
Senior Front End Developer
![Tettra](https://cdn.nolocation.io/companies/1660719903484302286.png)
Customer Success Manager
![Angi](https://cdn.nolocation.io/companies/1659875416164910470.png)
Senior Software Engineer .NET Core
![Ethereum](https://cdn.nolocation.io/companies/1661544528551725780.png)
Front End TypeScript Developer
![Toptal](https://cdn.nolocation.io/companies/1660146888834119919.png)