Proficient in Database Backups, Recovery, Restore, Linked Servers
Experience with High Availability and Disaster Recovery like Replication, Log Shipping, Mirroring and Clustering
Worked on Server performance debugging (event log, request monitoring)
Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes.
Assist developers with complex query tuning and schema refinement.
Basic T-SQL knowledge.
Sr Database Administrator
Job Overview:
We are looking for Sr. SQL Server Database Administration with the following background: 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.
