Support Engineer with PostgreSQL DBA/Data Reliability Engineer II

We are seeking a skilled PostgreSQL DBA/Data Reliability Engineer II to join our team. In this role, you will be responsible for ensuring the performance, availability, and reliability of our PostgreSQL RDS instances and associated data pipelines. You will work closely with development teams to optimise database performance and contribute to the overall data strategy of the organization. WHAT YOU’LL DO: Proactively monitor PostgreSQL RDS instances for performance, availability, and resource utilization (CPU, memory, storage, connections) using established monitoring tools (e.g., CloudWatch, Prometheus, Grafana, Kibana). Identify performance bottlenecks in PostgreSQL RDS and apply basic performance tuning techniques, including reviewing query execution plans, adding missing indexes, and recommending parameter adjustments. Monitor the health and performance of Debezium and Kafka Connect connectors, troubleshooting basic issues related to data capture and delivery. Oversee the execution of Apache Airflow DAGs, identify failed tasks, and manage troubleshooting and re-runs. Develop and maintain automation scripts and infrastructure as code (IAC) templates (e.g., using Crossplane, Terraform) to automate routine database tasks, deployments, and updates. Participate in on-call rotations to respond to database-related incidents and perform troubleshooting and root cause analysis. Implement and maintain security best practices for cloud databases, including access controls, encryption, and compliance with regulatory requirements. Regularly audit and assess database security configurations. Configure and manage database backup and recovery strategies to ensure data integrity and availability in case of failures or data loss. Analyze database query performance and collaborate with developers to optimize SQL queries and schemas. Participate in continuous improvement initiatives to enhance the reliability, scalability, and performance of cloud databases. Assist in the design and optimization of database schemas for cloud environments. Monitor ETL workflows and data pipelines for errors, performance bottlenecks, and processing delays, troubleshooting and resolving issues to ensure reliable and timely data movement. Provide support for data-related issues and participate in root cause analysis

Extensive experience in SQL, PostgreSQL architecture, schema/object management, performance tuning, backup, and recovery. Basic understanding of AWS Cloud, including AWS IaaS and AWS Redshift. Familiarity with data pipeline concepts and technologies such as Debezium, Kafka Connect, and ETL Development. Strong SQL scripting skills for querying and basic data manipulation. Knowledge of database security best practices, including access controls, encryption, and compliance with Data Privacy Laws Compliance PREFERRED SKILLS: Exposure to Spark for data processing. Basic understanding of Airflow for workflow orchestration. Familiarity with scripting languages (e.g., Python, Bash) is a plus. AWS Certified Database - Specialty certification is a plus. Expertise You’ll Bring: Bachelor’s degree in Computer Science, Information Technology, or a related field. 5-8 years of experience in database administration, with a focus on PostgreSQL. 2-4 years of hands-on experience with PostgreSQL RDS