Production DBA (Database Administrator)

• 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.

• 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