Position

WorkFusion is seeking a Senior-Level Database Engineer to join our Engineering team. The Development and maintenance of our platform presents many technical challenges in the areas of large-scale data processing, enterprise grade solutions and integrations. The ideal candidate is self-driven and can work successfully in a distributed team. You should possess strong knowledge of application support issues and troubleshooting in both cloud and on-premise environments. You will be a part of the Client Support team providing support to customer installations and our own cloud-based and on-premise solutions, including HA / DR solutions. This person will be actively involved in direct communication with customers and our own product team and will help lead issues to resolution.

Key responsibilities

• Manage the development and performance of SQL databases for web applications
• Ensure high levels of performance, availability, sustainability and security
• Designs, installs, upgrade, monitors, maintains, and conducts performance tuning procedures in a production MS SQL Server database environment while ensuring high levels of data availability.
• Develops, implements, and oversees MS SQL Server database policies and procedures to ensure the integrity and availability of databases and their accompanying software.
• Create, maintain, and execute scheduled jobs, data extracts, data refreshes, data loads and data replication.
• Detect and troubleshoot DB Server CPU, Memory, I / O, SQL Profiler and other resource contention
• Solid knowledge on performance tuning from MSSQL, PostgreSQL and MySQL databases.
• Develop new Tableau data sources and SQL data objects to support reporting environment.
• Design, implement, and test backup and recovery strategies that ensure 100% data availability.
• Develop data scripts, troubleshoot code and assist developers with performance tuning.
• Manage AWS Managed MSSQL RDS instances , solid understanding to support the AWS cloud database.
• Create operational runbooks, updating knowledge base, installation guides, learning courses and other types of documentation
• Support development teams and customers’ requests
• Closely communicate with customers and partners during installation, support and delivery
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking

Qualifications / Experience