Senior SQL Database Administrator

Advantages
You will have an opportunity to work with a leading employer in the local market.


Responsibilities
• Support of the PEGA Application Development Platform


• Support for database workload in AWS Cloud


• Providing SQL expertise as a shared resource to Agile projects


• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of difficult SQL issues


• Administrative support of SQL Server versions 2012, 2014, 2016, 2019 including: Database Engine, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)


• Support of application and database upgrades from existing SQL versions to SQL2016, SQL2019 and future supported releases


• Migration of database objects from development through production following documented standards, policies and procedures (Change Management Process)


• Maintaining up-to-date documentation and procedures for all supported applications and environments


• Organizing and monitoring personal workload and escalating to manager when issues arise


• Ensuring the proper setup and validation of backup and restore processes


• Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises


• Regular database capacity planning related to database growth and system utilization; trend analysis


• Working closely with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services


• Support of PowerShell, T-SQL stored procedures and functions to support internal processes and improve system performance (if applicable)


• Managing medium to large projects and participating in a variety of projects through the entire project lifecycle (if applicable)


• Assisting clients with various issues related to connectivity, permissions, access


• Evaluation of functionality and features with newer versions of the SQL Server DBMS as part of a readiness program


Qualifications
• BE / B Tech /MCA / M Tech / Proven administration/analyst skills preferably with a degree in Computer Science or related technology degree/diploma, or equivalent experience


• At least 5 to 7 years of SQL Server database administration experience handling medium to large databases


• Excellent verbal and written communication skills


• Experience with AWS Cloud technologies


• Experience with the Microsoft BI stack


• Experience with on-call support and trouble-shooting


• Strong T-SQL skills that include a thorough understanding of system tables, stored procedures, functions, triggers, and SQL tuning


• Hands-on experience with SQL Server installations and patching


• Strong organizational skills with the ability to handle several tasks efficiently

Nice to Have:

• SQL Server Certification an asset


Summary
Do you have this experience? If you answer YES, then please apply IMMEDIATELY to so we can then discuss your experience and interest in this opportunity!

Randstad Technologies Group

Canada's largest provider of IT Staffing Solutions, offering hundreds of permanent and contract opportunities across all roles, levels and platforms. Our Web-based tools help you see and apply for jobs matched automatically to your skills and preferences. When you're ready to interview we meet with you in person to help you build the technology career path you've always wanted. Visit www.randstad.ca to get started!


Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.