Database Administrator Job Description

Question

Database Administrator Job Description

Job descriptions
Information Technology

Job summary 1

Database Administrator plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines, and protection. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures, and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. Normally receives little instruction on day-to-day work, and general instructions on new assignments.

Duties & Responsibilities 1

special offer

Download PDF with all 10 Database Administrator Job Descriptions

100Hires
eBook

Free Guide:

The Ultimate guide
to recruiting

Provides technical and operational database administration. Installs maintains, develops, and implements policies and procedures for ensuring the security, availability, and integrity of the company databases and large data warehouse database environments.
Provides analysis and definitions of technical standards related to database resources.
Provides analysis and design functions for new and existing systems.
- Applies knowledge in the area of physical database design, performance, tuning, and backup and recovery procedures to resolve database performance issues, database capacity issues, replication, and other distributed data issues.
- Provide support resolving conversion and upgrade data issues. Liaise with Project Managers, Business Analysts, and Developers for the definition and clarification of requirements and to facilitate the progress of project tasks.
- Performs other duties as assigned.

Requirements & Skills 1

Bachelor's degree in computer science, engineering, or related field or equivalent experience
2 years’ database administration experience in Server Databases
Experience working with multiple operating systems
- Experience monitoring and auditing procedures of databases
- Experience in database schema design
- Experience with database security administration, disaster recovery planning, High availability, systems performance monitoring and tuning

Job summary 2

The Database Administrator will support the Server Database environment with responsibility for the creation of databases, performance tuning, cloning, copying, high availability, and data refreshes.

Duties & Responsibilities 2

Requirements & Skills 2

Job summary 3

You are a forward-thinking Database Administrator with the ability to rapidly troubleshoot complex technical problems under pressure. You have a deep knowledge of database concepts and can implement scalable solutions. Your intellectual curiosity leads you to continually learn about the latest database technology. You have excellent communication skills and enjoy working collaboratively with others.

Duties & Responsibilities 3

Design resilient, scalable database system architectures that facilitate company project goals and deliverables
Organize and prioritize the database team's work
Devise strategies to streamline existing processes and procedures used for both day-to-day and long-term support
Orchestrate best practices for database security controls and data governance
- Provide best practice recommendations and guidance via code reviews to other members of the team
- Develop automation frameworks to reliably support large database implementations
- Design, coordinate, and execute data migrations between systems

Requirements & Skills 3

Bachelors Degree or equivalent experience; Certifications preferred
At least 7 years of Microsoft SQL Server database administration experience
Strong analytical skills for problem resolution and extensive knowledge of database performance tuning, clustering, replication, backups, and log shipping
Scripting experience with either Python or Powershell
- Experience working with Git for version control
- Comfortable working in both Windows and Linux environments
- Possess excellent communication skills and maintain strong team relationships

Job summary 4

The Database Administrator maintains the integrity, security, and availability of multiple database(s). Duties include disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data. Administers maintains, develops, and implements policies and procedures for ensuring the security and integrity of the database. The candidate will evaluate and recommend available database management system (DBMS) products. Performs database and software life-cycle activities to ensure the highest level of system performance and availability and compliance with business requirements. The candidate will perform SQL, Oracle, and MySQL Database and Application server administration. The candidate organizes and formats data for efficient query and storage processes.

Duties & Responsibilities 4

Maintain the integrity, security, and availability of database(s).
Establish and maintain database user accounts.
Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the database(s).
Organize and format data for efficient query and storage processes.
Evaluate requirements and recommends available DBMS products.
Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data.
- Develop policies and procedures for ensuring the security and integrity of the database(s).
- Perform database and software life-cycle activities to ensure the highest level of system performance and availability.
- Support data modeling activities by way of prototype database implementations.

Requirements & Skills 4

A minimum of ten (10) years experience as a Database Administrator in programs and contracts of similar scope, type, and complexity is required.
Five (5) years of experience in an application programming language, such as Java, C++ or C, Perl, JavaScript, UNIX, XML, and HTML.
Must have experience with workflow tools, such as Apache or JBoss.
Must have experience with administering programs and databases.
Must have working experience with MySQL Databases, including MySQL Workbench and PHPADMIN
Working knowledge of installing, configuring, and maintaining ELK Stack to support the production environment.
- Knowledge of JIRA, Confluence, and GitLab
- Bachelor’s degree in a technical discipline from an accredited college or university is required.
- Four (4) years of additional DBA experience may be substituted for a bachelor’s degree.

Job summary 5

The Database Administrator must be able to efficiently investigate complex database issues and provide solutions. They must have the ability to effectively interface with management, database team members, software developers, and customers efficiently investigate complex database issues, and provide solutions. The candidate will need to handle installations, upgrades, backups, and configuration.

Duties & Responsibilities 5

