DBA (Postgre)

A leading organisation in Taiwan is seeking a highly skilled Database Administrator PostgreSQL to join their growing technology team. This role offers you the chance to work with cutting-edge database technologies across both on-premises and cloud environments, including AWS RDS and Aurora.

As a Database Administrator PostgreSQL based in Taiwan, you will be entrusted with managing complex database environments that span both traditional on-premises servers and modern cloud platforms. Your day-to-day activities will involve overseeing the health of PostgreSQL databases, driving migrations from legacy systems to AWS cloud infrastructure with minimal disruption, collaborating with technical teams to architect resilient solutions, analysing performance metrics to fine-tune operations, developing comprehensive disaster recovery plans for business continuity, implementing high availability features for uninterrupted service delivery, leveraging automation tools for efficient maintenance tasks, monitoring security compliance rigorously, and providing expert guidance on best practices. Success in this role requires a blend of technical proficiency in database administration with strong interpersonal skills for effective teamwork.

• Manage and optimise PostgreSQL databases across both on-premises infrastructure and AWS cloud platforms such as Amazon RDS and Aurora, ensuring seamless integration and performance.
• Lead the migration of legacy on-premises databases to AWS cloud services, planning and executing strategies that minimise downtime while maintaining data integrity.
• Collaborate closely with software engineers, architects, and cross-functional teams to design scalable, highly available database solutions tailored to evolving business requirements.
• Monitor database performance using tools like EXPLAIN and pg_stat_statements, identifying bottlenecks and implementing improvements for query execution and index efficiency.
• Conduct deep-dive analyses into system performance issues, refactoring schemas and applying advanced indexing strategies to support high-volume transactional workloads.
• Design robust backup, recovery, and disaster recovery plans that safeguard critical data assets against loss or service disruption in both cloud-based and on-premises settings.
• Implement high availability solutions including PostgreSQL replication (streaming, logical), AWS RDS Multi-AZ deployments, and Aurora replication for continuous uptime.
• Oversee the management of AWS RDS instances by tuning performance, scaling resources appropriately, optimising costs, and maintaining effective backup strategies.
• Utilise AWS-specific monitoring tools such as CloudWatch and CloudTrail to ensure optimal database performance, security compliance, and operational efficiency.
• Enforce best practices for database security by configuring roles, encryption protocols, audit logging mechanisms, and ensuring adherence to industry standards.

What you bring:

To excel as a Database Administrator PostgreSQL in this organisation’s technology team you will bring substantial hands-on experience managing sophisticated database infrastructures spanning both local servers and public cloud platforms. Your background should include deep familiarity with PostgreSQL administration processes from initial setup through ongoing optimisation; practical expertise migrating databases into AWS ecosystems; mastery over replication methodologies ensuring high availability; advanced capabilities tuning queries for peak performance; thorough understanding of backup protocols supporting rapid recovery; adeptness at scripting automation routines; awareness of compliance frameworks governing data protection; fluency using monitoring tools specific to cloud environments; plus outstanding interpersonal skills facilitating productive collaboration across diverse technical groups. Your proven track record delivering reliable solutions underpins your suitability for this impactful position.

• Extensive experience administering PostgreSQL databases including installation procedures, configuration management, troubleshooting techniques, and performance optimisation methods.
• Deep understanding of AWS cloud database services such as RDS, Aurora, DynamoDB with proven ability to set up, scale out resources efficiently, manage cost controls, and maintain secure instances.
• Proficiency in implementing PostgreSQL replication strategies (streaming or logical), clustering configurations for high availability solutions across hybrid environments.
• Expertise in query optimisation using diagnostic tools like EXPLAIN plans or pg_stat_statements along with hands-on experience refactoring schemas for improved scalability.
• Comprehensive knowledge of indexing strategies coupled with advanced data modelling skills suitable for large-scale relational applications handling significant transaction volumes.
• Demonstrated ability designing backup routines including point-in-time recovery options plus disaster recovery plans applicable to both on-premises servers and cloud-hosted databases.
• Strong scripting abilities utilising Python, Bash or Ansible for automating routine maintenance tasks as well as deploying cloud automation workflows for streamlined operations.
• Familiarity with AWS monitoring utilities such as CloudWatch or CloudTrail alongside IAM role configuration for enhanced security posture within managed database environments.
• Solid grasp of regulatory compliance requirements involving encryption standards, RBAC policies implementation plus audit logging practices safeguarding sensitive financial information.
• Excellent communication skills enabling clear presentation of complex technical concepts while fostering collaborative relationships among software engineers or systems administrators.