JOB DESCRIPTION
We are looking for a Production DBA to join our growing team. Someone who will be eager to learn about our large, existing database environment, and then help us make it even better. This role requires a proactive, results-focused individual who will troubleshoot issues and execute solutions before anyone notices there is even a problem. The right candidate should have excellent investigation and optimization skills with a proven track record of delivering reliable solutions to complex problems.
We are looking for a team-oriented individual who loves to learn and share their knowledge and expertise with others. Those skills must complement an ability to track down bottlenecks in operational environments and simplify complex functional and technical systems.
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.
Your 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
• We require a person with good English verbal and written communication skills. Those skills must complement an ability to simplify complex functional and technical requirements.
Why you'll love working here
COMPENSATION AND BENEFITS
• 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
We have big expectations for ourselves. We need people like you to help bring out the best in us and we promise to help bring out the best in you. Along the way, we will have fun, be stressed, argue, struggle, overcome, go on adventures, enjoy a few beverages, ponder the meaning of life amongst other things.
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.