MS SQL DBA Technical Lead
Summary
Lead a team to design, optimize, and maintain high-transaction Microsoft SQL Server environments, including Always On, clustering, and AWS-hosted instances, while troubleshooting performance and security issues.
- Extensive technical knowledge and experience in database management techniques including physical database optimization, database performance monitoring, backup and recovery.
- Experience of managing high transaction databases in clustered environment is preferable.
- Should have knowledge of basic ITIL fundamentals and certification would be preferred.
- Support Microsoft SQL Server 2008/2012/2014/2016/2017/2019/2022/2025 databases, SSIS and SSRS and SSAS Services.
- Implement and support Microsoft Clustering Services, Always On and Log shipping, replication
- Knowledge of SQL Server tools (Profiler, SSMS, PerfMon, DMVs, system sprocs).
- Experience of handling priority incidents
- Experience of backup tools like – CommVault, litespeed
- Experience of monitoring tool like – Foglight, AppDynamics, Redgate
- Solid acquaintance with windows server, security delegation, SPNs, storage components.
- Must have very good experience of AWS
- Experience of managing AWS databases on PostgreSQL,MySQL, Oracle, SQL Server
- Understanding and Practical experience of PowerShell scripting.
- Assisting developer in reviewing the code
- Assist with troubleshooting and root cause analysis.
- Basic Knowledge and awareness of networking and storage concept.
- Proficient in performance tuning, monitoring, backup, recovery, and security.
- Strong analytical and organizational skills, oral and written communications skills, problem solving and critical thinking skills.
- Ability to meet deadlines and be flexible, work independently or as part of a team, and ability to self-motivate and be proactive.
- Should be comfortable browsing a query execution plan and understand how to use it to identify opportunities for optimization.
- Understanding of potential lock escalations, deadlocks, isolation levels etc is vital
- Candidates having Database Administrators certification will be preferred
Total Experience Expected: 06-08 years
- Bachelor's degree in Computer Science, Information Technology, or a related field.
At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences.
All of our positions are open to people with disabilities.