Position: Senior Database Engineer

Location: Dublin

Work Arrangement: Hybrid

WorkFusion is seeking a Senior-Level Database Engineer to join our Engineering team in the US. 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 5+ 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

Would be a plus

• Experience working at a startup or high-growth software company
• Using Python for data processing/transferring
• Understanding of Hibernate and its optimizations
• Understanding Liquibase library to support the database schema model