Dayforce is a global human capital management (HCM) company headquartered in Toronto, Ontario, and Minneapolis, Minnesota, with operations across North America, Europe, Middle East, Africa (EMEA), and the Asia Pacific Japan (APJ) region.
Our award-winning Cloud HCM platform offers a unified solution database and continuous calculation engine, driving efficiency, productivity and compliance for the global workforce.
Our brand promise - Makes Work Life Better™ - Reflects our commitment to employees, customers, partners and communities globally.
Citizenship Requirement
Ability to obtain or currently possess Canadian Protected B security clearance is mandatory.
Must possess 5+ years of residency in Canada.
About The Opportunity
This position provides implementation, administration, support, monitoring and maintenance of the SQL Database environments across multiple cloud environments. The candidate will be joining the Cloud Database Engineering team being responsible for timely resolution of issues that impact database server usability, making sure systems are sized, built, and configured for optimal operation.
What You'll Get To Do
- Provide administration and support for mission critical and pre-production database environments
- Design and implementation of Azure cloud databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
- Migration of on-premises database to the Azure Cloud using SQL on VM, SQL MI and Azure SQL Database
- Perform and manage daily database maintenance, monitoring and performance tuning tasks
- Provide technical leadership through example, develop innovation, strategies, processes, and best practices
- Responsible for database disaster recovery of all database environments which includes managing and supporting SQL backup policies
- Identify and document performance and scaling improvements for development teams
- Assist in the design and implementation of security, auditing and integrity controls
- Benchmark, analyze, report on, and make recommendations for the improvement and growth of the SQL transactional replication infrastructure
- Provide guidance to Jr level DBAs
- Provide 24x7 on-call administration and support
Skills And Experience We Value
- At least 5+ years of recent experience maintaining and administrating mission-critical database environments
- Large enterprise production environments with high transaction volume
- SQL Server 2017, 2019 and 2022
- Cloud database solutions including SQL on VM, SQL managed instance, Azure SQL Database
- NoSQL database technologies such as MongoDb and CosmosDb
- Data streaming and caching technologies such as Kafka and Redis
- PowerShell and Azure CLI
- Automation of processes to improve efficiency
- Database triaging, tuning and monitoring
- Database design and application development life cycle
- Expert in troubleshooting, problem solving and initiative
- Excellent planning, time management, documentation skills
- Expert in T-SQL, SQL Profiler and PowerShell skills
- Expert in SQL monitoring tools SQL Sentry and DBA Dash
- Experience in managing Human Capital Management SaaS database systems
- Easily adapts to changing priorities
- Effective communication with distributed team members
- Works well individually and within a team
- Ability to conduct research into database issues and products and present ideas in a business-appropriate and user-friendly language.
What’s In It For You
Dayforce is fueled by the diversity of our talented employees. We are an equal opportunity employer and consider and embrace ALL individuals and what makes them unique. We believe our employees should be happy and healthy, with peace of mind and a sense of fulfillment.
We encourage individuals to apply based on their passions.
Dayforce encourages personal and professional growth. We offer excellent time away from work programs, comprehensive wellness initiatives and recognition through competitive pay and benefits.
With a commitment to community impact, including volunteer days and our charity, Dayforce Cares we provide opportunities for you to thrive both in your career and personal life. Our focus is not just on your job but on supporting you to be the best version of yourself.
About The Salary Ranges
Please note that the salary range mentioned in this job description should serve simply as a guide. The final compensation offered may vary based on a variety of factors, including bonuses and/or incentives, or a candidate’s experience, skills, budget and location. Our company is committed to providing a fair, equitable, and competitive package that reflects the value an individual brings to the organization.
Proficiency in English is required for this position as this role will regularly interact with English-speaking stakeholders, co-workers, managers and/or clients across the world. Further, our back office support teams, including but not limited to Human Resources, are primarily English speaking. Employees need to be able to communicate with these departments in English to appropriately administer their business relationship. Due to the significant high volume of interactions with these English-speaking co-workers, managers, stakeholders and/or clients, which is inherent to this position, it is not possible to reorganize the company's activities to avoid this requirement.
Fraudulent Recruiting
Beware of fraudulent recruiting. Legitimate Dayforce contacts will use an @dayforce.com email address. We do not request money, checks, equipment orders, or sensitive personal data during the recruitment process. If you have been asked for any of the above, or believe you have been contacted by someone posing as a Dayforce employee, please refer to our fraudulent recruiting statement found here: https://www.dayforce.com/be-aware-of-recruiting-fraud
