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:
- MS SQL server, Azure SQL services, Windows server, PowerShell scripting, TSQL, SSMS, SSRS and SSIS
- Strong T-SQL scripting knowledge
- MS Windows Server (OS, AD, IIS, FS, DNS, DHCP, PowerShell)
- Database management tools, load balancing, clustering, and replication
- LAMP stack configuration, support and troubleshooting considered an asset
- .NET framework, JAVA, XML considered an asset
- Networking and routing LAN/WAN/VLAN/VPN and TCP/IP/HTTPS protocols considered an asset
- 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