We are looking for a mid to senior level SQL Database Developer who has extensive experience with Microsoft SQL Server versions 2017/2019 or any later versions. The Ideal candidate will have a deep understanding of SQL design concepts, practices and procedures.
This position involves identifying business requirements, developing data models, performing data analysis, writing complex SQL queries, designing and coding stored procedures and performance tuning existing database processes.
Key Responsibilities:
- Design and develop database objects, tables, stored procedures, views, triggers, and SSIS packages.
- Performance tuning the stored procedures and T-SQL.
- Assist developers with query tuning and schema refinement.
- Independently analyze, solve and correct issues in real time while providing efficient resolutions.
- Respond to feedback from users regarding performance and work with developers to improve the performance of queries and indexes.
- Tune T-SQL queries to improve performance and sustainability.
- Provide support for the deployment of database scripts in development, test, pre-production and production environments.
- Monitor database performance parameters to provide fast query responses to front-end users.
- Setting up and managing SQL agents to perform regular SQL tasks.
Qualifications:
- Bachelor’s degree with a minimum GPA of 3.0 in Computer Science or a related field of study.
- Deep understanding of standard concepts, practices and procedures related to database management.
- 3+ years of experience in software development using Microsoft SQL Server 2017/19 or later, T-SQL and T-SQL language (queries, views, procedures), SQL Server database design, stored procedure design and implementation.
- Experience coding stored procedures (using T-SQL).
- Experience developing SSIS packages.
- Proven analytical problem solving and debugging skills.
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.
- Experience with performance tuning, query optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Familiarity with BI technologies (e.g. Microsoft Power BI).
- Excellent communications skills (written and verbal).
Benefits:
- Employee Health and Supplemental Insurance premiums, including Life insurance, paid 100% by the company*
- Competitive 401k Plan with company match
- Generous Paid Time Off (PTO) plan
- Paid holidays
How Ideal Concepts Supports Your Success:
As a growing company, Ideal Concepts will foster your individual professional development through training, mentorship, and continuous leadership development
- Being promoted here is based on your work performance, goal achievement and leadership capabilities, meaning every employee has the same opportunity, regardless of tenure or title, to grow in their career!
- You will work in a team atmosphere with motivated, passionate, and career-driven individuals just like yourself
- You will be a part of a collaborative environment that encourages problem-solvers and outside the box thinkers to find solutions and achieve excellence
Who We Are
Ideal Concepts, Inc. has impacted the insurance industry for over 20 years by simplifying the sale of insurance products from carrier to agent to client through cutting edge technology. Through this effort, we stand by our mission to provide flawless solutions with remarkable service to every client. Today Ideal Concepts is established with over 100 carrier partners in 50 states selling Health, Medicare, Life, Property & Casualty as well as a suite of supplemental insurance products.
As an employee of Ideal Concepts, Inc. you will enter a growing and changing environment that is motivated and shaped by our core values of integrity, ingenuity, tenacity, mastery and simplicity. Ideal Concepts, Inc. has been recognized for its prestigious growth many times, including 6 consecutive years on the Inc. 5000 Fastest Growing Companies in America and 4 consecutive years on the local accolade of Lehigh Valley Business Fastest Growing Companies.
As part of taking care of our employees, Ideal Concepts provides an excellent benefits package that will take care of you inside and outside the workplace. Beyond the opportunity to prosper in your career, Ideal Concepts will cover 100% of your premium for major medical, dental, vision and life insurance. You will also have access to a competitive 401k program where the company matches a portion of your employee contributions.
* Supplemental benefits such as Dental, Vision, Accident, Critical Illness, and Life insurance are subject to state availability and will only be provided if available in your state of residence.
Ideal Concepts, Inc. / InsureMe, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
We will soon return to our offices, at which time, we will utilize a hybrid work schedule with regular required work from the office and moderate flexibility to work from home.
