PostgreSQL Data Reliability Engineer

About the jobWe are a trusted Digital Engineering and Enterprise Modernization partner, combining deep technical expertise and industry experience to help our clients anticipate what’s next. Our offerings and proven solutions create unique competitive advantage for our clients by giving them the power to see beyond and rise above.We are experiencing tremendous growth, with $566 million in revenue in FY21, representing 12.9% year-over-year growth. Along with that growth, we onboarded over 3,000 new employees in the past year, bringing our total employee count to over 15,000 people located in 18 countries across the globe.At Persistent, our values are more than a list of ideals to improve our corporate image. We’re dedicated to building an inclusive culture that reflects what’s important to our employees and is based on what they value. As a result, 95% of our employees approve of the CEO and 83% recommend working at Persistent to a friend.About Position:We are looking for a PostgreSQL Data Reliability Engineer will be Proactively monitor PostgreSQL RDS instances for performance, availability, and resource utilization environments.About Position:Role: PostgreSQL Data Reliability EngineerLocation: Basking ridge, NJ (Hybrid)Hire Type: contractWhat 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).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.Expertise You'll Bring: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:Bachelor's 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.Benefits:Competitive salary and benefits packageCulture focused on talent development with quarterly promotion cycles and company-sponsored higher education and certificationsOpportunity to work with cutting-edge technologiesEmployee engagement initiatives such as project parties, flexible work hours, and ‘Long Service’ awardsAnnual health check-ups as well as insurance:Group term life insurancePersonal accident insuranceMediclaim hospitalization insurance for self, spouse, two children, and parentsWhy Persistent is an employer of choiceTechnology Innovation: culture of innovation using cutting-edge technology to bring value to clients.Growth and Career Progression: learning opportunities for growth, including quarterly promotion cycles.One Persistent Culture: global outlook with diversity and inclusion at its core.Mental and Physical Wellness: employee health and mindfulness programs