In today’s economic climate, job hunting can be daunting. Finding the right job – that job that makes you feel like you’re in the right place, at the right time may seem downright impossible. Here at ServiceChannel, http://www.servicechannel.com/, we like to think we’re defying those odds. We’re not only growing (and growing fast), but we’re also building a dynamic, innovative, collaborative team primed for success in today’s marketplace.
The winning combination?
Groundbreaking software (that’s where you’d come in)
On-site services (our software helps customers manage them)
Great customers—the world’s leading retailers
Great people (your teammates)
As MS SQL Database Administrator, you will help develop and manage the database systems that power the ServiceChannel SaaS software. You will build highly available, redundant, scalable, and high performing database systems to support our tremendous growth. You will manage the systems to keep them running at peak performance levels. You will have the chance to learn on the job while sharing your own experience and expertise. You will work closely with other members of our database administration team and the development and infrastructure teams to successfully deploy solutions that meet requirements and exceed expectations.
Responsibilities
Administer database systems across Production, Staging, QA, and Development environments
Recognize system deficiencies, diagnose performance issues, and implement effective solutions
SQL Server replication and cluster construction
Plan and implement disaster recovery
Database sharding and tuning
Monitor and report on database availability and performance
Optimize stored procedures, triggers, and functions
Optimize database schemas, views, and indexes
Data Warehousing, archival, and backup
Database change deployment process
Database maintenance and on call rotations
Generate code to extract, transform, and load data from/to production data sources from/to external sources (excel, text comma and tab delimited files, other Access, SQL databases, XML, etc)
Write code and create jobs to automate repetitive tasks
Work alone and in a group
Research problems independently
Establish and enforce coding standards
Implement, maintain, and audit database security and encryption
Plan growth and changes (capacity planning)
Resource governing
Experience, Skills & Education
3 years plus of experience as DBA expected
Light database administration expertise is acceptable given strong SQL development skills
Proficiency writing and optimizing Transact SQL, stored procedures, functions, performing bulk set operations (select/insert/update/delete) in MS SQL 2008 and newer
Detailed knowledge of relational database concepts
Recent experience with SQL Server 2008 (2019/2022 a plus)
Building and administering MS SQL Server Database Systems a major plus
Knowledge of SQL Server replication and clusters in Cloud environments a major plus
Knowledge of principles of database design, data acquisition, and data access analysis and design
Experience with SSIS and SSRS a plus
Strong verbal and written communication skills
Demonstrate ability to work in a small group setting to rapidly develop new and enhance existing systems
A BS degree in business or computer science, comparable work experience accepted
Additional experience welcomed:
Experience with JIRA;
Experience with Github, Teamcit
Experience with MongoDB,Cosmos DB
Experience with Redgate DLM, SQL Sentry, Powershell
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 ServiceChannel
ServiceChannel empowers many of your favorite brands to take care of their brick and mortar locations. Our customers are market leaders in the retail, restaurant, grocery, convenience store, fitness, banking, education and health industries. The facilities and store operations teams at CVS, Trader Joe’s, Adidas, Louis Vuitton and Chipotle, among 500 other brands in over 70+ countries, rely on us to deliver the best possible guest and employee experience. We are the leader in our space, and we continue to earn that position by driving innovation around IOT, AI and data with our software and services.In 2021, we joined the Fortive family of leading technology companies, united by a common purpose to make the world stronger, safer and smarter. Fortive is a Fortune 500 company and has been named by Fortune as one of the world’s most admired companies. Being part of Fortive means we are supported by a strong foundation of business systems, resources and culture, which will accelerate our growth journey!We offer an excellent benefits package including medical, dental, vision, life and LTD insurance, HSA, and a 401(k) retirement plan.
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.