
Senior Database Consultant, PostgreSQL
Posted 1 day ago

Posted 1 day ago
This is a fully remote position, open to applicants in Indonesia.
• Deliver technical support for EnterpriseDB PostgreSQL to clients both on-site and remotely.
• Gain insights into customers’ sectors and develop tailored technical recommendations.
• Establish database deployment architecture and set up effective database solutions.
• Evaluate current Postgres installations and relevant tools, providing documented technical recommendations.
• Collect and document enterprise-wide database needs by engaging with client stakeholders.
• Prepare professional service proposals that align with the goals and objectives of customers.
• Assist clients in creating custom applications based on Postgres.
• Resolve database issues, including performance-related challenges.
• Facilitate the migration of databases from Oracle, SQL Server, and/or MySQL to PostgreSQL.
• Optimize performance for current database setups.
• Support clients in upgrading applications to the latest Postgres version and configuring them to utilize new features.
• Design and implement high-availability configurations for PostgreSQL.
• Assess customer security requirements and provide recommendations accordingly.
• Maintain documentation in runbooks and client communications.
• Develop backup strategies, and execute upgrades and patching.
• Formulate data migration strategies for large databases while accommodating customer downtime limits.
• Apply advanced database monitoring techniques and set up alerts based on industry best practices and tools.
• Collaborate with product engineering teams on future product development.
• Offer insights to sales and sales engineering teams regarding potential new business opportunities.
• Engage in moderate travel, approximately 30–40% of the time.
• Over 8 years of experience working in a professional consulting organization focused on databases, with a strong foundational knowledge.
• More than 5 years of direct experience with PostgreSQL and Oracle databases.
• Proficient in implementing PostgreSQL databases for high availability in large enterprise settings.
• Familiar with database design and application development for PostgreSQL, Oracle, or similar databases.
• In-depth knowledge of general system administration and performance tuning for Linux (Ubuntu, CentOS, Red Hat, or Debian), including troubleshooting and scripting abilities.
• Well-versed in SQL and Microsoft Windows environments.
• Strong time management skills, capable of managing multiple projects simultaneously.
• Bachelor’s or master’s degree in computer science/engineering or equivalent experience.
• Willingness to travel about 30–40% of the time.
• Excellent written and verbal communication skills in both English and Bahasa.
• Outstanding troubleshooting capabilities.
• Proficient with PostgreSQL community version and EDB’s PostgreSQL.
• Familiar with EDB tools.
• Skilled in database tuning and PostgreSQL tools such as PgBadger, PEM, and BARMAN.
• Knowledgeable in PostgreSQL replication technologies: Streaming, Logical, and Bidirectional.
• Understanding of PostgreSQL architecture.
• Competent in PostgreSQL networking, HBA, and connection pooling (PgBouncer, PgPool).
• Working knowledge of OLTP/DSS/DW system design.
• Proficient in scripting languages such as BASH, KSH, Python, and Perl.
• Experience in deploying open-source software.
• Background in collaborating with virtual teams and working from remote office settings.
• Access to CuraLinc for health and wellness resources and practices.
• Wellness Fridays available until December 2026.
• Region-specific benefits (details can be obtained through the career site and Talent Acquisition team).
ERPA
Argano
BerryDunn — Assurance, Tax and Consulting
Internova Travel Group
Get handpicked remote jobs straight to your inbox weekly.