Dba - SQL (Lima)

**Qualifacts** is a leading provider of behavioral health, rehabilitative and human services software and SaaS solutions for clinical productivity, compliance and state reporting, billing, and business intelligence. Our comprehensive portfolio, including the
**CareLogic**,
**Credible**, and
**InSync** platforms, span and serve the entire behavioral health market in the US.

Get to know us:
**We follow a hybrid model, so employees are expected to be in the office 2 days per week.**

**The Opportunity**:
The Sr. SQL Server DBA is responsible for the overall administration of our SQL Server Environment including SQL Server installation and configuration, security, database maintenance, query tuning and optimization, database migration, code reviews and deployments, debugging, as well as configuration and support of always on high availability solution.

**Your Responsibilities**:

- 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.
- 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.

**Skills we need**:

- Technical or Bachelor's degree in Systems, Software Engineering or similar.
- Advanced English.
- Exp. in Always on High Availability solutions and best practices.
- Exp. in SQL Server installation and configuration and security.
- Exp. in database backup, restore and recovery.
- Exp. in database migration.
- Exp. in query tuning and optimization plus indexing.
- Exp. in debugging and troubleshooting database issues.
- Ability to implement encryption for sensitive data.
- Strong documentation skills for documenting database architecture, configurations, and processes.
- Understanding of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- Exp. with PowerShell scripting for automating routine tasks.
- Knowledge of T-SQL programming language.

**What we offer you**:

- Economic bonus and merit review.
- Full Health Insurance (EPS and oncologic) for you and your direct dependents.
- Fully paid English lessons.
- All legal benefits (CTS, 30-day paid vacation per year, life insurance, etc.)

Qualifacts is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, gender, age, disability, etc.