Job Description

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

• Bachelor’s degree in computer science or similar degree 
• Practical skills in tuning solutions for performance 
• Root cause analysis experience 
• Experienced in building complex scripts, queries, and stored procedures  
• Proficiency in MS SQL 2016 architecture 10+ yrs  
• Proficiency in RDS SQL, Azure SQL architecture and high availability 3+ yr 
• HA/DR configuration ( Always On / Database Mirroring)
• Proficiency in AWS RDS MSSQL administration