MSSQL Developer

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

• SQL