Data Reliability Engineer

Data Reliability Engineer

Client: Zeta

Location: Basking Ridge NJ

Fulltime/hybrid

About the Role:

As a Data Reliability Engineer II you will play a crucial role in developing optimizing and managing several large data lakes and data warehouses comprising data from multiple disparate sources.

Responsibilities:

• Proactively monitor PostgreSQL RDS instances for performance availability and resource utilization (CPU memory storage connections) using established monitoring tools (e.g. CloudWatch Prometheus).
• 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 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.
• 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.
• Skills:
• Familiarity with data pipeline concepts and technologies such as Debezium Kafka Connect and ETL frameworks.
• Basic understanding of Amazon Redshift and S3.
• 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.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Technical Support Engineer Basking Ridge NJ

Responsibilities:

• Customer Support: Provide first-level technical support to customers. Respond to inquiries troubleshoot issues and resolve problems in a timely and professional manner. Ensure a high level of customer satisfaction through effective communication and problem resolution.
• Incident Management: Monitor and triage incoming support requests via various channels (phone email ticketing system) and prioritize them based on urgency and impact. Log and track all customer interactions activities and resolutions accurately in the ticketing system.
• Troubleshooting: Diagnose and resolve basic technical issues related to banking systems applications and infrastructure. Utilize knowledge bases troubleshooting guides and documented procedures to identify solutions or escalate to higher-level support teams when necessary.
• Documentation and Knowledge Sharing: Contribute to the creation and maintenance of knowledge base articles FAQs and troubleshooting guides. Document common issues their resolutions and best practices to facilitate self-service for customers and improve overall efficiency.
• Escalation Management: Escalate complex or unresolved issues to the appropriate L2 or L3 support teams providing detailed information and following escalation procedures. Collaborate with higher-level support teams to ensure prompt and effective resolution of customer issues.
• Collaboration and Communication: Collaborate with cross-functional teams including developers system administrators and business analysts to resolve customer issues and provide timely updates to customers.
• Compliance and Security: Adhere to security protocols data privacy regulations and industry compliance standards when handling customer data and accessing sensitive systems or information

Skills:

• Knowledge Sharing: Contributing to the knowledge base and sharing insights with the team is an indicator of success
• Adaptability and Learning: Embracing change quickly acquiring new skills and effectively applying them to support customer needs indicate success in a rapidly evolving technical support environment
• Strong problem-solving skills and ability to troubleshoot basic technical issues independently
• Excellent communication and interpersonal skills with the ability to explain technical concepts to non-technical individuals
• Customer-oriented mindset with a focus on delivering high-quality customer service.
• Familiarity with ticketing systems and knowledge base tools is a plus
• Ability to work under pressure in a fast-paced environment and manage multiple priorities effectively
• Willingness to learn and adapt to new technologies and tools in the banking technology domain

Experience & Qualifications:

• A minimum of 3 to 5 years of overall experience is required.
• Hands-on experience with tools such as Postman Kibana Splunk and Grafana is required.
• Bachelors degree in computer science Information Technology or a related field.
• Experience in Banking /payment technologies is a plus.