Ideal Concepts, Inc. ยท 3 hours ago
Sr. Database Engineer
Allentown, PA
Full-time
Hybrid
Mid, Senior Level
3+ years expIdeal Concepts, Inc. is a company that has been transforming the insurance industry for over 20 years through innovative technology solutions. They are looking for a mid to senior level SQL Database Developer to design and develop database objects, perform data analysis, and optimize SQL queries to enhance database performance.
Commercial InsuranceFinancial ServicesHealth CareHealth InsuranceInsuranceMarketing
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
Qualification
Required
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
Beyond the opportunity to prosper in your career, Ideal Concepts will cover 100% of your premium for major medical, dental, vision and life insurance.
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.
Company
Ideal Concepts, Inc.
Ideal Concepts, Inc. started in the insurance sales and technology industry in 2005 under the leadership of founder and President, John Pequeno.
1001-5000 employees
H1B Sponsorship
Ideal Concepts, Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2023 (3)
2021 (6)
2020 (8)
Funding
Current Stage
Late StageLeadership Team
Susan Hughes
HR Business Partner
Company data provided by crunchbase