Database analyst Jobs in Oakville, ON

Role: Global SQL Database Administrator

Location: Mississauga

Our client is a market leader in the manufacturing of roofing and building materials. They are a Canadian owned and operated business with production facilities worldwide and has many years of unparalleled success in the roofing materials industry. Quality, integrity, and trustworthiness are the values that underlie this success, and we have built this company by hiring people who hold these values. People like you!

Job Description The Global SQL Database Administrator will support both operational and project related activities and maintain defined IT standards at all global locations. The scope includes designing, developing, installing, monitoring, maintaining, and performance-tuning of all MS SQL/Oracle databases while ensuring high levels of data availability. Incumbent will apply excellent communication, problem-solving, change management, and database skills to ensure the Database and related operations are accurate, up-to-date, available, secure, and performing as the business requires.

WHEN YOU JOIN US YOU WILL BE;

• Monitor and maintain database server and database health
• Database user administration - create/modify/delete
• Implement and maintain database backups and restores
• Optimize server and database settings for better performance
• Install database software and configure database servers
• Implement changes and apply new patches and versions when required
• Maintain High Availability Database Environments
• Provide 1st/2nd level support for issues
• Implement and maintain agent jobs
• Participate in projects as required
• Available to work after hours as needed for high impact incidents and project cutover activities
• Develop and maintain Disaster Recovery Procedures and participate in DR testing
• Participate in any Database Security Audits
• Work collaboratively with Developers
• Closely adheres to defined Global IT Service Management processes (when published) – change management, incident management, problem management, service level management, knowledge management and request fulfillment processes
• Additional duties as assigned by the Senior Database Administrator

OUR IDEAL CANDIDATE;

• Bachelor's Degree in Computer Science or Computer Engineering
• 2-5 Years Professional Experience including technical support
• Certification one or more RDBMS technologies: MS SQL, Oracle
• Experience with SQL Always-On and SQL Migrations
• Strong SQL programming and tuning skills
• Familiarity with SSIS, SSAS, SSRS
• Excellent Problem Solving Skills
• Understanding of disaster recovery and database backup procedures
• Ability to multi-task and work independently with minimal supervision and assistance
• Excellent knowledge of English. Knowledge of French or the ability to develop French – for roles based in Belgium.
• Additional Skills : SQL and P/L SQL
• Experience with Windows Server and/or Oracle Linux/Redhat Linux
• Experience with Oracle ASM/RAC/Dataguard/RMAN
• Solarwinds Database Performance Analyzer (DPA) or other Performance Monitoring Tools
• Oracle Enterprise Monitoring/Cloud Control
• Basic Knowledge of other databases such as MySQL, Postgres maybe an asset
• ITIL Certification
• WORK AUTHORIZATIONS AND TRAVEL; Some travel may be required to supported global locations (5%-20%)
• WHAT’S IN IT FOR YOU? Competitive compensation/pay package
• Dental/Vision/Medical benefits
• Life Insurance
• Health Spending Account
• Employee Support and Mental Wellness
• Competitive matched retirement savings program – RRSP
• Be part of a long standing and stable industry leader
• WORK AUTHORIZATIONS AND TRAVEL;Travel within North America and to Europe locations may be required
• #LI-AH1
• Benefits of Employment: Our client recognizes that its success is due to the strength of its employees. A primary goal is to promote individual employee's sense of accomplishment and contribution so that employees enjoy their association with them. The Company invests in its employees so that they are the most knowledgeable in the industry, and undertakes great efforts to nurture loyalty to, and teamwork. They are pleased to offer competitive compensation, health care, a progressive and challenging workplace and a commitment to teamwork and integrity.
• Diversity and Equal Opportunity Employment: They are an equal opportunity employer. They are committed to diversity and inclusion and are pleased to consider all qualified applicants for employment without consideration to race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, veteran status or disability. They encourage and welcome applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

Job 66347