5 July, 2019
Job ID: 20190704009
Company: NTT DATA
Job Role: SQL DBA Admin L2
Vacancies: Not Mentioned
Salary: Not Mentioned
Expert in installation, upgrade and configuration of SQL Server 2005,2008 and exposure in clustered environment.
Work experience in 24*7 production Support for SQL server 2005 and 2008
Good knowledge of RDMS
Design development and implementation expericence in SQL server 2005/2008.
Experience in Log shipping with SQL servers
Experience in implementing snapshot and Transcational replication models.
Successfully implemented Database Mirroring in SQL Servers 2005 for high availablity.
Good knowledge in preparing Disaster Recovery documentation, planning and testing.
Developed backup and recovery strategies for production environment.
Experience in performance tunning, query optimization, client/server connectivity, and Database consistency check using DBCC utilities.
Expericence in extracting, transforming and loading of data from excel, flat files, Oracle to MS SQL server by using DTS import/export utility, SQL server integration services.
Upgradation of environment from 2000 to 2005, 2005 to 2008.
Performed Database Refreshers
Participated in launching the application in the production environment.
working with SQL Profiler and windows performance counters for diagnose SQL.
Server Health Check
Management of users including creation/alteration, grant of system/db roles and permissions on various Database objects.
Having very good exposure in back up and recovery policies and procedures.
Automating the environment for all regular activities by using SQL server jobs and maintenance plans
Analysis the growth of database as a part of capacity planning.