Database Administration - SQL

Essential duties & responsibilities

• Provide operational support for multiple Accruent SAS Azure and SQL Server database products across multiple verticals and regions in a 24x7 Production and other managed environments
• Must be on call 24x7 for one-week shifts in a SQL DBA rotation
• Proactively monitor, analyze, and resolve database performance and other issues, and complete monthly product Environmental Health reports
• Participate in cross functional Tiger Teams to troubleshoot and resolve Production customer incidents, including root cause analysis
• Complete customer request / trouble / change tickets and manage ticket queues in JIRA to meet SLAs
• Create, update, and follow standard database process documents
• Work with Product and Engineering to improve product functionality and performance
• Participate in cross functional and team projects, and complete assigned tasks as scheduled
• Spec out and set up new database servers
• Capacity planning and database server resource management
• Perform SQL Server upgrades and database migrations as required
• Implement standard security best practices, ensure SQL Server and database tools are up-to-date with the latest Cumulative Updates (CUs), and provide compliance information for audits
• Develop and update product DR plans / runbooks and perform annual product DR tests
• Complete required and optional on-the-job and online training to advance technical and process skills
• Help train new DBAs
• Consistently demonstrate Accruent s values : results orientation, humility, winning attitude, drive to excellence, integrity, and grit

Knowledge, skills & abilities

Skills Required

Sql Dba, Azure Sql, T-sql, Azure, Powershell