Primary Responsibilities:
- Perform SQL Server Database Administrative responsibilities for on premises environments - provide end to end Database Administrative support, help with Performance Tuning, Query and Index reviews as well as tuning
- Assist with troubleshooting issues and identifying root cause
- Collaborate with teams we support to provide guidance on policies, best practices. Also assist the teams with project implementation, troubleshooting
- Setup replication and resolve replication issues, implement changes involving replication
- Implementing Always On Availability groups and addressing performance or maintenance requirements
- Ensure security and compliance as well as adherence to applicable industry and company security standards
- Proactively monitoring SQL servers, utilizing custom or vendor monitoring tools, setting up alerts or automation as applicable to help prevent issues
- Provide On call support. Understanding of applicable ITIL best practices
- Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so
Qualifications - External
Required Qualifications:
- Undergraduate degree or equivalent experience
- 9+ years of experience as SQL Server Database Administrator
- Good experience with administration and troubleshooting for Always On Availability groups
- Well experienced in SQL Server Replication (Transactional replication. Merge replication experience is good to have)
- Good experience working with SQL Server Failover clusters
- Proven expertise in supporting and troubleshooting SQL Server Failover Clusters
- Proven ability to troubleshoot issues and determine root caus
