SQL Developer (Troy, MI)

BeneSys, Inc.; Troy (MI); Remote; USD 100,000 - 110,000; Full time

Benefits offered by this job

Paid holidays

PTO

Jury leave

Medical insurance

Dental & Vision

Life insurance

401k with match

Referral bonus

Salary growth

Job summary

BeneSys, Inc. in Troy, MI is seeking an experienced SQL Developer to design, implement, and maintain our SQL Server databases. You will work on on-premises and Azure-based systems, including stored procedures, views, and jobs, with exposure to SSRS and SSIS as needed.

The role requires active participation in the full software development lifecycle and a willingness to learn new technologies. Candidates should have 5+ years of Microsoft tech experience, strong security knowledge, and the ability

Qualifications

• 5+ years of software development in Microsoft tech stack.
• Strong knowledge of web and application security.

Responsibilities

• Participate in SDLC lifecycle including sprint planning, standups, code reviews, and documentation.
• Maintain and optimize database performance and reliability.
• Develop and test database components (tables, views, procedures, functions, jobs).
• Create and modify SSRS reports and SSIS packages as needed.
• Collaborate with cross-functional teams to deliver software solutions.

Skills

T-SQL

Microsoft SQL Server

Azure

SSRS

SSIS

.NET

Java

React

AngularJS

Education

Bachelor’s degree

Tools

SQL Server Management Studio

Visual Studio

Azure Data Studio

Azure DevOps

Jira

Ivanti

Job description

Please see below for a current listing of available positions at BeneSys.

Location: Troy, MI

Job Id:2675

# of Openings:1

Job Summary

The SQL Developer should have extensive experience with T-SQL using Microsoft SQL Server both on-premises and in Azure. The Developer will have responsibilities for developing, maintaining, and enhancing all aspects of our SQL Database used by an in-house software application. This includes modifications to tables, views, stored procedures, functions, jobs, etc. Ancillary work on SSRS Reports and SSIS Packages may also be required. Must have experience with cloud platforms and modern software design patterns. Exposure to .NET, Java, React, AngularJS, and other modern technologies is a plus. The SQL Developer must be able to participate in multiple phases of the software development lifecycle with active participation in creation of technical specifications, development, functional testing, and maintenance. Must also have an eagerness to learn new technologies and practices.

Applicants for this remote role will only be considered if they live in these locations: Arizona, California, Colorado, Washington DC, Iowa, Illinois, Indiana, Kentucky, Massachusetts, Maryland, Michigan, Missouri, Nevada, Ohio, Oregon, Pennsylvania, Texas, Utah, Washington, Wisconsin.

**Please note – This is a regular full-time position. This is not a contracted (1099) role.

Essential Functions, Duties, Responsibilities

• Active participant and leader within the SDLC lifecycle; this role will participate in sprint planning activities, daily standups, prioritization meetings, code reviews & retrospectives, and should be well versed in development operations, and relevant processes and procedures including source control practices and production of documentation.
• Perform day-to-day operations (includes maintenance, problem investigation and resolution, database optimization and tuning, etc.).
• Evaluate business requirements and recommend appropriate solutions to achieve stated objectives.
• Independently analyze and correct issues in real time, providing end-to-end problem resolution through collaboration with cross-functional team members.
• Refine and automate regular processes, track issues and document changes.
• Develop and execute unit test cases and functional test cases for database use.
• Establish best practices for a growing team of SQL Developers.
• Effectively prioritize and manage concurrent projects, demonstrate initiative, and work independently with minimal supervision.
• Drive results & leverage past experiences to improve the environment and related processes.
• Follow current guidelines as established at the company-wide and department levels and provide input for modernizing existing standards.
• Serve as mentor to junior team members.
• Collaborate with peers, team members, and stakeholders to drive project success.
• Ability to prioritize and coordinate job duties, resources and personnel.
• Ability to adjust priorities, listen receptively to ideas and problems.
• Ability to reach acceptable compromise and to maintain strict confidentiality.
• Ability to work under time constraints; ability to communicate clearly and work effectively as a team member.
• Ability to analyze and compile data.
• Strong quantitative and qualitative analysis and problem-solving skills including the ability to understand new information domains.
• Self-motivated and directed, ability to prioritize workloads and multi-task. Must be able to effectively communicate with technical and non-technical user.
• Regular and predictable attendance is an essential function of this job.

Qualifications

• Requires 5 years of recent experience in writing software solutions with the latest Microsoft technologies
• Must have proper understanding of web and application security
• Ability to troubleshoot existing application issues
• Experience enhancing/upgrading existing systems by analyzing and identifying areas for modification and improvement
• Experience with industry-standard build and deployment processes within a structure change management process
• Good interpersonal and oral communication skills
• Ability to conduct research into security related products as required
• Experience working in a team-oriented, collaborative environment
• Experience with modern software development tools and systems including, but not limited to, SQL Server Management Studio, Visual Studio, Azure Data Studio, Azure DevOps, Jira, and Ivanti
• Experience with Agile software development methodologies including Scrum, Kan Ban, and SAFe

Education/Certifications/Licenses/Registrations

• Bachelor’s degree or equivalent experience required
• Relevant software development certifications and trainings

Competitive Benefits and Compensation Package

• 12 paid holidays
• Paid Time Off (PTO)
  • Pro-rated during first year of employment
  • 15 days of PTO provided in the next calendar year!
• Up to 20 days paid jury leave
• Medical, dental, and vision insurance, with option for dependent coverage
• Company-paid basic life, short-term disability, long-term disability, and AD&D insurance
• 401k with employer match
• Referral bonus for all successful full-time referrals
• Annual opportunities for increases

Pay

- The salary range for this position is $100,000 - $110,000 per year. Actual salary is dependent on skills, experience, education, and other business factors.

Our Culture

BeneSys wants to be a great service provider to the members we serve, and we recognize we can only do that if we are also a great employer with successful employees. In short, our success is driven by our employees’ successes. We want to be a place where people want to work, feel proud of what they do and feel fulfilled both professionally and personally. We want to create a place where employees can find long-term growth and potential.

Our culture focuses on three core values:

• Collaboration: working together across 31 locations to achieve the best for the company and our clients
• Dedication: striving to create an environment where all employees work toward a common goal while committing to providing the best customer service to our members and our colleagues
• Integrity: doing what we say we will do. Upholding strong ethical and moral principles

ADA & EEO

Reasonable accommodations will be made so that qualified individuals with disabilities are able to complete the application process and, if hired, fulfill the essential functions of their job.