SQL DBA

EXPERIENCE AND REQUIRED SKILL SETS

Manage and support of the SQL Server Databases, routine tasks in support of Senior SQL Database administrators
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.
5+ 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 databases related security and audit all database events in DBA ticketing system
Should have good knowledge in SQL Server DMVs, DMFs and system catalogue 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.
Good Understanding of T- SQL query.
Basic understanding of SQL Server query performance tuning areas like Index Seek vs Index.
Scan, RID Lookup, Key Clustered lookup.
Should have good knowledge on functions that are specific to ANSI SQL, where they can be used on other databases like Oracle eg: CAST and CONVERT.
Knowledge & Hands on System Functions, Triggers, Stored Procedures, Joins, Sub-queries