JobIndex - Online Job Portal in Mumbai India

Job Description

Sr Database Administrator

Job Code : JIJP/202404/165

Job Description :

We are looking for Sr. SQL Server Database Administration.

Skills

Having 3 Years of experience required in SQL Server Database Administration in 24*7 Production environments.
Good experience with SQL server 2017,2016,2014,2012 and 2008 R2Installations, Configurations, Migrations and maintenance.
Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups.
Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users.
Verifying and resolving the SQL Server Blocking issues and Finding and fixing the root cause.
Resolving the Disk space issues and finding the root cause and permanent fixes.
Hands on Experience in applying the Service packs and Cumulative packs for servers.
Experience in SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
Extensive experience in Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.
Expertise in Maintenance of databases, Performance Tuning and Troubleshooting.
Good experience with implementing and Troubleshooting High Availability of database servers using Replication, Log Shipping and Database Mirroring.
Knowledge on Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities.
Scheduling backup using batch file in Task Scheduler.
Knowledge on Azure DBA (storage account, Resource Group, User Accounts & bacpac).
Experience on Team Foundation Server 2010 and 2013.
Creating collections and solutions on TFS server based on user requirements.
Knowledge on TFS up gradation & migrations
Basic T-sql.