job posted by

Uddin

,

Summary

  • Job Level

    DBA Jobs

  • Location

    ,

  • Specialization

    Design/Developement

  • Category

    IT - Software Jobs

  • Job Type

    Full Time

  • Minimum Qualification

    B.E

  • Preferred Years of Experience

    1 - 3 years

  • Application Deadline

    2019-07-27

  • Available Slots

    4

  • Skills

Related Trainings

SQL Server DBA Client of COSX

, 1 year ago
Job Description

Job Summary
We are looking for MS SQL Server DBA role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.
Required Experience and Qualifications

REQUIREMENTS:
We are looking for a person who:

Has 6+ years of experience in database development and support in MS SQL Server environments.
Strong experience in Database Administration in SQL Server ( 2012 and 2016 )
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Expert experience in implementing operational automation.
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
SQL Database Operational support to tech users

Nice to have skills:

Solid acquaintance with windows server, security delegation, SPNs, storage components.
Documentation skills for processes and procedures
Knowledge of 3rd party DBA tools and applications ( e.g redgate, idera, SCOM, Erwin )
MCDBA / MCT certification

EDUCATION:

Bachelor or Master degree in computer or relevant streams.

Job Type: Full-time

Salary: ?500,000.00 to ?1,200,000.00 /year

Experience:

work: 6 years (Preferred)

Education:

Bachelor's (Preferred)

Copyright © 2016 - 2020 Udyogam.com . ALL Rights Reserved.