Database Administrator Sr

Database Administrator Sr

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.
Location: Work is what you do, not where you go. For this role, we are open to hybrid work in Mauritius
About The Opportunity
The Development DBA will work on the design, development, performance, scalability and deployment architecture of Dayforce HCM, our SaaS application.
What You’ll Get To Do

• Maintain Development and QA environment database servers on-premises and Azure
• Work with development teams to translate requirements into technical specifications; help to identify optimal database design, access strategies, and data integrity constraints
• Help establish data management standards for tools and infrastructure
• Assist in the design and implementation of security, auditing and integrity controls
• Work with the performance team to design, execute, and analyze benchmarks of the system
• Identify and document performance and scalability improvements
• Proactively make recommendations and resolve technical system issues to improve SQL stability and performance
• Benchmark, analyze, report on, and make recommendations for the improvement and growth of the SQL infrastructure, SQL systems and applications
• Provide SQL Server knowledge, solutions and education to the development teams and actively discuss, review, and recommend technical options and activities
• Effectively apply software development methodology and adhere to standards, including change management; maintain database coding standards
• Participate in database-related R&D projects, as needed

Skills And Experience We Value

• At least 3 years of recent experience developing and maintaining mission-critical database environments
• Experience with SQL Server replication, High Availability, and other SQL Server features
• Clear understanding of database design, referential integrity and the application development life cycle
• Experience in large enterprise high transaction OLTP environments
• Experience in Microsoft SQL Server 2016 and higher
• Strong T-SQL and Powershell skills
• Experience with database triaging, tuning and monitoring
• Familiarity with standard change control procedures
• Excellent communication and collaboration skills
• Good planning, time management, and documentation skills
• Willing to work evenings EST occasionally

What would make you really stand out

• Strong troubleshooting and problem solving skills
• Works well individually and as part of a team
• Ability to work with minimal supervision
• Easily adapts to changing priorities
• Able to research database issues and products, and to present ideas in business-appropriate and user-friendly language
• An understanding of programming with C#, Java
• Experience and willing to learn NoSQL databases, such as MongoDB
• Experience with data modeling tools such as Embarcadero, ERwin, or Information Architect