About Company
Are you ready to architect and safeguard the data infrastructure that powers groundbreaking innovation? At Hiring.zycto, we believe in connecting exceptional talent with organizations that are truly pushing boundaries. We’re a leading recruitment firm partnering with a diverse portfolio of clients across high-growth sectors, from advanced analytics to secure financial platforms. For a Senior Database Administrator, this means unparalleled exposure to complex, high-stakes environments where your expertise in data integrity, performance tuning, and system resilience will be critical. Join a community that champions technical excellence and empowers you to make a significant impact on enterprise-level data strategies. We’re an ideal environment for your advanced SQL skills.
Job Description
Hiring.zycto is seeking a highly skilled and experienced Senior Database Administrator specializing in SQL Server to join a dynamic team in Forest Hill, Toronto. This pivotal role involves overseeing the design, implementation, maintenance, and optimization of critical database systems that underpin our clients’ most vital operations. As a Senior DBA, you will be instrumental in ensuring the high availability, performance, and security of all SQL Server instances, working closely with development, operations, and business intelligence teams. You will be expected to leverage your deep technical expertise to proactively identify and resolve complex database issues, contribute to strategic architectural decisions, and champion best practices in database management. This is an exceptional opportunity for a proactive individual with a passion for data and a proven track record in managing robust, high-transactional SQL Server environments. We are looking for someone who thrives on challenges, continuous learning, and making a tangible impact on system reliability and efficiency. Your work will directly influence the success and scalability of various enterprise applications, demanding meticulous attention to detail and a comprehensive understanding of database technologies. If you are a leader in the SQL Server community and are eager to apply your skills in a stimulating environment, we encourage you to apply.
Key Responsibilities
- Design, implement, and maintain highly available and scalable SQL Server database solutions.
- Proactively monitor database performance, identify bottlenecks, and implement effective tuning strategies.
- Develop, test, and maintain robust backup, recovery, and disaster recovery plans for all production databases.
- Manage database security, user access, roles, and permissions in compliance with organizational policies.
- Collaborate with software development teams to optimize database schema design and T-SQL queries.
- Troubleshoot and resolve complex database-related issues, including performance, connectivity, and data integrity problems.
- Implement and manage SQL Server replication, AlwaysOn Availability Groups, and other high-availability features.
- Automate routine database tasks using PowerShell scripting and other relevant tools.
- Provide technical guidance and mentorship to junior database administrators and development staff.
- Stay abreast of emerging database technologies and best practices, evaluating their applicability to our environment.
Required Skills
- Minimum 5 years of hands-on experience as a SQL Server Database Administrator.
- Expert-level proficiency in SQL Server versions 2016, 2019, and 2022.
- Deep understanding of T-SQL programming, query optimization, and execution plans.
- Extensive experience with SQL Server high availability technologies (AlwaysOn Availability Groups, Clustering, Replication).
- Proven ability in database performance monitoring, tuning, and troubleshooting.
- Strong knowledge of database security principles and implementation.
- Proficiency in developing and implementing robust backup and recovery strategies.
- Experience with PowerShell scripting for database automation.
- Excellent analytical, problem-solving, and communication skills.
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Microsoft Certified: Azure Database Administrator Associate or similar certifications.
- Experience with cloud-based database services (Azure SQL Database, AWS RDS for SQL Server).
- Familiarity with other database systems (e.g., Oracle, PostgreSQL, MySQL).
- Experience working in a high-transactional, 24/7 production environment.
- Knowledge of data warehousing concepts and ETL processes (SSIS).
Perks & Benefits
- Competitive annual salary and performance-based bonuses.
- Comprehensive health, dental, and vision insurance plan.
- Generous paid time off, including vacation, sick days, and public holidays.
- Opportunities for professional development, training, and certification reimbursement.
- Employer-matched Retirement Savings Plan (RRSP).
- Collaborative, supportive, and innovative work environment.
- On-site fitness facilities and wellness programs.
- Dynamic company culture with regular team events.
How to Apply
Interested candidates are encouraged to click on the application link below to submit their resume and cover letter directly. Please highlight your relevant experience as a Senior SQL Server Database Administrator. We appreciate all applications, but only those selected for an interview will be contacted.