SQL Server DBA

Job Description

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.