Database Administrator Job Description: Top Duties and Requirements

Database Administrators, or Database Analysts, are technicians who use specialized software to store, organize, and maintain a company’s data. Their duties include planning and development of the database, maintaining the integrity of data, and troubleshooting any technical issues.

Build a Job Description

Database Administrator duties and responsibilities

Database Administrators are usually responsible for designing and implementing data administration policies, models, and standards. In some cases, Data Administrators need to lead and coordinate with other team members to explain their database design or management systems. Other responsibilities and duties of a Database Administrator include:

  • Implementing changes in database operations and ensuring data is readily available to end-users
  • Minimizing downtime of databases and ensuring data provided is accurate
  • Managing database access and keeping stored data up-to-date
  • Providing training, feedback, and support to users on the usage of data provided
  • Ensuring that the database is adequately backed up so that vital information can be retrieved in case of accidental loss or security breach
  • Monitoring performance and providing information on ways to improve the authenticity and security of data
  • Maintaining the efficiency of the database by providing regular checks and data updates
Build a Job Description

Database Administrator Job Description Examples:

 

Example 1

Gamesys Group is one of the world's leading gaming operators, with millions of players and [phone number]+ employees. We believe passionately in what we do. Quite simply, we craft entertainment with care, building trusted brands and creating great experiences that always put the player first. Our award-winning brands – including Virgin, Jackpotjoy, Monopoly, Heart and Vera&John – are some of the best known in the industry. Join us and you'll be joining a big, international group with some great brands and an exciting future. You'll feel part of one global family, working with smart people, and delivering a great experience for our players. There's one thing we expect from you, over and above everything else. Be yourself. One of the values in our DNA is 'stay wonderfully weird' – and that applies to all of us. The Role Gamesys is looking for a Database Administrator with a DevOps Centric mindset for automation. The successful candidate must have a passion for administering database systems and automating deployment processes. The Data Operations team manage on-premise and cloud-based operational databases, as well as real-time streaming services, and are responsible for the security and business continuity of these databases running at Gamesys. Key Responsibilities The role will work closely with other members of the Data Operations team (including database administrators and dataops engineers) as well as with Production Engineering and Enterprise Infrastructure teams to deliver the shared services and bring stability, performance, availability, and security to the database services. Administers Change Data Capture (CDC) and other data replication systems, to provide data transfer to data lakes and data warehouses. Maintains databases to optimum size and operation using archival and database optimisation techniques. Maintains awareness and knowledge of industry trends and identifies and drives identification of opportunities to be demonstrated in the Database arena. The Person Self-motivated, driven and takes ownership. Excellent communication skills, both written and verbal Confident and ability to work under pressure using own initiative. &;Get it done&; attitude Quick learner and a good team player. Skills and Attributes Experience in database systems like IBM DB2, MySQL and/or PostgreSQL Experience in PLSQL or a scripting language that can be used for generating processes to handle data archiving and removing. Proficient in optimising SQL queries to support high operational workloads. Strong Linux user with knowledge of cloud and modern data concepts with practical experience. Good understanding of security principles, with respect to data management Knowledge in maintaining code via Source Control version tools such as GIT. Understanding of cloud technologies such as AWS or GCP in implementing cloud-native systems and/or rebuilding an existing system on the cloud as required. Willing to learn management of production environments with tools. Ability to automate installations of database software using automation. Ability to interpret and communicate technical information into processes. Benefits We offer some of the most competitive benefits in the market, including continued personal growth and career development plans, as well as performance based bonuses. We also believe in providing an environment where employees can flourish. You'll have the opportunity (hopefully soon!) to work in a modern and well catered for environment, with monthly massages, office events and team-building activities. Until then, we also offer a Work From Home Allowance to ensure you have everything you need to work comfortably, during these times. We are Gamesys Group and we're here to make gaming everything it should be! You'll have fun making fun every day, and that's our promise.

Example 2

