Principal DBA at Amartha

Sorong, Southwest Papua, Indonesia -

Full Time

Start Date

Immediate

Expiry Date

29 Jan, 26

Salary

0.0

Posted On

31 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

PostgreSQL, Database Management, SQL Optimization, Monitoring Systems, CI/CD Pipelines, Cloud Platforms, Data Security, Technical Problem-Solving, Database Maintenance, Capacity Planning, Automation, Mentoring, Communication, Performance Tuning, Operational Issues, Reindexing

Industry

Financial Services

Description

Amartha is embarking on an exciting new journey and is seeking experienced engineers to collaborate with senior management, existing engineers, and product teams to shape the next wave of innovative product offerings. Our goal is to ensure Amartha leapfrogs into the next phase of its journey! We are looking for candidates with strong communication skills who can actively participate in discussions, bridge the gap between product and technology, and coach, mentor, and guide junior engineers in best practices and technical problem-solving. As a DBA, you will be responsible for designing, implementing, administering, and monitoring data management systems while ensuring their design, consistency, quality, and security. Responsibilities Serve as an individual contributor for all database-related activities. Monitor and ensure the uptime and availability of all production databases. Estimate PostgreSQL database capacities and develop methods for monitoring database usage and capacity. Lead efforts to create and enhance automated monitoring and proactive intervention procedures, minimizing downtime. Participate in the creation and migration of development, staging, and production database instances. Conduct SQL code reviews for developers to ensure queries are optimized and tuned for efficiency before production deployment. Perform regular database maintenance tasks, including vacuuming, reindexing, and archiving. Proactively address database operational issues to ensure smooth performance. Optimize query performance and perform preventative maintenance. Having at least 6-10 years of relevant industry experience. Proven experience with PostgreSQL, including both VM-based and managed platforms on Google Cloud Platform (GCP) and Amazon Web Services (AWS). Experience managing multiple databases and working with datastream technologies. Hands-on experience with CI/CD pipelines for automated deployment and integration. Proficiency in monitoring and alerting systems management, ensuring system reliability and quick issue resolution.

Responsibilities

As a Principal DBA, you will design, implement, administer, and monitor data management systems. You will also ensure the uptime and availability of production databases and lead efforts to enhance automated monitoring procedures.