Job Opening

SQL Engineer DBA

 

Apply Now

Role Summary

The SQL Engineer DBA will report to the Senior Director of Engineering. The role will be split between production support of Clinicient’s MS SQL environments and hands-on SQL development work as part of Clinicient’s SCRUM process.   The split is envisioned to be 50/50 but could migrate towards more development work as more and more production DBA processes become automated.

Essential Responsibilities

  • SQL Engineer
    • Primary lead on project to synchronize and identify master schema for Insight databases.
    • Create and tune indexes based on customer performance.
    • Implement data archival strategy across all customer databases.
    • Implement data model changes as part of the continuous delivery and build process.
    • Create, modify, and optimize SSIS packages, stored procedures, views, triggers, indexes, and SQL agent jobs.
    • Create ETL solutions for migrating data in/out of Clinicient databases.
    • Provide Engineering support for production issues and service requests.
  • Support Scrum Development teams
    • Provide support to development teams for solving challenging technical problems through application of prototypes, core library development, and knowledge of industry best practices
    • Participate in design and code reviews
  • Perform SQL coding as necessary
  • DevOps DBA
    • Work with the Technology Operations team to define current Capacity Plan, document future requirements, and implement plan to achieve.
    • Perform Installation and Configuration of SQL environments (Prod, Pre-Prod, DR)
    • Take ownership of Database Performance and improved Customer Experience. Implement Industry Standard Performance Monitoring and Alerting toolkits. Report out to team on trends across databases.   Tune databases to improve performance.
    • Regularly perform Load-Balancing and Database Migration across production horizontally scaled servers based on performance metrics.
    • Responsible for ensuring security of all customer and Clinicient data. Implement security best practices across databases in all environments.
    • Ensure Backup and Data Recovery processes meet immediate recovery backup best practices and backups are readily available in the event of a disaster.
    • Perform troubleshooting across databases as required, including diving into stored procedures when necessary.
    • Perform SQL Deployments following the Clinicient Change Control process across all SQL environments.
  • Perform other duties as assigned to ensure the success of the team and the entire organization.

Education and Experience

  • Minimum 7+ years of progressive work experience with production database administration and database development in a fast-paced environment.
  • Experience and desire to dive into complex technical problems when troubleshooting customer issues with performance or functionality.
  • Strong written and oral communication skills.
  • Healthcare industry experience desirable.
  • Experience with distributed computing (Hive/Hadoop) a plus.

About Clinicient

Clinicient’s vision is to improve 20 million lives by 2025. This is our higher purpose and what drives us to help therapists and clinics thrive in all aspects of their business. Get inspired by how therapists are improving lives everyday.

Our Mission

Our mission is a noble one: to reward great care through partnerships with the clinicians we serve. We do this by combining the clinical tools that allow our clients to efficiently deliver and document care and the financial tools to maximize reimbursements.

Benefits and Perks

Clinicient offers comprehensive and affordable medical, dental and vision plans, flexible spending accounts, $100.00 monthly transportation reimbursement, 401k plan, wellness program, and paid time-off. We are in the heart of Downtown, Portland, Oregon and offer a flexible and creative workplace that includes a game room, fully stocked fridge, local microbrews, and many fun events throughout the year.

Clinicient is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, protected veteran status or other characteristics protected by law.

 

Apply Now