Note: The job is a remote job and is open to candidates in USA. Dayforce is a global human capital management (HCM) company headquartered in Toronto and Minneapolis. The position involves implementation, administration, support, monitoring, and maintenance of SQL Database environments across multiple cloud environments, ensuring optimal operation and timely resolution of issues.
Responsibilities
- 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
- Candidate should be a US citizen or lawful permanent residents (Green card holder, permanent resident or naturalized citizen)
- Must be able to obtain a US security clearance
- At least 8+ years of recent experience maintaining and administrating mission-critical database environments
- Large enterprise production environments with high transaction volume
- SQL Server 2017, 2019, 2022 and 2025
- 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
Benefits
- Dayforce employees and their families are eligible to participate in the following benefits programs: medical, dental, vison, and life insurance.
- Dayforce employees are also eligible to participate in a 401k plan (plus match) and a Global Employee Stock Purchase Plan.
- Employees also receive unlimited Time Away From Work (in lieu of accrued vacation time), 10 paid US holidays, up to 80 hours of paid sick time and 17 weeks of paid parental leave, subject to the terms of the applicable policy or program.
- 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.
Company Overview