OnShift values people who are dedicated to innovation, and we reward them with flexibility, challenging work, competitive pay, solid benefits, career growth, and personal development. We’re looking for a Database Administrator to join our growing Product Development department! The successful candidate will have the opportunity to manage, tune, and architect exceptionally large databases with high transaction rates that deliver web content and services to our customers. If you are ready to love work, then check out this opportunity!

WHAT YOU’LL DO

• Manage databases (Postgres, SQL Azure, NoSQL) in Production/QA/Dev environments including installation, configuration, upgrades, schema changes, etc.

• Provide best practices on design, availability, replication, security, audit, and backup/recovery methodologies. Continuously re-evaluate the infrastructure for opportunities for optimization

• Troubleshoot database issues and maintain database systems availability and scalability within production environments

• Perform capacity-planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support application needs

• Support multiple Scrum teams to produce quality deliverables and meet deadlines, while effectively managing priorities and communicating progress

• Part of on-call rotation to respond to and resolve application issues to ensure production

WHO YOU ARE

• Associate’s or Bachelor’s degree, with a technical major, such as Information/Data Systems is preferred

• 3+ years of experience managing complex production database systems, preferably at a large consumer-facing internet site. Understanding of database packaged releases, patching strategy, and enforcing standards via tools and automation is essential

• Proficient with database server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backup, HA, etc.

• Ability to develop procedures, processes and conventions to standardize database operations

• Solid understanding of RDBMS security administration

• Experience in scripting languages of your choice (PowerShell, Python, etc.) for monitoring and custom automation Experience working with source code management tools (Git)

• Familiar with automated configuration management (Ansible, Terraform)

• Experience with Cloud based systems or Virtual environments (AWS, Azure, Google Cloud)

• Familiar with maintaining confidentiality and willingness to operate in a HIPAA-compliant environment and willingness to learn how to design/ follow procedures as well as write documentation to maintain compliance

• Previous Development/Operations experience a plus

WHAT’S IN IT FOR YOU

• Opportunity to learn and build skills in a high growth, collaborative culture

• 100% employer paid medical premiums for employees and their dependents, plus dental and vision options for election

• 100% employer paid short-term and long-term disability

• Paid time off and PTO rollover

• 7 paid holidays plus 5 flexible holiday options

• Health and wellness package

• 2 weeks parental leave

• Matching 401(k)

• Annual company bonus

• Ability to work fully remote. Office space is available to remote workers who reside in the Greater Cleveland, OH area.

WHO WE ARE

OnShift is a B2B Software Company headquartered in the theater district of Cleveland, Ohio. Along the way we've secured notable awards, some of them include 2022 National Top Workplaces, 2022 Regional Top Workplaces, and 2021 Weatherhead 100. We’re growing fast, we love what we do, and we do it with passion.

Since our inception, OnShift has been uniquely dedicated to the needs of the long-term post-acute healthcare and senior living workforce. We recognize that employees are the greatest asset, and today it's more critical than ever to attract and retain staff members. Our HCM software solutions are designed to deliver operational excellence while improving the daily lives of healthcare employees, so they can focus on what matters most—delivering quality care to patients and residents.

OUR COMMITMENT TO DIVERSITY

OnShift understands that diverse teams who feel a sense of belonging create a better employee experience, have more fun at work, drive better business results, and create more innovative products. OnShift is committed to continuously evaluating and improving our Diversity, Inclusion, and Belonging efforts through our internal Diversity, Inclusion, and Belonging (DIBs) initiative.

EEO STATEMENT

We believe in equal employment and advancement opportunities for all people, based on ability, potential and record of accomplishment.