*** Duties and Responsibilities
- Administer and monitor existing production databases and servers to ensure stability and reliability, addressing any issues that arise.
- Design, build and maintain database environments, schemas, and stored procedures to enable the delivery of valuable solutions to customers that meet goals for security, scalability, maintainability, availability, and resiliency.
- Build, deploy, and maintain data collection and monitoring tools across environments to understand the root causes of instability and high-cost infrastructure components.
- Learn and analyze new technologies and industry best practices to identify suitability for adoption by the company.
- Develop reusable patterns and encourage innovation that will increase overall team velocity.
- Demonstrate understanding of common software technologies and development practices/tools, including cloud environments, source control, remote development, issue tracking, and build/deployment automation.
*** Skills and Experience
- A Bachelor’s Degree (or equivalent training/experience) in Software/Computer/Database Engineering
- Strong hands-on experience working in production environments for administration, monitoring, and tuning of database servers
- 3+ years of technical experience with all aspects of the Microsoft SQL Server platform, including:
+ Performance Optimization of Query Plans
+ Backup Procedures and Disaster Recovery
+ Data Management Procedures (Archive, Purge, SSIS/ETL)
+ Reporting Services (SSRS)
+ Replication
+ Stored Procedure Development using T-SQL
- Experience with scripting languages such as Powershell for automation of monitoring/deployment tasks
- Demonstrated success in improving stability and reducing costs in a production database environment
- Experience working in a Continuous Integration/Delivery/Deployment environment and familiarity with DevOps practices
- Experience using Git for version control of database development files
- Experience with Analysis/Business Intelligence tools (SSAS, PowerBI) and other database platforms is an asset