Senior SQL DBA

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 safer and more productive. We accelerate transformation in high-impact fields like workplace safety, build environments, and healthcare.

We are a global industrial technology innovator with a startup spirit. Our forward-looking companies lead the way in healthcare sterilization, industrial safety, predictive maintenance, and other mission-critical solutions. 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 advanced technologies that help providers focus on exceptional patient care.

We are a diverse team 10,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 [HIDDEN TEXT].

Bonus or Equity

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

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 [HIDDEN TEXT].

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

Skills Required

Powershell, Ssrs, Ms Sql Server, Transact Sql, Mongodb, Cosmos DB, Ssis