Payfactors is changing the way companies attract and retain top talent through innovative compensation based tools and analytics.

Payfactors is looking for an Associate SQL Engineer who has experience doing T-SQL development. The successful candidate will be articulate, persuasive and have the ability to think clearly and quickly under pressure while remaining detail oriented and comfortable balancing multiple projects. Being forward thinking, and proactively looking at improving processes using best in class technologies are essential success factors of this position.

PRIMARY RESPONSIBILITIES:

Boston-area based - No sponsorship or relocation available at this time 

Manage SQL Server on Azure VM / Azure SQL/ Managed Instances

Implement resilient and performant database processes and solutions

Develop custom stored procedures, views, user defined functions and triggers

Understanding of T-SQL Programming / DDL / DML statementWork on data tickets on JIRA to solve data related issues

Debug and tune/optimize SQL code either directly or indirectly from application

Support development team with database requests as needed (including bug fixes, production data manipulation, and feature testing)

On-call duty required: responding to critical DB alerts / Handle any Production issues

Deploy SQL Server Patches

Manage databases backup / restore databases to non-production environments

REQUIREMENTS/SKILLS:

2-4 years of experience in developing & implementing stored procedures and functions using T-SQL

Memory OLTP technologies and best practice SQL standards

Experience designing database objects Ability to sit with other developers and troubleshoot

Experience with SQL Server 2016 and above

Experience in working on SQL Server on Azure VM / Azure SQL/ Managed Instances

2-4 years of experience in administering a Microsoft SQL server environment.

Experience in GIT Source Control

Understanding of DACPAC / Jenkins Builds & Octopus Deployment.

Intrinsic self-starter and problem solver

LIFE AT PAYFACTORS

“Take it as you need it”

Paid Time Off

Half Day Summer Fridays

Office socials, sports/concert tickets, swag + more

PLEASE NOTE THIS JOB DESCRIPTION IS NOT DESIGNED TO COVER OR CONTAIN A COMPREHENSIVE LISTING OF ACTIVITIES, DUTIES OR RESPONSIBILITIES THAT ARE REQUIRED OF THE EMPLOYEE FOR THIS JOB. DUTIES, RESPONSIBILITIES AND ACTIVITIES MAY CHANGE AT ANY TIME WITH OR WITHOUT NOTICE.

We are an Equal Opportunity Employer (Race/Color/Sex/Sexual Orientation/Gender Identity/Religion/National Origin/Disability/Vets) and are committed to building a team that reflects a broad range of experience and thought. We actively encourage applications from underrepresented groups in technology and business.