About InteliSys

Production DBA

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

 Compensation and Benefits