Database Administration - SQL

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
  
  

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 17,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.

At Fortive, we believe in growth. We’re honest about what’s working and what isn’t, and we never stop improving and innovating.

Fortive: For you, for us, for growth.

About Accruent

Personal development and becoming the best you is all about growth and exploring new skills and opportunities – both in and out of the office. At Accruent, we call this Grow Without Limits, and we’re proud to offer each of our employees the resources, coaching and support necessary to achieve Growth Without Limits in their personal and professional lives. Explore where the path takes you.

About Accruent At Accruent (a subsidiary or affiliate of Fortive Corporation), we strive to be on the cutting edge of the software world, providing purpose-built intelligent solutions that raise customer expectations, shift paradigms and transform the way businesses operate and achieve success.We aim to provide the same transformational growth for our 1,000+ employees which includes a vibrant office culture in major cities like Austin, London, and Amsterdam – and 10,000 customers in more than 150 countries – we know you’ll gain new experiences along the way. In our continued effort to help our teams Grow Without Limits, we provide all employees with the resources, coaching and support they need to reach new heights and experience true professional and personal development – and we do this because we believe it will help us grow as a global company in return.Every person can bring something incredible to the table, and we can always achieve more together. So, if you are courageous, adaptable, collaborative and interested in becoming the best you, we encourage you to join us for the ride – even if you don’t believe you have the exact experience to fill a particular role.Explore the path. Join Accruent.

We Are an Equal Opportunity Employer. Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment application process, please contact us at applyassistance@fortive.com.

Bonus or Equity

This position is also eligible for bonus as part of the total compensation package.

Personal development and becoming the best you is all about growth and exploring new skills and opportunities – both in and out of the office. At Accruent, we call this Grow Without Limits, and we’re proud to offer each of our employees the resources, coaching and support necessary to achieve Growth Without Limits in their personal and professional lives. Explore where the path takes you.

About Accruent At Accruent (a subsidiary or affiliate of Fortive Corporation), we strive to be on the cutting edge of the software world, providing purpose-built intelligent solutions that raise customer expectations, shift paradigms and transform the way businesses operate and achieve success.We aim to provide the same transformational growth for our 1,000+ employees which includes a vibrant office culture in major cities like Austin, London, and Amsterdam – and 10,000 customers in more than 150 countries – we know you’ll gain new experiences along the way. In our continued effort to help our teams Grow Without Limits, we provide all employees with the resources, coaching and support they need to reach new heights and experience true professional and personal development – and we do this because we believe it will help us grow as a global company in return.Every person can bring something incredible to the table, and we can always achieve more together. So, if you are courageous, adaptable, collaborative and interested in becoming the best you, we encourage you to join us for the ride – even if you don’t believe you have the exact experience to fill a particular role.Explore the path. Join Accruent.

We Are an Equal Opportunity Employer. Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment application process, please contact us at applyassistance@fortive.com.

This position is also eligible for bonus as part of the total compensation package.