Req SQL Server Application DBA

Hi,

Greetings!!!

We have a position for our client.

 

SQL Server Application DBA

 

Work Location: Louisville, KY

Duration: 1 year

 

Relevant Experience (Yrs) :7-10 Years

Technical/Functional Skills :In depth knowledge of SQL Engine/Query optimizer/ Indexes / SQL Waits

 

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log 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 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 )

 

Familiarity with windows server, security delegation, SPNs, storage components

 

Added advantage – Good knowledge of effective database change management process  governing changes across dev/qa/prod regions

 

Roles & Responsibilities:

•Lead database changes ( configurations and implementation)

•Design and implementing  data model,

• Performance Tuning, Query Optimization

•Troubleshoot SQL Code and design

•Good written and verbal communication skills with strong analytical and problem solving skills.

 

 

Regards,

Arvind

--
You received this message because you are subscribed to the Google Groups "US_Jobs&Consultants" group.
To post to this group, send email to us_jobsnconsultants@googlegroups.com.
To unsubscribe from this group, send email to us_jobsnconsultants+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/us_jobsnconsultants?hl=en.