Exp 5 Yrs
Notice Period 20 Days
Loaction Remote
Job Description
Expert in deciding and implementing backup strategies which match business s RTO and RPO.
Installing new SQL Server instances in both standalone and clustered environments.
Expert in understanding and implementing SQL Server Security
Expert in Implementing monitoring maintaining and troubleshooting SQL Server Log Shipping Replication Clustering and Alwayson AGs.
Great understanding of SQL Server internals
Troubleshoot SQL Server service outages as they occur.
Configure SQL Server monitoring utilities to minimize false alarms.
Extensive experience in understanding troubleshooting and fixing Performance issues by optimizing server performance by keeping uptodate DB health working with QueryStore reviewing and fixing issues with existing indexes statistics or by introducing new reviewing queries/stored procedures for antiperformance pattern and suggest the fix.
Monitor troubleshoot and fix IO subsystem and other resources as and when needed.
Understanding implementing and fixing Encryption Compression CDC CT Resource governor partitioning.
Experience with Migration and Upgradation of SQL Server.
Participate and lead DB DR tests.
Work as escalation point of contact for Jr. DBAs.
Good to Have
Experience with Azure database offerings
Experience with AWD database offerings
Experience with MongoDB PostgreSQL MySQL and Sybase
Skills and Competencies
Strong experience in Database Administration in SQL Server ( all versions)Experience in Performance Tuning Query Optimization using Performance Monitor SQL Profiler and other related monitoring and troubleshooting tools.
Ability to detect and troubleshoot SQL Server related CPU memory I/O disk space and other resource contention.
Strong knowledge of backups restores recovery models database shrink operations DBCC commands Clustering Database mirroring Replication AlwaysOn.
Experience of using Profiler traces and other tools to find the most frequently run queries
Strong knowledge of how indexes index management integrity checks configuration patching.
How statistics work how indexes are stored how they can be created and managed effectively.
Knowledge of SQL Server tools ( Profiler DTA SSMS PerfMon DMVs etc..)
SQL Development ability to write and troubleshoot DBA specific SQL Code and design ( stored procs functions tables views triggers indexes constraints )
Is a selfstarter who is committed high quality work and can adapt to new challenges either on their own or as part of a team
Ability to work in a deadline oriented environment
Excellent interpersonal and communication skills Written and Verbal. Exposure to International clients will be an advantage.
Experience in handling TB scale of DBs and PB scale of data will be an advantage
Ready to work in a 24*7 environment
sql profiler,constraints,clustering,tables,index management,resource governor,dmvs,sql server,backup,migration and upgradation of sql server,functions,indexes,mysql,profiling,ct,database administration,sybase,azure database,query optimization,cdc,compression,sql,mongodb,encryption,querystore,database mirroring,performance tuning,restore,alwayson,views,replication,recovery models,stored procedures,postgresql,performance monitor,triggers,dbcc commands,awd database,sql development,partitioning