Database Administrator Job Description Template [2024]

Table of Contents

    Database Administrators are responsible for designing, implementing, administering, and monitoring data management systems to ensure data design, consistency, quality, and security. They also oversee the installation, configuration, monitoring, maintenance, and improvement of the performance of databases and data stores. While the solution architect is responsible for designing databases, the implementation and maintenance of the system fall under the database administrator’s responsibilities. 

     

    About the Role

    As a database administrator, your key role will be to administer and design database schemas, and all types of database objects for IT projects like tables, views, stored procedures, functions, etc. Additionally, they will be the main advisor of all technical components for database management systems.  

    Job Overview

    We are looking for passionate, motivated, and self-driven individuals who will support our database management systems with their analytical and problem-solving skills. They will also provide functional and technical support on MS SQL server and help us manage SQL Server and SQL Server based applications in our regional offices. The ideal candidate should possess sound technical knowledge, a strong work ethic, and genuine interest in working in this field. 

    Responsibilities

    • Oversee Core MySQL, MariaDB, and MySQL Enterprise monitoring. 
    • Adept at query optimization, script optimization, and other optimization tools and techniques. 
    • Design and create database objects, such as data table structures, stored procedures, views, triggers reports, database administration, configuration, maintenance and support. 
    • Implement security and integrity controls, such as backup and data recovery strategies. 
    • Assist in translating business requirements into technical design specifications and preparing high-level documentation for the database design and objects. 
    • Conduct extensive research to identify errors and make recommendations on database products, services, protocols, and standards in support of procurement efforts. 
    • Manage database and table-level permissions by integrating MySQL with Windows Active Directory. 
    • Develop technical specifications, policies, and procedures for database management. 
    • Develop standards, policies, and strategies related to SQL-based systems. 
    • Diagnose and resolve database access and security issues. 
    • Create and schedule jobs in MySQL and ETL, deploy SQL patches, Perform Data Migration Activity. 
    • Install and configure test environments. 
    • Plan and execute data migrations between different database systems. 
    • Using additional techniques for database partitioning, replication, and migration. 
    • Diagnose and resolve database access and security issues. 

    Requirements

    • A degree in B.Sc./BA in computer science is preferred. 
    • Working knowledge of Oracle, MS SQL, and MYSQL server database administration and Oracle and Tomcat Apache Application Server administration. 
    • Prior experience managing multiple databases, application servers, and data integrity and databases. 
    • Quick learner and flexible in a dynamic environment. 
    • Good communication skills and team cooperation skills to manage working relationships with different departments. 
    • Possess active knowledge of Windows 2003-12, Windows Clustering, and Active Directory. 
    • Analytical and problem-solving skills. 
    • Time management and maintaining good relationships with the clients. 
    • Excel in a fast-paced and highly stressful environment. 

    Frequently Asked Questions (FAQs)

    1. What is a database administrator (DBA)?

    A Database Administrator (DBA) oversees the management and maintenance of databases and ensures their security, performance, and availability to meet the organization’s basic needs. 

    2. What are the roles and responsibilities of a DBA?

    A DBA’s key roles and responsibilities are managing databases, ensuring data security, designing data models, optimizing database performance, troubleshooting issues, and implementing backup and recovery to maintain data integrity. 

    3. What does a database administrator do?

    A database administrator is responsible for managing databases to ensure the user’s requirements are met. They overlook database designing, installation, configuration, security, backup, and troubleshooting. 

     

    cookie image

    By clicking “Accept", you consent to our website's use of cookies to give you the most relevant experience by remembering your preferences and repeat visits. You may visit "cookie policy” to know more about cookies we use.