Resources
Post a Job
 Special offer 

Jumpstart your hiring with a $100 CAD credit to sponsor your first job.*

Sponsored jobs are 4.5X more likely to result in a hire.**
  • Invite matched candidates to apply
  • Increase your visibility in job search results
  • Appear to more candidates longer
*The $100 CAD Sponsored Job credit offer is only available for new accounts in Canada that post a job and expires one year after account creation. Upon expiration of the credit, users are charged based on Sponsored Job budget. Terms, conditions, and quality standards apply **Indeed data (worldwide)

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
Are you a Job Seeker? Find Jobs

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
Are you a Job Seeker? Find Jobs

Database Administrator Job Description Examples:

Example 1

GlobeStar Systems is a leader in integrated clinical communication. Our cornerstone product, Connexall�, is an award-winning Enterprise grade IoT platform, purpose built for the healthcare industry. Connexall� is a sophisticated and customizable end-to-end integration and communication platform that helps its customers improve clinical workflow, reduce alarm fatigue, and drive better patient and staff outcomes.

Application and Database Administrator

Reporting to the Director of IT, the Application & Database Administrator position is responsible for support of all assigned applications, this position will serve as a subject matter expert on content, processes, and procedures associated with enterprise and in-house developed applications. Is responsible for the availability, integrity, accessibility, and performance of all the database systems by supporting, enhancing, administering, and maintaining the corporate databases.

