SQL Developer (Troy, MI)

SQL Developer (Troy, MI) 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 Proven Microsoft T-SQL skills Must have proper understanding of web and application security Experience developing software in Azure 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 Work Schedule - Full time. Monday - Friday, 7:30am - 4:30 pm. Permanent Remote position (No in-office days). 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! 3 days paid bereavement 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 Tuition reimbursement program Career development opportunities Referral bonus for all successful full-time referrals Annual opportunities for increases Pay - The salary range for this position is $105,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.