Job Summary

Provide DBA support for the Acoustic SaaS MS SQL Server database platform running on Windows focused on reliability, security, recoverability, and performance.

Responsibilities

• Provide 2nd level MS SQL Server support for a diverse SaaS platform
• Optimize performance while minimizing expense on Azure
• Oversee patching and upgrades without impacting production
• Work cooperatively with 1st and 3rd level support teams
• Provide extended availability for emergency issue that may arise out of business hours, respond to pages and calls that may be automated when critical systems require support
• Participate in on-call rotation shifts and respond after hours to urgent matters.
• Work with product engineering (development) teams to provide the infrastructure that best suites the SaaS products that Acoustic provides
• Work with security engineering to assure that the MS SQL Server environment is secure and provides the necessary auditing to monitor security
• Support and enhance monitoring tools to provide Operations and Engineering the ability to monitor platform health and performance
• Spread knowledge across team members. Identify knowledge gaps, create documentation, cross-train, learn and share new ideas
  
  

Requirements

• 5+ Years of experience in database design and support and maintenance and optimization
• Experience in SQL environments, specifically SQL Server 2016, which includes user management and application release deployments
• Automation experience using PowerShell
• Monitoring tools such as Munin, Splunk, SolarWinds
• Understanding of database security concepts and how to secure MS SQL Server database
• Experience working on Slack, MS Teams, Sharepoint, Confluence and Jira
  
  

Preferred

• Bachelor's Degree in Computer Science, IT or Engineering
• Microsoft Azure and SQL Certification
• SaaS experience in CI/CD pipeline deployment through integration of GitHUB
• Experience in T-SQL and performance tuning, architecture, security
• Experience or knowledge of other data platforms would be beneficial including MongoDB, Snowflake, Postgres, MySQL
• Experience in designing and developing Reports & ETL solutions using SQL Server SSIS/SSRS/SSAS and development tools such as Visual Studio