The Database Administrator II will be responsible for maintaining systems as defined and ensuring their ongoing availability. The Database Administrator II will take ownership for aspects of the Azure cloud and on premise SQL Server RDBMS systems. The scope of responsibility is for the complete understanding and optimization for multiple database products at Accruent. 

The ideal candidate will be highly motivated and have a passion for technology and creative problem solving. If you are self-driven, enjoy working in a team environment, have an ambitious spirit and enjoy crafting innovative solutions to complex problems, Accruent may be a fit for you. 

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 

A minimum of 5 years of experience with SQL Server database administration using best practices 2+ year of experience with native Azure SQL Database and/or Azure Managed Instance 3+ years of experience with T-SQL and Powershell scripting  2+ years of experience with industry standard SQL database monitoring and open source tools SQL Server and/or Azure database certifications are preferred  Bachelor’s Degree in Computer Science or related field is preferred Performance tuning and query/index optimization   Critical technical troubleshooting and problem solving skills Good understanding of database design principles Solid proficiency in database backup and recovery processes Quickly learns new product platforms and database technologies Ability to reason logically and participate in the development of innovative solutions Proven self-starter, self-reliant, and capable of educating others   Project and task oriented with attention to detail Ability to work well on group or individual projects Good verbal and written communication skills 

 

 

#LI-KJ1

Fortive Corporation Overview

Fortive’s essential technology makes the world stronger, safer, and smarter. We accelerate transformation across a broad range of applications including environmental, health and safety compliance, industrial condition monitoring, next-generation product design, and healthcare safety solutions.

We are a global industrial technology innovator with a startup spirit. Our forward-looking companies lead the way in software-powered workflow solutions, data-driven intelligence, AI-powered automation, and other disruptive technologies. We’re a force for progress, working alongside our customers and partners to solve challenges on a global scale, from workplace safety in the most demanding conditions to groundbreaking sustainability solutions.

We are a diverse team 18,000 strong, united by a dynamic, inclusive culture and energized by limitless learning and growth. We use the proven Fortive Business System (FBS) to accelerate our positive impact.

At Fortive, we believe in you. We believe in your potential—your ability to learn, grow, and make a difference.

At Fortive, we believe in us. We believe in the power of people working together to solve problems no one could solve alone.