Explore careers with our portfolio companies

No sql Admin L2

Acoustic

Acoustic

Pune, Maharashtra, India
Posted 6+ months ago
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