About us:
Arrise Solutions India Pvt. Ltd. (powering PragmaticPlay) is a leading content provider to the iGaming and Betting Industry, offering a multi-product portfolio that is innovative, regulated and mobile-focused. Pragmatic Play strives to create the most engaging and evocative experience for customers globally across a range of products, including slots, live casino, sports betting, virtual sports and bingo.
KEY RESPONSIBILITIES
- Design, implement, and maintain SQL Server databases to ensure reliability, efficiency, and security.
- Perform database tuning, optimization, and capacity planning to meet evolving business needs.
- Monitor and manage database performance, resolving issues and ensuring high availability and uptime.
- Collaborate with development teams to optimize SQL queries and schema designs for improved performance.
- Perform database upgrades, migrations, and patches while minimizing downtime and risk.
- Create and maintain documentation, including database standards, procedures, and configurations.
- Provide guidance and mentorship to team members and collaborate with other Game Server teams as needed.
KEY SKILLS
- 5-8 years MS SQL Server Administration experience required.
- Work experience in handling high volume database (say roughly 5TB minimum) in transactional replication environment (publisher, distributor, subscriber) OR Always On with hand on Index Management.
- Proficiency in performance tuning, query optimization, and troubleshooting database issues.
- Expert on high availability (HA) and disaster recovery (DR) options for SQL Server.
- Experience with database backup and recovery, and disaster recovery planning.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Expertise in implementing security measures, managing user access, permissions, and roles.
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Assist developers with complex query tuning and schema refinement.
- Provide 24x7 support for critical production systems.
- Deep understanding of SQL Server internals - How data is physically organized, what are indexes, statistics, bad cardinality, data skew, tables refactoring etc.
- Ability to understand execution plans (all join types, spools, scans etc.) quickly find source of problem and come up with a solution.
What we offer
- Professional and personal development
- Opportunities to progress within a dynamic team.
- Close and collaborative colleagues
Our Values
- PERSISTENCE We never give up and are determined to be the best at what we do.
- RESPECT We value and respect our clients, their players, and our team members; promoting professionalism, integrity and fairness without compromise.
- OWNERSHIP We take ownership of our work and consistently deliver in a reliable manner; always providing the highest level of quality.