Description
- 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.
Requirements
- 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.
