int(8782)
Mumbai, India

MSSQL

Our client is looking for an expert in SQL Server databases to provide day to day support and maintenance.

Please contact Harshal Ahuja or email your cv directly in word format with job reference no. JO000008387 to Tech-India@theedgepartnership.com.

Please note that due to the high number of applications only shortlisted candidates will be contacted. If you do not hear from us in the next 5 business days we regret to inform you that your application for this position was unsuccessful.

Apply for this Job

Key responsibilities

  • Involved in Installation and configuration of MS SQL Server 2000, 2005, 2008 and 2008 R2 and 2012 in Windows environment.
  • Patching installations for standalone and cluster servers.
  • Configuring and maintaining all types of Database Backups and Recovery operations.
  • Performing Database Maintenance Activities like rebuilding/reorganizing indexes and update statistics, checking database integrity and clean up history on regular intervals.
  • Executing the scripts in prod environment.
  • Resolving Space Management issues like TempDB contention, Data, and log file space issues.
  • Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures, DBCC, Activity Monitor and Profiler.
  • Identifying and Resolving fragmentation and performance issues.
  • Weekly Refreshing Database from Production to Test Environment.
  • Enrolling users, controlling, and monitoring User Access to the database, and maintaining system security.
  • Upgrading the databases from lower versions to higher versions of SQL server.

Role requirements

  • Good experience on Upgradation and Migration of SQL Server.
  • Hands-on experience on high availability solutions like Replication and Database Mirroring and Log Shipping and Cluster activities.
  • Configuring, monitoring, and troubleshooting the Transaction Replication and DR activities.
  • Solid experience Cluster installation and good experience adding the nodes in the respective servers in SQL Server 2000, 2005, 2008R2.
  • Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.
  • Configuring and maintaining and troubleshooting the Database mirroring and also experience in Mirroring DR activities.
  • Configuring and maintaining and troubleshooting the Database Log Shipping and also experience in Mirroring DR activities.
  • SQL Query re-writing and tunning.
  • Basic knowledge on creating the SSIS packages and deploying them.
  • Closing the tickets within the SLA time and monitoring the SLA.
  • Good experience on Installing and configuring the SSRS, SSIS.