• Save Job
  • 8 - 11 Years
  • Posted : above 1 month

Job Description:

Manage and support of the SQL Server Databases, routine tasks in support of Senior SQL Database administrators

SQL DBA will possess the following experience

Production Activities Ensure active and effective backup policies in place
Monitor system for performance and load issues
Apply system patches as appropriate
Manage execution of application patches and ensure rollback strategy is in place
Performance monitor system for slowest queries and provide regular report to development team
Profile T-SQL and fine-tune queries through hints, application of keys or restructuring of query
Plan for future scale and performance needs based upon historical data and projected system growth
Resolving database maintenance and corruption issues
General Trouble-shoot issues in all environments as and when needed
Build automation scripts for DB maintenance using a scripting language such as PowerShell, VBScript

Skills Required and Responsibilities 8 years of experience in SQL Server Database administration/development
Support daily DBA activities including maintenance operations not limited to Backups, Restores and Index rebuilds
Ability to support Always on( FCI and AG) for HA and Log Shipping, Mirroring for DR in SQL Server 2012/2014
In-depth knowledge of Windows Operating system & Storage internals
Support database related security and audit all database events in DBA ticketing system
Should have good knowledge in SQL Server DMVs, DMFs and system catalog views
Proficient in writing T-SQL scripts for SQL Server automation and scheduling jobs through SQL Agent
Troubleshooting SQL Server with tools like SQL Server extended events, SQL Profiler, Database tuning advisor for any major application issues
Support SQL Server Integration Services jobs and work with teams related to any issues
Recommending & Implementing Microsoft Best practices in environment
Microsoft certified professional is plus

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Others - other Industry
Functional Area : IT Software : Software Products & Services
Role : Database Administration (DBA)
Salary : As per Industry Standards
Deadline : 03rd Jun 2020

Key Skills:

Would you like to try out these free online tutorials?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status