Job Description

As the database engineer of the SQL Server platform, you will be responsible for driving the tuning, configuration, maintenance, and performance of critical SQL Server systems to ensure the availability and consistent performance of our customer facing applications. This is a hands-on position requiring very effective technical skills, as well as good interpersonal and communication skills. In this role you will be the face and advocate for SQL server at Q2 and helping the organization mature its best practices when dealing with SQL databases. The ability to troubleshoot and solve advanced SQL performance issues, automate complex tasks, and write custom solutions to problems will be critical to the success of this role. We are looking for a database engineer that has matured skills in writing/maintaining highly scalable SQL code on an OLTP system. Responsibilities Establish standards and practices to configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security Onboard and operationalize new businesses brought on by acquisition in order to bring them up to our standard and ensure that they can scale Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end Identify new opportunities and help refine automation of regular processes, track issues, and document changes Work in an Agile Scrum or equivalent models Solve/Assist in complex query tuning and schema refinement Expert in troubleshooting performance issues Join the on-call rotation with other Engineers Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members Skills and Qualifications 12+ years of experience writing performant / maintainable / scalable SQL 6+ years MS SQL Server experience required Matured experience in T-SQL and scripting skills. Advance knowledge of Query Optimizer and query performance tuning Working knowledge of SQL Server Internals, wait types, scheduling, etc. Working knowledge of query parallelism and worker thread utilization Working experience in Windows Clustering, partitioning, purging concepts Knowledge of Microsoft Azure Cloud (IAAS) Excellent written and verbal communication Ability to organize and plan work independently is critical. Ability to work in a rapidly changing environment Ability to multi-task and context-switch effectively between different activities and teams Knowledge on Microsoft cloud managed DBs/Systems, e.g. Managed SQL Instance, Azure SQL DB etc. will be a big plus .NET or other object-oriented development experience a big plus Domain knowledge and experience in the banking/fintech industry is a plus Health & Wellness Hybrid & Remote Work Opportunities Flexible Time Off Career Development & Mentoring Programs Generous Retirement Benefit Plans, including a company-matching HSA program. Health & Wellness Benefits, including a 12-weeks of parental leave for eligible new parents Community Volunteering & Company Philanthropy Programs Employee Peer Recognition Programs - You Earned it

foundit