This site uses cookies. To find out more, see our Cookies Policy

Senior SQL Database Developer in Irvine, CA at National General Insurance

Date Posted: 3/22/2019

Job Snapshot

Job Description

Essential Duties and Responsibilities:

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.

  • Design, development and implement high quality relational data components to support the Online Transactional Processing (OLTP) for Microsoft stack
  • Design and create SQL statements within stored procedures or functions; perform database queries and analysis.
  • Help in the design, implementation, verification, debugging, optimizing and maintenance of SQL Server database objects (database design, table design, index creation, stored procedures, views, functions, scripts, etc.) and processes for the application, reporting and interface modules.
  • Design, code and test SQL Server Reporting Services components (User Interface, Middleware, Stored Procedures, Tables, etc.)
  • Design and develop SSIS packages, configuration files, stored procedures, tables, views and functions.
  • May work on multiple, small to large scale technical projects at a time, as well as ongoing production support.
  • Conduct code walkthroughs, peer reviews, and produce technical documentation.
  • Adhere to published coding standards and documentation requirements.
  • Maintain confidentiality of all sensitive data.


Minimum Skills and Competencies:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

  • 3+ years IT developer experience using MSSQL 2012 or higher, SSIS, SSRS
  • Must have bachelor's degree in computer science or equivalent certifications in relevant technology areas and strong knowledge in relevant areas
  • Significant experience in SSIS and SSRS (intermediate to advanced preferred)
  • Understanding of relational database concepts.
  • Good organizational skills and ability to assemble business information
  • Experience using SQL management Studio and TFS source control
  • Must have understanding of structured programming design techniques and best-practice design patterns used to create high-quality, robust and readable code
  • Must have experience in all phases of the Software Development Life cycle
  • Excellent analytical, communication, and presentation skills, including the delivery and creation of presentations (ability to simplify complex topics into basic concepts)
  • Ability to work with senior management, IT staff, and extended user community
  • High degree of initiative, dependability, and ability to work with minimal supervision
  • Insurance industry experience 



Job Requirements


About National General Holdings:

National General Holdings Corp. is headquartered in New York City. National General traces its roots to 1939, has a financial strength rating of A– (excellent) from A.M. Best, and provides personal and commercial automobile, homeowners, umbrella, recreational vehicle, motorcycle, supplemental health, and other niche insurance products. We are a specialty personal lines insurance holding company. Through our subsidiaries, we provide a variety of insurance products, including personal and commercial automobile, homeowners, umbrella, recreational vehicle, supplemental health, lender-placed and other niche insurance products.

National General is a fast paced, dynamic, and entrepreneurial organization. Our team members live by and exemplify what we call the 4Es. At National General, we are Energized, Engaged, Empowered, and we Execute every day in order to provide an exceptional experience for our customers! We are passionate about our organization and the value that we add every day. A successful candidate with National General will embody the 4Es. Our team is poised to outperform the competition. We are National General Insurance and with us you can be extraordinary! Come join our team!

Companies and Partners

Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.

In addition to a phenomenal career opportunity, National General Insurance offers an excellent benefits package including:

• Paid Training
• Medical, Dental, Vision benefits
• Wellness Programs
• Life and Short/Long Term Disability Insurance
• 401k w/ Company Match
• Company Paid Holidays & Generous Time-off policy
• Employee Discount Program
• Career Advancement and Development Opportunities
• On-site Healthcare Clinic (Winston-Salem and Cleveland offices)
• On-site Fitness Center (Cleveland and Dallas offices)
• Subsidized parking (Cleveland office)

National General Holdings Corp. is an Equal Opportunity (EO) employer – Veterans/Disabled and other protected categories. All qualified applicants will receive consideration for employment regardless of any characteristic protected by law. Candidates must possess authorization to work in the United States, as it is not our practice to sponsor individuals for work visas.

In the event you need assistance or accommodation in completing your online application, please contact NGIC main office by phone at (336) 435-2000.