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