SQL Database Administrator II
Fortive Corporation
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.
Fortive: For you, for us, for growth.
This position is also eligible for bonus as part of the total compensation package.
The salary range for this position (in local currency) is 81,200.00 - 150,800.00
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.
Confirm your E-mail: Send Email
All Jobs from Fortive Corporation