Connecture

  • Senior Database Administrator

    Job Locations US-WI-Brookfield
    Job ID
    2018-1355
    # of Openings
    1
    Category
    Information Technology
    Type
    Regular Full-Time
  • Overview

    The Senior Database Administrator works with software vendors on the implementation and continued support of application databases. The incumbent also designs data base applications to specifications provided by higher level staff, tests, corrects, monitors, and updates developed applications. Also works with operations staff on performances and tuning analysis, systems support and optimization, as well as provides technical assistance to applications developers. In addition, this individual sets up backup and recovery procedures for data bases and controls access to data in physical data base designs for both privacy and security.

     

    Scope of Leadership

    The Senior Database Administrator position is a career-Level position within field. The role requires experience and proficiency in discipline. The Senior Database Administrator works with minimal supervision with wide latitude for independent judgment. The direct promotion path for a Senior Database Administrator is to Lead Database Administrator.

     

    NOTE: This position is not static and is subject to change as Connecture’s and the Department’s needs change.

    Responsibilities

    The essential responsibilities of the Senior Database Administrator are to.

    • Contributes to team effort by accomplishing related results as needed.
    • Maintains quality service by establishing and enforcing organization standards.
    • Supports database functions by designing and coding utilities.
    • Design and document database architecture. Data Modeling.
    • Design Data Warehousing and Business Intelligence platform.
    • Build database scheme, tables, procedures and permissions.
    • Set up data sharing and disk partitioning.
    • Develop database utilities and automated reporting.
    • Oversee backup, clustering, mirroring, replication and failover.
    • Provide 24/7 support for critical situations.
    • Implement security and encryption.
    • Install and test upgrades and patches.
    • Restore and recover corrupted databases.
    • Analyze and sustain capacity and performance requirements
    • Analyze, consolidate and tune database for optimal efficiency
    • Evaluate and recommend new database technologies
    • Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
    • Installs revised or new systems by proposing specifications and flowcharts; recommending optimum access techniques; coordinating installation requirements.
    • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.

    Qualifications

    • A BS/BA Degree Computer Science/ Information Systems or equivalent work experience.
    • 6-9 years Oracle / SQL Server / DB2 database development and administration design of OLTP systems, relational database design, data modeling tools, creation of databases using complex structures, complex data loads and migrations, complex data migrations and manipulation using SQL, develop and deploy backup/restore strategies, and monitoring and performance tuning databases.

    • Experience in design of OLTP systems.
    • Experience in relational database design.
    • Experience using data modeling tools.
    • Experience doing complex data migrations and manipulation using SQL.
    • Experience in OLAP and Data Warehousing database architectures.
    • Experience with N-tiered or Internet applications.
    • Experience using DB2.
    • Experience with design tools such as Embarcadero’s DBArtisan and ER Studio
    • Experience monitoring and performance tuning databases.
    • Perform complex DBA tasks, including creating databases using complex structures, ensuring data security and integrity, and performing complex data loads and migrations.
    • Develop and deploy backup/restore strategies.
    • Coordinate and participate in large database projects.
    • Knowledge of the insurance industry.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed