AllentownRecruiter Since 2001
the smart solution for Allentown jobs

SENIOR SQL DATABASE DEVELOPER - FULL TIME, PERMANENT, DIRECT HIRE ROLE - Onsite- Allentown, PA

Company: Ideal Concepts, Inc.
Location: Allentown
Posted on: January 12, 2021

Job Description:

We have made temporary arrangements for our staff to be able to work mostly off-site. Once we are cleared to return to our offices safely it will be a fully on-site position in ALLENTOWN, PA. again FULL TIME, PERMANENT, DIRECT HIRE ROLE with Ideal Concepts Inc. in Allentown, PA. Ideal C oncepts Inc is a product-based company Ideal Concepts Inc. is a technology company, focused on insurance products and processes, revolutionizing how insurance business gets done. We are looking for a senior level SQL Database Developer who have experience with Microsoft SQL Server versions 2012/2014 and ideally 2016. The Ideal candidate will have a background using MS SQL Server and be able to understand from basic to complex SQL design concepts, practices and procedures. This position involves identifying business requirements, developing data models, performing data analysis, writing SQL queries, designing and coding stored procedures and performance tuning existing database processes. Responsibilities: * Design and develop database objects, stored procedures, views, functions, tables, triggers and SSIS packages; ensure their stability, reliability, and performance. * Design, develop, and maintain SSRS reports based on user requirements. * Write and optimize SQL statements for data access and retention. * Perform regular database management duties including backups and audits to ensure that SQL databases remain accessible, secure, and stable. * Test databases for performance, fine-tune when necessary. * Collaborate with developers on database design, query tuning, and schema refinement. * Independently analyze, solve and correct database related 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 stored procedures and 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. * Study the technical requirements provided by product team and design databases to fulfill the requirements. * Participate in all team activities like sprints and project planning. Requirements: * Bachelor's degree with a minimum GPA of 3.0 in Computer Science or a related field of study. * Knowledge of standard concepts, practices and procedures related to database management. * 5+ years of experience in software development using Microsoft SQL Server 2008 R2, 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). Why Ideal Concepts Inc.? * Career advancement opportunities in a growing organization * Better Business Bureau "A+" Rating * Opportunities to do new development and application maintenance of state-of-the-art systems * Work on new technologies such as AngularJs, .Net Core, SQL server 2016, Web RTS, HTML5, CSS3 and others * An opportunity to work directly with the company, no layers, no middle-men * Visa sponsorship opportunities available (H1bs, etc.) * Our Vision - Become the largest transactional insurance marketing company in the world * Our Mission - To provide flawless solutions with remarkable service to every client * Our Goals are - Grow by 300% annually Benefits: * Company pays 100% of the employee's weekly premium for major medical, dental, vision, and life insurance * 8 paid predetermined holidays * Employee 401K * Generous PTO policy * Technology focused, fast paced working environment * Professional team atmosphere with motivated, career-driven professionals as co-workers * Expansion and growth with one of the top technology and health insurance marketing companies in the nation * H1B transfers/sponsorships are available on a case by case status * Job Requirements:Responsibilities:* Design and develop database objects, stored procedures, views, functions, tables, triggers and SSIS packages; ensure their stability, reliability, and performance.* Design, develop, and maintain SSRS reports based on user requirements.* Write and optimize SQL statements for data access and retention.* Perform regular database management duties including backups and audits to ensure that SQL databases remain accessible, secure, and stable.* Test databases for performance, fine-tune when necessary.* Collaborate with developers on database design, query tuning, and schema refinement.* Independently analyze, solve and correct database related 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 stored procedures and 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.* Study the technical requirements provided by product team and design databases to fulfill the requirements.* Participate in all team activities like sprints and project planning.

Keywords: Ideal Concepts, Inc., Allentown , SENIOR SQL DATABASE DEVELOPER - FULL TIME, PERMANENT, DIRECT HIRE ROLE - Onsite- Allentown, PA, Other , Allentown, Pennsylvania

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Remote Sr. Loan Officer - NMLS Licensed
Description: Job DescriptionMinimum Qualifications Must have passed SAFE/UST Licensing Exam Minimum of 1 year of recent, proven success as a Loan Officer in a high-volume setting Minimum of 2 active individual (more...)
Company: Quicken Loans
Location: Lancaster
Posted on: 01/20/2021

Power-Generation Equipment Repairer (91D)
Description: Since the Army National Guard uses a plethora of electronic systems, power is essential to success. As the Power-Generation Equipment Repairer, you'll supply the power to run virtually every aspect of (more...)
Company: Army National Guard
Location: Harrisburg
Posted on: 01/20/2021

Client Specialist
Description: Company Description SGS is the world's leading inspection, verification, testing and certification company. SGS is recognized as the global benchmark for quality and integrity. With more than--94,000 (more...)
Company: SGS North America
Location: Harrisburg
Posted on: 01/20/2021


Instacart Shopper (car required)
Description: FULL-SERVICE SHOPPERWhy shop and deliver with Instacart Instacart is the North American leader in grocery delivery. We strive to help make grocery delivery effortless, affordable, and accessible to everyone. (more...)
Company: Instacart
Location: Harrisburg
Posted on: 01/20/2021

Food Delivery - Weekly Pay
Description: Deliver with Uber. Earn on your schedule.Work on your schedule. Deliver for a few hours in the mornings, every night, or just on weekends-it's up to you.Earn Good Money. You'll earn by bringing people
Company: Uber Eats
Location: Lancaster
Posted on: 01/20/2021

Licensed Insurance Representative
Description: Job Description Licensed Insurance Representative WE HAVE A UNIQUE LIFE INSURANCE AGENT
Company: Lincoln Heritage Life Insurance Company
Location: Harrisburg
Posted on: 01/20/2021

Now Hiring: (PT) Few Minutes Gets You $300 For Questionnaire
Description: 1 Enter Email 2
Company: Part-Time-Cash
Location: Harrisburg
Posted on: 01/20/2021

Night Crew Leader
Description: Our night crew leaders ensure our night crew is set up for
Company: Giant Food Stores
Location: Harrisburg
Posted on: 01/20/2021

Senior Product Designer
Description: Some Recent Projects We've Been Working On IncludeStack Overflow exists to serve developers. Whether we're helping them get answers to their questions or find a new job, we build products that millions (more...)
Company: Stack Overflow
Location: Harrisburg
Posted on: 01/20/2021

High Demand For Quality Siding Pros - Get New Clients In Your Area
Description: Over 25 million homeowners have trusted HomeAdvisor 1800Contractor to help them find quality professionals with the expertise to turn their home improvement
Company: HomeAdvisor
Location: Lancaster
Posted on: 01/20/2021

Log In or Create An Account

Get the latest Pennsylvania jobs by following @recnetPA on Twitter!

Allentown RSS job feeds