Snr Database Administrator to provide in-depth operational support and participate in the architecture, deployment, and management of on-prem and cloud-based databases, systems, and services
Job Type: Permanent
Positions to fill: 1
Start Date: Aug 21, 2023
Job End Date: Aug 21, 2023
Pay Rate: Salary: Negotiable
Job ID: 132016
Location: Ottawa
Our valued client is looking for a Snr Database Administrator providing in-depth operational support and participate in the architecture, deployment, and management of on-prem and cloud-based databases, systems, and services
Permanent opportunity, hybrid in Ottawa (approx. 1 day a week on site)
Responsibilities:
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 unauthorized 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, 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
- Escalate to and work with external suppliers and service providers as needed
- Introduce solutions to eliminate issues and drive continuous service performance improvements
- Work outside of business hours and in the weekends as needed
Must Have Skills:
- 8+ years experience as a Database Administrator building, configuring, managing, monitoring, optimizing, tuning, and supporting mission critical, highly available databases, servers, clusters and environments
- Experience with the following systems, tools, and technologies:
- MS SQL server, Azure SQL services, Windows server, PowerShell scripting, TSQL, SSMS, SSRS and SSIS
- T-SQL scripting knowledge
- MS Windows Server (OS, AD, IIS, FS, DNS, DHCP, PowerShell)
- Database management tools, load balancing, clustering, and replication
- Experience managing public cloud-based environments (Azure and AWS)
Nice to Have Skills:
- Experience in data security and protection including backup, encryption, high availability, and disaster recover
- Experience in capacity and performance management
- Experience with LAMP stack configuration, support and troubleshooting
- .NET framework, JAVA, XML
- Networking and routing LAN/WAN/VLAN/VPN and TCP/IP/HTTPS protocols