Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.
National General Insurance

National General Insurance

Database Administrator I

Nashville, TN
Full Time
Paid
  • Responsibilities

    Work as a part of a team who are responsible for administering, supporting and assisting in the implementation of new and existing SQL systems, data conversions and migrations, stored procedure review, deployment and monitoring of the systems. This includes maintaining legacy system databases and assisting in the migration to new systems. This includes day-to-day administration, performance tuning, and maintenance supporting several core systems. Responsible for reviewing maintenance plans, ensuring 100% of databases are backed up, responding to failures, writing and testing disaster recovery plans.

     

    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.

    • Ensure system availability and recovery
    • Execute performance tuning, backup and restoration of databases
    • Provide daily management of Microsoft SQL Server infrastructure and assure service availability
    • Maintain all databases including Development, QA, Training, and Production environments
    • Work with business users, developers, and infrastructure teams to ensure quality products
    • Responsible for documenting all database maintenance procedures
    • Maintain policies and procedures to ensure regulatory compliance
    • Keep SQL servers up to date with necessary patches
    • Perform release management activities
    • Perform server migration/upgrade activities
    • Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
  • Qualifications

    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.

    • Bachelor Degree or in-lieu of degree equivalent education, training and work-related experience
    • Knowledge of Microsoft SQL Server 2014/2016 and/or Oracle 11g/12c
    • Thorough understanding of Relational Databases, T-SQL/PLSQL Scripting, Database Normalization best practices, database technologies and concepts
    • Database Design in a Software Development Environment as a contributor
    • Experience with Team Foundation Server, Visual Studio, Redgate, and Idera
    • Proficient with SQL Development – ability to write and troubleshoot SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints)
    • Experience troubleshooting and resolving database integrity and performance issues
    • Experience with Performance Tuning and Query Optimization
    • Proficient in Microsoft Office (Word, Excel, Outlook, PowerPoint)

     

    DESIRED SKILLS:

    • Bachelor Degree in Computer Science or a related field or equivalent experience
    • Experience in Microsoft SQL Server Clustering, Replication and Always On or Oracle Data Guard
    • Experience with SSRS, SSIS or SSAS
    • Expert experience in implementing operational automation
  • Industry
    Insurance
  • Fun Fact
    We're a company of many niche businesses where you can grow and thrive in many different disciplines.
  • About Us

    National General is a leading insurance carrier which has been in the industry since 1939. Through subsidiaries and other affiliated companies, National General offers homeowners, flood, personal and commercial auto, RV, motorcycle, life, accident and supplemental health insurance products. National General Insurance is a thriving company committed to ensuring that our employees achieve their personal best. Our employees are advancing their careers at a best-in-class insurance provider that is an industry leader in innovation. We give employees resources which enable them to take charge of their own future success.