PostgreSQL DBAData Reliability Engineer

Role : PostgreSQL DBA/Data Reliability Engineer
Location : Basking ridge NJ (Hybrid/ Only local)
Contract

As a PostgreSQL DBA/Data Reliability Engineer II

Responsibilities:

• 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).
• Assist in identifying performance bottlenecks in PostgreSQL RDS. Apply basic performance tuning techniques like reviewing query execution plans adding missing indexes and recommending parameter adjustments.
• Monitor the health and performance of Debezium and Kafka Connect connectors identifying and troubleshooting basic issues related to data capture and delivery.
• Monitor the execution of Apache Airflow DAGs identify failed tasks and 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.
• Assist in implementing and maintaining 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.
• Analyse 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. Troubleshoot and resolve issues to ensure reliable and timely data movement.
• Provide support for data related issues and participate in root cause analysis.

Skills:

• Extensive experience in SQL PostgreSQL Architecture Schema/Object management Performance tuning back up and recovery.
• Basic understanding of AWS Cloud Amazon Redshift and S3.
• Familiarity with data pipeline concepts and technologies such as Debezium Kafka Connect and ETL frameworks.
• Exposure to Apache Spark for data processing.
• Basic understanding of Apache Airflow for workflow orchestration.
• Strong SQL scripting skills for querying and basic data manipulation.
• Familiarity with scripting languages (e.g. Python Bash) is a plus.
• Knowledge of database security best practices including access controls encryption and compliance with regulatory requirements (e.g. GDPR HIPAA).
• Having AWS Certified Database - Specialty certification is a plus.

Experience and Qualifications:

• Bachelors degree in computer science Information Technology or a related field.
• 5-7 years of experience in database administration with a focus on PostgreSQL.
• 2-4 years of hands-on experience with PostgreSQL RDS.