Perform SQL database maintenance, monitoring, and tuning activities.
Provide emergency and urgent support as required by the business and/or application owner to ensure the availability and integrity of the application and data.
Work with the application owners, on an as-requested basis, to plan for and provide guidance on database virtualization and software upgrade planning.
Work with remote DBA support resources to maintain 24x7 uptime requirement.
Monitor and maintain database backup and disaster recovery procedures.
- Maintain and audit database-level security.
- Evaluate, test, and deploy new database patches and upgrades.
- Configure and maintain database administration tools for monitoring performance and change management.

Requirements & Skills 5

Job summary 6

Database Administrator manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access, and security administration. Performs backup and recovery on Database Management Systems, configures database parameters and prototype designs against logical data models and defines data repository requirements, data dictionaries, and warehousing requirements.

Duties & Responsibilities 6

Administers maintains, develops, and implements policies and procedures for ensuring the security and integrity of the company database.
Implements data models and database designs, data access, and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues.
Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance, and cost.

Requirements & Skills 6

Bachelor's Degree in Computer Science, Information Systems, or another related field. Or equivalent work experience.
Typically has 3 to 5 years of IT work experience.
- Familiar with standard concepts, practices, and procedures within a particular field.
- Relies on related experience and judgment to plan and accomplish goals.
- A certain degree of creativity and latitude is required.

Job summary 7

The Database Administrator is responsible for installing, configuring, managing, and upgrading company databases. In this role you will provide day-to-day operational and technical support for databases across the enterprise, offering technical expertise to other members of the IT team.

Duties & Responsibilities 7

Maintain the integrity, security, performance, and availability of databases
Manage a replicated architecture that provides tuning and monitoring of database security
- Perform backup and recovery of databases, index maintenance, performance tuning, and monitoring of databases
- Demonstrate ability to analyze resource bottlenecks and provide suggestions to the team, management, and internal customers on how to alleviate pressure and plan for capacity
- Provide recommendations and strategies to application owners on how to improve the performance and scalability of their database components

Requirements & Skills 7

Bachelor's Degree or equivalent in Computer Science, Information Systems, or related field
5+ years of Microsoft SQL Server DBA experience
- Proficient knowledge to provide oversight and expertise to software developers in SQL tuning, coding, and deployment of stored procedures
- Expert skill level executing SQL Server high-availability technologies (replication, mirroring, failover clusters, etc.)
- MCSA 2014+

Job summary 8

We are seeking a Database Administrator to join our team. This position will provide support for and within the assigned relational database platform to ensure appropriate performance, configuration, maintenance, and upgrades are administered. The ideal candidate will have 3+ years of increasing experience and responsibility in Microsoft SQL Server administration. This role will partner with IT Development and Network operations teams with database issues and resolutions. This position will also perform troubleshooting and fix issues so that IT development teams and end-users have a good user experience.

Duties & Responsibilities 8

Requirements & Skills 8

Bachelor’s degree in Computer Science or equivalent training/education/experience instead of degree will be considered.
3+ years of experience with Microsoft SQL Server.
Experience with troubleshooting the performance of Microsoft SQL Server.
Experience with Microsoft SQL Server high availability and disaster recovery technologies and concepts.
Proficiency with T-SQL to manage and administer Microsoft SQL Server.
Understanding of Microsoft SSIS, SSRS, and SSAS administration.
- Understanding of underlying operating system storage and networking.
- Basic understanding of business intelligence software platforms.
- Knowledge of cloud relational or non-relational data storage engines is preferred.

Job summary 9

We are looking for a motivated, resourceful Database Administrator with the desire to be a critical member of our team supporting both production and development environments. We value team members who strive to produce high-quality work through collaboration with team members and customers while making a difference through individual contributions to ensure project success for our team and our customers. You will primarily be supporting the development team while ensuring the stability of the production database. You will be working closely with technical team members to maximize the performance of the database in all environments and ensure compliance with all security directives. You will be managing account access for the support team as well as application schemas.

Duties & Responsibilities 9

Installing database software and quarterly patches for Oracle databases in production and development environments.
Performing maintenance of tablespaces and datafiles and database troubleshooting as needed.
Ensuring the integrity of the production database, including backup and recovery procedures as well as standby databases.
- Optimizing the performance of the database and supporting developers by assisting with optimizing queries.
- Establishing and maintaining database accounts and permissions.
- Working independently with minimal supervision.

Requirements & Skills 9

Bachelor's degree in Computer Science or Information Systems or another technically relevant degree.
7 years of experience in Oracle database administration.
Experience with backup, recovery, and Oracle Data Guard.
Proficiency with Oracle PL/SQL and stored procedures.
Ability to work collaboratively in a team environment with a strong focus on customer service and solution ownership.
- Ability to meet deadlines and manage multiple, dynamic priorities.
- Ability to communicate clearly and concisely.
- Ability to obtain a CISSP or CASP Certification within six months of hire.

Job summary 10

This position designs, maintains and controls the corporate databases and data dictionary. Establishes and enforces all database standards. Analyzes all informational requirements of new or production systems and develops database specifications. Establishes and enforces controls to ensure database integrity and security.

Duties & Responsibilities 10

Requirements & Skills 10

Frequently asked questions

What is the role of a database administrator?

A Database Administrator (DBA) is responsible for the management, performance, security, and integrity of an organization's databases. They play a crucial role in ensuring that databases are properly designed, implemented, and maintained to meet the organization's data management needs. The specific tasks and responsibilities of a DBA may vary depending on the organization's size, industry, and the complexity of its database systems. However, here are some common responsibilities of a database administrator:

Database Design and Implementation: DBAs participate in the design and planning of database systems. They work closely with application developers and system architects to create efficient database structures, define data models, and establish data integrity rules.

Database Installation and Configuration: DBAs install and configure database management systems (DBMS) such as Oracle, MySQL, SQL Server, or PostgreSQL. They set up database environments, configure system parameters, and optimize performance settings.

Data Security and Access Control: DBAs implement security measures to protect databases from unauthorized access, data breaches, and data loss. They define user roles, permissions, and access controls, and ensure compliance with security regulations and industry standards.

Database Performance Monitoring and Tuning: DBAs monitor database performance and identify performance bottlenecks or issues. They optimize queries, analyze query execution plans, manage indexes, and tune the database system to improve efficiency and response times.

Database Backup and Recovery: DBAs develop and implement backup and recovery strategies to protect against data loss or system failures. They schedule regular backups, perform recovery operations when needed, and test data recovery procedures to ensure data availability and integrity.

Database Maintenance and Upgrades: DBAs perform routine maintenance tasks, such as database reorganizations, data archiving, and software updates. They apply patches, upgrades, and bug fixes to keep the database management system up to date and secure.

Data Replication and High Availability: DBAs configure and manage database replication and clustering technologies to ensure high availability and fault tolerance. They set up backup servers, implement replication processes, and monitor data synchronization.

Capacity Planning: DBAs assess the current and future data storage and processing requirements of the organization. They monitor database growth, plan for scalability, and make recommendations for hardware and storage upgrades as needed.

Database Documentation and Reporting: DBAs maintain documentation of database systems, including data dictionaries, schemas, and system configurations. They generate reports on database performance, usage, and security, and communicate this information to stakeholders and management.

Collaboration and Support: DBAs collaborate with application developers, system administrators, and other IT teams to support database-related needs. They troubleshoot database-related issues, provide technical support, and assist in resolving database-related incidents.

In summary, database administrators play a critical role in managing and maintaining databases, ensuring data integrity, security, and performance. They combine technical expertise with problem-solving skills and a strong attention to detail to support an organization's data management objectives.

Who does a database administrator work with?

A Database Administrator (DBA) works with various stakeholders within an organization to effectively manage and support database systems. Here are some key individuals and teams that DBAs collaborate with:

Application Developers: DBAs work closely with application developers to ensure seamless integration of databases with software applications. They collaborate on database schema design, query optimization, and data access methods to ensure efficient and reliable application performance.

System Administrators: DBAs collaborate with system administrators to manage server infrastructure, network connectivity, and storage systems. They coordinate activities related to database installation, configuration, and performance tuning, taking into account system-level considerations.

Data Analysts: DBAs work with data analysts to understand their data needs, provide access to relevant databases, and assist in optimizing data retrieval and analysis processes. They ensure that data is available, reliable, and properly structured for analysis.

Business Stakeholders: DBAs interact with business stakeholders, including managers and executives, to understand data requirements, prioritize database-related projects, and address any concerns or requests. They provide insights on data management best practices and contribute to strategic decision-making.

IT Security Team: DBAs collaborate with the IT security team to implement and enforce data security policies and practices. They work together to ensure compliance with data protection regulations, manage access controls, and address security vulnerabilities or incidents.

Database Vendors and Consultants: DBAs may work with external database vendors or consultants who provide specialized expertise or support for specific database systems or projects. They collaborate on implementation, upgrades, or troubleshooting activities.

Help Desk and Support Teams: DBAs assist help desk or support teams in resolving database-related issues. They provide guidance, troubleshooting assistance, and knowledge transfer to ensure timely and effective resolution of user-reported problems.

Data Governance and Compliance Teams: DBAs collaborate with data governance and compliance teams to establish and maintain data management policies, data quality standards, and compliance with relevant regulations. They contribute to data governance initiatives, data classification, and metadata management.

Database User Community: DBAs interact with end-users of the database systems, such as business users or data analysts, to understand their requirements, provide technical support, and address any data-related issues or questions.

Project Management Office (PMO): DBAs may collaborate with the PMO to align database-related projects with organizational goals, provide input on project planning and resource allocation, and ensure that database-related projects are executed effectively and delivered on time.

Collaboration with these stakeholders ensures that database systems meet the organization's needs, are secure and well-maintained, and support the overall IT infrastructure and business operations.

We use cookies to offer you our service. By continuing to use this site, you consent to our use of cookies as described in our policy