*Purpose and SCOPE: * Reporting to the Manager of DevOps this position is part of the team responsible for supporting and maintaining various business applications. This position works with the Network Operations and Business Analyst team to troubleshoot, diagnose and rectify problems. This position also works with Application Developers to develop, maintain and optimize PL/SQL. *JOB Responsibilities: * The following are the main job responsibilities and priorities for this position: * Installing, patching, configuring, upgrading and maintaining various Oracle and SQL Server Databases and Database appliances in a Windows and Linux environment. * Installing, patching, configuring, upgrading, and maintaining Oracle 19c Clusterware, RAC and ASM. * Programming triggers, stored procedures, functions and packages using PL/SQL and T SQL. * Working with the network operations team to ensure uptime and recoverability of the Production and Test environments. * Working with business analyst team to ensure all application/database requirements are met. * Working with the Network Operations team to ensure uptime and recoverability of the Production and Test environments. * Troubleshooting, diagnosing and rectifying problems. * Ensuring databases are optimized for database recovery, high availability and disaster recovery. * Creating technical documents for standard operation procedures and recovery procedures. * *Education and Experience* * University Diploma in Computer Sciences is mandatory. * Three plus years' experience working as an Application Administrator, Database Administrator or Software Developer in a business environment is preferred. * Oracle Certification (OCP in version 19c) preferred *Skills and Knowledge* * Experience using Oracle Database 19c and SQL Server is a must. * Experience using, setting up, configuring, and troubleshooting Oracle 19c Clusterware, RAC and ASM technologies is a must. * Experience with RMAN and Data Pump is a must. * Experience writing PL/SQL is a must. * Knowledge of Linux in an enterprise server environment is a must. * Knowledge of shell scripting is must. * Excellent knowledge of backup and recovery scenarios. * Excellent knowledge of database performance tuning. * Knowledge of Oracle Enterprise Manager (OEM) 19c and other monitoring tools is an asset. * Experience using and implementation of Oracle Auditing is an asset. * Experience writing T SQL is an asset. * Experience with JD Edwards or other ERP system is an asset. * Experience with data warehouse, data modeling, and ETL is an asset. * Knowledge of VBScript and Java Script is an asset. * Exceptional communications and interpersonal skills. * A strong aptitude in learning new technology quickly and independently Job Type: Full-time Schedule: * Day shift

Example 3

Amanst Inc. is looking for *Senior Database Administrator* for a contract opportunity with Ontario Government. Estimated Business Days: 250 days Must haves: * Experience with administering and managing resources in Azure, such as Storage Accounts, Keyvaults, Azure Data Factory * Experience with Microsoft Azure SQL database administration and SQL Server [phone number], including: data backup, recovery, security, etc. across multiple regions * Experience with installation of patches and cumulative updates in SQL Server environments, VM’s * Experience with Powershell scripting * Experience in administration and configuration of CosmosDB and MySQLDB About the Role As a Database Administrator, you will be administering the Information Management platform for the organization including the creation, maintenance and management of all databases and environments that support enterprise applications and systems. Additionally, this role will also be responsible for designing databases, both in SQL servers and in a server- less environment. This is an exciting opportunity to use your collaborative communication style, excellent analytical skills, and your in-depth knowledge of database management to ensure client satisfaction with the databases and environments. Note: This role will be focused on the use and application of the Microsoft BI and Azure software stack including SQL Server and Azure Server Integration Services. About Your Day * Plan, design and create databases for the organization, while ensuring the databases are secured according to requirements * Maintain and monitor the database platform * Implementing performance tuning on the databases and re-balancing workloads across database servers * Manage version control of database schemas & procedures in the Azure DevOps * Assist with streamlining and improving data integration efficiencies, reducing effort related to development and support, while providing security, flexibility and scalability * Partner with Information Security team to manage user access provisioning, grants and permissions, in a safe and secure way. * Assist with the implementation of database solutions and assist others performing implementations that impact databases or enterprise * Work with Azure Storage services such as; Blob Storage, Tables, Azure CDN, File Storage and Data Warehouse * Provide technical guidance or assistance to vendor/internal teams on data extraction, delivery, loading, and reporting About You * Completed Post-Secondary education in Computer Science, IT or related areas OR equivalent combination of education and experience * Microsoft Certifications and/or other vendor certifications would be a strong asset * 7+ years of progressive experience in Database systems design, development and implementation. * Experience with Microsoft Azure SQL database administration and SQL Server [phone number], including: data backup, recovery, security, etc. across multiple regions * Working knowledge of Microsoft Dynamics/D365 and programming languages API would be a strong asset * Experience scheduling workloads from IaaS to multiple targets in Azure * Supporting business critical operations for on-premises or Azure instances. * Experience administering and managing resources in Azure, such as Storage Accounts, Keyvaults, Azure Data Factory * Ability to monitor, troubleshoot and resolve issues using default tools, third-party solutions, or Azure console, and provide performance and tuning recommendations as needed * Experience with installation of patches and cumulative updates in SQL Server environments, VM’s * Experience with Powershell scripting * Experience in administration and configuration of CosmosDB and MySQLDB * Intermediate skill with using Microsoft Office applications * Excellent verbal and written communication skills Experience and Skill Set Requirements Requirements: 20% * Completed Post-Secondary education in Computer Science, IT or related areas OR equivalent combination of education and experience * Working knowledge of Microsoft Dynamics/D365 and programming languages API would be a strong asset * Microsoft Certifications and/or other vendor certifications would be a strong asset Experience Requirements: 40% * 7+ years of progressive experience in Database systems design, development and implementation. * Experience scheduling workloads from IaaS to multiple targets in Azure * Experience supporting business critical operations for on-premises or Azure instances ? Technical Requirements: 40% * Experience with administering and managing resources in Azure, such as Storage Accounts, Keyvaults, Azure Data Factory * Experience with Microsoft Azure SQL database administration and SQL Server [phone number], including: data backup, recovery, security, etc. across multiple regions * Experience with installation of patches and cumulative updates in SQL Server environments, VM’s * Experience with Powershell scripting * Experience in administration and configuration of CosmosDB and MySQLDB * Intermediate skill with using Microsoft Office applications Job Types: Full-time, Fixed term contract Schedule: * Monday to Friday

