New Position Software SQL Database Developer
Position DetailsBack to position list
Position: Software SQL Database Developer
Employment Type: Full Time
Location: Allentown, PA
Openings: 1
We looking for a Senior SQL Database Architect who has in-depth experience with Microsoft SQL Server, specifically 2012/2014 and ideally 2016. The successful candidate will be an experienced Developer with extensive enterprise background using MS SQL Server. The Senior SQL Database Architect will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries, design and code complex stored procedures, and performance tune existing database processes.
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 complex query tuning and schema refinement.
  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
  • Tuning T-SQL queries to improve performance
Requirements:
  • Bachelor’s degree in Computer Science or equivalent.
  • In-depth knowledge of standard concepts, practices and procedures related to database management
  • Required 8 years of solid experience with Microsoft SQL Server 2008 R2 and above. Must know SQL inside and out.
  • Required 8 years T-SQL language (queries, views, procedures)
  • Required 8 years SQL Server Database Design, Stored Procedure Design and implementation
  • Experience coding complex stored procedures (using T-SQL).
  • Experience with 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 in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
  • Monitoring performance and managing parameters to provide fast query responses to front-end users
  • Familiarity with BI technologies (e.g. Microsoft Power BI)
  • Excellent English communications skills (written and verbal)
Benefits:
  • 15 days of PTO
  • 8 paid predetermined holidays
  • Fully covered health benefits (%100 company contribution), including major medical, dental, vision, accident, critical illness and life insurance
  • 401k plan
  • Expansion and growth with one of the top insurance technology companies in the nation
  • Professional team atmosphere with motivated, career-driven professionals as co-workers
  • H1B sponsorship available
    Apply Now