SQL DBA

Position: SQL Server DBA

Location: Burlington MA (Onsite)

Job Type: Fulltime

Job description:

• Ensure the availability and optimization of the MSSQLin Hosted and IaaS SQL VM in Azure.
• Experience with Azure SQL Database and Managed Instance in Azure. Snowflake experience is a big plus!
• Monitor performance on application databases queries and suggest/apply continuous tuning.
• The responsibilities include working closely with application teams and other Stakeholders in identifying issues related to MSSQL.
• Make sure to follow technical standards and operational procedures to meet database performance High Availability replication scalability and security requirements in both hosted and cloud environments.
• The individual will need handson experience in design and troubleshooting realtime MSSQL related issues.
• Monitor performance on application databases queries and suggest/apply continuous tuning.
• The responsibilities include working closely with application teams and other Stakeholders in identifying issues related to MSSQL.
• Must have experience in tuning of database instances.
• Responsible for coming up with standards to ensure that all application design and code is produced with proper integrity security and performance.
• Work closely with Database manager collaborate with various Application support and engineering teams to optimize database performance and reliability.
• Senior Database Performance Engineer are encouraged and supported to acquire relevant Azure certifications (e.g. DP300 DP900 AZ900 Exam).
• Establish maintain and adhere to CRD technical standards policies and procedures.
• Responsible for taking initiative and drive solutions coming up with standards to ensure that all application design and code is produced with proper integrity security and performance.
• 68 years of experience working with large MS SQL Serverdatabases and Snowflake in a 24 x 7 x 365 production environment
• Good performance tuning experience using all available tools like SolarWinds Query Store Extended Events and methods to investigate and make recommendations to improve slow performing queries and procedures at the database and server level.
• 5 years of handson experience operating MS SQL servers and related technologies in Azure.
• Very good understanding of database encryption highavailability disaster recovery database replication backup/restore.
• Must be detailed oriented have excellent written and verbal communication skills and be an aggressive selfstarter.
• A strong sense of customer service attention to detail and issue ownership.
• Understanding of ITIL concepts desired.
• Ability to lead and work well with multiple priorities and effectively handle concurrent demands to prioritize responsibilities
• Ability to formulate clear governance strategy present and gain support
• Ability to effectively integrate contribute and overlap with other functions including cloud/enterprise architecture compliance risk engineering developers
• Ability to formulate objectives with clear business value and demonstrate progress along the way
• Ability to communicate complex and innovative concepts with proven experience driving decision making across different stakeholder groups