Job Description :
SQL DBA
Location: San Ramon
Duration: 6 Month +


Position Requirements:
Has 7+ years of experience in database development and production support of medium- to large-scale mission-critical MS SQL Server environments (multi- terabyte
Strong hands-on experience in Database Administration in SQL Server (2008/2012/2014)
Creating and configuring the physical database and database instances
Performing Enterprise wide Database Upgrade and Migrations projects

Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Strong knowledge and 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 and experience with index management, integrity checks, configuration, patching, including how statistics work, how indexes are stored, how they can be created and managed effectively.
Knowledge and experience of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system SPROCs)
Excellent verbal and written communication skills
Experience providing SQL Database Operational support to tech users
Responsible for implementation and release of database changes as requested by the application team
Provide off hours support and maintenance as required, part of the 24x7 operations support on call rotations