SQL Server Database Administrator

- 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, VBScriptSkills Required and Responsibilities :- 7+ years- of experience in SQL Server Database administration/development.- Support daily DBA activities including maintenance operations not limited to Backups, Restores & 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 DMV- s, DMF's 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.