SQL DBA Developer & Administrator

About The Company :
Landmark IT Solution based in Hyderabad strive to design, develop and deliver high-end and flawless services

Website : www.landmarkit.in

Job Profile : SQL DBA Developer & Administrator

Job Location : Hyderabad

Desired Experience : 3 - 5 years

Course Specialization : B.Tech/BE – CS/IT

Training/Probation Period : None

Batches : 2012/2011/2010

Salary : INR 4 LPA - 8 LPA ( The Salary depends on quality/Skills /performance in interview rounds of the candidate )

Bond : None

Date of Joining : Immediate

Tentative Interview Date*: Will be communicated post registration window is closed.

*The shortlisted candidates will be sent Admit Cards/Call Letters on their registered mail Id, which they will need to carry on the date of Interview. No candidate will be entertained by the company without the formal intimation from Aspiring Minds.

Job Descriptions :

-Strong experience in Database Administration in SQL Server

-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

Skills Required :

-Solid acquaintance with windows server, security delegation, SPNs, storage components.

-Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )

-Knowledge of 3rd party DBA tools and applications ( e.g redgate, idera, SCOM, Erwin )

-MCDBA / MCT certification

Interview Process :

-Written

-Technical Round

-HR Round