What does a Database Administrator do?

Database Administrators are usually in charge of a company’s data. They store information and ensure that information is secure from unauthorized access or accidental loss. They also make sure that the company’s data is available to the end-user in a readily available manner.

Database Administrators can work in different industries, including supply chain management firms, technology consulting firms, manufacturing firms, health care facilities, engineering companies, government organizations, and non-governmental agencies, among others.

Database Administrator skills and qualifications

As an individual charged with the management of sensitive information, Database Administrators are professional and organized. They have strong communication and numerical skills. Other important skills required of a Database Administrator include:

  • Analytical and problem-solving skills
  • Ability to work independently and as part of a team
  • Strong attention to detail
  • Experience with database development and management software
  • Ability to multitask, prioritize tasks, and manage time efficiently
  • Strong aptitude for mathematics

Database Administrator experience requirements

The experience required of a Database Administrator varies depending on the industry, the size of your business, and the sensitivity of the data. Database Administrators working for large companies or with sensitive information should generally have two to five years of experience with database programming languages such as PL/SQL coding. Database Administrators should also have experience with different database software, including SQL servers, MySQL, Oracle RAC, or related programs. Candidates need an in-depth understanding of how databases work.

Database Administrator education and training requirements

Look for candidates with a bachelor’s degree in information technology (IT), computer science, computer information systems (CIS), or another related field. Depending on the complexity of the tasks, some employers prefer candidates with a master’s degree or additional college diploma in a specialized field. As individuals working with data, Database Administrators need basic knowledge of programming. Elective training courses can help ensure candidates have adequate hands-on learning to prepare them for working with databases.

Database Administrator salary expectations

According to Indeed Salaries, the average rate for a Database Administrator in Canada is $40.11 per hour. However, wages depend on factors like the employee’s experience, education, location, the size of the database, and the hiring company.

Job description samples for similar positions

If a Database Administrator is not quite what you are looking for, similar job descriptions include:

Ready to Hire? Build a Job Description

Database Administrator job description FAQs

What are the qualities of a Database Administrator?

As technical individuals, Database Administrators are detail-oriented and have a pragmatic approach to work. They’re logical thinkers, meticulous, and pay attention to detail to prevent errors. Additionally, Database Administrators are committed to lifelong learning, as they need to stay updated on industry trends and technological advances. They have a passion for technology, and understand computer software and the importance of data security. 

What makes a Database Administrator job description stand out?

To attract great candidates, provide a high-level overview of the size of the database, the nature of the information, and its purpose. Include specific duties and responsibilities, and state whether the position requires team management or leadership. The role is generally individual, but if leadership skills are important, that information should be included to draw the right candidates. Providing a competitive salary range is sure to make the description stand out among similar positions. If your company offers benefits, like RRSP-matching programs or flexible working hours, highlight those in the description as well.

Who does a Database Administrator report to?

Who a Database Administrator reports to depends on the structure and the size of the organization. In a startup setting, a Database Administrator reports to the owner, Chief Technology Officer (CTO) or another top executive. However, in a large establishment, the Database Administrator reports to a Manager or Director of the technology department.

Job Description Examples

Need help writing a job description for a specific role? Use these job description examples to create your next great job posting. Or if you’re ready to hire, post your job on Indeed.

No search results found