Primary Responsibilities

  • Collaborate with various stakeholders to play an active role, in selecting, configuring, and implementing application systems.
  • Interacts with users and evaluates vendor products.
  • Leads and participates in efforts to develop and implement processes for application and system monitoring.
  • Leads and participates in efforts to implement application updates to include upgrades, patches, and new releases.
  • Develops test plans to verify the logic of new or modified programs.
  • Maintains systems documentation.
  • Provides advice and training to end-users.
  • Analyze internal user business requirements and develop, maintain, and modify reports for the ERP platform.
  • Develop, and maintain the overall health of the ERP, CRM, Incident Management systems and other third-party applications.
  • Configuration planning and installation of mostly MS-SQL and My-SQL databases.
  • Conduct database performance analysis, tuning and maintenance.
  • Create and maintain reports in SQL server 2016/2019 Reporting Services and Power BI.
  • Apply database patches as required to both Production and Test databases.
  • Responsible for developing, implementing, and overseeing database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

    Qualifications

  • A Bachelor�s degree in Information Technology or related field required.
  • Minimum 3 years of experience in Application Management and Database Administrator
  • Microsoft SQL Certification is required.
  • Knowledge in Power BI is an asset.
  • System application administration experience related to ERP, Microsoft-based products, master data management, middleware services, and digital platforms.
  • Ability to select new enterprise-level software packages and optimize existing processes.
  • Experience with installing, administering, and supporting applications in a multi-platform environment.
  • Strong understanding of database structures, theories, principles, and practices.
  • General Database Administration, Performance and Health/capacity monitoring (SQL Server 2016/2019).
  • Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of databases.
  • Extensive knowledge of T-SQL (Ad-hoc maintenance scripts, stored procedures, views).
  • Experience integrating SQL Server and Power Bi.
  • Expert knowledge of design and maintenance of SQL Server 2016/2019 Reporting Services reports.
  • Expert knowledge of applications management.

    Job Type: Full-time

    Benefits:
  • Dental care
  • Disability insurance
  • Extended health care
  • Flextime
  • Life insurance
  • Paid time off
  • RRSP match
  • Tuition reimbursement
  • Work from home
    Schedule:
  • 8 hour shift
    Supplemental pay types:
  • Bonus pay

    Ability to commute/relocate:
  • Toronto, ON: reliably commute or plan to relocate before starting work (required)

    Education:
  • Bachelor's Degree (required)

    Experience:
  • Database administration: 3 years 2 years (required)

    • Example 2

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients.

    We are currently seeking competent individuals to fulfill the role of Database Administrator to join our dynamic team for our client

    Contract Duration: 6 months
    Extension: Yes
    FTE: Yes

    Position Summary-

  • Monitor the system, and act upon system and application automated alerts
  • Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues
    (ex. correcting installation, configuration, or data problems)
  • Plan and perform software installation, configuration, upgrade and patching
  • Plan and perform database configuration, maintenance, upgrade and patching
  • Perform and manage system and database backups
  • Perform manual switch to redundant system / database components, in case of system failure

    Job Responsibilities:
    Provide on-site database and system support
    Monitor, collect statistical information, and provide reporting on capacity and system performance Based on statistics, make recommendations to maintain and improve capacity and system performance
    Monitor the system, and act upon system and application automated alerts
    Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
    Plan and perform software installation, configuration, upgrade and patching
    Plan and perform database configuration, maintenance, upgrade and patching
    Perform and manage system and database backups
    Perform manual switch to redundant system / database components, in case of system failure

    Must Have Skills/Requirements:
  • Bachelor's degree in a technical field such as computer science, computer engineering or related field required
  • 5+ years Database Administration experience
  • Experience in providing technical support, covering database administration and
    operations to include monitoring maintenance capacity, performance
    monitoring/planning and incident/problem troubleshooting and resolution
  • Experience with MSSQL 2019/2017/2016/2014/2012
  • Experience with Windows server 2012/2016/2019.
  • Experience with Windows 10/8/7 client operating systems.
  • Experience with SQL Always-On, mirroring, clustering and data replication.
  • Experience with MSSQL services (SSRS/SSAS/SSIS/Fulltext/Polybase/R) and OLAP.
  • Experience with application side tuning versus server-side tuning.
  • Experience with VB, C#, Power shell, Azure Cloud would be an asset to the role.

    Job Type: $60.00-$80.00 per hour

    • Example 3

    With its Corporate office in Red Deer, Alberta and its Regional office in London Ontario, Peavey Industries LP is the corporate parent to retail brands Peavey Mart, MainStreet Hardware, and Ace Canada. We are 100% Canadian and employee-owned.

    Peavey is an engaging workplace. We are proud to promote from within and provide training to make this possible. We offer flex-time and comprehensive benefits.

    We are committed to our customers and the communities and agricultural regions we serve every day.

    Location:London, ON or Red Deer, AB. Hybrid work environment required in-office 2 days a week.

    Job Overview:The Database Administrator is responsible for directing and/or performing all activities related to maintaining a successful database environment*. *This role ensures Peavey Industries databases, and its related applications operate functionally and efficiently.

    Ideal Candidate:We are looking for an analytics-driven individual who is skilled at problem-solving and has effective communication skills. They will have proven abilities in planning, organizing, and working on multiple tasks simultaneously. They will also have familiarity with the following: Azure DevOps, Data Factory, Azure Synapse, Microsoft Azure SecOps, IaaS, PaaS, DBaaS, and IPaaS solutions (Boomi, Informatica, MuleSoft).

    Responsibilities

    � Manage an environment of SQL Server, Azure SQL DB, AS400 and other databases through multiple product lifecycle environments, from development to mission-critical production systems

    � Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

    � Refine and automate regular processes, track issues, and document changes

    � Manage and ensure compliance with database backup strategies

    � Troubleshoot problems as they occur, including weekends, on-call rotation as required

    � Complete administration of SQL Server Replication (transactional, peer-to-peer)

    � Complete administration of SQL Server Clustering, including Always On; additional knowledge of other HA/DR options as asset

    � Creating and deploying Power BI and SSRS dashboards.

    � Manage and maintain service pack updates, cumulative updates and security patches

    Qualifications

    � Bachelor�s Degree in computer science or a related field/equivalent experience

    � Microsoft certifications

    � 5-8+ years of experience in MS SQL Server production support in a mission-critical environment, Microsoft Azure SQL DBs, and AS400 environment

    � Experience in analysis and tuning of T-SQL queries to improve performance, providing baselines and reporting to higher teams on results

    � Experience with backup, restore, and recovery models

    Employee Perks

    � Employee ownership program

    � Employee discount

    � RRSP matching program

    � Competitive group benefits

    � Inclusive work culture

    � Laid back atmosphere

    � Work-life balance

    *Only those selected for an interview will be contacted.

    Job Types: Full-time, Permanent

    Ability to commute/relocate:
  • London, ON: reliably commute or plan to relocate before starting work (required)

    Education:
  • Bachelor's Degree (preferred)

    Experience:
  • Database administration: 5 years (required)
  • MS SQL Server production support: 5 years (preferred)

    Licence/Certification:
  • Microsoft certification (required)

    • Example 4

    Position: Database Administrator

    Location: Remote canada

    Duration: Long Term contract

    Job description:

    At least 8 years of experience as database administrator with at least 4 years on SQL Server.

    This database admin position must have deep knowledge and past work experience in the following

    � SQL server upgrade from 2012 and 2019

    � Data in transit encryption via TLS 1.2

    � Data at rest encryption via SQL 2019 native TDE

    � Performance monitoring & tuning

    The candidate must also have:

    � Strong? Foundational knowledge in database structure, configuration, installation and practices

    � Extensive experience administering Microsoft SQL Server among other major relational database languages and applications

    � Keen attention to detail, a strong customer service orientation and the ability to work as part of a team

    � Ability to manage, monitor and maintain enterprise level databases making requested changes, updates and modifications to database structure and data

    � Capability to enforce database security, integrity, stability and system availability; maintaining database backup and recovery infrastructure

    Job Type: Fixed term to Friday

    Example 5

    As a member of the development team, you will be primarily responsible for designing and developing high quality solutions within our suite of products (Omni CMS, Digarc, Destiny One, Lumens), as well implementing integrations with external systems, such as LMS systems, Banner, Colleague, etc.
    You will work with team members to implement efficient, reusable database schemas and queries as well as optimize existing schemas and queries to improve performance. You will also work with the team to implement integrations with external systems through the maintenance and implementation of stored procedures to interact with external schemas and API's.
    We are looking for the type of person that loves to have their hands in everything and someone who can take on the challenge of working within a growing team with a great deal of responsibility. In this role, you will be given the opportunity to actively contribute to all phases of the development cycle that will take your skills and experience to the next level.
    How you'll make an impact:

  • Act a as subject matter expert across product lines, for the modification and creation of database schemas and queries
  • Analyze database usage patterns to optimize performance for indexes and queries
  • Participate in all phases of the software development lifecycle � requirements, architecture, design, development, testing, deployment.
  • Participate in the project planning process including estimating and process improvements in an Agile environment.
  • Developing new features, enhancing existing features, fixing bugs and upgrading software to maintain tech health
  • Deliver solutions that are highly usable, efficient, secure and scalable.
  • Strive at all times to do work using best practices � through experience or experimentation.

    What you'll need to succeed:

  • The education and experience. You have either a diploma or a degree in Computer Sciences, IT, or related field and/or 5+ years work experience in a development environment.
  • 5+ years of professional experience working with MS SQL Server and Oracle
  • The ability to trouble shoot and optimize database performance issues
  • Knowledge of best practices for database schema and query creation
  • The tech exposure. You have experience with most of the following technologies and infrastructures:
  • MS SQL Server
  • MS SQL Reporting Services
  • Java (JavaEE experience preferred)
  • Coldfusion
  • Tomcat, Apache
  • AWS, Azure and/or Digital Ocean

  • Familiarity with the following systems is an advantage but not necessary:
  • Ellucian Banner
  • Ellucian Colleague
  • Oracle's PeopleSoft

  • Familiarity with project management tools such as Jira and Git
  • A perfectionist streak. You want to be part of a team dedicated to creating and delivering quality software. You define and follow best practices for web design and usability principles.
  • Outstanding communication. You will split your time between heads-down work and team collaboration and innovation. We support each other out loud, working out solutions.
  • Pride. You enjoy your work and getting a job done well. You want to be part of a team that promotes their accomplishments and sees the difference they make.
  • Ownership. You can be counted on to deliver the best solution in collaboration with your team. You take ownership for your work, your tasks, your timelines.
  • Driven. You want to be challenged and you are constantly seeking new opportunities to learn, gain and apply new skills and knowledge.

    What you�ll gain:

  • Competitive compensation
  • Employee benefits including health, dental and vision insurance among others
  • Learning and development opportunities
  • You will make a difference every day for universities trying to grow, and students trying to learn.

    Only qualified candidates selected for an interview will be contacted.
    Company Overview:
    Modern Campus is obsessed with empowering its 1,800+ higher education customers to thrive when radical transformation is required to respond to lower student enrollments and revenue, rising costs, crushing student debt and administrative complexity.
    The Modern Campus engagement platform powers solutions for non-traditional student management, web content management, catalog and curriculum management, student engagement and development, conversational text messaging, career pathways, and campus maps and virtual tours. The result: innovative institutions can create a learner-to-earner lifecycle that engages modern learners for life, while providing modern administrators with the tools needed to streamline workflows and drive high efficiency.
    Learn how Modern Campus is leading the modern learner engagement movement at [website] and follow us on LinkedIn.
    Modern Campus is committed to fair and accessible employment practices and are committed to providing accommodations for persons with disabilities. We will work with all applicants to determine appropriate accommodation for individual accessibility needs.

  • Toronto, ON, Canada
  • Full Type: Full-time

    • 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.

    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

      *Indeed provides this information as a courtesy to users of this site. Please note that we are not your recruiting or legal advisor, we are not responsible for the content of your job descriptions, and none of the information provided herein guarantees performance.