Job Description
Qualifacts is a leading provider of behavioral health software and SaaS solutions for clinical productivity, compliance and state reporting, billing, and business intelligence. Its mission is to be an innovative and trusted technology and end-to-end solutions partner, enabling exceptional outcomes for its customers and those they serve. Qualifacts' comprehensive portfolio, including the CareLogic®, Credible™, and InSync® platforms, spans and serves the entire behavioral health, rehabilitative, and human services market supporting non-profit Certified Community Behavioral Health Clinics (CCBHC) as well as for-profit large enterprise and small business providers. Qualifacts has a loyal customer base, with more than 2,500 customers representing 75,000 providers serving more than 6 million patients. Qualifacts was recognized in the 2022 and 2023 Best in KLAS : Software and Services report as having the top ranked Behavioral Health EHR solutions.
Responsibilities for the Database Administrator – SQL Server
- Install, configure, and maintain SQL Server instances
- Configure and administer high availability and disaster recovery solutions, such as Always on Availability Groups to ensure business continuity and data availability
- Monitor database performance, identify bottlenecks and areas for improvement, and proactively tune queries and configurations to ensure optimal performance
- Apply patches and updates to SQL Server instances and other related software, ensuring minimal disruption to business operations
- Deploy SQL scripts to multiple databases using 3rd party or custom tools
- Debug and troubleshoot database issues and collaborate with development teams to resolve them.
- Automate routine database administration tasks using scripts
- Regularly refresh lower environments with production database backups
- Implement and maintain database security policies and procedures, ensuring compliance with industry standards and regulations
- Develop and implement backup and restore strategies to protect data against loss or corruption and perform regular backups
- Plan and execute database migrations to new hardware, software versions, or cloud platforms, and ensure data consistency and integrity during the migration process
- Develop and maintain database documentation, including procedures, diagrams, and technical specifications, to facilitate knowledge sharing and ensure compliance with regulatory requirements
- Perform daily and operational database tasks
- Design and implement backup policies
- Be available for on-call support as needed
Qualifications Of The Database Administrator – SQL Server
Bachelor's degree or equivalentCertifications in SQL ServerExperience
5+ years of experienceExperience in in Always on High Availability solutions and best practicesExperience in SQL Server installation and configurationExperience in SQL Server securityExperience in database backup, restore and recoveryExperience in query tuning and optimizationExperience in debugging and troubleshooting database issuesExperience in database maintenance tasks such as backups, restores, and recoveryExperience in database migrationExperience with PowerShell scripting for automating routine tasks.Experience working with Amazon Web ServicesExperience with database migration to AWSExperience in working with a ticketing system and managing ticketsKnowledge, Skills, and Abilities of the Database Administrator – SQL Server
Ability to apply patches and updates to SQL Server instances and other related softwareKnowledge of performance tuning techniques, including query optimization and indexingAbility to implement encryption for sensitive dataStrong documentation skills for documenting database architecture, configurations, and processesAbility to provide standby support for critical database issuesAbility to troubleshoot and resolve database issuesUnderstanding of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)Knowledge of T-SQL programming languageStrong written and verbal communication skills, with the ability to effectively communicate with technical and non-technical stakeholdersStrong analytical and problem-solving skillsAbility to work independently and in a team-oriented environmentWorking knowledge of MySQL or Aurora MySQLSQL Server database administration experience in a Healthcare or SaaS domainFamiliarity with SQL SentryThis is an onsite position, 5 days / week, in the Vadodara office working the MID SHIFT. Hours are 1pm-10pm IST. Remote applicants will not be considered.
Qualifacts is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Skills Required
Amazon Web Services, T-sql, Mysql, Sql Server, Powershell Scripting