Staff Database Engineer

Description: We are Asia’s fastest-growing skill-based gaming company and partner brand of Flutter which is a multi-billion dollar global gaming organization. We are focused on providing our customers with the most innovative and exciting gaming experience possible. Our success has been driven by our commitment to excellence, our passion for gaming, and our ability to continuously innovate. We are driven by our strong value system, which encompasses an obsession with data, a hustler’s attitude, an owner's mindset, leading with love, and embracing change. Key Responsibilities: Database Administration: • Manage, monitor, and optimize PostgreSQL databases to ensure high availability and performance. • Perform version upgrades and handle migrations for PostgreSQL databases in production and non-production environments. • Configure, upgrade, and troubleshoot database clusters, ensuring minimal downtime. • Perform regular backups, disaster recovery planning, and data restoration tasks. High Availability & Failover Management: • Design and implement high-availability solutions using tools like Patroni for PostgreSQL. • Manage and optimize failover mechanisms to ensure minimal downtime and data integrity during outages. • Troubleshoot and resolve cluster-related issues, ensuring continuous database availability. • Expertise in AWS Aurora RDS for PostgreSQL, including configuring, monitoring, and optimizing managed database clusters. Upgrade and Migration Expertise: • Plan, test, and execute PostgreSQL version upgrades while ensuring application compatibility and minimal disruption. • Lead database migrations from on-premises systems to the cloud (e.g., AWS Aurora, AWS RDS). • Perform migrations from other database platforms (e.g., SQL Server, MySQL) to PostgreSQL when required. • Automate upgrade and migration processes using scripts and tools to improve efficiency and reduce risks. Performance Tuning & Optimization: • Analyze and optimize database performance, including query tuning, indexing, and partitioning. • Proactively identify bottlenecks and implement solutions for high-performance applications. Database Security & Compliance: • Implement and maintain database security policies, encryption, and access controls. • Enforce role-based access control (RBAC) for database users to ensure secure and compliant data access. • Ensure compliance with data protection regulations and organizational standards. Data Engineering Solutions: • Design and support data pipelines for data lakes , ensuring efficient ingestion, transformation, and storage of large-scale data. • Develop and implement archiving strategies for historical and infrequently accessed data, optimizing storage and costs. • Collaborate with data engineering teams to integrate database solutions with data lakes and analytics platforms. Exposure to Other Database Technologies: • Manage and support additional database systems like MongoDB, Cassandra, and Redis. • Design and implement solutions for NoSQL and distributed data storage needs. • Leverage multi-database knowledge to suggest the right database solutions for different use cases. Automation & Scripting: • Develop scripts for database monitoring, failover automation, upgrade and migration processes, and other recurring tasks. • Implement Infrastructure-as-Code (IaC) tools to manage database environments. Incident Management & Troubleshooting: • Respond promptly to database incidents, including cluster failures, failover events, and upgrade-related issues. • Perform root cause analysis and implement long-term fixes for cluster and database-related problems. Collaboration & Leadership: • Work closely with developers, DevOps, and data engineering teams to design and implement efficient database architectures. • Mentor junior DBAs and provide guidance on best practices for database management, high availability, and migrations. Technical Skills: • In-depth knowledge of PostgreSQL architecture, replication, clustering, and failover strategies. • Strong understanding of SQL, PL/pgSQL, and query optimization. • Expertise in PostgreSQL upgrades and migrations, including in-place and out-of-place upgrades. • Familiarity with tools like pgAdmin, pgBouncer, Patroni, and AWS RDS/Aurora consoles. • Proficiency in managing NoSQL databases and understanding their data models. • Experience with database monitoring tools like Grafana, Prometheus, or CloudWatch. • Knowledge of scripting languages (Python, Bash, or Perl) and automation frameworks. • Expertise in implementing RBAC for database systems and managing secure access. • Understanding of big data technologies and integration with data lakes (e.g., AWS S3, Data Lake). Requirements: 7 to 9 years of experience and expertise in PostgreSQL. About Junglee Games Junglee Games is a leader in the skill-gaming space, with more than 100 million users. Founded in San Francisco in 2012, and part of the $30 Bn Flutter Entertainment Group, Junglee Games is the fastest-growing skill-gaming company in the world. Some of our notable games are Junglee Rummy, Howzat, Eatme.io, Carron Stars and Solitaire Gold. Our mission is to build entertainment for millions of people around the world and connect people through high-quality games. Since we were founded, we've drawn 700 of the world’s most talented people into our ranks. Our team has worked on international AAA titles like Transformers, Star Wars: The Old Republic, Real Steel, Rio, Mech Conquest, and Dueling Blades. Our designers have worked on some of Hollywood’s biggest hits including the movie Avatar. Junglee is not just a gaming business - it is a blend of data science, innovation, cutting-edge technology and, most importantly, a values-driven culture that is creating the next set of conscious leaders. Junglee Games is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.