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.
2. 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.
3. 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.
4. Performance Tuning Optimization:
Analyze and optimize database performance, including query tuning, indexing, and partitioning.
Proactively identify bottlenecks and implement solutions for high-performance applications.
5. 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.
6. 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.
7. 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.
8. 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.
9. 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.
10. 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.
Qualifications skills required
Experience: Ideal experience range. 8-12 years
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).
Be a part of Junglee Games to:
Value Customers Data - Prioritize customers, use data-driven decisions, master KPIs, and leverage ideation and A/B testing to drive impactful outcomes.
Inspire Extreme Ownership - We embrace ownership, collaborate effectively, and take pride in every detail to ensure every game becomes a smashing success.
Lead with Love - We reject micromanagement and fear, fostering open dialogue, mutual growth, and a fearless yet responsible work ethic.
Embrace change - Change drives progress and our strength lies in adapting swiftly and recognizing when to evolve to stay ahead.
Play the Big Game - We think big, challenge norms, and innovate boldly, driving impactful results through fresh ideas and inventive problem-solving.
Avail a comprehensive benefits package that includes paid gift coupons, fitness plans, gadget allowances, fuel costs, family healthcare, and much more.