Mid-Level SQL Database Admin

Mid-Level SQL Database Admin

02 Nov 2021
Ohio, Cincinnati, 45203 Cincinnati USA

Mid-Level SQL Database Admin



The Database Administrator's role is to design, install, monitor, maintain, and performance tune all corporate databases (development, test and production) while ensuring high levels of data availability. This individual is also responsible for contributing to and implementing database policies and procedures to ensure the security, integrity and availability of databases and their accompanying software.

ESSENTIAL JOB FUNCTIONS:

Under general direction:



Database Administration

  • Managing, monitoring and maintaining company databases.

  • Making requested changes, updates and modifications to database structure and data.

    • Develop and maintain new databases, including schema, tables, indexes, views, functions, stored procedures, security, resource requirements, and other aspects.

    • Automate maintenance and other tasks using SQL Server Agent.



  • Ensuring database security, integrity, performance and system availability.

    • Maintain index and maintenance scripts to stay within maintenance windows.

    • Recommend tools for enterprise-wide monitoring of all SQL Server instances and develop and monitor database performance.

    • Maintain data encryption at rest and in motion encryption for all database servers, including SSL certificate generation and signature.

    • Benchmark baseline performance for all corporate database servers and related environment.

    • Diagnose production problems on all corporate databases, including root cause diagnosis and correction.

    • Patch and upgrade all database server instances as needed.



  • Maintaining database backup and recovery infrastructure.

    • Maintain full, differential and transaction backup process.

    • Maintain automated restore scripts which handle Point in Time Restore (PITR) for Full, Differential, and log files.

    • Participate in Disaster Recovery (DR) activities.



  • Provides guidance during the development and enhancement of production applications including working with it development team during the application development life cycle.




  • General - Other


  • Prioritize work according to the business needs.

  • Maintain company-wide SQL Server licensing assignment and tracking.

  • Perform evaluations of existing and proposed application design and code for database accuracy, capacity, maintainability and performance. Provide detailed feedback on DB improvements.

  • Analyze projects and design ways to improve their efficiency and accuracy.

  • Ability to create and maintain technical documentation.


  • BH: 211492

    Related jobs

    Job Details

    • ID
      JC5442062
    • State
    • City
    • Job type
      Permanent
    • Salary
      USD $80000 - $88000 per annum 80000 - 88000 per annum
    • Hiring Company
      Vaco Technology
    • Date
      2020-11-02
    • Deadline
      2021-01-01
    • Category

    Jocancy Online Job Portal by jobSearchi.