Skip to content

Database Administrator

Function

The Database Administrator will provide first and second levels of support, participate in the architecture, deployment, management, and support of highly available on-prem and cloud-based mission-critical infrastructure, databases, systems, applications, and web services to deliver exceptional service quality and meet service level agreements.

Core Competencies:

  • Troubleshooting, analysis, and problem-solving
  • Team orientated
  • Results driven
  • Decision making
  • Communication and interpersonal skills

Position Accountabilities:

Database and System Administration

  • Provide in-depth operational support and participate in the architecture, deployment, and management of on-prem and cloud-based databases, systems, and services in a fast-paced, rapidly growing, geographically distributed environment
  • Design, create, tune, test and debug databases, instances and database objects and processes, including schemas, queries, indexes, stored procedures, data loading, mirroring, and replication
  • Support the application development teams in the creation and debugging of complex SQL queries and other programming constructs
  • Install server software, configure database servers and database instances, monitor, and maintain database and system health and security, manage DB users’ accounts, permissions, and security levels
  • Create, implement, validate, and continuously improve data protection and recovery processes and procedures, including backup, failover, and disaster recovery
  • Recommend, document, and implement database and system standards, management and maintenance policies and standard operational procedures

Service Delivery

  • Proactive regular monitoring and reporting on the health and availability, capacity, security, usage, and performance of the services
  • Minimize database and systems downtime, maintain, and improve query performance, optimizes parameters; implement changes and new releases; perform regular maintenance and update and upgrade database servers and operating systems when required
  • Plan, implement and regularly audit the environment to ensure data security, privacy, and integrity and to prevent unauthorised access and misuse of the data
  • Introduce, support, and enhance automation and continuous delivery and ensure that standards and best practices are followed
  • Implement and enhance database and systems monitoring, alerting and event management
  • Work very closely with the IT operations and application development teams to support and improve service delivery
  • Work closely with the scrum and service management teams to support application release and deployment initiatives
  • Create, update, and maintain documentation as needed.

Service Support

  • Support the IT Operations and Application development teams, assume ownership and respond to service requests, incidents, and problems
  • Perform root cause analysis and implement preventative measures to maintain service performance
  • Take corrective actions for alerts and events or escalate as appropriate
  • Escalate to and work with external suppliers and service providers as needed
  • Introduce solutions to eliminate issues and drive continuous service performance improvements
  • Research and advise on new tools and technologies and contribute to the continuous improvement of the environment
  • Work outside of business hours and on the weekends as needed

Qualifications and Skills

  • Proven experience in building, configuring, managing, monitoring, optimizing, tuning, and supporting mission-critical, highly available databases, servers, clusters and environments
  • Strong understanding and experience in capacity and performance management
  • Strong understanding and experience in data security and protection including backup, encryption, high availability, and disaster recovery
  • A mindset towards integration, automation, and continuous improvement
  • Data modelling and database design
  • Performance management and tuning
  • SQL code reviews and walk-thru(s)
  • High competence in the following systems, tools, and technologies:
    1. MS SQL server, Azure SQL services, Windows server, PowerShell scripting, TSQL, SSMS, SSRS and SSIS
    2. Strong T-SQL scripting knowledge
    3. MS Windows Server (OS, AD, IIS, FS, DNS, DHCP, PowerShell)
    4. Database management tools, load balancing, clustering, and replication
    5. LAMP stack configuration, support and troubleshooting considered an asset
    6. .NET framework, JAVA, XML considered an asset
    7. Networking and routing LAN/WAN/VLAN/VPN and TCP/IP/HTTPS protocols considered an asset
    8. Hands-on experience managing public cloud-based environments (Azure and AWS)

Education, Certifications and Experience Requirements:

  • 8+ years of relevant work experience in a large-scale environment.
  • University degree in computer science or a related field or equivalent experience
  • Professional certifications in database and administration are considered an asset
  • ITIL certification is considered an asset

Apply Now

We thank all applicants for their interest, however only those under consideration for the role will be contacted.

Apply now

At CREA, we are committed to fostering an inclusive, barrier-free and accessible environment. Part of this commitment includes arranging accommodations to ensure an equitable opportunity to participate in the recruitment and selection process. If you require an accommodation, we will work with you to meet your needs.