Production DBA (Database Administrator)

freeC's Client

*** 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

• Highly paid and competitive salary package, 13th month salary.
• Potential bonuses based on both company and individual performances
• 12 days of annual leave and 05 days of sick leave
• Healthcare, parking, telephone, bank allowances provided
• 100 USD for annual health-check
• Annual gift on your work anniversary
• Professional growth with individual career path
• Opportunity to work on-site in Canada
• Flexible working time
• Regular company sponsored outings and trips
• Stable international working environment with transparency and work-life balance